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

Function create_table_if_not_exists

script/check_sql.py:11–18  ·  view source on GitHub ↗
(db_obj, table_name, create_table_sql)

Source from the content-addressed store, hash-verified

9 return json.load(f)
10
11def create_table_if_not_exists(db_obj, table_name, create_table_sql):
12 # 尝试创建表,如果表不存在
13 try:
14 db_obj.execute(create_table_sql)
15 db_obj.commit()
16 print(f"【创建表】'{table_name}' 已成功创建。")
17 except sqlite3.OperationalError as e:
18 print(f"创建表时出错:{e}")
19
20def check_and_add_missing_fields(db_obj, table_name, field_definitions):
21 cursor = db_obj.cursor()

Callers 1

Calls 2

executeMethod · 0.45
commitMethod · 0.45

Tested by

no test coverage detected