MCPcopy Create free account
hub / github.com/aaPanel/BaoTa / update_database_for_table

Function update_database_for_table

script/check_sql.py:37–52  ·  view source on GitHub ↗
(db_name, table_name)

Source from the content-addressed store, hash-verified

35 print(f"【错误】尝试向表 '{table_name}' 添加字段 '{field_name}' 时出错: {e}")
36
37def update_database_for_table(db_name, table_name):
38 db_json = get_database_json()
39 db_dir = '/www/server/panel/data/db'
40 db_path = f"{db_dir}/{db_name}"
41 print(f"【处理数据库】正在处理数据库文件:{db_name}")
42 db_obj = sqlite3.connect(db_path)
43
44 if table_name in db_json.get(db_name, {}):
45 table_info = db_json[db_name][table_name]
46 print(f"【处理表】正在处理表:{table_name}")
47 create_table_if_not_exists(db_obj, table_name, table_info['sql'])
48 check_and_add_missing_fields(db_obj, table_name, table_info['fields'])
49 else:
50 print(f"表 '{table_name}' 在数据库 '{db_name}' 的定义中未找到。")
51
52 db_obj.close()
53
54if __name__ == "__main__":
55 if len(sys.argv) != 3:

Callers 1

check_sql.pyFile · 0.85

Calls 6

get_database_jsonFunction · 0.70
connectMethod · 0.45
getMethod · 0.45
closeMethod · 0.45

Tested by

no test coverage detected