def run(): """ Create 4 Ticket seeds """ full_ticket = Ticket() daily_ticket_a = Ticket() daily_ticket_b = Ticket() daily_ticket_c = Ticket() community_ticket = Ticket() full_ticket.ticket_type = 'full' daily_ticket_a.ticket_type = 'daily-13' daily_ticket_b.ticket_type = 'daily-14' daily_ticket_c.ticket_type = 'daily-15' community_ticket.ticket_type = 'community' full_ticket.price = 400000 daily_ticket_a.price = 200000 daily_ticket_b.price = 300000 daily_ticket_c.price = 350000 community_ticket.price = 0 full_ticket.information = 'Ticket for full 3 days devsummit event.' daily_ticket_a.information = 'Ticket for 13th November at devsummit event.' daily_ticket_b.information = 'Ticket for 14th November at devsummit event.' daily_ticket_c.information = 'Ticket for 15th November at devsummit event.' community_ticket.information = 'Ticket for community, only given by admin.' db.session.add(full_ticket) db.session.add(daily_ticket_a) db.session.add(daily_ticket_b) db.session.add(daily_ticket_c) db.session.add(community_ticket) db.session.commit()
def test_valid_id(): ticket = Ticket(title='test', creator="*****@*****.**", created=datetime.now()) ticket.save() abort_if_ticket_id_invalid(ticket.id) ticket.delete()
def create(self, payloads): self.model_ticket = Ticket() self.model_ticket.ticket_type = payloads['ticket_type'] self.model_ticket.price = payloads['price'] self.model_ticket.information = payloads['information'] self.model_ticket.type = payloads['type'] self.model_ticket.usd_price = payloads['usd_price'] if payloads['type'] == TICKET_TYPES['exhibitor']: if payloads['proposal_url']: proposal_url = self.save_file( payloads['proposal_url'] ) if payloads['proposal_url'] is not None else None self.model_ticket.proposal_url = proposal_url db.session.add(self.model_ticket) try: db.session.commit() data = self.model_ticket.as_dict() if payloads['type'] == TICKET_TYPES['exhibitor'] and data[ 'proposal_url']: data['proposal_url'] = Helper().url_helper( data['proposal_url'], current_app.config['GET_PROPOSAL_DOC_DEST']) print(data['proposal_url']) return {'error': False, 'data': data} except SQLAlchemyError as e: data = e.orig.args return {'error': True, 'data': data}
def get_event_ticket(): set_settings(paypal_mode='sandbox', paypal_sandbox_username=environ.get('PAYPAL_SANDBOX_USERNAME', 'SQPTVKtS8YvItGQuvHFvwve4'), paypal_sandbox_password=environ.get('PAYPAL_SANDBOX_PASSWORD', 'SQPTVKtS8YvItGQuvHFvwve4'), paypal_sandbox_signature=environ.get('PAYPAL_SANDBOX_SIGNATURE', 'SQPTVKtS8YvItGQuvHFvwve4'), secret='super secret key') event = ObjectMother.get_event() event.name = 'Super Event' event.state = 'Published' event.paypal_email = '*****@*****.**' save_to_db(event, "Event Saved") stripe_auth = StripeAuthorization( stripe_secret_key=environ.get('STRIPE_SECRET_KEY', 'sk_test_SQPTVKtS8YvItGQuvHFvwve4'), stripe_refresh_token=environ.get('STRIPE_REFRESH_TOKEN', 'sk_test_SQPTVKtS8YvItGQuvHFvwve4'), stripe_publishable_key=environ.get('STRIPE_PUBLISHABLE_KEY', 'pk_test_e2jsd4RNUlYesCUb2KJ9nkCm'), stripe_user_id=environ.get('STRIPE_USER_ID', '1445522255'), stripe_email=environ.get('STRIPE_EMAIL', '*****@*****.**'), event_id=event.id ) save_to_db(stripe_auth, "StripeAuthorization Saved") ticket = Ticket(name='Test Ticket', type='paid', sales_start=datetime.now() - timedelta(days=5), sales_end=datetime.now() + timedelta(days=5), description="SomeTicket", event=event, price=50) save_to_db(ticket, "Ticket Saved") save_to_db(Module(ticket_include=True, payment_include=True, donation_include=True)) return event, ticket
def create_ticket(self, flight_seat_id, ticket_no, status, user_id): ticket = Ticket(flight_seat_id=flight_seat_id, ticket_no=ticket_no, status=status, user_id=user_id) ticket.save() return ticket
def load_test_data(test_date): user = User('test123', 'abc123') user.save() user = User.query.all()[0] meal = Meal('Test meal', 'Meal desciption', test_date, b'009383615') meal.save() meal = Meal.query.all()[0] availability = Availability(test_date, meal.id) availability.save() availability = Availability.query.all()[0] ticket1 = Ticket(test_date, user.id, availability.id) ticket1.save() ticket2 = Ticket(test_date, user.id, availability.id) ticket2.save()
def add_ticket(): form = AddTicketForm(request.form) if request.method == 'POST': # and form.validate(): with db.auto_commit(): ticket = Ticket() ticket.set_attrs(form.data) db.session.add(ticket) return redirect(url_for('admin.add_ticket')) return render_template('admin/TicketAdd.html', form=form)
def save_tickets(tickets_data, event): """ Save all tickets :param tickets_data: :param event: :return: """ ticket_ids = [] for ticket_data in tickets_data: if ticket_data['id']: with db.session.no_autoflush: ticket = Ticket.query.filter_by(id=ticket_data['id'], event_id=event.id).first() ticket_tags = db.session.query(ticket_tags_table).filter_by( ticket_id=ticket.id) if ticket_tags.first(): ticket_tags.delete() else: ticket = Ticket(event=event) ticket.name = ticket_data['name'] ticket.quantity = ticket_data[ 'quantity'] if ticket_data['quantity'] != '' else 100 ticket.position = ticket_data['position'] ticket.type = ticket_data['type'] ticket.description_toggle = ticket_data['description_visibility'] ticket.description = ticket_data['description'] ticket.price = ticket_data['price'] if ticket_data[ 'price'] != '' and ticket.type == 'paid' else 0 ticket.hide = ticket_data['ticket_visibility'] ticket.min_order = ticket_data[ 'min_order'] if ticket_data['min_order'] != '' else 1 ticket.max_order = ticket_data[ 'max_order'] if ticket_data['max_order'] != '' else 10 ticket.sales_start = get_event_time_field_format( ticket_data, 'sales_start') ticket.sales_end = get_event_time_field_format(ticket_data, 'sales_end') ticket.absorb_fees = ticket_data['absorb_fees'] if ticket_data['tags_string'].strip() != '': tag_names = ticket_data['tags_string'].split(',') for tag_name in tag_names: tag = TicketTag(name=tag_name, event_id=event.id) db.session.add(tag) db.session.add(ticket) ticket_ids.append(ticket.id) with db.session.no_autoflush: unwanted_tickets = Ticket.query.filter( ~Ticket.id.in_(ticket_ids)).filter_by(event_id=event.id).all() for unwanted_ticket in unwanted_tickets: if not unwanted_ticket.has_order_tickets(): db.session.delete(unwanted_ticket)
def create(self, db: Session, *, obj_in: TicketCreate) -> Ticket: db_obj = Ticket( ticket_id=obj_in.ticket_id, contract_nr=obj_in.contract_nr, customer_name=obj_in.customer_name, status=obj_in.status, kind=obj_in.kind, owner_id=obj_in.owner_id, store_internal_id=obj_in.store_internal_id, created_at=obj_in.created_at, updated_at=obj_in.updated_at, ) db.add(db_obj) db.commit() db.refresh(db_obj) return db_obj
def add_ticket_to_db(ticket, date_search, iata_from_model, iata_to_model): ticket_info = check_ticket(ticket) if ticket_info["flights"][0]["invalid"] == 1: return ticket["price"] = ticket_info["flights_price"] new_ticket = Ticket( fly_from=iata_from_model, fly_to=iata_to_model, date_from=ticket["date_from"], date_to=ticket["date_to"], date_search=date_search, booking_token=ticket["booking_token"], price=ticket["price"], ) db_session.add(new_ticket) db_session.commit()
def add(current_user, workspaceId, projectId): """ Create Tickets """ if request.content_type == 'application/json': post_data = request.get_json() ticket = Ticket( firstName=post_data.get('firstName'), lastName=post_data.get(""), notes=post_data.get("notes"), phone=post_data.get("phone"), email=post_data.get("email"), channel=post_data.get("channel"), lastModified=util.get_current_time(), modifiedBy=current_user.email_id, category=post_data.get("category"), status=post_data.get("status"), # createdOn = post_data.get(None, null=True), createdBy=current_user.email_id, isDeleted=False, projectId=projectId) ticket.create() res_payload = { 'id': ticket._id, 'firstName': ticket.firstName, 'lastName': ticket.lastName, 'channel': ticket.channel, 'createdOn': ticket.createdOn, 'status': ticket.status, 'notes': ticket.notes, 'category': ticket.category, 'phone': ticket.phone, 'email': ticket.email } return response_with_obj('success', 'Ticket created successfully', res_payload, 200) else: return response('failed', 'Content-type must be json', 402)
def post(self): """ Creating an Ticket ad """ ticket_schema = TicketSchema() ticket_data = request.get_json() validated_ticket_data, errors = ticket_schema.load(ticket_data) if errors: return dict(status='fail', message=errors), 400 ticket = Ticket(**validated_ticket_data) saved_ticket = ticket.save() if not saved_ticket: return dict(status='fail', message='Internal Server Error'), 500 new_ticket_data, errors = ticket_schema.dumps(ticket) return dict(status='success', data=dict(ticket=json.loads(new_ticket_data))), 201
def post(self): args = ticketParser.parse_args() ticket = Ticket(title = args['title'], creator = args['creator'], created=datetime.now()) ticket.save() return {'ticket_id' : ticket.id}