从嵌套字典创建单个字典以更新MySQLdb

nested_dict = {
    'id': 1,
    'name': 'John',
    'details': {
        'age': 25,
        'email': 'john@example.com'
    }
}

def flatten_dict(nested_dict, parent_key='', sep='_'):
    flattened_dict = {}
    for key, value in nested_dict.items():
        new_key = parent_key + sep + key if parent_key else key
        if isinstance(value, dict):
            flattened_dict.update(flatten_dict(value, new_key, sep))
        else:
            flattened_dict[new_key] = value
    return flattened_dict

flat_dict = flatten_dict(nested_dict)
print(flat_dict)

import MySQLdb

# 连接到MySQL数据库
db = MySQLdb.connect(host='localhost', user='username', passwd='password', db='database')

# 创建游标对象
cursor = db.cursor()

# 更新数据库记录
sql = "UPDATE table SET name=%s, age=%s, email=%s WHERE id=%s"
params = (flat_dict['name'], flat_dict['details_age'], flat_dict['details_email'], flat_dict['id'])
cursor.execute(sql, params)

# 提交更改
db.commit()

# 关闭连接
db.close()