1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768 |
- """
- @author: luojunhui
- 返回预分配信息
- """
- import json
- from static.config import db_article
- class PreResponse(object):
- """
- 预匹配处理
- """
- def __init__(self, params, mysql_client):
- """
- 输入trace_id, 返回trace_id所绑定的视频信息
- :param params:
- :param mysql_client:
- """
- self.trace_id = None
- self.params = params
- self.mysql_client = mysql_client
- def checkParams(self):
- """
- 校验参数
- :return:
- """
- try:
- self.trace_id = self.params['traceId']
- return None
- except Exception as e:
- response = {
- "error": "params check failed",
- "info": str(e)
- }
- return response
- async def findVideoInfo(self):
- """
- :return:
- """
- sql = f"""
- select video_info1, video_info2, video_info3 from {db_article}
- where trace_id = '{self.trace_id}';
- """
- video_info = await self.mysql_client.async_select(sql)
- video_info_list = video_info[0]
- vid_list = [json.loads(i) for i in video_info_list]
- return vid_list
- async def deal(self):
- """
- deal function
- :return:
- """
- params_error = self.checkParams()
- if params_error:
- return params_error
- else:
- video_info_list = await self.findVideoInfo()
- response = {
- "traceId": self.trace_id,
- "videoObjList": video_info_list
- }
- return response
|