请移动所有数据库访问代码(
SELECT ...
def sync_db_request(container_id):
data = mysqlcon("SELECT date,moves,location,vessel,voyage,current_status FROM container_status WHERE date_current in (SELECT max(date_current) FROM container_status) and company_id={0}".format(container_id),"rpa")
a = {"Result":[]}
if data == ():
pass
else:
for i in data:
a["Result"].append(i)
return a
async def Logistic(request):
container_id = request.query['container_id']
company = request.query['company']
a = await request.loop.run_in_executor(None, sync_db_request, container_id)
return web.Response(text=json.dumps(a),headers={'ACCESS-CONTROL-ALLOW-ORIGIN':'*'})