frompot_libs.mysql_util.mysql_utilimportMysqlUtilasyncdefuser_lock_auth_by_user_id(user_id):"""根据user_id查询user_lock_auth"""sql="SELECT * FROM user_lock_auth WHERE user_id = %s"asyncwithMysqlUtil()asconn:lock_auth_list=awaitconn.fetchall(sql,args=(user_id,))returnlock_auth_listasyncdefu_lock_by_mac(mac):sql="SELECT * from u_lock where mac = %s "asyncwithMysqlUtil()asconn:lock_dic=awaitconn.fetchone(sql,args=(mac,))returnlock_dicasyncdefu_lock_by_id(lock_id):sql="SELECT * from u_lock where id = %s "asyncwithMysqlUtil()asconn:lock_dic=awaitconn.fetchone(sql,args=(lock_id,))returnlock_dic