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}
