Function check_and_add_missing_fields

script/check_sql.py:20–35

(db_obj, table_name, field_definitions)

        print(f"创建表时出错：{e}")

def check_and_add_missing_fields(db_obj, table_name, field_definitions):
    cursor = db_obj.cursor()
    # 检查现有字段
    cursor.execute(f"PRAGMA table_info({table_name})")
    existing_columns = {row[1]: row for row in cursor.fetchall()}
    
    for field_def in field_definitions:
        if isinstance(field_def, list) and len(field_def) > 2:
            field_name, field_type = field_def[1], field_def[2]
            if field_name not in existing_columns:
                try:
                    cursor.execute(f"ALTER TABLE {table_name} ADD COLUMN {field_name} {field_type}")
                    db_obj.commit()
                    print(f"【添加字段】表 '{table_name}' 中缺少字段 '{field_name}'，已成功添加。")
                except sqlite3.OperationalError as e:
                    print(f"【错误】尝试向表 '{table_name}' 添加字段 '{field_name}' 时出错: {e}")

def update_database_for_table(db_name, table_name):
    db_json = get_database_json()