from typing import Optional, Awaitable import pandas as pd import numpy as np import datetime import pymysql from sqlalchemy import create_engine import simplejson import requests import tornado.web import pandas as pd import json import numpy as np from sqlalchemy import create_engine from db_config import * import traceback def get_video(acc_id, start_time, end_time, video_cnt): # url = "http://192.168.1.8:8080/jeecg-boot/kuaishou/Ai/getNewVideoList" # request_data = {'account_id': acc_id, 'start_time': start_time, 'end_time': end_time, 'video_cnt': video_cnt} # request = requests.post(url, request_data) # res_data = simplejson.loads(request.text) res_data = { "code": 0, "data": [ { "video_url": "http://ucmov.a.yximgs.com/upic/2021/01/07/11/BMjAyMTAxMDcxMTI4MTlfMTI1MDY0NTMyOV80MTk5NzI5Njc0Ml8wXzM=_b_B210bce3effacab7744fa87897f2b4662.mp4?tag=1-1609990769-unknown-0-9ercfqrqp4-dd65af98d83fca04&clientCacheKey=3xigm8jk8fqbti6_b.mp4&tt=b&di=811c96e5&bp=13890", "photo_id": "5227271831775447110", "signature": "ed963b1333fe607d563d5cb0d916b65b", "stat_date": "2021-01-12 10:57:26", "channel_type": 0, "imageList": [ "5ce93696dac9a326ff18505f49391297", "a368dd69d95539f26f5bee9d1580ccf8", "33b3e1a2cad48a2309d6ce351e6082fd", "56f6a8ec736dcdb17a2f052ebfcc255e", "addd5dc29c52ef863a40c6b688ce7951", "cb6e10ec5258145056aaafad647e1c36", "763344141ace6707c79f54bba3db5d1a", "86e061c34bf675690cb57943d8675130", "5d5258e7ff4af9dbb196e10ec4e878ce", "59ca244d88e7f23ef47744110e753bac", "260e0f08aebbf168b5fd80ee864b2e4c", "49a551a978d7dd182a04bd6af7e0c08d", "0c5c43f3b2c215e66d646fb9c03e110b", "44731b7d8b7e93ac12e8dcf3d34cc272", "2227f6cc89a5c0f242e04762b0444032" ] }, { "video_url": "http://sjymov.a.yximgs.com/upic/2020/12/03/15/BMjAyMDEyMDMxNTEyNDZfMTI1MDY0NTMyOV80MDE1Mjg1MDE5OV8wXzM=_b_B7fd27f653e6af4e8cf0979041e31a38b.mp4?tag=1-1606982411-unknown-0-1ksr2io24f-3a57957a462092c7&clientCacheKey=3xmtw52hxui5j7k_b.mp4&tt=b&di=8bba1fd5&bp=13890", "photo_id": "5211227760959967759", "signature": "fc7717ac4f08316e81aa463c720226c2", "stat_date": "2021-01-12 10:57:21", "channel_type": 0, "imageList": [ "11836a6a4042b254a64bd9a6ca99f9b5", "82349cfa1e26bd17397a303b85dd0fbb", "04b1dc6793b0d2a65d8f8b45ce37744d", "4165fa246defbced026558d62ef30ed5", "064af2a19b313c0c436f6c2e4d2384eb", "13997aaa0294bcf1ca0c27a43aecceb2", "fb138ea0251f0a1c243cb287f1f865d8", "83e9292549f9617ceb5cb468cd5cce0d", "4bf798acb18747baacec0762d76e2006", "74d7b71c4e7be44d12cd7af03568053b", "b74620eeaa6c19620530b7cb553e954d", "2a1c907e5e3cf0cf2e871e5df16cca8f", "981660adc052f807ece9155124290ae1", "1247852f30b51511b510ef3b2d7f0b70", "b13119ff3fb326adfdcd04bb87324d02" ] } ], "message": "SUCCESS" } if res_data["code"] != 0: return else: return res_data["data"] def get_request_params(): video_dict = get_video(account_id, start_date, end_date, video_cnt) if video_dict is None: return request_dict = { "video": video_dict, "operation_type": operation_type, "group": {}, "campaign": {} } request_dict["group"]["cpa_bid"] = cpa_bid request_json = json.dumps(request_dict) return request_json if __name__ == '__main__': account_id = 9556344 day_delta = 10 video_cnt = 10 start_date = (datetime.datetime.now()+datetime.timedelta(days=-day_delta)).strftime("%Y-%m-%d %H:%M:%S") end_date = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S") operation_type = "add" cpa_bid = 22000 print(get_request_params())