def query_case_code():
mysql = mysql_db('172.16.25.52', 'paidan_user', 'aaA5y6C9vL', 'test2') #
# 查询当天+指定用户id上传的案件编号
query_data = mysql.select_execute(
f"SELECT event_id FROM `test2`.`event` WHERE created_at LIKE '{get_today()}%' and cuser='******' ORDER BY code DESC LIMIT 1;")
case_code = random.choice(query_data)[0]
return case_code
def db():
return mysql_db(**PAIDAN_DB_QA)
def db():
return mysql_db(**GY_DB_QA)
