def insert_origin_bag_md5(game_id: str, group_id: str, md5: str) -> bool:
if switch.DB_ENABLE:
sql = Sqlite(FPath.ASSETS_PATH + "/db/info.sqlite")
sql_line = "INSERT INTO BAG (GAME_ID,GROUP_ID,MD5) VALUES (?,?,?);"
result = sql.execute(sql_line, (game_id, group_id, md5))
sql.close()
return result
return True
def get_common_sdk_md5(version: str) -> str:
if switch.DB_ENABLE:
sql = Sqlite(FPath.ASSETS_PATH + "/db/info.sqlite")
sql_line = "SELECT MD5 FROM COMMON WHERE VERSION=?;"
md5_list = sql.query(sql_line, (version, ))
sql.close()
if md5_list:
return md5_list[0][0]
return ""
def insert_common_sdk_md5(version: str, md5: str, file_size: int) -> bool:
if switch.DB_ENABLE:
sql = Sqlite(FPath.ASSETS_PATH + "/db/info.sqlite")
sql_line = "INSERT INTO COMMON (VERSION,MD5,SIZE) VALUES (?,?,?);"
result = sql.execute(sql_line, (version, md5, file_size))
sql.close()
return result
else:
return True
def get_origin_bag_md5(game_id: str, group_id: str) -> str:
if switch.DB_ENABLE:
sql = Sqlite(FPath.ASSETS_PATH + "/db/info.sqlite")
sql_line = "SELECT MD5 FROM BAG WHERE GAME_ID=? AND GROUP_ID=?;"
md5_list = sql.query(sql_line, (game_id, group_id))
sql.close()
if md5_list:
return md5_list[0][0]
return ""
def get_channel_sdk_size(channel_name: str, version: str) -> int:
if switch.DB_ENABLE:
sql = Sqlite(FPath.ASSETS_PATH + "/db/info.sqlite")
sql_line = "SELECT SIZE FROM CHANNEL WHERE NAME=? AND VERSION=?;"
size_list = sql.query(sql_line, (channel_name, version))
sql.close()
if size_list:
return size_list[0][0]
return 0
def get_common_sdk_size(version: str) -> int:
if switch.DB_ENABLE:
sql = Sqlite(FPath.ASSETS_PATH + "/db/info.sqlite")
sql_line = "SELECT SIZE FROM COMMON WHERE VERSION = ?;"
size_list = sql.query(sql_line, (version, ))
sql.close()
if size_list:
return size_list[0][0]
return 0
def update_origin_bag_md5(game_id: str, group_id: str, md5: str) -> bool:
if switch.DB_ENABLE:
sql = Sqlite(FPath.ASSETS_PATH + "/db/info.sqlite")
sql_line = "UPDATE BAG SET MD5= '" + md5 + "' WHERE GAME_ID=? AND GROUP_ID=?;"
result = sql.execute(sql_line, (game_id, group_id))
sql.close()
return result
else:
return True
def update_common_sdk_md5(version: str, md5: str, file_size: int) -> bool:
if switch.DB_ENABLE:
sql = Sqlite(FPath.ASSETS_PATH + "/db/info.sqlite")
sql_line = "UPDATE COMMON SET MD5= '" + md5 + "', SIZE = " + str(
file_size) + " WHERE VERSION=?;"
result = sql.execute(sql_line, (version, ))
sql.close()
return result
else:
return True
def update_channel_sdk_md5(channel_name: str, version: str, md5: str,
file_size: int) -> bool:
if switch.DB_ENABLE:
sql = Sqlite(FPath.ASSETS_PATH + "/db/info.sqlite")
sql_line = "UPDATE CHANNEL SET MD5='" + md5 + "', SIZE = " + str(
file_size) + " WHERE NAME=? AND VERSION=?;"
result = sql.execute(sql_line, (channel_name, version))
sql.close()
return result
else:
return True