genealogy-app/check_genealogy_records_version.py

import pymysql
from app import get_db_connection

conn = get_db_connection()
cursor = conn.cursor()

print('genealogy_records表中genealogy_version字段的值:')
cursor.execute('SELECT DISTINCT genealogy_version FROM genealogy_records')
versions = cursor.fetchall()
for version in versions:
    print(f"Genealogy Version: {version['genealogy_version']}")

print('\n搜索卷四的记录数量:')
cursor.execute('SELECT COUNT(*) as count FROM genealogy_records WHERE genealogy_version LIKE %s', ('%卷四%',))
count = cursor.fetchone()['count']
print(f"卷四记录数量: {count}")

print('\n搜索卷五的记录数量:')
cursor.execute('SELECT COUNT(*) as count FROM genealogy_records WHERE genealogy_version LIKE %s', ('%卷五%',))
count = cursor.fetchone()['count']
print(f"卷五记录数量: {count}")

cursor.close()
conn.close()