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 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://?