from typing import Optional, Awaitable import pandas as pd import numpy as np import datetime 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())