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