genealogy-app/check_db.py

import pymysql

print('测试数据库连接...')
try:
    conn = pymysql.connect(
        host='rm-f8ze60yirdj8786u2wo.mysql.rds.aliyuncs.com',
        port=3306,
        user='root',
        password='csqz@20255',
        db='csqz-client',
        charset='utf8mb4',
        cursorclass=pymysql.cursors.DictCursor
    )
    print('数据库连接成功')
    
    cursor = conn.cursor()
    cursor.execute('SHOW COLUMNS FROM family_member_info')
    columns = cursor.fetchall()
    print('\n表结构:')
    for col in columns:
        print(col['Field'])
    
    conn.close()
except Exception as e:
    print(f'Error: {e}')