def post(action): """ 添加广告主:curl http://127.0.0.1:5000/advertiser/add -X POST -d "advertiser_name=rise&site_name=瑞思学科英语 &url=http://www.risecenter.com&connector=孙一丁&phone=13011110000&category=87&qualifications= {'5001001': 'https://qualifications.oss-cn-beijing.aliyuncs.com/rise/bp.jpeg', '5001002': 'https://qualifications.oss-cn-beijing.aliyuncs.com/rise/icp.jpg', '5001021': 'https://qualifications.oss-cn-beijing.aliyuncs.com/rise/brand.jpeg', '5001091': 'https://qualifications.oss-cn-beijing.aliyuncs.com/rise/eq.jpeg'}" -H "Authorization: token 2343fe43jias34df5hue34fs53afsa734ref" """ if action == 'add': args = advertiser_post.parse_args() # 构建新数据 advertiser_id, advertising_id = create_id("emar", args['advertiser_name'], mdb, rds, method='hget') args['advertiser_id'] = advertiser_id tasks = Advertiser(advertiser_name=args['advertiser_name'], site_name=args['site_name'], url=args['url'], connector=args['connector'], phone=args['phone'], email=args['email'], address=args['address'], brand=args['brand'], category=args['category'], qualifications=args['qualifications'], qq=args['qq'], province=args['province'], city=args['city'], advertiser_id=args['advertiser_id']) try: session.add(tasks) session.commit() # 资源添加成功,返回200 result = {'code': 200, 'message': 'add advertiser ok', 'data': advertiser_json(tasks)} return result, 200 except Exception as err: session.rollback() logging.error(traceback.format_exc()) logging.error(err) return {'code': 500, 'message': 'add task failed'}, 500 else: return {'code': 404, 'message': '你访问的网页找不到'}, 404
def put(action): """ 更新广告主:curl http://127.0.0.1:5000/advertiser/update -X PUT -d "advertiser_name=rise&site_name=瑞思学科英语 &url=http://www.risecenter.com&connector=孙一丁&phone=13011110000&category=87&qualifications= {'5001001': 'https://qualifications.oss-cn-beijing.aliyuncs.com/rise/bp.jpeg', '5001002': 'https://qualifications.oss-cn-beijing.aliyuncs.com/rise/icp.jpg', '5001021': 'https://qualifications.oss-cn-beijing.aliyuncs.com/rise/brand.jpeg', '5001091': 'https://qualifications.oss-cn-beijing.aliyuncs.com/rise/eq.jpeg'}" -H "Authorization: token 2343fe43jias34df5hue34fs53afsa734ref" """ if action == 'update': args = advertiser_put.parse_args() advertiser_id_set = set( [advertiser.advertiser_id for advertiser in session.query(Advertiser.advertiser_id)]) if args['advertiser_id'] not in advertiser_id_set: return {'code': 400, 'message': '输入的广告主id不存在'}, 400 advertiser = session.query(Advertiser).filter(Advertiser.advertiser_id == args['advertiser_id'])[0] advertiser.advertiser_name = args['advertiser_name'] advertiser.site_name = args['site_name'] advertiser.url = args['url'] advertiser.connector = args['connector'] advertiser.phone = args['phone'] advertiser.email = args['email'] advertiser.address = args['address'] advertiser.brand = args['brand'] advertiser.category = args['category'] advertiser.qualifications = args['qualifications'] advertiser.qq = args['qq'] advertiser.province = args['province'] advertiser.city = args['city'] advertiser.advertiser_id = args['advertiser_id'] try: session.merge(advertiser) session.commit() # 资源添加成功,返回200 result = {'code': 200, 'message': 'update advertiser ok', 'data': advertiser_json(advertiser)} return result, 200 except Exception as err: session.rollback() logging.error(traceback.format_exc()) logging.error(err) return {'code': 500, 'message': 'update advertiser failed'}, 500 else: return {'code': 404, 'message': '你访问的网页找不到'}, 404
def post(action): if action == 'add': args = channel_post.parse_args() # 构建新数据 args['channel_id'] = channel_crowd(rds, 'channel') tasks = Channel(channel_id=args['channel_id'], channel_name=args['channel_name'], status=args['status']) try: session.add(tasks) session.commit() # 资源添加成功,返回200 result = {'code': 200, 'message': 'add channel ok', 'data': channel_json(tasks)} return result, 200 except Exception as err: session.rollback() logging.error(traceback.format_exc()) logging.error(err) return {'code': 500, 'message': 'add channel failed'}, 500 else: return {'code': 404, 'message': '你访问的网页找不到'}, 404
def post(): """ 添加一个数据:curl http://127.0.0.1:5000/task/ -X POST -d "template_id=512010&width_height=640x960 &picture_width=640&picture_height=960&picture_size=30" -H "Authorization: token 2343fe43jias34df5hue34fs53afsa734ref" """ args = parser_post.parse_args() # 构建新数据 tasks = EmarTemplate(template_id=args['template_id'], width_height=args['width_height'], picture_width=args['picture_width'], picture_height=args['picture_height'], picture_size=args['picture_size']) try: session.add(tasks) session.commit() # 资源添加成功,返回200 return get_json(tasks), 200 except Exception as err: session.rollback() logging.error(traceback.format_exc()) logging.error(err) return {'code': 500, 'message': 'update advertiser failed'}, 500
def post(action): """ 添加创意 curl http://127.0.0.1:5000/creative/add -X POST -d "advertiser_id=1000020000000000000& creative_name=rise&creative_type=2&creative_url=http://material-mm.oss-cn-beijing.aliyuncs.com/rise /kxj_1200x627.jpg&width=1200&height=627&url=http://material-mm.oss-cn-bei&landing_page=http://material- mm.oss-cn-beijing.aliyuncs.com/rise/kxj_1200x627.jpg&status=0" -H "Authorization: token 2343fe43jias34df5hue34fs53afsa734ref" 更新创意 curl http://127.0.0.1:5000/creative/update -X POST -d "creative_id=1000020000000000002& advertiser_id=1000020000000000000&creative_name=jikestar&creative_type=2&creative_url=http://material-mm. oss-cn-beijing.aliyuncs.com/rise/kxj_1200x627.jpg&width=1200&height=627&url=http://material-mm.oss-cn-bei &landing_page=http://material-mm.oss-cn-beijing.aliyuncs.com/rise/kxj_1200x627.jpg&status=0" -H "Authorization: token 2343fe43jias34df5hue34fs53afsa734ref" """ if action == 'add': args = creative_post.parse_args() # 构建新数据 advertising_id = get_creative_id(mdb, rds, args['advertiser_id']) args['creative_id'] = advertising_id tasks = Creative(advertiser_id=args['advertiser_id'], creative_id=args['creative_id'], creative_name=args['creative_name'], creative_type=args['creative_type'], creative_url=args['creative_url'], width=args['width'], height=args['height'], url=args['url'], size=args['size'], landing_page=args['landing_page'], title=args['title'], image_type=args['image_type'], video_duration=args['video_duration'], extra=args['extra'], impr_monitor_url=args['impr_monitor_url'], click_monitor_url=args['click_monitor_url'], deeplink=args['deeplink'], desc=args['desc'], status=args['status'] ) try: session.add(tasks) session.commit() # 资源添加成功,返回200 result = {'code': 200, 'message': 'add creative ok', 'data': creative_json(tasks)} return result, 200 except Exception as err: session.rollback() logging.error(traceback.format_exc()) logging.error(err) return {'code': 500, 'message': 'add creative failed'}, 500 elif action == 'update': args = creative_post.parse_args() creative_id_set = set([creative.creative_id for creative in session.query(Creative.creative_id)]) if args['creative_id'] not in creative_id_set: return {'code': 400, 'message': '输入的广告创意id不存在'}, 400 creative = session.query(Creative).filter(Creative.creative_id == args['creative_id'])[0] creative.advertiser_id = args['advertiser_id'] creative.creative_id = args['creative_id'] creative.creative_name = args['creative_name'] creative.creative_type = args['creative_type'] creative.creative_url = args['creative_url'] creative.width = args['width'] creative.height = args['height'] creative.url = args['url'] creative.size = args['size'] creative.landing_page = args['landing_page'] creative.title = args['title'] creative.image_type = args['image_type'] creative.video_duration = args['video_duration'] creative.extra = args['extra'] creative.impr_monitor_url = args['impr_monitor_url'] creative.click_monitor_url = args['click_monitor_url'] creative.deeplink = args['deeplink'] creative.desc = args['desc'] creative.status = args['status'] try: session.merge(creative) session.commit() # 资源添加成功,返回200 result = {'code': 200, 'message': 'update creative ok', 'data': creative_json(creative)} return result, 200 except Exception as err: session.rollback() logging.error(traceback.format_exc()) logging.error(err) return {'code': 500, 'message': 'update creative failed'}, 500 else: return {'code': 404, 'message': '你访问的网页找不到'}, 404
def post(action): """ :param action: :return: dict 添加活动 curl http://127.0.0.1:5000/campaign/add -X POST -d "advertiser_id=1000020000000000000& creative_name=jikestar_model&category=87&platform=2&budget=1200&price=0.4&status=0&adx_ids=[1,2]& speed=0&creatives=[123,231]" -H "Authorization: token 2343fe43jias34df5hue34fs53afsa734ref" 更新活动 curl http://127.0.0.1:5000/campaign/update -X POST -d "advertiser_id=1000020000000700000& creative_name=jikestar_model_131w&category=87&platform=2&budget=1200&price=0.4&status=0& adx_ids=[1,2]&speed=0&creatives=[123,231]" -H "Authorization: token 2343fe43jias34df5hue34fs53afsa734ref" """ if action == 'add': args = campaign_post.parse_args() # 构建新数据 advertiser_id = get_campaign_id(mdb, rds, args['advertiser_id']) args['advertiser_id'] = advertiser_id tasks = Campaign(advertiser_id=args['advertiser_id'], creative_name=args['creative_name'], category=args['category'], platform=args['platform'], budget=args['budget'], price=args['price'], status=args['status'], adx_ids=args['adx_ids'], speed=args['speed'], start_date=args['start_date'], end_date=args['end_date'], week_hours=args['week_hours'], areas=args['areas'], ip_list=args['ip_list'], device_brand=args['device_brand'], device_price=args['device_price'], connection=args['connection'], os=args['os'], lbs=args['lbs'], crowds=args['crowds'], creatives=args['creatives'], ) try: session.add(tasks) session.commit() # 资源添加成功,返回200 result = {'code': 200, 'message': 'add campaign ok', 'data': campaign_json(tasks)} return result, 200 except Exception as err: session.rollback() logging.error(traceback.format_exc()) logging.error(err) return {'code': 500, 'message': 'add campaign failed'}, 500 elif action == 'update': args = campaign_post.parse_args() advertiser_id_set = set([campaign.advertiser_id for campaign in session.query(Campaign.advertiser_id)]) print(advertiser_id_set, args['advertiser_id']) if args['advertiser_id'] not in advertiser_id_set: return {'code': 400, 'message': '输入的广告活动id不存在'}, 400 campaign = session.query(Campaign).filter(Campaign.advertiser_id == args['advertiser_id'])[0] campaign.advertiser_id = args['advertiser_id'] campaign.creative_name = args['creative_name'] campaign.category = args['category'] campaign.platform = args['platform'] campaign.budget = args['budget'] campaign.price = args['price'] campaign.status = args['status'] campaign.adx_ids = args['adx_ids'] campaign.speed = args['speed'] campaign.start_date = args['start_date'] campaign.end_date = args['end_date'] campaign.week_hours = args['week_hours'] campaign.areas = args['areas'] campaign.ip_list = args['ip_list'] campaign.device_brand = args['device_brand'] campaign.device_price = args['device_price'] campaign.connection = args['connection'] campaign.os = args['os'] campaign.lbs = args['lbs'] campaign.crowds = args['crowds'] campaign.creatives = args['creatives'] try: session.merge(campaign) session.commit() # 资源添加成功,返回200 result = {'code': 200, 'message': 'update campaign ok', 'data': campaign_json(campaign)} return result, 200 except Exception as err: session.rollback() logging.error(traceback.format_exc()) logging.error(err) return {'code': 500, 'message': 'update campaign failed'}, 500 else: return {'code': 404, 'message': '你访问的网页找不到'}, 404