def get(self): connection = sqlite3.connect('data.db') cursor = connection.cursor() query = "SELECT * FROM campaigns" result = cursor.execute(query) campaigns = [] for row in result: campaign_model = CampaignModel(row[0], row[1], row[2], row[3]) campaigns.append(campaign_model.json()) connection.close() return {'campaigns': campaigns}
def get(self, campaign_name): campaign = CampaignModel.find_by_name(campaign_name) try: if campaign: return campaign.json() except Exception as e: return {"message": "Record not found'{}'".format(e)}, 404
def put(self, token): try: data = self.parser.parse_args() validateObj = CampaignModel.validateData(data, request) if type(validateObj) is dict: return {"success": False, "errors": validateObj}, 400 campaign_id = decodeID(token) campaign = CampaignModel.find_by_id(campaign_id) if not campaign or campaign.token != token: return {"success": False, 'message': 'Record Not Found'}, 404 campaign.category_name = data['campaign_name'] campaign.description = data['description'] campaign.brand_id = data['brand_id'] campaign.product_ids = data['product_ids'] campaign.currency_id = data['currency_id'] campaign.budget_amount = data['budget_amount'] campaign.objective_id = data['objective_id'] campaign.kpi_id = data['kpi_id'] campaign.target_locations = data['target_locations'] campaign.exclude_locations = data['exclude_locations'] campaign.modified_on = datetime.now() campaign.modified_by = 1 campaign.modified_on = datetime.now() campaign.modified_by = 1 ######## campaign_name = data['campaign_name'] description = data['description'] target_locations = data['target_locations'] exclude_locations = data['exclude_locations'] if (campaign_name.strip() and description.strip() and target_locations.strip() and exclude_locations.strip()): campaign.save_to_db() else: return { "success": False, "message": "String Should not be empty" } return { "success": True, "message": "Record updated successfully." }, 200 except Exception as e: return {"success": False, "message": str(e)}
def get(cls, token): try: campaign_id = decodeID(token) campaign = CampaignModel.find_by_id(campaign_id) if not campaign or campaign.token != token: return {"success": False, 'message': 'Record Not Found'}, 404 return campaign.json(), 200 except Exception as e: return {"success": False, "message": str(e)}
def delete(cls, campaign_name): campaign = CampaignModel.find_by_name(campaign_name) if campaign: campaign.deleted_by = 1 campaign.deleted_on = datetime.now() campaign.save_to_db() #campaign.delete_from_db() return {'message': 'Record deleted'} else: return {"Message": "Record Not FOUND"}
def mutate(root, info, company_id, product_id, campaign_data): company = CompanyModel.find_by_id(company_id) if not company: raise Exception("Company not found!") product = ProductModel.find_by_id(product_id) if not product: raise Exception("Product not found!") campaign = CampaignModel(**campaign_data, product=product, company=company) campaign.save() return NewCampaign(campaign=campaign)
def delete(cls, token): try: campaign_id = decodeID(token) campaign = CampaignModel.find_by_id(campaign_id) if not campaign or campaign.token != token: return {"success": False, 'message': 'Record Not Found'}, 404 campaign.deleted_by = 1 campaign.deleted_on = datetime.now() campaign.save_to_db() #campaign.delete_from_db() return {"success": True, 'message': 'Record deleted.'}, 200 except Exception as e: return {"success": False, "message": str(e)}
def put(self, campaign_name): data = self.parser.parse_args() campaign = CampaignModel.find_by_name(campaign_name) if campaign: campaign.description = data['description'] campaign.brand_id = data['brand_id'] campaign.product_ids = data['product_ids'] campaign.currency_id = data['currency_id'] campaign.budget_amount = data['budget_amount'] campaign.objective_id = data['objective_id'] campaign.kpi_id = data['kpi_id'] campaign.target_locations = data['target_locations'] campaign.exclude_locations = data['exclude_locations'] campaign.modified_on = datetime.now() campaign.modified_by = 1 else: return {"Message": "Record Not FOUND"} campaign.save_to_db() return campaign.json()
def post(self, campaign_name): db.create_all() db.session.commit() if CampaignModel.find_by_name(campaign_name): return { 'message': "An Record with name '{}' already exists.".format( campaign_name) }, 400 data = self.parser.parse_args() campaign = CampaignModel( campaign_name, **data, ) campaign.created_by = 1 campaign.created_on = datetime.now() campaign.modified_by = 0 campaign.deleted_by = 0 campaign.start_date = datetime.now() campaign.end_date = datetime.now() campaign.days = 1 try: campaign.save_to_db() except Exception as e: return { "message": "An error occurred while inserting the Record.'{}'".format(e) } return campaign.json(), 201
def post(self): data = self.parser.parse_args() campaign = CampaignModel(**data) campaign.created_by = 1 campaign.created_on = datetime.now() campaign.modified_by = 0 campaign.deleted_by = 0 campaign.modified_on = None campaign.deleted_on = None try: validateObj = CampaignModel.validateData(data, request) if type(validateObj) is dict: return {"success": False, "errors": validateObj}, 400 if CampaignModel.find_by_name(data['campaign_name']): return { "success": False, "message": "A campaign with that Record Name already exists" }, 400 campaign_name = data['campaign_name'] description = data['description'] target_locations = data['target_locations'] exclude_locations = data['exclude_locations'] ######################## CHECKING STRING HAS VALUE OR NOT################################################### if (campaign_name.strip() and description.strip() and target_locations.strip() and exclude_locations.strip()): campaign.save_to_db() campaign.token = encodeID(campaign.campaign_id) campaign.save_to_db() else: return { "success": False, "message": "String Should not be empty" } except Exception as e: return { "message": "An error occurred creating the Record.'{}'".format(e) }, 500 return campaign.json(), 201