数据库字典模板

import mysql.connector

def generate_database_dictionary(host, user, password, database):
    conn = mysql.connector.connect(host=host, user=user, password=password, database=database)
    cursor = conn.cursor(dictionary=True)
    
    cursor.execute("SHOW TABLES")
    tables = cursor.fetchall()
    
    dictionary = {}
    
    for table in tables:
        table_name = table['Tables_in_' + database]
        dictionary[table_name] = {}
        
        cursor.execute(f"DESCRIBE {table_name}")
        columns = cursor.fetchall()
        
        for column in columns:
            dictionary[table_name][column['Field']] = {
                'Type': column['Type'],
                'Null': column['Null'],
                'Key': column['Key'],
                'Default': column['Default'],
                'Extra': column['Extra']
            }
    
    return dictionary

# 示例调用
db_dict = generate_database_dictionary('localhost', 'user', 'password', 'mydatabase')
print(db_dict)