def Check_Video(self, connect: Connection, db_create: DB_CREATE,
cursor: Cursor) -> None:
"""
Check_Video(connect: Connection, db_create: DB_CREATE,
cursor: Cursor) -> None
检查视频表是否存在，不存在则创建
:param connect: 数据库连接对象
:param db_create: 数据库创建操作对象
:param cursor: 光标
:return: None
"""
if not self._Check_Table(
connect=connect,
cursor=cursor,
table_name=DB_CONFIG().Video,
table_info=(
DB_CONFIG().Video_Fields,
DB_CONFIG().Video_Fields_Types
)
):
print(f"检测到视频表<{DB_CONFIG().Video}>未创建\n"
f"自动创建中")
db_create.Video()
print(f"视频表为<{DB_CONFIG().Video}>")
def __init__(self, connect: Connection, cursor: Cursor):
"""
初始化
:param connect: 数据库连接对象
:param cursor: 光标
"""
self.__connect = connect
self.__cursor = cursor
self.__name = DB_CONFIG().Task
self.__fields = DB_CONFIG().Task_Fields
def Project(self) -> None:
"""
Project() -> None
专项答题表创建
:return: None
"""
name = DB_CONFIG().Project
fields = DB_CONFIG().Project_Fields
fields_types = DB_CONFIG().Project_Fields_Types
sql = f'''CREATE TABLE {name}
({fields[0]} {fields_types[0]} PRIMARY KEY AUTOINCREMENT,
{fields[1]} {fields_types[1]} NOT NULL
);'''
self.__cursor.execute(sql)
self.__connect.commit()
def Task(self) -> None:
"""
Task() -> None
任务表创建
:return: None
"""
name = DB_CONFIG().Task
fields = DB_CONFIG().Task_Fields
fields_types = DB_CONFIG().Task_Fields_Types
sql = f'''CREATE TABLE {name}
({fields[0]} {fields_types[0]} PRIMARY KEY AUTOINCREMENT,
{fields[1]} {fields_types[1]} NOT NULL,
{fields[2]} {fields_types[2]} NOT NULL
);'''
self.__cursor.execute(sql)
self.__connect.commit()
def Check_Baidu_AI(self, connect: Connection, db_create: DB_CREATE,
cursor: Cursor) -> None:
"""
Check_Project(connect: Connection, db_create: DB_CREATE,
cursor: Cursor) -> None
检查专项答题表是否存在，不存在则创建
:param connect: 数据库连接对象
:param db_create: 数据库创建操作对象
:param cursor: 光标
:return: None
"""
if not self._Check_Table(
connect=connect,
cursor=cursor,
table_name=DB_CONFIG().Baidu_AI,
table_info=(DB_CONFIG().Baidu_AI_Fields,
DB_CONFIG().Baidu_AI_Fields_Types)):
print(f"检测到百度AI表<{DB_CONFIG().Baidu_AI}>未创建\n" f"自动创建中")
db_create.Baidu_AI()
print(f"百度AI表为<{DB_CONFIG().Baidu_AI}>")