ai_strategy_request.log 129 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525
  1. 01/14/2021 10:57:19 AM INFO ai strategy request service started at 2021-01-14 10:57:19
  2. 01/14/2021 10:57:39 AM INFO ai strategy request service started at 2021-01-14 10:57:39
  3. 01/14/2021 11:01:29 AM INFO ai strategy request service started at 2021-01-14 11:01:29
  4. 01/14/2021 11:04:56 AM INFO ai strategy request service started at 2021-01-14 11:04:56
  5. 01/14/2021 11:07:17 AM INFO ai strategy request service started at 2021-01-14 11:07:17
  6. 01/14/2021 11:10:29 AM INFO ai strategy request service started at 2021-01-14 11:10:29
  7. 01/14/2021 12:04:22 PM INFO ai strategy request service started at 2021-01-14 12:04:22
  8. 01/14/2021 12:05:00 PM INFO ai strategy request service started at 2021-01-14 12:05:00
  9. 01/14/2021 12:06:32 PM INFO *************************************** NEW REQUEST ***************************************
  10. 01/14/2021 12:06:32 PM INFO raw data from request is {
  11. "video": [
  12. {
  13. "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",
  14. "photo_id": "5227271831775447110",
  15. "signature": "ed963b1333fe607d563d5cb0d916b65b",
  16. "stat_date": "2021-01-12 10:57:26",
  17. "channel_type": 0,
  18. "imageList": [
  19. "5ce93696dac9a326ff18505f49391297",
  20. "a368dd69d95539f26f5bee9d1580ccf8",
  21. "33b3e1a2cad48a2309d6ce351e6082fd",
  22. "56f6a8ec736dcdb17a2f052ebfcc255e",
  23. "addd5dc29c52ef863a40c6b688ce7951",
  24. "cb6e10ec5258145056aaafad647e1c36",
  25. "763344141ace6707c79f54bba3db5d1a",
  26. "86e061c34bf675690cb57943d8675130",
  27. "5d5258e7ff4af9dbb196e10ec4e878ce",
  28. "59ca244d88e7f23ef47744110e753bac",
  29. "260e0f08aebbf168b5fd80ee864b2e4c",
  30. "49a551a978d7dd182a04bd6af7e0c08d",
  31. "0c5c43f3b2c215e66d646fb9c03e110b",
  32. "44731b7d8b7e93ac12e8dcf3d34cc272",
  33. "2227f6cc89a5c0f242e04762b0444032"
  34. ]
  35. },
  36. {
  37. "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",
  38. "photo_id": "5211227760959967759",
  39. "signature": "fc7717ac4f08316e81aa463c720226c2",
  40. "stat_date": "2021-01-12 10:57:21",
  41. "channel_type": 0,
  42. "imageList": [
  43. "11836a6a4042b254a64bd9a6ca99f9b5",
  44. "82349cfa1e26bd17397a303b85dd0fbb",
  45. "04b1dc6793b0d2a65d8f8b45ce37744d",
  46. "4165fa246defbced026558d62ef30ed5",
  47. "064af2a19b313c0c436f6c2e4d2384eb",
  48. "13997aaa0294bcf1ca0c27a43aecceb2",
  49. "fb138ea0251f0a1c243cb287f1f865d8",
  50. "83e9292549f9617ceb5cb468cd5cce0d",
  51. "4bf798acb18747baacec0762d76e2006",
  52. "74d7b71c4e7be44d12cd7af03568053b",
  53. "b74620eeaa6c19620530b7cb553e954d",
  54. "2a1c907e5e3cf0cf2e871e5df16cca8f",
  55. "981660adc052f807ece9155124290ae1",
  56. "1247852f30b51511b510ef3b2d7f0b70",
  57. "b13119ff3fb326adfdcd04bb87324d02"
  58. ]
  59. }
  60. ],
  61. "operation_type": "add",
  62. "ai_strategy_remark":"打捞历史素材",
  63. "group_info": {
  64. "cpa_bid": 22000,
  65. "unit_name": "222"
  66. },
  67. "campaign_info": {
  68. "campaign_id": "",
  69. "campaign_name":"广告计划名称test",
  70. "campaign_type":2
  71. },
  72. "creative_info":{
  73. "creative_name":"创意名称",
  74. "action_bar_text":"下载抢购",
  75. "description":"不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!"
  76. },
  77. "account_id": 23212
  78. }
  79. 01/14/2021 12:06:32 PM ERROR Traceback (most recent call last):
  80. File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
  81. if data["operation_type"] == "add":
  82. TypeError: string indices must be integers
  83. 01/14/2021 12:06:56 PM INFO *************************************** NEW REQUEST ***************************************
  84. 01/14/2021 12:06:56 PM INFO raw data from request is {
  85. "video": [
  86. {
  87. "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",
  88. "photo_id": "5227271831775447110",
  89. "signature": "ed963b1333fe607d563d5cb0d916b65b",
  90. "stat_date": "2021-01-12 10:57:26",
  91. "channel_type": 0,
  92. "imageList": [
  93. "5ce93696dac9a326ff18505f49391297",
  94. "a368dd69d95539f26f5bee9d1580ccf8",
  95. "33b3e1a2cad48a2309d6ce351e6082fd",
  96. "56f6a8ec736dcdb17a2f052ebfcc255e",
  97. "addd5dc29c52ef863a40c6b688ce7951",
  98. "cb6e10ec5258145056aaafad647e1c36",
  99. "763344141ace6707c79f54bba3db5d1a",
  100. "86e061c34bf675690cb57943d8675130",
  101. "5d5258e7ff4af9dbb196e10ec4e878ce",
  102. "59ca244d88e7f23ef47744110e753bac",
  103. "260e0f08aebbf168b5fd80ee864b2e4c",
  104. "49a551a978d7dd182a04bd6af7e0c08d",
  105. "0c5c43f3b2c215e66d646fb9c03e110b",
  106. "44731b7d8b7e93ac12e8dcf3d34cc272",
  107. "2227f6cc89a5c0f242e04762b0444032"
  108. ]
  109. },
  110. {
  111. "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",
  112. "photo_id": "5211227760959967759",
  113. "signature": "fc7717ac4f08316e81aa463c720226c2",
  114. "stat_date": "2021-01-12 10:57:21",
  115. "channel_type": 0,
  116. "imageList": [
  117. "11836a6a4042b254a64bd9a6ca99f9b5",
  118. "82349cfa1e26bd17397a303b85dd0fbb",
  119. "04b1dc6793b0d2a65d8f8b45ce37744d",
  120. "4165fa246defbced026558d62ef30ed5",
  121. "064af2a19b313c0c436f6c2e4d2384eb",
  122. "13997aaa0294bcf1ca0c27a43aecceb2",
  123. "fb138ea0251f0a1c243cb287f1f865d8",
  124. "83e9292549f9617ceb5cb468cd5cce0d",
  125. "4bf798acb18747baacec0762d76e2006",
  126. "74d7b71c4e7be44d12cd7af03568053b",
  127. "b74620eeaa6c19620530b7cb553e954d",
  128. "2a1c907e5e3cf0cf2e871e5df16cca8f",
  129. "981660adc052f807ece9155124290ae1",
  130. "1247852f30b51511b510ef3b2d7f0b70",
  131. "b13119ff3fb326adfdcd04bb87324d02"
  132. ]
  133. }
  134. ],
  135. "operation_type": "add",
  136. "ai_strategy_remark":"打捞历史素材",
  137. "group_info": {
  138. "cpa_bid": 22000,
  139. "unit_name": "222"
  140. },
  141. "campaign_info": {
  142. "campaign_id": "",
  143. "campaign_name":"广告计划名称test",
  144. "campaign_type":2
  145. },
  146. "creative_info":{
  147. "creative_name":"创意名称",
  148. "action_bar_text":"下载抢购",
  149. "description":"不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!"
  150. },
  151. "account_id": 23212
  152. }
  153. 01/14/2021 12:06:56 PM ERROR Traceback (most recent call last):
  154. File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
  155. if data["operation_type"] == "add":
  156. TypeError: string indices must be integers
  157. 01/14/2021 12:06:57 PM INFO *************************************** NEW REQUEST ***************************************
  158. 01/14/2021 12:06:57 PM INFO raw data from request is {
  159. "video": [
  160. {
  161. "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",
  162. "photo_id": "5227271831775447110",
  163. "signature": "ed963b1333fe607d563d5cb0d916b65b",
  164. "stat_date": "2021-01-12 10:57:26",
  165. "channel_type": 0,
  166. "imageList": [
  167. "5ce93696dac9a326ff18505f49391297",
  168. "a368dd69d95539f26f5bee9d1580ccf8",
  169. "33b3e1a2cad48a2309d6ce351e6082fd",
  170. "56f6a8ec736dcdb17a2f052ebfcc255e",
  171. "addd5dc29c52ef863a40c6b688ce7951",
  172. "cb6e10ec5258145056aaafad647e1c36",
  173. "763344141ace6707c79f54bba3db5d1a",
  174. "86e061c34bf675690cb57943d8675130",
  175. "5d5258e7ff4af9dbb196e10ec4e878ce",
  176. "59ca244d88e7f23ef47744110e753bac",
  177. "260e0f08aebbf168b5fd80ee864b2e4c",
  178. "49a551a978d7dd182a04bd6af7e0c08d",
  179. "0c5c43f3b2c215e66d646fb9c03e110b",
  180. "44731b7d8b7e93ac12e8dcf3d34cc272",
  181. "2227f6cc89a5c0f242e04762b0444032"
  182. ]
  183. },
  184. {
  185. "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",
  186. "photo_id": "5211227760959967759",
  187. "signature": "fc7717ac4f08316e81aa463c720226c2",
  188. "stat_date": "2021-01-12 10:57:21",
  189. "channel_type": 0,
  190. "imageList": [
  191. "11836a6a4042b254a64bd9a6ca99f9b5",
  192. "82349cfa1e26bd17397a303b85dd0fbb",
  193. "04b1dc6793b0d2a65d8f8b45ce37744d",
  194. "4165fa246defbced026558d62ef30ed5",
  195. "064af2a19b313c0c436f6c2e4d2384eb",
  196. "13997aaa0294bcf1ca0c27a43aecceb2",
  197. "fb138ea0251f0a1c243cb287f1f865d8",
  198. "83e9292549f9617ceb5cb468cd5cce0d",
  199. "4bf798acb18747baacec0762d76e2006",
  200. "74d7b71c4e7be44d12cd7af03568053b",
  201. "b74620eeaa6c19620530b7cb553e954d",
  202. "2a1c907e5e3cf0cf2e871e5df16cca8f",
  203. "981660adc052f807ece9155124290ae1",
  204. "1247852f30b51511b510ef3b2d7f0b70",
  205. "b13119ff3fb326adfdcd04bb87324d02"
  206. ]
  207. }
  208. ],
  209. "operation_type": "add",
  210. "ai_strategy_remark":"打捞历史素材",
  211. "group_info": {
  212. "cpa_bid": 22000,
  213. "unit_name": "222"
  214. },
  215. "campaign_info": {
  216. "campaign_id": "",
  217. "campaign_name":"广告计划名称test",
  218. "campaign_type":2
  219. },
  220. "creative_info":{
  221. "creative_name":"创意名称",
  222. "action_bar_text":"下载抢购",
  223. "description":"不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!"
  224. },
  225. "account_id": 23212
  226. }
  227. 01/14/2021 12:06:57 PM ERROR Traceback (most recent call last):
  228. File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
  229. if data["operation_type"] == "add":
  230. TypeError: string indices must be integers
  231. 01/14/2021 12:07:00 PM INFO *************************************** NEW REQUEST ***************************************
  232. 01/14/2021 12:07:00 PM INFO raw data from request is {
  233. "video": [
  234. {
  235. "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",
  236. "photo_id": "5227271831775447110",
  237. "signature": "ed963b1333fe607d563d5cb0d916b65b",
  238. "stat_date": "2021-01-12 10:57:26",
  239. "channel_type": 0,
  240. "imageList": [
  241. "5ce93696dac9a326ff18505f49391297",
  242. "a368dd69d95539f26f5bee9d1580ccf8",
  243. "33b3e1a2cad48a2309d6ce351e6082fd",
  244. "56f6a8ec736dcdb17a2f052ebfcc255e",
  245. "addd5dc29c52ef863a40c6b688ce7951",
  246. "cb6e10ec5258145056aaafad647e1c36",
  247. "763344141ace6707c79f54bba3db5d1a",
  248. "86e061c34bf675690cb57943d8675130",
  249. "5d5258e7ff4af9dbb196e10ec4e878ce",
  250. "59ca244d88e7f23ef47744110e753bac",
  251. "260e0f08aebbf168b5fd80ee864b2e4c",
  252. "49a551a978d7dd182a04bd6af7e0c08d",
  253. "0c5c43f3b2c215e66d646fb9c03e110b",
  254. "44731b7d8b7e93ac12e8dcf3d34cc272",
  255. "2227f6cc89a5c0f242e04762b0444032"
  256. ]
  257. },
  258. {
  259. "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",
  260. "photo_id": "5211227760959967759",
  261. "signature": "fc7717ac4f08316e81aa463c720226c2",
  262. "stat_date": "2021-01-12 10:57:21",
  263. "channel_type": 0,
  264. "imageList": [
  265. "11836a6a4042b254a64bd9a6ca99f9b5",
  266. "82349cfa1e26bd17397a303b85dd0fbb",
  267. "04b1dc6793b0d2a65d8f8b45ce37744d",
  268. "4165fa246defbced026558d62ef30ed5",
  269. "064af2a19b313c0c436f6c2e4d2384eb",
  270. "13997aaa0294bcf1ca0c27a43aecceb2",
  271. "fb138ea0251f0a1c243cb287f1f865d8",
  272. "83e9292549f9617ceb5cb468cd5cce0d",
  273. "4bf798acb18747baacec0762d76e2006",
  274. "74d7b71c4e7be44d12cd7af03568053b",
  275. "b74620eeaa6c19620530b7cb553e954d",
  276. "2a1c907e5e3cf0cf2e871e5df16cca8f",
  277. "981660adc052f807ece9155124290ae1",
  278. "1247852f30b51511b510ef3b2d7f0b70",
  279. "b13119ff3fb326adfdcd04bb87324d02"
  280. ]
  281. }
  282. ],
  283. "operation_type": "add",
  284. "ai_strategy_remark":"打捞历史素材",
  285. "group_info": {
  286. "cpa_bid": 22000,
  287. "unit_name": "222"
  288. },
  289. "campaign_info": {
  290. "campaign_id": "",
  291. "campaign_name":"广告计划名称test",
  292. "campaign_type":2
  293. },
  294. "creative_info":{
  295. "creative_name":"创意名称",
  296. "action_bar_text":"下载抢购",
  297. "description":"不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!"
  298. },
  299. "account_id": 23212
  300. }
  301. 01/14/2021 12:07:00 PM ERROR Traceback (most recent call last):
  302. File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
  303. if data["operation_type"] == "add":
  304. TypeError: string indices must be integers
  305. 01/14/2021 12:07:04 PM INFO *************************************** NEW REQUEST ***************************************
  306. 01/14/2021 12:07:04 PM INFO raw data from request is {
  307. "video": [
  308. {
  309. "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",
  310. "photo_id": "5227271831775447110",
  311. "signature": "ed963b1333fe607d563d5cb0d916b65b",
  312. "stat_date": "2021-01-12 10:57:26",
  313. "channel_type": 0,
  314. "imageList": [
  315. "5ce93696dac9a326ff18505f49391297",
  316. "a368dd69d95539f26f5bee9d1580ccf8",
  317. "33b3e1a2cad48a2309d6ce351e6082fd",
  318. "56f6a8ec736dcdb17a2f052ebfcc255e",
  319. "addd5dc29c52ef863a40c6b688ce7951",
  320. "cb6e10ec5258145056aaafad647e1c36",
  321. "763344141ace6707c79f54bba3db5d1a",
  322. "86e061c34bf675690cb57943d8675130",
  323. "5d5258e7ff4af9dbb196e10ec4e878ce",
  324. "59ca244d88e7f23ef47744110e753bac",
  325. "260e0f08aebbf168b5fd80ee864b2e4c",
  326. "49a551a978d7dd182a04bd6af7e0c08d",
  327. "0c5c43f3b2c215e66d646fb9c03e110b",
  328. "44731b7d8b7e93ac12e8dcf3d34cc272",
  329. "2227f6cc89a5c0f242e04762b0444032"
  330. ]
  331. },
  332. {
  333. "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",
  334. "photo_id": "5211227760959967759",
  335. "signature": "fc7717ac4f08316e81aa463c720226c2",
  336. "stat_date": "2021-01-12 10:57:21",
  337. "channel_type": 0,
  338. "imageList": [
  339. "11836a6a4042b254a64bd9a6ca99f9b5",
  340. "82349cfa1e26bd17397a303b85dd0fbb",
  341. "04b1dc6793b0d2a65d8f8b45ce37744d",
  342. "4165fa246defbced026558d62ef30ed5",
  343. "064af2a19b313c0c436f6c2e4d2384eb",
  344. "13997aaa0294bcf1ca0c27a43aecceb2",
  345. "fb138ea0251f0a1c243cb287f1f865d8",
  346. "83e9292549f9617ceb5cb468cd5cce0d",
  347. "4bf798acb18747baacec0762d76e2006",
  348. "74d7b71c4e7be44d12cd7af03568053b",
  349. "b74620eeaa6c19620530b7cb553e954d",
  350. "2a1c907e5e3cf0cf2e871e5df16cca8f",
  351. "981660adc052f807ece9155124290ae1",
  352. "1247852f30b51511b510ef3b2d7f0b70",
  353. "b13119ff3fb326adfdcd04bb87324d02"
  354. ]
  355. }
  356. ],
  357. "operation_type": "add",
  358. "ai_strategy_remark":"打捞历史素材",
  359. "group_info": {
  360. "cpa_bid": 22000,
  361. "unit_name": "222"
  362. },
  363. "campaign_info": {
  364. "campaign_id": "",
  365. "campaign_name":"广告计划名称test",
  366. "campaign_type":2
  367. },
  368. "creative_info":{
  369. "creative_name":"创意名称",
  370. "action_bar_text":"下载抢购",
  371. "description":"不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!"
  372. },
  373. "account_id": 23212
  374. }
  375. 01/14/2021 12:07:04 PM ERROR Traceback (most recent call last):
  376. File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
  377. if data["operation_type"] == "add":
  378. TypeError: string indices must be integers
  379. 01/14/2021 01:30:14 PM INFO *************************************** NEW REQUEST ***************************************
  380. 01/14/2021 01:30:14 PM INFO raw data from request is {
  381. "video": [
  382. {
  383. "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",
  384. "photo_id": "5227271831775447110",
  385. "signature": "ed963b1333fe607d563d5cb0d916b65b",
  386. "stat_date": "2021-01-12 10:57:26",
  387. "channel_type": 0,
  388. "imageList": [
  389. "5ce93696dac9a326ff18505f49391297",
  390. "a368dd69d95539f26f5bee9d1580ccf8",
  391. "33b3e1a2cad48a2309d6ce351e6082fd",
  392. "56f6a8ec736dcdb17a2f052ebfcc255e",
  393. "addd5dc29c52ef863a40c6b688ce7951",
  394. "cb6e10ec5258145056aaafad647e1c36",
  395. "763344141ace6707c79f54bba3db5d1a",
  396. "86e061c34bf675690cb57943d8675130",
  397. "5d5258e7ff4af9dbb196e10ec4e878ce",
  398. "59ca244d88e7f23ef47744110e753bac",
  399. "260e0f08aebbf168b5fd80ee864b2e4c",
  400. "49a551a978d7dd182a04bd6af7e0c08d",
  401. "0c5c43f3b2c215e66d646fb9c03e110b",
  402. "44731b7d8b7e93ac12e8dcf3d34cc272",
  403. "2227f6cc89a5c0f242e04762b0444032"
  404. ]
  405. },
  406. {
  407. "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",
  408. "photo_id": "5211227760959967759",
  409. "signature": "fc7717ac4f08316e81aa463c720226c2",
  410. "stat_date": "2021-01-12 10:57:21",
  411. "channel_type": 0,
  412. "imageList": [
  413. "11836a6a4042b254a64bd9a6ca99f9b5",
  414. "82349cfa1e26bd17397a303b85dd0fbb",
  415. "04b1dc6793b0d2a65d8f8b45ce37744d",
  416. "4165fa246defbced026558d62ef30ed5",
  417. "064af2a19b313c0c436f6c2e4d2384eb",
  418. "13997aaa0294bcf1ca0c27a43aecceb2",
  419. "fb138ea0251f0a1c243cb287f1f865d8",
  420. "83e9292549f9617ceb5cb468cd5cce0d",
  421. "4bf798acb18747baacec0762d76e2006",
  422. "74d7b71c4e7be44d12cd7af03568053b",
  423. "b74620eeaa6c19620530b7cb553e954d",
  424. "2a1c907e5e3cf0cf2e871e5df16cca8f",
  425. "981660adc052f807ece9155124290ae1",
  426. "1247852f30b51511b510ef3b2d7f0b70",
  427. "b13119ff3fb326adfdcd04bb87324d02"
  428. ]
  429. }
  430. ],
  431. "operation_type": "add",
  432. "ai_strategy_remark":"打捞历史素材",
  433. "group_info": {
  434. "cpa_bid": 22000,
  435. "unit_name": "222"
  436. },
  437. "campaign_info": {
  438. "campaign_id": "",
  439. "campaign_name":"广告计划名称test",
  440. "campaign_type":2
  441. },
  442. "creative_info":{
  443. "creative_name":"创意名称",
  444. "action_bar_text":"下载抢购",
  445. "description":"不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!"
  446. },
  447. "account_id": 23212
  448. }
  449. 01/14/2021 01:30:14 PM ERROR Traceback (most recent call last):
  450. File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
  451. if data["operation_type"] == "add":
  452. TypeError: string indices must be integers
  453. 01/14/2021 01:30:19 PM INFO *************************************** NEW REQUEST ***************************************
  454. 01/14/2021 01:30:19 PM INFO raw data from request is {
  455. "video": [
  456. {
  457. "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",
  458. "photo_id": "5227271831775447110",
  459. "signature": "ed963b1333fe607d563d5cb0d916b65b",
  460. "stat_date": "2021-01-12 10:57:26",
  461. "channel_type": 0,
  462. "imageList": [
  463. "5ce93696dac9a326ff18505f49391297",
  464. "a368dd69d95539f26f5bee9d1580ccf8",
  465. "33b3e1a2cad48a2309d6ce351e6082fd",
  466. "56f6a8ec736dcdb17a2f052ebfcc255e",
  467. "addd5dc29c52ef863a40c6b688ce7951",
  468. "cb6e10ec5258145056aaafad647e1c36",
  469. "763344141ace6707c79f54bba3db5d1a",
  470. "86e061c34bf675690cb57943d8675130",
  471. "5d5258e7ff4af9dbb196e10ec4e878ce",
  472. "59ca244d88e7f23ef47744110e753bac",
  473. "260e0f08aebbf168b5fd80ee864b2e4c",
  474. "49a551a978d7dd182a04bd6af7e0c08d",
  475. "0c5c43f3b2c215e66d646fb9c03e110b",
  476. "44731b7d8b7e93ac12e8dcf3d34cc272",
  477. "2227f6cc89a5c0f242e04762b0444032"
  478. ]
  479. },
  480. {
  481. "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",
  482. "photo_id": "5211227760959967759",
  483. "signature": "fc7717ac4f08316e81aa463c720226c2",
  484. "stat_date": "2021-01-12 10:57:21",
  485. "channel_type": 0,
  486. "imageList": [
  487. "11836a6a4042b254a64bd9a6ca99f9b5",
  488. "82349cfa1e26bd17397a303b85dd0fbb",
  489. "04b1dc6793b0d2a65d8f8b45ce37744d",
  490. "4165fa246defbced026558d62ef30ed5",
  491. "064af2a19b313c0c436f6c2e4d2384eb",
  492. "13997aaa0294bcf1ca0c27a43aecceb2",
  493. "fb138ea0251f0a1c243cb287f1f865d8",
  494. "83e9292549f9617ceb5cb468cd5cce0d",
  495. "4bf798acb18747baacec0762d76e2006",
  496. "74d7b71c4e7be44d12cd7af03568053b",
  497. "b74620eeaa6c19620530b7cb553e954d",
  498. "2a1c907e5e3cf0cf2e871e5df16cca8f",
  499. "981660adc052f807ece9155124290ae1",
  500. "1247852f30b51511b510ef3b2d7f0b70",
  501. "b13119ff3fb326adfdcd04bb87324d02"
  502. ]
  503. }
  504. ],
  505. "operation_type": "add",
  506. "ai_strategy_remark":"打捞历史素材",
  507. "group_info": {
  508. "cpa_bid": 22000,
  509. "unit_name": "222"
  510. },
  511. "campaign_info": {
  512. "campaign_id": "",
  513. "campaign_name":"广告计划名称test",
  514. "campaign_type":2
  515. },
  516. "creative_info":{
  517. "creative_name":"创意名称",
  518. "action_bar_text":"下载抢购",
  519. "description":"不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!"
  520. },
  521. "account_id": 23212
  522. }
  523. 01/14/2021 01:30:19 PM ERROR Traceback (most recent call last):
  524. File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
  525. if data["operation_type"] == "add":
  526. TypeError: string indices must be integers
  527. 01/14/2021 01:30:20 PM INFO *************************************** NEW REQUEST ***************************************
  528. 01/14/2021 01:30:20 PM INFO raw data from request is {
  529. "video": [
  530. {
  531. "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",
  532. "photo_id": "5227271831775447110",
  533. "signature": "ed963b1333fe607d563d5cb0d916b65b",
  534. "stat_date": "2021-01-12 10:57:26",
  535. "channel_type": 0,
  536. "imageList": [
  537. "5ce93696dac9a326ff18505f49391297",
  538. "a368dd69d95539f26f5bee9d1580ccf8",
  539. "33b3e1a2cad48a2309d6ce351e6082fd",
  540. "56f6a8ec736dcdb17a2f052ebfcc255e",
  541. "addd5dc29c52ef863a40c6b688ce7951",
  542. "cb6e10ec5258145056aaafad647e1c36",
  543. "763344141ace6707c79f54bba3db5d1a",
  544. "86e061c34bf675690cb57943d8675130",
  545. "5d5258e7ff4af9dbb196e10ec4e878ce",
  546. "59ca244d88e7f23ef47744110e753bac",
  547. "260e0f08aebbf168b5fd80ee864b2e4c",
  548. "49a551a978d7dd182a04bd6af7e0c08d",
  549. "0c5c43f3b2c215e66d646fb9c03e110b",
  550. "44731b7d8b7e93ac12e8dcf3d34cc272",
  551. "2227f6cc89a5c0f242e04762b0444032"
  552. ]
  553. },
  554. {
  555. "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",
  556. "photo_id": "5211227760959967759",
  557. "signature": "fc7717ac4f08316e81aa463c720226c2",
  558. "stat_date": "2021-01-12 10:57:21",
  559. "channel_type": 0,
  560. "imageList": [
  561. "11836a6a4042b254a64bd9a6ca99f9b5",
  562. "82349cfa1e26bd17397a303b85dd0fbb",
  563. "04b1dc6793b0d2a65d8f8b45ce37744d",
  564. "4165fa246defbced026558d62ef30ed5",
  565. "064af2a19b313c0c436f6c2e4d2384eb",
  566. "13997aaa0294bcf1ca0c27a43aecceb2",
  567. "fb138ea0251f0a1c243cb287f1f865d8",
  568. "83e9292549f9617ceb5cb468cd5cce0d",
  569. "4bf798acb18747baacec0762d76e2006",
  570. "74d7b71c4e7be44d12cd7af03568053b",
  571. "b74620eeaa6c19620530b7cb553e954d",
  572. "2a1c907e5e3cf0cf2e871e5df16cca8f",
  573. "981660adc052f807ece9155124290ae1",
  574. "1247852f30b51511b510ef3b2d7f0b70",
  575. "b13119ff3fb326adfdcd04bb87324d02"
  576. ]
  577. }
  578. ],
  579. "operation_type": "add",
  580. "ai_strategy_remark":"打捞历史素材",
  581. "group_info": {
  582. "cpa_bid": 22000,
  583. "unit_name": "222"
  584. },
  585. "campaign_info": {
  586. "campaign_id": "",
  587. "campaign_name":"广告计划名称test",
  588. "campaign_type":2
  589. },
  590. "creative_info":{
  591. "creative_name":"创意名称",
  592. "action_bar_text":"下载抢购",
  593. "description":"不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!"
  594. },
  595. "account_id": 23212
  596. }
  597. 01/14/2021 01:30:20 PM ERROR Traceback (most recent call last):
  598. File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
  599. if data["operation_type"] == "add":
  600. TypeError: string indices must be integers
  601. 01/14/2021 01:30:22 PM INFO *************************************** NEW REQUEST ***************************************
  602. 01/14/2021 01:30:22 PM INFO raw data from request is {
  603. "video": [
  604. {
  605. "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",
  606. "photo_id": "5227271831775447110",
  607. "signature": "ed963b1333fe607d563d5cb0d916b65b",
  608. "stat_date": "2021-01-12 10:57:26",
  609. "channel_type": 0,
  610. "imageList": [
  611. "5ce93696dac9a326ff18505f49391297",
  612. "a368dd69d95539f26f5bee9d1580ccf8",
  613. "33b3e1a2cad48a2309d6ce351e6082fd",
  614. "56f6a8ec736dcdb17a2f052ebfcc255e",
  615. "addd5dc29c52ef863a40c6b688ce7951",
  616. "cb6e10ec5258145056aaafad647e1c36",
  617. "763344141ace6707c79f54bba3db5d1a",
  618. "86e061c34bf675690cb57943d8675130",
  619. "5d5258e7ff4af9dbb196e10ec4e878ce",
  620. "59ca244d88e7f23ef47744110e753bac",
  621. "260e0f08aebbf168b5fd80ee864b2e4c",
  622. "49a551a978d7dd182a04bd6af7e0c08d",
  623. "0c5c43f3b2c215e66d646fb9c03e110b",
  624. "44731b7d8b7e93ac12e8dcf3d34cc272",
  625. "2227f6cc89a5c0f242e04762b0444032"
  626. ]
  627. },
  628. {
  629. "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",
  630. "photo_id": "5211227760959967759",
  631. "signature": "fc7717ac4f08316e81aa463c720226c2",
  632. "stat_date": "2021-01-12 10:57:21",
  633. "channel_type": 0,
  634. "imageList": [
  635. "11836a6a4042b254a64bd9a6ca99f9b5",
  636. "82349cfa1e26bd17397a303b85dd0fbb",
  637. "04b1dc6793b0d2a65d8f8b45ce37744d",
  638. "4165fa246defbced026558d62ef30ed5",
  639. "064af2a19b313c0c436f6c2e4d2384eb",
  640. "13997aaa0294bcf1ca0c27a43aecceb2",
  641. "fb138ea0251f0a1c243cb287f1f865d8",
  642. "83e9292549f9617ceb5cb468cd5cce0d",
  643. "4bf798acb18747baacec0762d76e2006",
  644. "74d7b71c4e7be44d12cd7af03568053b",
  645. "b74620eeaa6c19620530b7cb553e954d",
  646. "2a1c907e5e3cf0cf2e871e5df16cca8f",
  647. "981660adc052f807ece9155124290ae1",
  648. "1247852f30b51511b510ef3b2d7f0b70",
  649. "b13119ff3fb326adfdcd04bb87324d02"
  650. ]
  651. }
  652. ],
  653. "operation_type": "add",
  654. "ai_strategy_remark":"打捞历史素材",
  655. "group_info": {
  656. "cpa_bid": 22000,
  657. "unit_name": "222"
  658. },
  659. "campaign_info": {
  660. "campaign_id": "",
  661. "campaign_name":"广告计划名称test",
  662. "campaign_type":2
  663. },
  664. "creative_info":{
  665. "creative_name":"创意名称",
  666. "action_bar_text":"下载抢购",
  667. "description":"不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!"
  668. },
  669. "account_id": 23212
  670. }
  671. 01/14/2021 01:30:22 PM ERROR Traceback (most recent call last):
  672. File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
  673. if data["operation_type"] == "add":
  674. TypeError: string indices must be integers
  675. 01/14/2021 01:30:33 PM INFO *************************************** NEW REQUEST ***************************************
  676. 01/14/2021 01:30:33 PM INFO raw data from request is {
  677. "video": [
  678. {
  679. "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",
  680. "photo_id": "5227271831775447110",
  681. "signature": "ed963b1333fe607d563d5cb0d916b65b",
  682. "stat_date": "2021-01-12 10:57:26",
  683. "channel_type": 0,
  684. "imageList": [
  685. "5ce93696dac9a326ff18505f49391297",
  686. "a368dd69d95539f26f5bee9d1580ccf8",
  687. "33b3e1a2cad48a2309d6ce351e6082fd",
  688. "56f6a8ec736dcdb17a2f052ebfcc255e",
  689. "addd5dc29c52ef863a40c6b688ce7951",
  690. "cb6e10ec5258145056aaafad647e1c36",
  691. "763344141ace6707c79f54bba3db5d1a",
  692. "86e061c34bf675690cb57943d8675130",
  693. "5d5258e7ff4af9dbb196e10ec4e878ce",
  694. "59ca244d88e7f23ef47744110e753bac",
  695. "260e0f08aebbf168b5fd80ee864b2e4c",
  696. "49a551a978d7dd182a04bd6af7e0c08d",
  697. "0c5c43f3b2c215e66d646fb9c03e110b",
  698. "44731b7d8b7e93ac12e8dcf3d34cc272",
  699. "2227f6cc89a5c0f242e04762b0444032"
  700. ]
  701. },
  702. {
  703. "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",
  704. "photo_id": "5211227760959967759",
  705. "signature": "fc7717ac4f08316e81aa463c720226c2",
  706. "stat_date": "2021-01-12 10:57:21",
  707. "channel_type": 0,
  708. "imageList": [
  709. "11836a6a4042b254a64bd9a6ca99f9b5",
  710. "82349cfa1e26bd17397a303b85dd0fbb",
  711. "04b1dc6793b0d2a65d8f8b45ce37744d",
  712. "4165fa246defbced026558d62ef30ed5",
  713. "064af2a19b313c0c436f6c2e4d2384eb",
  714. "13997aaa0294bcf1ca0c27a43aecceb2",
  715. "fb138ea0251f0a1c243cb287f1f865d8",
  716. "83e9292549f9617ceb5cb468cd5cce0d",
  717. "4bf798acb18747baacec0762d76e2006",
  718. "74d7b71c4e7be44d12cd7af03568053b",
  719. "b74620eeaa6c19620530b7cb553e954d",
  720. "2a1c907e5e3cf0cf2e871e5df16cca8f",
  721. "981660adc052f807ece9155124290ae1",
  722. "1247852f30b51511b510ef3b2d7f0b70",
  723. "b13119ff3fb326adfdcd04bb87324d02"
  724. ]
  725. }
  726. ],
  727. "operation_type": "add",
  728. "ai_strategy_remark":"打捞历史素材",
  729. "group_info": {
  730. "cpa_bid": 22000,
  731. "unit_name": "222"
  732. },
  733. "campaign_info": {
  734. "campaign_id": "",
  735. "campaign_name":"广告计划名称test",
  736. "campaign_type":2
  737. },
  738. "creative_info":{
  739. "creative_name":"创意名称",
  740. "action_bar_text":"下载抢购",
  741. "description":"不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!"
  742. },
  743. "account_id": 23212
  744. }
  745. 01/14/2021 01:30:33 PM ERROR Traceback (most recent call last):
  746. File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
  747. if data["operation_type"] == "add":
  748. TypeError: string indices must be integers
  749. 01/14/2021 01:54:35 PM INFO ai strategy request service started at 2021-01-14 13:54:35
  750. 01/14/2021 01:54:55 PM INFO *************************************** NEW REQUEST ***************************************
  751. 01/14/2021 01:54:56 PM INFO raw data from request is {
  752. "video": [
  753. {
  754. "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",
  755. "photo_id": "5227271831775447110",
  756. "signature": "ed963b1333fe607d563d5cb0d916b65b",
  757. "stat_date": "2021-01-12 10:57:26",
  758. "channel_type": 0,
  759. "imageList": [
  760. "5ce93696dac9a326ff18505f49391297",
  761. "a368dd69d95539f26f5bee9d1580ccf8",
  762. "33b3e1a2cad48a2309d6ce351e6082fd",
  763. "56f6a8ec736dcdb17a2f052ebfcc255e",
  764. "addd5dc29c52ef863a40c6b688ce7951",
  765. "cb6e10ec5258145056aaafad647e1c36",
  766. "763344141ace6707c79f54bba3db5d1a",
  767. "86e061c34bf675690cb57943d8675130",
  768. "5d5258e7ff4af9dbb196e10ec4e878ce",
  769. "59ca244d88e7f23ef47744110e753bac",
  770. "260e0f08aebbf168b5fd80ee864b2e4c",
  771. "49a551a978d7dd182a04bd6af7e0c08d",
  772. "0c5c43f3b2c215e66d646fb9c03e110b",
  773. "44731b7d8b7e93ac12e8dcf3d34cc272",
  774. "2227f6cc89a5c0f242e04762b0444032"
  775. ]
  776. },
  777. {
  778. "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",
  779. "photo_id": "5211227760959967759",
  780. "signature": "fc7717ac4f08316e81aa463c720226c2",
  781. "stat_date": "2021-01-12 10:57:21",
  782. "channel_type": 0,
  783. "imageList": [
  784. "11836a6a4042b254a64bd9a6ca99f9b5",
  785. "82349cfa1e26bd17397a303b85dd0fbb",
  786. "04b1dc6793b0d2a65d8f8b45ce37744d",
  787. "4165fa246defbced026558d62ef30ed5",
  788. "064af2a19b313c0c436f6c2e4d2384eb",
  789. "13997aaa0294bcf1ca0c27a43aecceb2",
  790. "fb138ea0251f0a1c243cb287f1f865d8",
  791. "83e9292549f9617ceb5cb468cd5cce0d",
  792. "4bf798acb18747baacec0762d76e2006",
  793. "74d7b71c4e7be44d12cd7af03568053b",
  794. "b74620eeaa6c19620530b7cb553e954d",
  795. "2a1c907e5e3cf0cf2e871e5df16cca8f",
  796. "981660adc052f807ece9155124290ae1",
  797. "1247852f30b51511b510ef3b2d7f0b70",
  798. "b13119ff3fb326adfdcd04bb87324d02"
  799. ]
  800. }
  801. ],
  802. "operation_type": "add",
  803. "ai_strategy_remark":"打捞历史素材",
  804. "group_info": {
  805. "cpa_bid": 22000,
  806. "unit_name": "222"
  807. },
  808. "campaign_info": {
  809. "campaign_id": "",
  810. "campaign_name":"广告计划名称test",
  811. "campaign_type":2
  812. },
  813. "creative_info":{
  814. "creative_name":"创意名称",
  815. "action_bar_text":"下载抢购",
  816. "description":"不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!"
  817. },
  818. "account_id": 23212
  819. }
  820. 01/14/2021 02:02:05 PM INFO ai strategy request service started at 2021-01-14 14:02:05
  821. 01/14/2021 02:02:23 PM INFO *************************************** NEW REQUEST ***************************************
  822. 01/14/2021 02:02:23 PM INFO raw data from request is {'video': [{'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']}], 'operation_type': 'add', 'ai_strategy_remark': '打捞历史素材', 'group_info': {'cpa_bid': 22000, 'unit_name': '222'}, 'campaign_info': {'campaign_id': '', 'campaign_name': '广告计划名称test', 'campaign_type': 2}, 'creative_info': {'creative_name': '创意名称', 'action_bar_text': '下载抢购', 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}, 'account_id': 23212}
  823. 01/14/2021 02:08:30 PM ERROR Traceback (most recent call last):
  824. File "E:\ai_ads\ai_strategy_request_handler.py", line 37, in post
  825. inst.write_intelligence_strategy_table()
  826. File "E:\ai_ads\ai_strategy_request_handler.py", line 109, in write_intelligence_strategy_table
  827. df.to_sql(name="ctop_ai_kuaishou_intelligence_strategy", con=engine, if_exists='append', index=False)
  828. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\core\generic.py", line 2786, in to_sql
  829. method=method,
  830. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 599, in to_sql
  831. method=method,
  832. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1397, in to_sql
  833. table.insert(chunksize, method=method)
  834. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 831, in insert
  835. exec_insert(conn, keys, chunk_iter)
  836. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 748, in _execute_insert
  837. conn.execute(self.table.insert(), data)
  838. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
  839. return meth(self, multiparams, params)
  840. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
  841. return connection._execute_clauseelement(self, multiparams, params)
  842. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
  843. distilled_params,
  844. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  845. e, statement, parameters, cursor, context
  846. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1514, in _handle_dbapi_exception
  847. util.raise_(exc_info[1], with_traceback=exc_info[2])
  848. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  849. raise exception
  850. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  851. cursor, statement, parameters, context
  852. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  853. cursor.execute(statement, parameters)
  854. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 146, in execute
  855. query = self.mogrify(query, args)
  856. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 125, in mogrify
  857. query = query % self._escape_args(args, conn)
  858. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 109, in _escape_args
  859. return {key: conn.literal(val) for (key, val) in args.items()}
  860. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 109, in <dictcomp>
  861. return {key: conn.literal(val) for (key, val) in args.items()}
  862. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 517, in literal
  863. return self.escape(obj, self.encoders)
  864. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 510, in escape
  865. return converters.escape_item(obj, self.charset, mapping=mapping)
  866. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\converters.py", line 23, in escape_item
  867. val = encoder(val, charset, mapping)
  868. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\converters.py", line 32, in escape_dict
  869. quoted = escape_item(v, charset, mapping)
  870. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\converters.py", line 23, in escape_item
  871. val = encoder(val, charset, mapping)
  872. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\converters.py", line 42, in escape_sequence
  873. return "(" + ",".join(n) + ")"
  874. TypeError: sequence item 0: expected str instance, dict found
  875. 01/14/2021 02:12:31 PM INFO ai strategy request service started at 2021-01-14 14:12:31
  876. 01/14/2021 02:12:48 PM INFO *************************************** NEW REQUEST ***************************************
  877. 01/14/2021 02:12:49 PM INFO raw data from request is {'video': [{'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']}], 'operation_type': 'add', 'ai_strategy_remark': '打捞历史素材', 'group_info': {'cpa_bid': 22000, 'unit_name': '222'}, 'campaign_info': {'campaign_id': '', 'campaign_name': '广告计划名称test', 'campaign_type': 2}, 'creative_info': {'creative_name': '创意名称', 'action_bar_text': '下载抢购', 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}, 'account_id': 23212}
  878. 01/14/2021 02:12:59 PM ERROR Traceback (most recent call last):
  879. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  880. cursor, statement, parameters, context
  881. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  882. cursor.execute(statement, parameters)
  883. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
  884. result = self._query(query)
  885. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
  886. conn.query(q)
  887. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
  888. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  889. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
  890. result.read()
  891. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
  892. first_packet = self.connection._read_packet()
  893. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  894. packet.raise_for_error()
  895. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  896. err.raise_mysql_exception(self._data)
  897. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  898. raise errorclass(errno, errval)
  899. pymysql.err.IntegrityError: (1048, "Column 'ai_strategy_id' cannot be null")
  900. The above exception was the direct cause of the following exception:
  901. Traceback (most recent call last):
  902. File "E:\ai_ads\ai_strategy_request_handler.py", line 39, in post
  903. if inst.add_campaign() == -1:
  904. File "E:\ai_ads\ai_strategy_request_handler.py", line 155, in add_campaign
  905. df.to_sql(name="ctop_ai_kuaishou_campaign_level_operation_record", con=engine, if_exists='append', index=False)
  906. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\core\generic.py", line 2786, in to_sql
  907. method=method,
  908. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 599, in to_sql
  909. method=method,
  910. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1405, in to_sql
  911. raise err
  912. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1397, in to_sql
  913. table.insert(chunksize, method=method)
  914. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 831, in insert
  915. exec_insert(conn, keys, chunk_iter)
  916. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 748, in _execute_insert
  917. conn.execute(self.table.insert(), data)
  918. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
  919. return meth(self, multiparams, params)
  920. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
  921. return connection._execute_clauseelement(self, multiparams, params)
  922. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
  923. distilled_params,
  924. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  925. e, statement, parameters, cursor, context
  926. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  927. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  928. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  929. raise exception
  930. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  931. cursor, statement, parameters, context
  932. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  933. cursor.execute(statement, parameters)
  934. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
  935. result = self._query(query)
  936. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
  937. conn.query(q)
  938. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
  939. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  940. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
  941. result.read()
  942. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
  943. first_packet = self.connection._read_packet()
  944. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  945. packet.raise_for_error()
  946. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  947. err.raise_mysql_exception(self._data)
  948. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  949. raise errorclass(errno, errval)
  950. sqlalchemy.exc.IntegrityError: (pymysql.err.IntegrityError) (1048, "Column 'ai_strategy_id' cannot be null")
  951. [SQL: INSERT INTO ctop_ai_kuaishou_campaign_level_operation_record (campaign_uuid, account_id, ai_strategy_id, campaign_name, campaign_id, campaign_type, operation_type, campaign_create_time, create_time) VALUES (%(campaign_uuid)s, %(account_id)s, %(ai_strategy_id)s, %(campaign_name)s, %(campaign_id)s, %(campaign_type)s, %(operation_type)s, %(campaign_create_time)s, %(create_time)s)]
  952. [parameters: {'campaign_uuid': '24e40154-ff63-482c-9302-4682eae86191', 'account_id': 23212, 'ai_strategy_id': None, 'campaign_name': '广告计划名称test', 'campaign_id': 30956133, 'campaign_type': 2, 'operation_type': 'add', 'campaign_create_time': '2021-01-13 13:50:16', 'create_time': datetime.datetime(2021, 1, 14, 14, 12, 56, 35246)}]
  953. (Background on this error at: http://sqlalche.me/e/13/gkpj)
  954. 01/14/2021 02:14:33 PM INFO ai strategy request service started at 2021-01-14 14:14:33
  955. 01/14/2021 02:14:40 PM INFO *************************************** NEW REQUEST ***************************************
  956. 01/14/2021 02:14:40 PM INFO raw data from request is {'video': [{'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']}], 'operation_type': 'add', 'ai_strategy_remark': '打捞历史素材', 'group_info': {'cpa_bid': 22000, 'unit_name': '222'}, 'campaign_info': {'campaign_id': '', 'campaign_name': '广告计划名称test', 'campaign_type': 2}, 'creative_info': {'creative_name': '创意名称', 'action_bar_text': '下载抢购', 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}, 'account_id': 23212}
  957. 01/14/2021 02:14:46 PM ERROR Traceback (most recent call last):
  958. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  959. cursor, statement, parameters, context
  960. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  961. cursor.execute(statement, parameters)
  962. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
  963. result = self._query(query)
  964. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
  965. conn.query(q)
  966. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
  967. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  968. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
  969. result.read()
  970. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
  971. first_packet = self.connection._read_packet()
  972. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  973. packet.raise_for_error()
  974. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  975. err.raise_mysql_exception(self._data)
  976. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  977. raise errorclass(errno, errval)
  978. pymysql.err.OperationalError: (1054, "Unknown column 'ai_strategy_uuid' in 'field list'")
  979. The above exception was the direct cause of the following exception:
  980. Traceback (most recent call last):
  981. File "E:\ai_ads\ai_strategy_request_handler.py", line 39, in post
  982. if inst.add_campaign() == -1:
  983. File "E:\ai_ads\ai_strategy_request_handler.py", line 154, in add_campaign
  984. df.to_sql(name="ctop_ai_kuaishou_campaign_level_operation_record", con=engine, if_exists='append', index=False)
  985. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\core\generic.py", line 2786, in to_sql
  986. method=method,
  987. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 599, in to_sql
  988. method=method,
  989. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1405, in to_sql
  990. raise err
  991. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1397, in to_sql
  992. table.insert(chunksize, method=method)
  993. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 831, in insert
  994. exec_insert(conn, keys, chunk_iter)
  995. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 748, in _execute_insert
  996. conn.execute(self.table.insert(), data)
  997. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
  998. return meth(self, multiparams, params)
  999. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
  1000. return connection._execute_clauseelement(self, multiparams, params)
  1001. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
  1002. distilled_params,
  1003. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  1004. e, statement, parameters, cursor, context
  1005. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  1006. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  1007. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  1008. raise exception
  1009. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  1010. cursor, statement, parameters, context
  1011. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  1012. cursor.execute(statement, parameters)
  1013. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
  1014. result = self._query(query)
  1015. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
  1016. conn.query(q)
  1017. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
  1018. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  1019. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
  1020. result.read()
  1021. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
  1022. first_packet = self.connection._read_packet()
  1023. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  1024. packet.raise_for_error()
  1025. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  1026. err.raise_mysql_exception(self._data)
  1027. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  1028. raise errorclass(errno, errval)
  1029. sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1054, "Unknown column 'ai_strategy_uuid' in 'field list'")
  1030. [SQL: INSERT INTO ctop_ai_kuaishou_campaign_level_operation_record (campaign_uuid, account_id, ai_strategy_uuid, campaign_name, campaign_id, campaign_type, operation_type, campaign_create_time, create_time) VALUES (%(campaign_uuid)s, %(account_id)s, %(ai_strategy_uuid)s, %(campaign_name)s, %(campaign_id)s, %(campaign_type)s, %(operation_type)s, %(campaign_create_time)s, %(create_time)s)]
  1031. [parameters: {'campaign_uuid': '8c73f237-5da7-49ef-96c1-762b8dc80fe7', 'account_id': 23212, 'ai_strategy_uuid': '446b54b2-00e1-4330-95c7-7ed7685b803e', 'campaign_name': '广告计划名称test', 'campaign_id': 30956133, 'campaign_type': 2, 'operation_type': 'add', 'campaign_create_time': '2021-01-13 13:50:16', 'create_time': datetime.datetime(2021, 1, 14, 14, 14, 44, 432470)}]
  1032. (Background on this error at: http://sqlalche.me/e/13/e3q8)
  1033. 01/14/2021 02:16:39 PM INFO ai strategy request service started at 2021-01-14 14:16:39
  1034. 01/14/2021 02:16:48 PM INFO *************************************** NEW REQUEST ***************************************
  1035. 01/14/2021 02:16:49 PM INFO raw data from request is {'video': [{'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']}], 'operation_type': 'add', 'ai_strategy_remark': '打捞历史素材', 'group_info': {'cpa_bid': 22000, 'unit_name': '222'}, 'campaign_info': {'campaign_id': '', 'campaign_name': '广告计划名称test', 'campaign_type': 2}, 'creative_info': {'creative_name': '创意名称', 'action_bar_text': '下载抢购', 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}, 'account_id': 23212}
  1036. 01/14/2021 02:16:54 PM ERROR Traceback (most recent call last):
  1037. File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
  1038. inst.get_group_dict()
  1039. File "E:\ai_ads\ai_strategy_request_handler.py", line 191, in get_group_dict
  1040. basic_group_info = {'template_id': self.advertiser_strategy['template_id'],
  1041. KeyError: 'template_id'
  1042. 01/14/2021 02:18:03 PM INFO ai strategy request service started at 2021-01-14 14:18:03
  1043. 01/14/2021 02:18:08 PM INFO *************************************** NEW REQUEST ***************************************
  1044. 01/14/2021 02:18:09 PM INFO raw data from request is {'video': [{'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']}], 'operation_type': 'add', 'ai_strategy_remark': '打捞历史素材', 'group_info': {'cpa_bid': 22000, 'unit_name': '222'}, 'campaign_info': {'campaign_id': '', 'campaign_name': '广告计划名称test', 'campaign_type': 2}, 'creative_info': {'creative_name': '创意名称', 'action_bar_text': '下载抢购', 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}, 'account_id': 23212}
  1045. 01/14/2021 02:18:12 PM ERROR Traceback (most recent call last):
  1046. File "E:\ai_ads\ai_strategy_request_handler.py", line 36, in post
  1047. inst.get_advertiser_strategy_info()
  1048. File "E:\ai_ads\ai_strategy_request_handler.py", line 89, in get_advertiser_strategy_info
  1049. self.advertiser_strategy = advertiser_strategy_df.T.to_dict()[0]
  1050. KeyError: 0
  1051. 01/14/2021 02:19:35 PM INFO ai strategy request service started at 2021-01-14 14:19:35
  1052. 01/14/2021 02:19:43 PM INFO *************************************** NEW REQUEST ***************************************
  1053. 01/14/2021 02:19:43 PM INFO raw data from request is {'video': [{'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']}], 'operation_type': 'add', 'ai_strategy_remark': '打捞历史素材', 'group_info': {'cpa_bid': 22000, 'unit_name': '222'}, 'campaign_info': {'campaign_id': '', 'campaign_name': '广告计划名称test', 'campaign_type': 2}, 'creative_info': {'creative_name': '创意名称', 'action_bar_text': '下载抢购', 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}, 'account_id': 23212}
  1054. 01/14/2021 02:19:46 PM ERROR Traceback (most recent call last):
  1055. File "E:\ai_ads\ai_strategy_request_handler.py", line 36, in post
  1056. inst.get_advertiser_strategy_info()
  1057. File "E:\ai_ads\ai_strategy_request_handler.py", line 89, in get_advertiser_strategy_info
  1058. self.advertiser_strategy_id = advertiser_strategy_df['id'].values[0]
  1059. IndexError: index 0 is out of bounds for axis 0 with size 0
  1060. 01/14/2021 02:34:37 PM INFO ai strategy request service started at 2021-01-14 14:34:37
  1061. 01/14/2021 02:34:46 PM INFO *************************************** NEW REQUEST ***************************************
  1062. 01/14/2021 02:34:46 PM INFO raw data from request is {'video': [{'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']}], 'operation_type': 'add', 'ai_strategy_remark': '打捞历史素材', 'group_info': {'cpa_bid': 22000, 'unit_name': '222'}, 'campaign_info': {'campaign_id': '', 'campaign_name': '广告计划名称test', 'campaign_type': 2}, 'creative_info': {'creative_name': '创意名称', 'action_bar_text': '下载抢购', 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}, 'account_id': 23212}
  1063. 01/14/2021 02:35:16 PM ERROR Traceback (most recent call last):
  1064. File "E:\ai_ads\ai_strategy_request_handler.py", line 39, in post
  1065. if inst.add_campaign() == -1:
  1066. File "E:\ai_ads\ai_strategy_request_handler.py", line 116, in add_campaign
  1067. if self.campaign_info['campaign_type'] != self.advertiser_strategy['campaign_type']:
  1068. KeyError: 'campaign_type'
  1069. 01/14/2021 02:41:45 PM INFO ai strategy request service started at 2021-01-14 14:41:45
  1070. 01/14/2021 02:41:57 PM INFO ai strategy request service started at 2021-01-14 14:41:57
  1071. 01/14/2021 02:42:06 PM INFO *************************************** NEW REQUEST ***************************************
  1072. 01/14/2021 02:42:07 PM INFO raw data from request is {'video': [{'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']}], 'operation_type': 'add', 'ai_strategy_remark': '打捞历史素材', 'group_info': {'cpa_bid': 22000, 'unit_name': '222'}, 'campaign_info': {'campaign_id': '', 'campaign_name': '广告计划名称test', 'campaign_type': 2}, 'creative_info': {'creative_name': '创意名称', 'action_bar_text': '下载抢购', 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}, 'account_id': 23212}
  1073. 01/14/2021 02:42:22 PM ERROR Traceback (most recent call last):
  1074. File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
  1075. inst.get_group_dict()
  1076. File "E:\ai_ads\ai_strategy_request_handler.py", line 207, in get_group_dict
  1077. 'day_budget': self.advertiser_strategy['day_budget'],
  1078. KeyError: 'day_budget'
  1079. 01/14/2021 02:42:51 PM INFO ai strategy request service started at 2021-01-14 14:42:51
  1080. 01/14/2021 02:43:08 PM INFO *************************************** NEW REQUEST ***************************************
  1081. 01/14/2021 02:43:09 PM INFO raw data from request is {'video': [{'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']}], 'operation_type': 'add', 'ai_strategy_remark': '打捞历史素材', 'group_info': {'cpa_bid': 22000, 'unit_name': '222'}, 'campaign_info': {'campaign_id': '', 'campaign_name': '广告计划名称test', 'campaign_type': 2}, 'creative_info': {'creative_name': '创意名称', 'action_bar_text': '下载抢购', 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}, 'account_id': 23212}
  1082. 01/14/2021 02:43:15 PM ERROR Traceback (most recent call last):
  1083. File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
  1084. inst.get_group_dict()
  1085. File "E:\ai_ads\ai_strategy_request_handler.py", line 243, in get_group_dict
  1086. 'is_open': self.advertiser_strategy['is_open'],
  1087. KeyError: 'is_open'
  1088. 01/14/2021 02:44:32 PM INFO ai strategy request service started at 2021-01-14 14:44:32
  1089. 01/14/2021 02:44:38 PM INFO *************************************** NEW REQUEST ***************************************
  1090. 01/14/2021 02:44:39 PM INFO raw data from request is {'video': [{'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']}], 'operation_type': 'add', 'ai_strategy_remark': '打捞历史素材', 'group_info': {'cpa_bid': 22000, 'unit_name': '222'}, 'campaign_info': {'campaign_id': '', 'campaign_name': '广告计划名称test', 'campaign_type': 2}, 'creative_info': {'creative_name': '创意名称', 'action_bar_text': '下载抢购', 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}, 'account_id': 23212}
  1091. 01/14/2021 02:44:45 PM ERROR Traceback (most recent call last):
  1092. File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
  1093. inst.get_group_dict()
  1094. File "E:\ai_ads\ai_strategy_request_handler.py", line 263, in get_group_dict
  1095. single_group_info_to_db['ai_strategy_id'] = self.ai_strategy_id
  1096. AttributeError: 'ParseAddCampaignOrAddGroupRequest' object has no attribute 'ai_strategy_id'
  1097. 01/14/2021 02:46:18 PM INFO ai strategy request service started at 2021-01-14 14:46:18
  1098. 01/14/2021 02:46:24 PM INFO *************************************** NEW REQUEST ***************************************
  1099. 01/14/2021 02:46:25 PM INFO raw data from request is {'video': [{'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']}], 'operation_type': 'add', 'ai_strategy_remark': '打捞历史素材', 'group_info': {'cpa_bid': 22000, 'unit_name': '222'}, 'campaign_info': {'campaign_id': '', 'campaign_name': '广告计划名称test', 'campaign_type': 2}, 'creative_info': {'creative_name': '创意名称', 'action_bar_text': '下载抢购', 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}, 'account_id': 23212}
  1100. 01/14/2021 02:46:32 PM ERROR Traceback (most recent call last):
  1101. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  1102. cursor, statement, parameters, context
  1103. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  1104. cursor.execute(statement, parameters)
  1105. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
  1106. result = self._query(query)
  1107. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
  1108. conn.query(q)
  1109. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
  1110. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  1111. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
  1112. result.read()
  1113. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
  1114. first_packet = self.connection._read_packet()
  1115. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  1116. packet.raise_for_error()
  1117. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  1118. err.raise_mysql_exception(self._data)
  1119. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  1120. raise errorclass(errno, errval)
  1121. pymysql.err.OperationalError: (1364, "Field 'unit_id' doesn't have a default value")
  1122. The above exception was the direct cause of the following exception:
  1123. Traceback (most recent call last):
  1124. File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
  1125. inst.get_group_dict()
  1126. File "E:\ai_ads\ai_strategy_request_handler.py", line 273, in get_group_dict
  1127. index=False)
  1128. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\core\generic.py", line 2786, in to_sql
  1129. method=method,
  1130. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 599, in to_sql
  1131. method=method,
  1132. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1405, in to_sql
  1133. raise err
  1134. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1397, in to_sql
  1135. table.insert(chunksize, method=method)
  1136. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 831, in insert
  1137. exec_insert(conn, keys, chunk_iter)
  1138. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 748, in _execute_insert
  1139. conn.execute(self.table.insert(), data)
  1140. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
  1141. return meth(self, multiparams, params)
  1142. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
  1143. return connection._execute_clauseelement(self, multiparams, params)
  1144. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
  1145. distilled_params,
  1146. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  1147. e, statement, parameters, cursor, context
  1148. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  1149. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  1150. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  1151. raise exception
  1152. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  1153. cursor, statement, parameters, context
  1154. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  1155. cursor.execute(statement, parameters)
  1156. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
  1157. result = self._query(query)
  1158. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
  1159. conn.query(q)
  1160. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
  1161. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  1162. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
  1163. result.read()
  1164. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
  1165. first_packet = self.connection._read_packet()
  1166. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  1167. packet.raise_for_error()
  1168. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  1169. err.raise_mysql_exception(self._data)
  1170. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  1171. raise errorclass(errno, errval)
  1172. sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1364, "Field 'unit_id' doesn't have a default value")
  1173. [SQL: INSERT INTO ctop_ai_kuaishou_unit_level_operation_record (group_uuid, template_id, bid_type, use_app_market, app_store, bid, cpa_bid, smart_bid, ocpx_action_type, deep_conversion_type, roi_ratio, scene_id, unit_type, begin_time, end_time, schedule_time, convert_id, url_type, web_uri_type, url, schema_uri, app_id, show_mode, speed, site_type, gift_data, video_landing_page, auto_target, auto_create_photo, region, district_ids, user_type, age_min, age_max, ages_range, gender, platform_os, android_osv, ios_osv, network, device_brand, device_price, business_interest_type, business_interest, fans_star, interest_video, app_interest, app_ids, filter_converted_level, population, exclude_population, paid_audience, is_open, no_age_break, no_gender_break, no_area_break, behavior_interest, unit_name, ai_strategy_uuid, account_id, campaign_id, create_time, operation_type) VALUES (%(group_uuid)s, %(template_id)s, %(bid_type)s, %(use_app_market)s, %(app_store)s, %(bid)s, %(cpa_bid)s, %(smart_bid)s, %(ocpx_action_type)s, %(deep_conversion_type)s, %(roi_ratio)s, %(scene_id)s, %(unit_type)s, %(begin_time)s, %(end_time)s, %(schedule_time)s, %(convert_id)s, %(url_type)s, %(web_uri_type)s, %(url)s, %(schema_uri)s, %(app_id)s, %(show_mode)s, %(speed)s, %(site_type)s, %(gift_data)s, %(video_landing_page)s, %(auto_target)s, %(auto_create_photo)s, %(region)s, %(district_ids)s, %(user_type)s, %(age_min)s, %(age_max)s, %(ages_range)s, %(gender)s, %(platform_os)s, %(android_osv)s, %(ios_osv)s, %(network)s, %(device_brand)s, %(device_price)s, %(business_interest_type)s, %(business_interest)s, %(fans_star)s, %(interest_video)s, %(app_interest)s, %(app_ids)s, %(filter_converted_level)s, %(population)s, %(exclude_population)s, %(paid_audience)s, %(is_open)s, %(no_age_break)s, %(no_gender_break)s, %(no_area_break)s, %(behavior_interest)s, %(unit_name)s, %(ai_strategy_uuid)s, %(account_id)s, %(campaign_id)s, %(create_time)s, %(operation_type)s)]
  1174. [parameters: {'group_uuid': '67d22f1d-92d0-48c7-af60-b08886f81e86', 'template_id': None, 'bid_type': None, 'use_app_market': None, 'app_store': None, 'bid': None, 'cpa_bid': 22000, 'smart_bid': None, 'ocpx_action_type': None, 'deep_conversion_type': None, 'roi_ratio': None, 'scene_id': None, 'unit_type': None, 'begin_time': None, 'end_time': None, 'schedule_time': None, 'convert_id': None, 'url_type': None, 'web_uri_type': None, 'url': None, 'schema_uri': None, 'app_id': None, 'show_mode': None, 'speed': None, 'site_type': None, 'gift_data': None, 'video_landing_page': None, 'auto_target': None, 'auto_create_photo': None, 'region': None, 'district_ids': None, 'user_type': None, 'age_min': None, 'age_max': None, 'ages_range': None, 'gender': None, 'platform_os': None, 'android_osv': None, 'ios_osv': None, 'network': None, 'device_brand': None, 'device_price': None, 'business_interest_type': None, 'business_interest': None, 'fans_star': None, 'interest_video': None, 'app_interest': None, 'app_ids': None, 'filter_converted_level': None, 'population': None, 'exclude_population': None, 'paid_audience': None, 'is_open': None, 'no_age_break': None, 'no_gender_break': None, 'no_area_break': None, 'behavior_interest': '{}', 'unit_name': '222-1', 'ai_strategy_uuid': 'f2736c30-b9c3-41e6-a0f7-e722002393f9', 'account_id': 23212, 'campaign_id': 30956133, 'create_time': datetime.datetime(2021, 1, 14, 14, 46, 29, 779931), 'operation_type': 'add'}]
  1175. (Background on this error at: http://sqlalche.me/e/13/e3q8)
  1176. 01/14/2021 02:48:15 PM INFO ai strategy request service started at 2021-01-14 14:48:15
  1177. 01/14/2021 02:48:26 PM INFO *************************************** NEW REQUEST ***************************************
  1178. 01/14/2021 02:48:26 PM INFO raw data from request is {'video': [{'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']}], 'operation_type': 'add', 'ai_strategy_remark': '打捞历史素材', 'group_info': {'cpa_bid': 22000, 'unit_name': '222'}, 'campaign_info': {'campaign_id': '', 'campaign_name': '广告计划名称test', 'campaign_type': 2}, 'creative_info': {'creative_name': '创意名称', 'action_bar_text': '下载抢购', 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}, 'account_id': 23212}
  1179. 01/14/2021 02:48:31 PM ERROR Traceback (most recent call last):
  1180. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  1181. cursor, statement, parameters, context
  1182. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  1183. cursor.execute(statement, parameters)
  1184. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
  1185. result = self._query(query)
  1186. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
  1187. conn.query(q)
  1188. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
  1189. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  1190. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
  1191. result.read()
  1192. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
  1193. first_packet = self.connection._read_packet()
  1194. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  1195. packet.raise_for_error()
  1196. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  1197. err.raise_mysql_exception(self._data)
  1198. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  1199. raise errorclass(errno, errval)
  1200. pymysql.err.IntegrityError: (1048, "Column 'bid_type' cannot be null")
  1201. The above exception was the direct cause of the following exception:
  1202. Traceback (most recent call last):
  1203. File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
  1204. inst.get_group_dict()
  1205. File "E:\ai_ads\ai_strategy_request_handler.py", line 273, in get_group_dict
  1206. index=False)
  1207. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\core\generic.py", line 2786, in to_sql
  1208. method=method,
  1209. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 599, in to_sql
  1210. method=method,
  1211. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1405, in to_sql
  1212. raise err
  1213. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1397, in to_sql
  1214. table.insert(chunksize, method=method)
  1215. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 831, in insert
  1216. exec_insert(conn, keys, chunk_iter)
  1217. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 748, in _execute_insert
  1218. conn.execute(self.table.insert(), data)
  1219. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
  1220. return meth(self, multiparams, params)
  1221. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
  1222. return connection._execute_clauseelement(self, multiparams, params)
  1223. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
  1224. distilled_params,
  1225. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  1226. e, statement, parameters, cursor, context
  1227. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  1228. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  1229. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  1230. raise exception
  1231. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  1232. cursor, statement, parameters, context
  1233. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  1234. cursor.execute(statement, parameters)
  1235. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
  1236. result = self._query(query)
  1237. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
  1238. conn.query(q)
  1239. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
  1240. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  1241. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
  1242. result.read()
  1243. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
  1244. first_packet = self.connection._read_packet()
  1245. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  1246. packet.raise_for_error()
  1247. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  1248. err.raise_mysql_exception(self._data)
  1249. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  1250. raise errorclass(errno, errval)
  1251. sqlalchemy.exc.IntegrityError: (pymysql.err.IntegrityError) (1048, "Column 'bid_type' cannot be null")
  1252. [SQL: INSERT INTO ctop_ai_kuaishou_unit_level_operation_record (group_uuid, template_id, bid_type, use_app_market, app_store, bid, cpa_bid, smart_bid, ocpx_action_type, deep_conversion_type, roi_ratio, scene_id, unit_type, begin_time, end_time, schedule_time, convert_id, url_type, web_uri_type, url, schema_uri, app_id, show_mode, speed, site_type, gift_data, video_landing_page, auto_target, auto_create_photo, region, district_ids, user_type, age_min, age_max, ages_range, gender, platform_os, android_osv, ios_osv, network, device_brand, device_price, business_interest_type, business_interest, fans_star, interest_video, app_interest, app_ids, filter_converted_level, population, exclude_population, paid_audience, is_open, no_age_break, no_gender_break, no_area_break, behavior_interest, unit_name, ai_strategy_uuid, account_id, campaign_id, create_time, operation_type) VALUES (%(group_uuid)s, %(template_id)s, %(bid_type)s, %(use_app_market)s, %(app_store)s, %(bid)s, %(cpa_bid)s, %(smart_bid)s, %(ocpx_action_type)s, %(deep_conversion_type)s, %(roi_ratio)s, %(scene_id)s, %(unit_type)s, %(begin_time)s, %(end_time)s, %(schedule_time)s, %(convert_id)s, %(url_type)s, %(web_uri_type)s, %(url)s, %(schema_uri)s, %(app_id)s, %(show_mode)s, %(speed)s, %(site_type)s, %(gift_data)s, %(video_landing_page)s, %(auto_target)s, %(auto_create_photo)s, %(region)s, %(district_ids)s, %(user_type)s, %(age_min)s, %(age_max)s, %(ages_range)s, %(gender)s, %(platform_os)s, %(android_osv)s, %(ios_osv)s, %(network)s, %(device_brand)s, %(device_price)s, %(business_interest_type)s, %(business_interest)s, %(fans_star)s, %(interest_video)s, %(app_interest)s, %(app_ids)s, %(filter_converted_level)s, %(population)s, %(exclude_population)s, %(paid_audience)s, %(is_open)s, %(no_age_break)s, %(no_gender_break)s, %(no_area_break)s, %(behavior_interest)s, %(unit_name)s, %(ai_strategy_uuid)s, %(account_id)s, %(campaign_id)s, %(create_time)s, %(operation_type)s)]
  1253. [parameters: {'group_uuid': '7fe06093-52eb-4087-b402-69eebe17c0b0', 'template_id': None, 'bid_type': None, 'use_app_market': None, 'app_store': None, 'bid': None, 'cpa_bid': 22000, 'smart_bid': None, 'ocpx_action_type': None, 'deep_conversion_type': None, 'roi_ratio': None, 'scene_id': None, 'unit_type': None, 'begin_time': None, 'end_time': None, 'schedule_time': None, 'convert_id': None, 'url_type': None, 'web_uri_type': None, 'url': None, 'schema_uri': None, 'app_id': None, 'show_mode': None, 'speed': None, 'site_type': None, 'gift_data': None, 'video_landing_page': None, 'auto_target': None, 'auto_create_photo': None, 'region': None, 'district_ids': None, 'user_type': None, 'age_min': None, 'age_max': None, 'ages_range': None, 'gender': None, 'platform_os': None, 'android_osv': None, 'ios_osv': None, 'network': None, 'device_brand': None, 'device_price': None, 'business_interest_type': None, 'business_interest': None, 'fans_star': None, 'interest_video': None, 'app_interest': None, 'app_ids': None, 'filter_converted_level': None, 'population': None, 'exclude_population': None, 'paid_audience': None, 'is_open': None, 'no_age_break': None, 'no_gender_break': None, 'no_area_break': None, 'behavior_interest': '{}', 'unit_name': '222-1', 'ai_strategy_uuid': '014b6510-c59c-4720-9cea-2c378279741f', 'account_id': 23212, 'campaign_id': 30956133, 'create_time': datetime.datetime(2021, 1, 14, 14, 48, 29, 934222), 'operation_type': 'add'}]
  1254. (Background on this error at: http://sqlalche.me/e/13/gkpj)
  1255. 01/14/2021 02:49:19 PM INFO ai strategy request service started at 2021-01-14 14:49:19
  1256. 01/14/2021 02:49:27 PM INFO *************************************** NEW REQUEST ***************************************
  1257. 01/14/2021 02:49:27 PM INFO raw data from request is {'video': [{'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']}], 'operation_type': 'add', 'ai_strategy_remark': '打捞历史素材', 'group_info': {'cpa_bid': 22000, 'unit_name': '222'}, 'campaign_info': {'campaign_id': '', 'campaign_name': '广告计划名称test', 'campaign_type': 2}, 'creative_info': {'creative_name': '创意名称', 'action_bar_text': '下载抢购', 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}, 'account_id': 23212}
  1258. 01/14/2021 02:49:33 PM ERROR Traceback (most recent call last):
  1259. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  1260. cursor, statement, parameters, context
  1261. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  1262. cursor.execute(statement, parameters)
  1263. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
  1264. result = self._query(query)
  1265. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
  1266. conn.query(q)
  1267. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
  1268. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  1269. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
  1270. result.read()
  1271. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
  1272. first_packet = self.connection._read_packet()
  1273. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  1274. packet.raise_for_error()
  1275. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  1276. err.raise_mysql_exception(self._data)
  1277. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  1278. raise errorclass(errno, errval)
  1279. pymysql.err.DataError: (1366, "Incorrect integer value: 'add' for column `jeecg-boot`.`ctop_ai_kuaishou_unit_level_operation_record`.`operation_type` at row 1")
  1280. The above exception was the direct cause of the following exception:
  1281. Traceback (most recent call last):
  1282. File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
  1283. inst.get_group_dict()
  1284. File "E:\ai_ads\ai_strategy_request_handler.py", line 273, in get_group_dict
  1285. index=False)
  1286. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\core\generic.py", line 2786, in to_sql
  1287. method=method,
  1288. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 599, in to_sql
  1289. method=method,
  1290. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1405, in to_sql
  1291. raise err
  1292. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1397, in to_sql
  1293. table.insert(chunksize, method=method)
  1294. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 831, in insert
  1295. exec_insert(conn, keys, chunk_iter)
  1296. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 748, in _execute_insert
  1297. conn.execute(self.table.insert(), data)
  1298. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
  1299. return meth(self, multiparams, params)
  1300. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
  1301. return connection._execute_clauseelement(self, multiparams, params)
  1302. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
  1303. distilled_params,
  1304. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
  1305. e, statement, parameters, cursor, context
  1306. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
  1307. sqlalchemy_exception, with_traceback=exc_info[2], from_=e
  1308. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
  1309. raise exception
  1310. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
  1311. cursor, statement, parameters, context
  1312. File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
  1313. cursor.execute(statement, parameters)
  1314. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
  1315. result = self._query(query)
  1316. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
  1317. conn.query(q)
  1318. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
  1319. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  1320. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
  1321. result.read()
  1322. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
  1323. first_packet = self.connection._read_packet()
  1324. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  1325. packet.raise_for_error()
  1326. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  1327. err.raise_mysql_exception(self._data)
  1328. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  1329. raise errorclass(errno, errval)
  1330. sqlalchemy.exc.DataError: (pymysql.err.DataError) (1366, "Incorrect integer value: 'add' for column `jeecg-boot`.`ctop_ai_kuaishou_unit_level_operation_record`.`operation_type` at row 1")
  1331. [SQL: INSERT INTO ctop_ai_kuaishou_unit_level_operation_record (group_uuid, template_id, bid_type, use_app_market, app_store, bid, cpa_bid, smart_bid, ocpx_action_type, deep_conversion_type, roi_ratio, scene_id, unit_type, begin_time, end_time, schedule_time, convert_id, url_type, web_uri_type, url, schema_uri, app_id, show_mode, speed, site_type, gift_data, video_landing_page, auto_target, auto_create_photo, region, district_ids, user_type, age_min, age_max, ages_range, gender, platform_os, android_osv, ios_osv, network, device_brand, device_price, business_interest_type, business_interest, fans_star, interest_video, app_interest, app_ids, filter_converted_level, population, exclude_population, paid_audience, is_open, no_age_break, no_gender_break, no_area_break, behavior_interest, unit_name, ai_strategy_uuid, account_id, campaign_id, create_time, operation_type) VALUES (%(group_uuid)s, %(template_id)s, %(bid_type)s, %(use_app_market)s, %(app_store)s, %(bid)s, %(cpa_bid)s, %(smart_bid)s, %(ocpx_action_type)s, %(deep_conversion_type)s, %(roi_ratio)s, %(scene_id)s, %(unit_type)s, %(begin_time)s, %(end_time)s, %(schedule_time)s, %(convert_id)s, %(url_type)s, %(web_uri_type)s, %(url)s, %(schema_uri)s, %(app_id)s, %(show_mode)s, %(speed)s, %(site_type)s, %(gift_data)s, %(video_landing_page)s, %(auto_target)s, %(auto_create_photo)s, %(region)s, %(district_ids)s, %(user_type)s, %(age_min)s, %(age_max)s, %(ages_range)s, %(gender)s, %(platform_os)s, %(android_osv)s, %(ios_osv)s, %(network)s, %(device_brand)s, %(device_price)s, %(business_interest_type)s, %(business_interest)s, %(fans_star)s, %(interest_video)s, %(app_interest)s, %(app_ids)s, %(filter_converted_level)s, %(population)s, %(exclude_population)s, %(paid_audience)s, %(is_open)s, %(no_age_break)s, %(no_gender_break)s, %(no_area_break)s, %(behavior_interest)s, %(unit_name)s, %(ai_strategy_uuid)s, %(account_id)s, %(campaign_id)s, %(create_time)s, %(operation_type)s)]
  1332. [parameters: {'group_uuid': 'cdf0c2a6-e2e8-4efe-9358-2fc67df722c7', 'template_id': None, 'bid_type': None, 'use_app_market': None, 'app_store': None, 'bid': None, 'cpa_bid': 22000, 'smart_bid': None, 'ocpx_action_type': None, 'deep_conversion_type': None, 'roi_ratio': None, 'scene_id': None, 'unit_type': None, 'begin_time': None, 'end_time': None, 'schedule_time': None, 'convert_id': None, 'url_type': None, 'web_uri_type': None, 'url': None, 'schema_uri': None, 'app_id': None, 'show_mode': None, 'speed': None, 'site_type': None, 'gift_data': None, 'video_landing_page': None, 'auto_target': None, 'auto_create_photo': None, 'region': None, 'district_ids': None, 'user_type': None, 'age_min': None, 'age_max': None, 'ages_range': None, 'gender': None, 'platform_os': None, 'android_osv': None, 'ios_osv': None, 'network': None, 'device_brand': None, 'device_price': None, 'business_interest_type': None, 'business_interest': None, 'fans_star': None, 'interest_video': None, 'app_interest': None, 'app_ids': None, 'filter_converted_level': None, 'population': None, 'exclude_population': None, 'paid_audience': None, 'is_open': None, 'no_age_break': None, 'no_gender_break': None, 'no_area_break': None, 'behavior_interest': '{}', 'unit_name': '222-1', 'ai_strategy_uuid': '84a7b6ae-009f-4619-abf9-4007e8304563', 'account_id': 23212, 'campaign_id': 30956133, 'create_time': datetime.datetime(2021, 1, 14, 14, 49, 31, 147808), 'operation_type': 'add'}]
  1333. (Background on this error at: http://sqlalche.me/e/13/9h9h)
  1334. 01/14/2021 02:51:38 PM INFO ai strategy request service started at 2021-01-14 14:51:38
  1335. 01/14/2021 02:51:50 PM INFO *************************************** NEW REQUEST ***************************************
  1336. 01/14/2021 02:51:50 PM INFO raw data from request is {'video': [{'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']}], 'operation_type': 1, 'ai_strategy_remark': '打捞历史素材', 'group_info': {'cpa_bid': 22000, 'unit_name': '222'}, 'campaign_info': {'campaign_id': '', 'campaign_name': '广告计划名称test', 'campaign_type': 2}, 'creative_info': {'creative_name': '创意名称', 'action_bar_text': '下载抢购', 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}, 'account_id': 23212}
  1337. 01/14/2021 02:51:59 PM ERROR Traceback (most recent call last):
  1338. File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
  1339. inst.get_group_dict()
  1340. File "E:\ai_ads\ai_strategy_request_handler.py", line 302, in get_group_dict
  1341. single_group_info.creative_list.append(single_creative_info)
  1342. AttributeError: 'dict' object has no attribute 'creative_list'
  1343. 01/14/2021 02:52:37 PM INFO ai strategy request service started at 2021-01-14 14:52:37
  1344. 01/14/2021 02:52:42 PM INFO *************************************** NEW REQUEST ***************************************
  1345. 01/14/2021 02:52:42 PM INFO raw data from request is {'video': [{'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']}], 'operation_type': 1, 'ai_strategy_remark': '打捞历史素材', 'group_info': {'cpa_bid': 22000, 'unit_name': '222'}, 'campaign_info': {'campaign_id': '', 'campaign_name': '广告计划名称test', 'campaign_type': 2}, 'creative_info': {'creative_name': '创意名称', 'action_bar_text': '下载抢购', 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}, 'account_id': 23212}
  1346. 01/14/2021 02:52:49 PM ERROR Traceback (most recent call last):
  1347. File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
  1348. inst.get_group_dict()
  1349. File "E:\ai_ads\ai_strategy_request_handler.py", line 306, in get_group_dict
  1350. single_creative_info_to_db['ai_strategy_id'] = self.ai_strategy_id
  1351. AttributeError: 'ParseAddCampaignOrAddGroupRequest' object has no attribute 'ai_strategy_id'
  1352. 01/14/2021 02:53:24 PM INFO ai strategy request service started at 2021-01-14 14:53:24
  1353. 01/14/2021 02:53:32 PM INFO *************************************** NEW REQUEST ***************************************
  1354. 01/14/2021 02:53:32 PM INFO raw data from request is {'video': [{'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']}], 'operation_type': 1, 'ai_strategy_remark': '打捞历史素材', 'group_info': {'cpa_bid': 22000, 'unit_name': '222'}, 'campaign_info': {'campaign_id': '', 'campaign_name': '广告计划名称test', 'campaign_type': 2}, 'creative_info': {'creative_name': '创意名称', 'action_bar_text': '下载抢购', 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}, 'account_id': 23212}
  1355. 01/14/2021 02:54:34 PM ERROR Traceback (most recent call last):
  1356. File "E:\ai_ads\ai_strategy_request_handler.py", line 47, in post
  1357. request = requests.post(create_group_and_creative_url, create_group_and_creative_res)
  1358. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\api.py", line 119, in post
  1359. return request('post', url, data=data, json=json, **kwargs)
  1360. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\api.py", line 61, in request
  1361. return session.request(method=method, url=url, **kwargs)
  1362. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\sessions.py", line 528, in request
  1363. prep = self.prepare_request(req)
  1364. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\sessions.py", line 466, in prepare_request
  1365. hooks=merge_hooks(request.hooks, self.hooks),
  1366. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\models.py", line 316, in prepare
  1367. self.prepare_url(url, params)
  1368. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\models.py", line 390, in prepare_url
  1369. raise MissingSchema(error)
  1370. requests.exceptions.MissingSchema: Invalid URL '': No schema supplied. Perhaps you meant http://?
  1371. 01/14/2021 02:59:58 PM INFO ai strategy request service started at 2021-01-14 14:59:58
  1372. 01/14/2021 03:00:20 PM INFO *************************************** NEW REQUEST ***************************************
  1373. 01/14/2021 03:00:20 PM INFO raw data from request is {'video': [{'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']}], 'operation_type': 1, 'ai_strategy_remark': '打捞历史素材', 'group_info': {'cpa_bid': 22000, 'unit_name': '222'}, 'campaign_info': {'campaign_id': '', 'campaign_name': '广告计划名称test', 'campaign_type': 2}, 'creative_info': {'creative_name': '创意名称', 'action_bar_text': '下载抢购', 'description': '不买亏大了!众多商品低至一元!看看你多花了多少冤枉钱!'}, 'account_id': 23212}
  1374. 01/14/2021 03:00:52 PM ERROR Traceback (most recent call last):
  1375. File "E:\ai_ads\ai_strategy_request_handler.py", line 47, in post
  1376. request = requests.post(create_group_and_creative_url, create_group_and_creative_res)
  1377. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\api.py", line 119, in post
  1378. return request('post', url, data=data, json=json, **kwargs)
  1379. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\api.py", line 61, in request
  1380. return session.request(method=method, url=url, **kwargs)
  1381. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\sessions.py", line 528, in request
  1382. prep = self.prepare_request(req)
  1383. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\sessions.py", line 466, in prepare_request
  1384. hooks=merge_hooks(request.hooks, self.hooks),
  1385. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\models.py", line 316, in prepare
  1386. self.prepare_url(url, params)
  1387. File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\models.py", line 390, in prepare_url
  1388. raise MissingSchema(error)
  1389. requests.exceptions.MissingSchema: Invalid URL '': No schema supplied. Perhaps you meant http://?
  1390. 01/14/2021 05:55:56 PM INFO ai strategy request service started at 2021-01-14 17:55:56
  1391. 01/14/2021 06:02:53 PM INFO *************************************** NEW REQUEST ***************************************
  1392. 01/14/2021 06:02:53 PM INFO raw data from request is {'callbackdata': [{'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '9999-99-99', 'code': 0, 'message': '创建成功'}, {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}]}
  1393. 01/14/2021 06:02:53 PM ERROR Traceback (most recent call last):
  1394. File "E:\ai_ads\ai_callback_add_group_handler.py", line 32, in post
  1395. inst.update_table_info()
  1396. File "E:\ai_ads\ai_callback_add_group_handler.py", line 47, in update_table_info
  1397. db_con = pymysql.connect(host, port, user, passwd, db, charset)
  1398. TypeError: __init__() takes 1 positional argument but 7 were given
  1399. 01/14/2021 06:04:52 PM INFO ai strategy request service started at 2021-01-14 18:04:52
  1400. 01/14/2021 06:04:57 PM INFO *************************************** NEW REQUEST ***************************************
  1401. 01/14/2021 06:04:57 PM INFO raw data from request is {'callbackdata': [{'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '9999-99-99', 'code': 0, 'message': '创建成功'}, {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}]}
  1402. 01/14/2021 06:04:57 PM ERROR Traceback (most recent call last):
  1403. File "E:\ai_ads\ai_callback_add_group_handler.py", line 32, in post
  1404. inst.update_table_info()
  1405. File "E:\ai_ads\ai_callback_add_group_handler.py", line 61, in update_table_info
  1406. self.logger.info("on single update callback info: %s" % item)
  1407. AttributeError: 'UpdateGroupLevelRecordTable' object has no attribute 'logger'
  1408. 01/14/2021 06:06:06 PM INFO ai strategy request service started at 2021-01-14 18:06:06
  1409. 01/14/2021 06:06:10 PM INFO *************************************** NEW REQUEST ***************************************
  1410. 01/14/2021 06:06:10 PM INFO raw data from request is {'callbackdata': [{'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '9999-99-99', 'code': 0, 'message': '创建成功'}, {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}]}
  1411. 01/14/2021 06:06:10 PM INFO on single update callback info: {'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '9999-99-99', 'code': 0, 'message': '创建成功'}
  1412. 01/14/2021 06:06:10 PM ERROR Traceback (most recent call last):
  1413. File "E:\ai_ads\ai_callback_add_group_handler.py", line 32, in post
  1414. inst.update_table_info()
  1415. File "E:\ai_ads\ai_callback_add_group_handler.py", line 65, in update_table_info
  1416. WHERE group_uuid=%d""" % (unit_id, unit_create_time, group_uuid)
  1417. TypeError: %d format: a number is required, not str
  1418. 01/14/2021 06:06:44 PM INFO ai strategy request service started at 2021-01-14 18:06:44
  1419. 01/14/2021 06:06:47 PM INFO *************************************** NEW REQUEST ***************************************
  1420. 01/14/2021 06:06:47 PM INFO raw data from request is {'callbackdata': [{'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '9999-99-99', 'code': 0, 'message': '创建成功'}, {'group_uuid': '', 'code': -1, 'message': '广告组名称重复'}]}
  1421. 01/14/2021 06:06:48 PM INFO on single update callback info: {'group_uuid': '12-ab', 'unit_id': 5555, 'unit_create_time': '9999-99-99', 'code': 0, 'message': '创建成功'}
  1422. 01/14/2021 06:06:48 PM ERROR Traceback (most recent call last):
  1423. File "E:\ai_ads\ai_callback_add_group_handler.py", line 32, in post
  1424. inst.update_table_info()
  1425. File "E:\ai_ads\ai_callback_add_group_handler.py", line 66, in update_table_info
  1426. cursor.execute(sql)
  1427. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
  1428. result = self._query(query)
  1429. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
  1430. conn.query(q)
  1431. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
  1432. self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  1433. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
  1434. result.read()
  1435. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
  1436. first_packet = self.connection._read_packet()
  1437. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
  1438. packet.raise_for_error()
  1439. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
  1440. err.raise_mysql_exception(self._data)
  1441. File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
  1442. raise errorclass(errno, errval)
  1443. pymysql.err.OperationalError: (1054, "Unknown column 'ab' in 'where clause'")
  1444. 01/14/2021 06:08:20 PM INFO ai strategy request service started at 2021-01-14 18:08:20
  1445. 01/14/2021 06:09:15 PM INFO ai strategy request service started at 2021-01-14 18:09:15
  1446. 01/14/2021 06:13:03 PM INFO ai strategy request service started at 2021-01-14 18:13:03
  1447. 01/14/2021 06:13:50 PM INFO ai strategy request service started at 2021-01-14 18:13:50
  1448. 01/14/2021 06:14:47 PM INFO ai strategy request service started at 2021-01-14 18:14:47
  1449. 01/14/2021 06:17:37 PM INFO ai strategy request service started at 2021-01-14 18:17:37
  1450. 01/14/2021 06:19:16 PM INFO ai strategy request service started at 2021-01-14 18:19:16
  1451. 01/14/2021 06:39:23 PM INFO ai strategy request service started at 2021-01-14 18:39:23