| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459 |
- 01/14/2021 10:57:19 AM INFO ai strategy request service started at 2021-01-14 10:57:19
- 01/14/2021 10:57:39 AM INFO ai strategy request service started at 2021-01-14 10:57:39
- 01/14/2021 11:01:29 AM INFO ai strategy request service started at 2021-01-14 11:01:29
- 01/14/2021 11:04:56 AM INFO ai strategy request service started at 2021-01-14 11:04:56
- 01/14/2021 11:07:17 AM INFO ai strategy request service started at 2021-01-14 11:07:17
- 01/14/2021 11:10:29 AM INFO ai strategy request service started at 2021-01-14 11:10:29
- 01/14/2021 12:04:22 PM INFO ai strategy request service started at 2021-01-14 12:04:22
- 01/14/2021 12:05:00 PM INFO ai strategy request service started at 2021-01-14 12:05:00
- 01/14/2021 12:06:32 PM INFO *************************************** NEW REQUEST ***************************************
- 01/14/2021 12:06: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": "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
- }
- 01/14/2021 12:06:32 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
- if data["operation_type"] == "add":
- TypeError: string indices must be integers
- 01/14/2021 12:06:56 PM INFO *************************************** NEW REQUEST ***************************************
- 01/14/2021 12:06:56 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
- }
- 01/14/2021 12:06:56 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
- if data["operation_type"] == "add":
- TypeError: string indices must be integers
- 01/14/2021 12:06:57 PM INFO *************************************** NEW REQUEST ***************************************
- 01/14/2021 12:06:57 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
- }
- 01/14/2021 12:06:57 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
- if data["operation_type"] == "add":
- TypeError: string indices must be integers
- 01/14/2021 12:07:00 PM INFO *************************************** NEW REQUEST ***************************************
- 01/14/2021 12:07:00 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
- }
- 01/14/2021 12:07:00 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
- if data["operation_type"] == "add":
- TypeError: string indices must be integers
- 01/14/2021 12:07:04 PM INFO *************************************** NEW REQUEST ***************************************
- 01/14/2021 12:07:04 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
- }
- 01/14/2021 12:07:04 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
- if data["operation_type"] == "add":
- TypeError: string indices must be integers
- 01/14/2021 01:30:14 PM INFO *************************************** NEW REQUEST ***************************************
- 01/14/2021 01:30:14 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
- }
- 01/14/2021 01:30:14 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
- if data["operation_type"] == "add":
- TypeError: string indices must be integers
- 01/14/2021 01:30:19 PM INFO *************************************** NEW REQUEST ***************************************
- 01/14/2021 01:30:19 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
- }
- 01/14/2021 01:30:19 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
- if data["operation_type"] == "add":
- TypeError: string indices must be integers
- 01/14/2021 01:30:20 PM INFO *************************************** NEW REQUEST ***************************************
- 01/14/2021 01:30: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": "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
- }
- 01/14/2021 01:30:20 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
- if data["operation_type"] == "add":
- TypeError: string indices must be integers
- 01/14/2021 01:30:22 PM INFO *************************************** NEW REQUEST ***************************************
- 01/14/2021 01:30:22 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
- }
- 01/14/2021 01:30:22 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
- if data["operation_type"] == "add":
- TypeError: string indices must be integers
- 01/14/2021 01:30:33 PM INFO *************************************** NEW REQUEST ***************************************
- 01/14/2021 01:30:33 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
- }
- 01/14/2021 01:30:33 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 33, in post
- if data["operation_type"] == "add":
- TypeError: string indices must be integers
- 01/14/2021 01:54:35 PM INFO ai strategy request service started at 2021-01-14 13:54:35
- 01/14/2021 01:54:55 PM INFO *************************************** NEW REQUEST ***************************************
- 01/14/2021 01:54:56 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
- }
- 01/14/2021 02:02:05 PM INFO ai strategy request service started at 2021-01-14 14:02:05
- 01/14/2021 02:02:23 PM INFO *************************************** NEW REQUEST ***************************************
- 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}
- 01/14/2021 02:08:30 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 37, in post
- inst.write_intelligence_strategy_table()
- File "E:\ai_ads\ai_strategy_request_handler.py", line 109, in write_intelligence_strategy_table
- df.to_sql(name="ctop_ai_kuaishou_intelligence_strategy", con=engine, if_exists='append', index=False)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\core\generic.py", line 2786, in to_sql
- method=method,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 599, in to_sql
- method=method,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1397, in to_sql
- table.insert(chunksize, method=method)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 831, in insert
- exec_insert(conn, keys, chunk_iter)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 748, in _execute_insert
- conn.execute(self.table.insert(), data)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
- return meth(self, multiparams, params)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
- return connection._execute_clauseelement(self, multiparams, params)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
- distilled_params,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1514, in _handle_dbapi_exception
- util.raise_(exc_info[1], with_traceback=exc_info[2])
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
- cursor, statement, parameters, context
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
- cursor.execute(statement, parameters)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 146, in execute
- query = self.mogrify(query, args)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 125, in mogrify
- query = query % self._escape_args(args, conn)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 109, in _escape_args
- return {key: conn.literal(val) for (key, val) in args.items()}
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 109, in <dictcomp>
- return {key: conn.literal(val) for (key, val) in args.items()}
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 517, in literal
- return self.escape(obj, self.encoders)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 510, in escape
- return converters.escape_item(obj, self.charset, mapping=mapping)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\converters.py", line 23, in escape_item
- val = encoder(val, charset, mapping)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\converters.py", line 32, in escape_dict
- quoted = escape_item(v, charset, mapping)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\converters.py", line 23, in escape_item
- val = encoder(val, charset, mapping)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\converters.py", line 42, in escape_sequence
- return "(" + ",".join(n) + ")"
- TypeError: sequence item 0: expected str instance, dict found
- 01/14/2021 02:12:31 PM INFO ai strategy request service started at 2021-01-14 14:12:31
- 01/14/2021 02:12:48 PM INFO *************************************** NEW REQUEST ***************************************
- 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}
- 01/14/2021 02:12:59 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
- cursor, statement, parameters, context
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
- cursor.execute(statement, parameters)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
- conn.query(q)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
- packet.raise_for_error()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.IntegrityError: (1048, "Column 'ai_strategy_id' cannot be null")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 39, in post
- if inst.add_campaign() == -1:
- File "E:\ai_ads\ai_strategy_request_handler.py", line 155, in add_campaign
- df.to_sql(name="ctop_ai_kuaishou_campaign_level_operation_record", con=engine, if_exists='append', index=False)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\core\generic.py", line 2786, in to_sql
- method=method,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 599, in to_sql
- method=method,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1405, in to_sql
- raise err
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1397, in to_sql
- table.insert(chunksize, method=method)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 831, in insert
- exec_insert(conn, keys, chunk_iter)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 748, in _execute_insert
- conn.execute(self.table.insert(), data)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
- return meth(self, multiparams, params)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
- return connection._execute_clauseelement(self, multiparams, params)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
- distilled_params,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
- cursor, statement, parameters, context
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
- cursor.execute(statement, parameters)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
- conn.query(q)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
- packet.raise_for_error()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.IntegrityError: (pymysql.err.IntegrityError) (1048, "Column 'ai_strategy_id' cannot be null")
- [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)]
- [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)}]
- (Background on this error at: http://sqlalche.me/e/13/gkpj)
- 01/14/2021 02:14:33 PM INFO ai strategy request service started at 2021-01-14 14:14:33
- 01/14/2021 02:14:40 PM INFO *************************************** NEW REQUEST ***************************************
- 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}
- 01/14/2021 02:14:46 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
- cursor, statement, parameters, context
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
- cursor.execute(statement, parameters)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
- conn.query(q)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
- packet.raise_for_error()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.OperationalError: (1054, "Unknown column 'ai_strategy_uuid' in 'field list'")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 39, in post
- if inst.add_campaign() == -1:
- File "E:\ai_ads\ai_strategy_request_handler.py", line 154, in add_campaign
- df.to_sql(name="ctop_ai_kuaishou_campaign_level_operation_record", con=engine, if_exists='append', index=False)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\core\generic.py", line 2786, in to_sql
- method=method,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 599, in to_sql
- method=method,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1405, in to_sql
- raise err
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1397, in to_sql
- table.insert(chunksize, method=method)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 831, in insert
- exec_insert(conn, keys, chunk_iter)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 748, in _execute_insert
- conn.execute(self.table.insert(), data)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
- return meth(self, multiparams, params)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
- return connection._execute_clauseelement(self, multiparams, params)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
- distilled_params,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
- cursor, statement, parameters, context
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
- cursor.execute(statement, parameters)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
- conn.query(q)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
- packet.raise_for_error()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1054, "Unknown column 'ai_strategy_uuid' in 'field list'")
- [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)]
- [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)}]
- (Background on this error at: http://sqlalche.me/e/13/e3q8)
- 01/14/2021 02:16:39 PM INFO ai strategy request service started at 2021-01-14 14:16:39
- 01/14/2021 02:16:48 PM INFO *************************************** NEW REQUEST ***************************************
- 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}
- 01/14/2021 02:16:54 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
- inst.get_group_dict()
- File "E:\ai_ads\ai_strategy_request_handler.py", line 191, in get_group_dict
- basic_group_info = {'template_id': self.advertiser_strategy['template_id'],
- KeyError: 'template_id'
- 01/14/2021 02:18:03 PM INFO ai strategy request service started at 2021-01-14 14:18:03
- 01/14/2021 02:18:08 PM INFO *************************************** NEW REQUEST ***************************************
- 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}
- 01/14/2021 02:18:12 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 36, in post
- inst.get_advertiser_strategy_info()
- File "E:\ai_ads\ai_strategy_request_handler.py", line 89, in get_advertiser_strategy_info
- self.advertiser_strategy = advertiser_strategy_df.T.to_dict()[0]
- KeyError: 0
- 01/14/2021 02:19:35 PM INFO ai strategy request service started at 2021-01-14 14:19:35
- 01/14/2021 02:19:43 PM INFO *************************************** NEW REQUEST ***************************************
- 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}
- 01/14/2021 02:19:46 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 36, in post
- inst.get_advertiser_strategy_info()
- File "E:\ai_ads\ai_strategy_request_handler.py", line 89, in get_advertiser_strategy_info
- self.advertiser_strategy_id = advertiser_strategy_df['id'].values[0]
- IndexError: index 0 is out of bounds for axis 0 with size 0
- 01/14/2021 02:34:37 PM INFO ai strategy request service started at 2021-01-14 14:34:37
- 01/14/2021 02:34:46 PM INFO *************************************** NEW REQUEST ***************************************
- 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}
- 01/14/2021 02:35:16 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 39, in post
- if inst.add_campaign() == -1:
- File "E:\ai_ads\ai_strategy_request_handler.py", line 116, in add_campaign
- if self.campaign_info['campaign_type'] != self.advertiser_strategy['campaign_type']:
- KeyError: 'campaign_type'
- 01/14/2021 02:41:45 PM INFO ai strategy request service started at 2021-01-14 14:41:45
- 01/14/2021 02:41:57 PM INFO ai strategy request service started at 2021-01-14 14:41:57
- 01/14/2021 02:42:06 PM INFO *************************************** NEW REQUEST ***************************************
- 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}
- 01/14/2021 02:42:22 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
- inst.get_group_dict()
- File "E:\ai_ads\ai_strategy_request_handler.py", line 207, in get_group_dict
- 'day_budget': self.advertiser_strategy['day_budget'],
- KeyError: 'day_budget'
- 01/14/2021 02:42:51 PM INFO ai strategy request service started at 2021-01-14 14:42:51
- 01/14/2021 02:43:08 PM INFO *************************************** NEW REQUEST ***************************************
- 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}
- 01/14/2021 02:43:15 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
- inst.get_group_dict()
- File "E:\ai_ads\ai_strategy_request_handler.py", line 243, in get_group_dict
- 'is_open': self.advertiser_strategy['is_open'],
- KeyError: 'is_open'
- 01/14/2021 02:44:32 PM INFO ai strategy request service started at 2021-01-14 14:44:32
- 01/14/2021 02:44:38 PM INFO *************************************** NEW REQUEST ***************************************
- 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}
- 01/14/2021 02:44:45 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
- inst.get_group_dict()
- File "E:\ai_ads\ai_strategy_request_handler.py", line 263, in get_group_dict
- single_group_info_to_db['ai_strategy_id'] = self.ai_strategy_id
- AttributeError: 'ParseAddCampaignOrAddGroupRequest' object has no attribute 'ai_strategy_id'
- 01/14/2021 02:46:18 PM INFO ai strategy request service started at 2021-01-14 14:46:18
- 01/14/2021 02:46:24 PM INFO *************************************** NEW REQUEST ***************************************
- 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}
- 01/14/2021 02:46:32 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
- cursor, statement, parameters, context
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
- cursor.execute(statement, parameters)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
- conn.query(q)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
- packet.raise_for_error()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.OperationalError: (1364, "Field 'unit_id' doesn't have a default value")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
- inst.get_group_dict()
- File "E:\ai_ads\ai_strategy_request_handler.py", line 273, in get_group_dict
- index=False)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\core\generic.py", line 2786, in to_sql
- method=method,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 599, in to_sql
- method=method,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1405, in to_sql
- raise err
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1397, in to_sql
- table.insert(chunksize, method=method)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 831, in insert
- exec_insert(conn, keys, chunk_iter)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 748, in _execute_insert
- conn.execute(self.table.insert(), data)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
- return meth(self, multiparams, params)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
- return connection._execute_clauseelement(self, multiparams, params)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
- distilled_params,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
- cursor, statement, parameters, context
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
- cursor.execute(statement, parameters)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
- conn.query(q)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
- packet.raise_for_error()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (1364, "Field 'unit_id' doesn't have a default value")
- [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)]
- [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'}]
- (Background on this error at: http://sqlalche.me/e/13/e3q8)
- 01/14/2021 02:48:15 PM INFO ai strategy request service started at 2021-01-14 14:48:15
- 01/14/2021 02:48:26 PM INFO *************************************** NEW REQUEST ***************************************
- 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}
- 01/14/2021 02:48:31 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
- cursor, statement, parameters, context
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
- cursor.execute(statement, parameters)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
- conn.query(q)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
- packet.raise_for_error()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.IntegrityError: (1048, "Column 'bid_type' cannot be null")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
- inst.get_group_dict()
- File "E:\ai_ads\ai_strategy_request_handler.py", line 273, in get_group_dict
- index=False)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\core\generic.py", line 2786, in to_sql
- method=method,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 599, in to_sql
- method=method,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1405, in to_sql
- raise err
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1397, in to_sql
- table.insert(chunksize, method=method)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 831, in insert
- exec_insert(conn, keys, chunk_iter)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 748, in _execute_insert
- conn.execute(self.table.insert(), data)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
- return meth(self, multiparams, params)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
- return connection._execute_clauseelement(self, multiparams, params)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
- distilled_params,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
- cursor, statement, parameters, context
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
- cursor.execute(statement, parameters)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
- conn.query(q)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
- packet.raise_for_error()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
- raise errorclass(errno, errval)
- sqlalchemy.exc.IntegrityError: (pymysql.err.IntegrityError) (1048, "Column 'bid_type' cannot be null")
- [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)]
- [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'}]
- (Background on this error at: http://sqlalche.me/e/13/gkpj)
- 01/14/2021 02:49:19 PM INFO ai strategy request service started at 2021-01-14 14:49:19
- 01/14/2021 02:49:27 PM INFO *************************************** NEW REQUEST ***************************************
- 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}
- 01/14/2021 02:49:33 PM ERROR Traceback (most recent call last):
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
- cursor, statement, parameters, context
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
- cursor.execute(statement, parameters)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
- conn.query(q)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
- packet.raise_for_error()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
- raise errorclass(errno, errval)
- pymysql.err.DataError: (1366, "Incorrect integer value: 'add' for column `jeecg-boot`.`ctop_ai_kuaishou_unit_level_operation_record`.`operation_type` at row 1")
- The above exception was the direct cause of the following exception:
- Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
- inst.get_group_dict()
- File "E:\ai_ads\ai_strategy_request_handler.py", line 273, in get_group_dict
- index=False)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\core\generic.py", line 2786, in to_sql
- method=method,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 599, in to_sql
- method=method,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1405, in to_sql
- raise err
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 1397, in to_sql
- table.insert(chunksize, method=method)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 831, in insert
- exec_insert(conn, keys, chunk_iter)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pandas\io\sql.py", line 748, in _execute_insert
- conn.execute(self.table.insert(), data)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute
- return meth(self, multiparams, params)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection
- return connection._execute_clauseelement(self, multiparams, params)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement
- distilled_params,
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context
- e, statement, parameters, cursor, context
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception
- sqlalchemy_exception, with_traceback=exc_info[2], from_=e
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_
- raise exception
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context
- cursor, statement, parameters, context
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\sqlalchemy\engine\default.py", line 593, in do_execute
- cursor.execute(statement, parameters)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 148, in execute
- result = self._query(query)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\cursors.py", line 310, in _query
- conn.query(q)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 548, in query
- self._affected_rows = self._read_query_result(unbuffered=unbuffered)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 775, in _read_query_result
- result.read()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 1156, in read
- first_packet = self.connection._read_packet()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\connections.py", line 725, in _read_packet
- packet.raise_for_error()
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\protocol.py", line 221, in raise_for_error
- err.raise_mysql_exception(self._data)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\pymysql\err.py", line 143, in raise_mysql_exception
- raise errorclass(errno, errval)
- 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")
- [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)]
- [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'}]
- (Background on this error at: http://sqlalche.me/e/13/9h9h)
- 01/14/2021 02:51:38 PM INFO ai strategy request service started at 2021-01-14 14:51:38
- 01/14/2021 02:51:50 PM INFO *************************************** NEW REQUEST ***************************************
- 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}
- 01/14/2021 02:51:59 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
- inst.get_group_dict()
- File "E:\ai_ads\ai_strategy_request_handler.py", line 302, in get_group_dict
- single_group_info.creative_list.append(single_creative_info)
- AttributeError: 'dict' object has no attribute 'creative_list'
- 01/14/2021 02:52:37 PM INFO ai strategy request service started at 2021-01-14 14:52:37
- 01/14/2021 02:52:42 PM INFO *************************************** NEW REQUEST ***************************************
- 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}
- 01/14/2021 02:52:49 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 44, in post
- inst.get_group_dict()
- File "E:\ai_ads\ai_strategy_request_handler.py", line 306, in get_group_dict
- single_creative_info_to_db['ai_strategy_id'] = self.ai_strategy_id
- AttributeError: 'ParseAddCampaignOrAddGroupRequest' object has no attribute 'ai_strategy_id'
- 01/14/2021 02:53:24 PM INFO ai strategy request service started at 2021-01-14 14:53:24
- 01/14/2021 02:53:32 PM INFO *************************************** NEW REQUEST ***************************************
- 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}
- 01/14/2021 02:54:34 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 47, in post
- request = requests.post(create_group_and_creative_url, create_group_and_creative_res)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\api.py", line 119, in post
- return request('post', url, data=data, json=json, **kwargs)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\api.py", line 61, in request
- return session.request(method=method, url=url, **kwargs)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\sessions.py", line 528, in request
- prep = self.prepare_request(req)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\sessions.py", line 466, in prepare_request
- hooks=merge_hooks(request.hooks, self.hooks),
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\models.py", line 316, in prepare
- self.prepare_url(url, params)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\models.py", line 390, in prepare_url
- raise MissingSchema(error)
- requests.exceptions.MissingSchema: Invalid URL '': No schema supplied. Perhaps you meant http://?
- 01/14/2021 02:59:58 PM INFO ai strategy request service started at 2021-01-14 14:59:58
- 01/14/2021 03:00:20 PM INFO *************************************** NEW REQUEST ***************************************
- 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}
- 01/14/2021 03:00:52 PM ERROR Traceback (most recent call last):
- File "E:\ai_ads\ai_strategy_request_handler.py", line 47, in post
- request = requests.post(create_group_and_creative_url, create_group_and_creative_res)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\api.py", line 119, in post
- return request('post', url, data=data, json=json, **kwargs)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\api.py", line 61, in request
- return session.request(method=method, url=url, **kwargs)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\sessions.py", line 528, in request
- prep = self.prepare_request(req)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\sessions.py", line 466, in prepare_request
- hooks=merge_hooks(request.hooks, self.hooks),
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\models.py", line 316, in prepare
- self.prepare_url(url, params)
- File "D:\anaconda3\envs\ai_ads\lib\site-packages\requests\models.py", line 390, in prepare_url
- raise MissingSchema(error)
- requests.exceptions.MissingSchema: Invalid URL '': No schema supplied. Perhaps you meant http://?
|