批量对比mysql数据结构

import mysql.connector

def get_table_structure(cursor, table_name):
    cursor.execute(f"SHOW CREATE TABLE {table_name}")
    return cursor.fetchone()[1]

def compare_table_structures(db1, db2, table_name):
    conn1 = mysql.connector.connect(**db1)
    conn2 = mysql.connector.connect(**db2)
    
    cursor1 = conn1.cursor()
    cursor2 = conn2.cursor()
    
    structure1 = get_table_structure(cursor1, table_name)
    structure2 = get_table_structure(cursor2, table_name)
    
    if structure1 == structure2:
        print(f"Table {table_name} structures are identical.")
    else:
        print(f"Table {table_name} structures differ:")
        print("DB1 Structure:")
        print(structure1)
        print("DB2 Structure:")
        print(structure2)
    
    cursor1.close()
    cursor2.close()
    conn1.close()
    conn2.close()

# Example usage
db1 = {
    'host': 'localhost',
    'user': 'user1',
    'password': 'password1',
    'database': 'db1'
}

db2 = {
    'host': 'localhost',
    'user': 'user2',
    'password': 'password2',
    'database': 'db2'
}

compare_table_structures(db1, db2, 'example_table')