def delete(self, id): response = ResponseBuilder() sponsor = db.session.query(Sponsor).filter_by(id=id) if sponsor.first(): sponsor_dict = sponsor.first().as_dict() if sponsor_dict['attachment'] is not None: Helper().silent_remove(current_app.config['STATIC_DEST'] + sponsor_dict['attachment']) sponsor.delete() db.session.commit() return response.set_message('data deleted').set_data(None).build() return response.set_message('data not found').set_error(True).build()
def delete(self, id): response = ResponseBuilder() self.model_booth_gallery = db.session.query(BoothGallery).filter_by(id=id) if self.model_booth_gallery.first() is not None: # delete file os.remove(current_app.config['STATIC_DEST'] + self.model_booth_gallery.first().url) # delete row self.model_booth_gallery.delete() db.session.commit() return response.set_message('data deleted successfully').set_error(False).build() else: return response.set_message('data not found').set_error(True).build()
def postIncludes(self, includes): response = ResponseBuilder() user_id = self.model_user.as_dict()['id'] entityModel = eval(includes['name'])() entityModel.user_id = user_id for key in includes: if key is not 'name': setattr(entityModel, key, includes[key]) db.session.add(entityModel) try: db.session.commit() if includes['name'] == 'Booth': user_booth = UserBooth() user_booth.user_id = user_id user_booth.booth_id = entityModel.as_dict()['id'] db.session.add(user_booth) db.session.commit() return response.set_data(None).build() except SQLAlchemyError as e: data = e.args return response.set_message(data).set_error(True).set_data( None).build()
def update_photo(self, payloads, id): response = ResponseBuilder() try: user_photo = db.session.query(UserPhoto).filter_by(user_id=id) file = payloads['photo'] photo = None photo = self.save_file(file, id) if user_photo.first() is None: user_photo = UserPhoto() user_photo.user_id = id user_photo.url = photo db.session.add(user_photo) db.session.commit() return response.set_message('Photo updated').set_data(None).build() if photo: user_photo.update({ 'url': photo, 'updated_at': datetime.datetime.now() }) db.session.commit() data = user_photo.first().as_dict() return response.set_data(data).build() except SQLAlchemyError as e: data = e return response.set_error(True).set_data(data).build()
def delete(self, id): response = ResponseBuilder() source = db.session.query(Source).filter_by(id=id) if source.first() is not None: # delete row source.delete() db.session.commit() return response.set_message('data deleted').build() else: return response.set_data(None).set_message('data not found').set_error(True).build()
def delete(self, id): response = ResponseBuilder() rundown = db.session.query(RundownList).filter_by(id=id) if rundown.first() is not None: # delete row rundown.delete() db.session.commit() return response.set_message('data deleted').build() else: data = 'data not found' return response.set_data(None).set_message(data).set_error(True).build()
def delete(self, id): response = ResponseBuilder() packagemanagement = db.session.query(PackageManagement).filter_by( id=id) if packagemanagement.first() is not None: packagemanagement.delete() db.session.commit() return response.set_message('Package entry was deleted').build() else: data = 'Entry not found' return response.set_data(None).set_message(data).set_error( True).build()
def delete(self, id): response = ResponseBuilder() orderverification = db.session.query(OrderVerification).filter_by(id=id).first() if orderverification.payment_proof is not None: Helper().silent_remove(current_app.config['STATIC_DEST'] + orderverification.payment_proof) orderverification = db.session.query(OrderVerification).filter_by(id=id) if orderverification.first() is not None: orderverification.delete() db.session.commit() return response.set_message('Order Verification entry was deleted').build() else: data = 'Entry not found' return response.set_data(None).set_message(data).set_error(True).build()
def credit_payment(self, payloads): response = ResponseBuilder() if not all( isinstance(string, str) for string in [ payloads['order_id'], payloads['email'], payloads['first_name'], payloads['last_name'], payloads['phone'], payloads['card_number'], payloads['card_exp_month'], payloads['card_exp_year'], payloads['card_cvv'], payloads['client_key'] ]) and not isinstance(payloads['gross_amount'], int): return response.build_invalid_payload_response() # get the token id first token_id = requests.get( url + 'card/register?' + 'card_number=' + payloads['card_number'] + '&card_exp_month=' + payloads['card_exp_month'] + '&card_exp_year=' + payloads['card_exp_year'] + '&card_cvv=' + payloads['card_cvv'] + '&bank=' + payloads['bank'] + '&secure=' + 'true' + '&gross_amount=' + str(payloads['gross_amount']) + '&client_key=' + payloads['client_key'], headers=self.headers) token_id = token_id.json() # prepare data data = {} if 'status_code' in token_id and token_id['status_code'] == '200': data['saved_token_id'] = token_id['saved_token_id'] data['masked_card'] = token_id['masked_card'] else: return response.set_message( token_id['validation_messages'][0]).set_error(True).build() # check for referal discount ref = self.get_order_referal(payloads['order_id']) # generate order details payload item_details = self.get_order_details(payloads['order_id'], ref) data['payment_type'] = payloads['payment_type'] data['transaction_details'] = {} data['transaction_details']['order_id'] = payloads['order_id'] data['transaction_details']['gross_amount'] = payloads['gross_amount'] data['credit_card'] = {} data['credit_card']['token_id'] = token_id['saved_token_id'] data['item_details'] = item_details data['customer_details'] = {} data['customer_details']['first_name'] = payloads['first_name'] data['customer_details']['last_name'] = payloads['last_name'] data['customer_details']['email'] = payloads['email'] data['customer_details']['phone'] = payloads['phone'] return self.send_to_midtrans_api(data)
def delete(self, id): response = ResponseBuilder() prizelist_dict = db.session.query(PrizeList).filter_by(id=id).first() if prizelist_dict.attachment is not None: os.remove(current_app.config['STATIC_DEST'] + prizelist_dict.attachment) prizelist = db.session.query(PrizeList).filter_by(id=id) if prizelist.first() is not None: prizelist.delete() db.session.commit() return response.set_message('Prize list entry was deleted').build() else: data = 'Entry not found' return response.set_data(None).set_message(data).set_error( True).build()
def create(self, payloads): response = ResponseBuilder() codes = [r.code for r in db.session.query(RedeemCode.code).all()] for i in range(0, int(payloads['count'])): code = secrets.token_hex(4) while (code in codes): code = secrets.token_hex(4) self.model_redeem_code = RedeemCode() self.model_redeem_code.codeable_type = payloads['codeable_type'] self.model_redeem_code.codeable_id = payloads['codeable_id'] self.model_redeem_code.code = code self.model_redeem_code.used = False db.session.add(self.model_redeem_code) db.session.commit() return response.set_message('Redeem code created successfully').set_data(None).set_error(False).build()
def show(self, speaker): response = ResponseBuilder() speaker_document = db.session.query(SpeakerDocument).filter_by( speaker_id=speaker['id']).order_by( SpeakerDocument.created_at.desc()).all() if speaker_document is not None: speaker_document = BaseModel.as_list(speaker_document) for _speaker_document in speaker_document: _speaker_document['material'] = Helper().url_helper( _speaker_document['material'], app.config['GET_SPEAKER_DOC_DEST']) user = db.session.query(User).filter_by( id=speaker['user_id']).first().include_photos().as_dict() _speaker_document['user'] = user return response.set_data(speaker_document).build() else: data = 'data not found' return response.set_message(data).set_data(None).build()
def purchase(self, payloads): response = ResponseBuilder() codes = [r.code for r in db.session.query(RedeemCode.code).all()] package = db.session.query(PackageManagement).filter_by(id=payloads['package_id']).first() payloads['count'] = package.quota for i in range(0, int(payloads['count'])): code = secrets.token_hex(4) while (code in codes): code = secrets.token_hex(4) self.model_redeem_code = RedeemCode() self.model_redeem_code.codeable_type = payloads['codeable_type'] self.model_redeem_code.codeable_id = payloads['codeable_id'] self.model_redeem_code.code = code self.model_redeem_code.used = False db.session.add(self.model_redeem_code) db.session.commit() return response.set_message('Redeem code created successfully').set_data(package.as_dict()).set_error(False).build()
def purchase_user_redeems(self, payloads): response = ResponseBuilder() codes = [r.code for r in db.session.query(RedeemCode.code).all()] ticket = db.session.query(Ticket).filter_by(id=payloads['ticket_id']).first() for i in range(0, ticket.quota): code = secrets.token_hex(4) while (code in codes): print(code) code = secrets.token_hex(4) self.model_redeem_code = RedeemCode() self.model_redeem_code.codeable_type = 'user' self.model_redeem_code.codeable_id = payloads['codeable_id'] self.model_redeem_code.code = code self.model_redeem_code.used = False db.session.add(self.model_redeem_code) db.session.commit() return response.set_message('Redeem code created successfully').set_data(None).set_error(False).build()