def getpic5(id): try: client = POOL.connection() res_pic5=None cursor = client.cursor(cursor=pymysql.cursors.DictCursor) sql = sql_user.get('getpic5').format(tid=id['tid']) cursor.execute(sql) res_pic5= cursor.fetchone() client.commit() except Exception as ex: client.rollbake() finally: client.close() return res_pic5
def rande(id): try: client = POOL.connection() res_pic1=None cursor = client.cursor(cursor=pymysql.cursors.DictCursor) sql = sql_user.get('rande').format() cursor.execute(sql) res_pic1= cursor.fetchall() client.commit() print(res_pic1) except Exception as ex: client.rollbake() finally: client.close() return res_pic1