manual_request_json.py 4.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108
  1. from typing import Optional, Awaitable
  2. import pandas as pd
  3. import numpy as np
  4. import datetime
  5. import pymysql
  6. from sqlalchemy import create_engine
  7. import simplejson
  8. import requests
  9. import tornado.web
  10. import pandas as pd
  11. import json
  12. import numpy as np
  13. from sqlalchemy import create_engine
  14. from db_config import *
  15. import traceback
  16. def get_video(acc_id, start_time, end_time, video_cnt):
  17. # url = "http://192.168.1.8:8080/jeecg-boot/kuaishou/Ai/getNewVideoList"
  18. # request_data = {'account_id': acc_id, 'start_time': start_time, 'end_time': end_time, 'video_cnt': video_cnt}
  19. # request = requests.post(url, request_data)
  20. # res_data = simplejson.loads(request.text)
  21. res_data = {
  22. "code": 0,
  23. "data": [
  24. {
  25. "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",
  26. "photo_id": "5227271831775447110",
  27. "signature": "ed963b1333fe607d563d5cb0d916b65b",
  28. "stat_date": "2021-01-12 10:57:26",
  29. "channel_type": 0,
  30. "imageList": [
  31. "5ce93696dac9a326ff18505f49391297",
  32. "a368dd69d95539f26f5bee9d1580ccf8",
  33. "33b3e1a2cad48a2309d6ce351e6082fd",
  34. "56f6a8ec736dcdb17a2f052ebfcc255e",
  35. "addd5dc29c52ef863a40c6b688ce7951",
  36. "cb6e10ec5258145056aaafad647e1c36",
  37. "763344141ace6707c79f54bba3db5d1a",
  38. "86e061c34bf675690cb57943d8675130",
  39. "5d5258e7ff4af9dbb196e10ec4e878ce",
  40. "59ca244d88e7f23ef47744110e753bac",
  41. "260e0f08aebbf168b5fd80ee864b2e4c",
  42. "49a551a978d7dd182a04bd6af7e0c08d",
  43. "0c5c43f3b2c215e66d646fb9c03e110b",
  44. "44731b7d8b7e93ac12e8dcf3d34cc272",
  45. "2227f6cc89a5c0f242e04762b0444032"
  46. ]
  47. },
  48. {
  49. "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",
  50. "photo_id": "5211227760959967759",
  51. "signature": "fc7717ac4f08316e81aa463c720226c2",
  52. "stat_date": "2021-01-12 10:57:21",
  53. "channel_type": 0,
  54. "imageList": [
  55. "11836a6a4042b254a64bd9a6ca99f9b5",
  56. "82349cfa1e26bd17397a303b85dd0fbb",
  57. "04b1dc6793b0d2a65d8f8b45ce37744d",
  58. "4165fa246defbced026558d62ef30ed5",
  59. "064af2a19b313c0c436f6c2e4d2384eb",
  60. "13997aaa0294bcf1ca0c27a43aecceb2",
  61. "fb138ea0251f0a1c243cb287f1f865d8",
  62. "83e9292549f9617ceb5cb468cd5cce0d",
  63. "4bf798acb18747baacec0762d76e2006",
  64. "74d7b71c4e7be44d12cd7af03568053b",
  65. "b74620eeaa6c19620530b7cb553e954d",
  66. "2a1c907e5e3cf0cf2e871e5df16cca8f",
  67. "981660adc052f807ece9155124290ae1",
  68. "1247852f30b51511b510ef3b2d7f0b70",
  69. "b13119ff3fb326adfdcd04bb87324d02"
  70. ]
  71. }
  72. ],
  73. "message": "SUCCESS"
  74. }
  75. if res_data["code"] != 0:
  76. return
  77. else:
  78. return res_data["data"]
  79. def get_request_params():
  80. video_dict = get_video(account_id, start_date, end_date, video_cnt)
  81. if video_dict is None:
  82. return
  83. request_dict = {
  84. "video": video_dict,
  85. "operation_type": operation_type,
  86. "group": {},
  87. "campaign": {}
  88. }
  89. request_dict["group"]["cpa_bid"] = cpa_bid
  90. request_json = json.dumps(request_dict)
  91. return request_json
  92. if __name__ == '__main__':
  93. account_id = 9556344
  94. day_delta = 10
  95. video_cnt = 10
  96. start_date = (datetime.datetime.now()+datetime.timedelta(days=-day_delta)).strftime("%Y-%m-%d %H:%M:%S")
  97. end_date = datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
  98. operation_type = "add"
  99. cpa_bid = 22000
  100. print(get_request_params())