3 ؀h@sDddlmZmZmZmZmZmZmZddlmZm Z ddl Z ddl Z ddl Z ddl Z ddlZddlmZddlmZddlmZddlmZddlmZdd lmZdd lmZdd lmZdd lm Z d dZ!GdddZ"GdddZ#GdddZ$GdddZ%GdddZ&GdddZ'GdddZ(GdddZ)dS))Flaskjsonifyrender_templateurl_forrequestredirectjson)datetime timedeltaN)db) BookingType) PaymentMethod) BookingStatus) Mandatory)Vehicle) GuestType)Gate)FacilityPricingcCs|jjdS)N)sessionclose)selfr-/booking_service/app/routes/seed_functions.pyrsrc@seZdZddZdS)BookingTypeSeedcCsg}tjjtjtjdkjtjdkjdkrXtdddddd}tjj||j dtjjtjtjdkjtjd kjdkrtd d d dddd }tjj||j d tjjtjtjdkjtjdkjdkrtddddddd }tjj||j dtjjtjtjdkjtjdkjdkr^tddddddd }tjj||j dtjjtjtjdkjtjdkjdkrtdddddd}tjj||j dtjjtjtjdkjtjdkjdkr tdddddd}tjj||j dtjjtjtjdkjtjdkjdkr`tdd d!ddd}tjj||j d"y,tjj t t|j d#t d$|id%fSt k r}z8t|tjjt tg}|j d&t d$|id'fSd}~XnXdS)(NPB001A20rzPartner BookingzA booking made by a partner.1Admin)booking_type_public_idbooking_type_namebooking_type_descriptionbooking_type_back session_idz/Partner Booking has been added to the database.GB601X10z Guest BookingzA guest booking.)rrrbooking_type_publicr r!z-Guest Booking has been added to the database.ZVB938L19Z VolunteerzVolunteer booking.z)Volunteer has been added to the database.FF9330A3zFront Office BookingzFront Office Booking booking.z4Front Office Booking has been added to the database.8D7E6504SchoolzSchool booking.)rrrbooking_type_groupr!z&School has been added to the database.C3237489 CorporatezCorporate booking.z)Corporate has been added to the database.7769748CzMember BookingzMember booking.z&Member has been added to the database.z9The booking types table has been seeded. Please carry on.messagezgIt's us, not you. There was an error while seeding the booking types table. :-( Please try again later.i)r rqueryr filterdeletion_markerrcountaddappendcommitrr Exceptionprintrollback)outputpartner_booking guest_bookingZ volunteerschool corporatemembererrr"seed_default_booking_types_methodss                                z2BookingTypeSeed.seed_default_booking_types_methodsN)__name__ __module__ __qualname__r>rrrrrsrc@seZdZddZdS)BookingStatusSeedc Cszg}tjjtjtjdkjtjdkjdkrVtddddd}tjj||j dtjjtjtjdkjtjdkjdkrtdd d dd}tjj||j d tjjtjtjdkjtjd kjdkrtd d ddd}tjj||j dtjjtjtjdkjtjdkjdkrNtddddd}tjj||j dtjjtjtjdkjtjdkjdkrtddddd}tjj||j dtjjtjtjdkjtjdkjdkrtddddd}tjj||j dtjjtjtjdkjtjdkjdkrJtddddd}tjj||j dtjjtjtjdkjtjd kjdkrtd d!d"dd}tjj||j d#tjjtjtjdkjtjd$kjdkrtd$d%d&dd} tjj| |j d'y,tjj t t|j d(t d)|id*fSt k rt} z8t| tjjt tg}|j d+t d)|id,fSd} ~ XnXdS)-Nz$d0c9dc58-4bd7-4279-85e1-70b8b1632f02r ConfirmedzA confirmed order.r)booking_status_public_idbooking_status_namebooking_status_descriptionr!z)Confirmed has been added to the database.z$4161804a-846b-438d-b969-ae2af85fd4c8 UnconfirmedzAn unconfirmed booking.z+Unconfirmed has been added to the database.z$17e163c2-cbcf-4323-9606-609f0015fb65 AbandonedzAn abandoned booking.z)Abandoned has been added to the database.z$626f13f2-aab0-4488-a774-44969b3062a3 CancelledzA cancelled booking.z)Cancelled has been added to the database.z$d57587b6-24da-40a6-a4d1-fe41972dc936zPending Paymentz%A booking that is yet to be paid for.z/Pending Payment has been added to the database.z$3216010b-7c03-48b4-b82e-6c8ea5e3096bzNo-ShowzGA booking that is yet to be checked in past the expected check-in date.z'No-Show has been added to the database.z$693afa26-7429-4a79-afbf-e44e513663dfUpdatedz A booking that has been updated.z'Updated has been added to the database.z$3b5376e0-a4dc-476e-aebc-6280b44b756az To Invoicez A booking that is to be invoicedz*To Invoice has been added to the database.z$180e751e-a70f-4052-8119-0dffd938c2c9Depositz2A booking that has had an incomplete payment made.z'Deposit has been added to the database.z:The booking status table has been seeded. Please carry on.r+r,zhIt's us, not you. There was an error while seeding the booking status table. :-( Please try again later.i)r rr-rr.r/rDr0r1r2r3rrr4r5r6) r7Z confirmedZ unconfirmedZ abandoned cancelledpendingZno_showupdatedinvoiceZdepositr=rrrseed_default_booking_statuss                                        z-BookingStatusSeed.seed_default_booking_statusN)r?r@rArPrrrrrBsrBc@seZdZddZdS)PaymentMethodSeedcCsg}tjjtjtjdkjtjdkjdkrZtddddddd}tjj||j dtjjtjtjdkjtjd kjdkrtd d d dddd}tjj||j d tjjtjtjdkjtjd kjdkrtd ddddd}tjj||j dtjjtjtjdkjtjdkjdkr\tdddddd}tjj||j dtjjtjtjdkjtjdkjdkrtddddddd}tjj||j dtjjtjtjdkjtjdkjdkr tdddddd}tjj||j dtjjtjtjdkjtjdkjdkr`tdddddd}tjj||j d y,tjj t t|j d!t d"|id#fSt k r}z8t|tjjt tg}|j d$t d"|id%fSd}~XnXdS)&Nz$73414fc2-5bf7-42d1-9cdf-08fee8a0b08erz Credit CardzMeans of payment by credit cardrr)payment_method_public_idpayment_method_namepayment_method_descriptionpayment_method_guestpayment_method_partnerr!z+Credit Card has been added to the database.z$cbff45f3-4f12-41da-8b4a-bf308112f032ZMpesazMobile money payment method.z%Mpesa has been added to the database.z$746bb582-89ed-4c83-ac3c-f25d9d60b266z Bank Transferz"Means of payment by bank transfer.)rRrSrTrVr!z-Bank Transfer has been added to the database.z$a4e3aeb3-0937-49d5-b3dd-87b8c2f2654bZOtherzMiscellaneous payment method.z%Other has been added to the database.z$4c6a9513-ea69-437e-9c3a-32a7afc1706az%Split (Two Different Payment Methods)zA mix of two payment methods.zESplit (Two Different Payment Methods) has been added to the database.z$94a91336-3bac-4e2f-8881-2887d27e4d61Z InclusivezN/A.z)Inclusive has been added to the database.z$1e62ecfc-6a3a-4112-835c-4dc3fe8e28c7ZPrepaidz'Prepaid has been added to the database.z;The payment methods table has been seeded. Please carry on.r+r,ziIt's us, not you. There was an error while seeding the payment methods table. :-( Please try again later.i)r rr-r r.r/rRr0r1r2r3rrr4r5r6)r7Z card_methodZ mpesa_methodZbank_transfer_methodr=rrrseed_default_payment_methods>s                                z.PaymentMethodSeed.seed_default_payment_methodsN)r?r@rArWrrrrrQ=srQc@seZdZddZdS)MandatoryPaymentsSeedc Csrg}tjjtjtjdkjtjdkjdkrtddddddd d }tjj||j d td d ddddd d }tjj||j dtddddddd d }tjj||j dtddddddd d }tjj||j dtddddddd d }tjj||j dtd d!dd"ddd d }tjj||j d#td$d%ddddd d }tjj||j d&td'd(dd"ddd d }tjj||j d)td*d+dd,ddd d } tjj| |j d-tdd.dd/d0dd d } tjj| |j d1y,tjj t t|j d2t d3|id4fSt k rl} z8t| tjjt tg}|j d5t d3|id6fSd} ~ XnXdS)7Nz$cf347d6b-11e8-4b85-95bf-543da14e0bb3rz$cdf8982a-3252-40ec-a49b-d752420eaa9bzNon Resident AdultZUSDZ85Air)payment_public_idpayment_personpayment_person_currencypayment_person_amountmarkermaximum_numberr!z2Non Resident Adult has been added to the database.z$6ba37724-04df-4a1d-b475-c2915ec52a81zNon Resident ChildZ42Ciz2Non Resident Child has been added to the database.z$9ab7da60-6813-411a-9a00-f2d8a413c5bbzNon Resident Student21iz4Non Resident Student has been added to the database.z$b0dc8ab1-91e2-4474-ad29-9dcda9c30fc5zEA Resident AdultKESZ2200z1EA Resident Adult has been added to the database.z$a0d24649-c085-4b5e-adec-d3f93f2e22d2zEA Resident ChildZ1100z1EA Resident Child has been added to the database.z$18b25633-12bb-44da-b9f8-47dc629bace4zEA Resident Student550z3EA Resident Student has been added to the database.z$a8fe2f62-1671-41ff-a059-d80a5d1d3ea7z Citizen Adultz-Citizen Adult has been added to the database.z$c1b66cb1-6c83-42c0-86f5-0db21d1b9f60z Citizen Childz-Citizen Child has been added to the database.z$c7bf17ef-5d92-4cf7-866a-881fba828de3zCitizen StudentZ275z/Citizen Student has been added to the database.Infant0Iz&Infant has been added to the database.z>The mandatory payments table has been seeded. Please carry on.r+r,zlIt's us, not you. There was an error while seeding the mandatory payments table. :-( Please try again later.i)r rr-rr.r/rZr0r1r2r3rrr4r5r6) r7non_resident_adultnon_resident_childnon_resident_studentZea_resident_adultZea_resident_childea_resident_studentZ citizen_adultZ citizen_childcitizen_studentZinfantr=rrrseed_default_mandatory_paymentss                          z5MandatoryPaymentsSeed.seed_default_mandatory_paymentsN)r?r@rArlrrrrrXsrXc@seZdZddZdS)VehicleChargesSeedcCsg}tjjtjtjdkjtjdkjdkrZtddddddd}tjj||j d tjjtjtjdkjtjd kjdkrtd d d dddd}tjj||j d tjjtjtjdkjtjdkjdkrtddddddd}tjj||j dy,tjj t t|j dt d|idfSt k r}z8t|tjjt tg}|j dt d|idfSd}~XnXdS)Nz$d1954103-53af-4411-9550-1634d255e343rz 1 to 6 Seatsiz$162fface-f5f1-41de-913b-d2bb784dda3ar)vehicle_charge_public_idvehicle_charge_categoryvehicle_charge_category_costvehicle_charge_cost_currencyr_r!z/The vehicle class 1 to 6 seats has been seeded.z$e6473bfe-ccc1-4f96-850a-ae022eb4e87az 7 to 14 Seatsiz0The vehicle class 7 to 14 seats has been seeded.z$99330ddf-4bd6-4c5e-8844-66b6d7ba1134z15 Seats and Abovei'z5The vehicle class 15 seats and above has been seeded.z;The vehicle charges table has been seeded. Please carry on.r+r,ziIt's us, not you. There was an error while seeding the vehicle charges table. :-( Please try again later.i)r rr-rr.r/ror0r1r2r3rrr4r5r6)r7Z vehicle_1Z vehicle_2Z vehicle_3r=rrrseed_default_vehicle_chargesbsh                z/VehicleChargesSeed.seed_default_vehicle_chargesN)r?r@rArsrrrrrmasrmc@seZdZddZdS)BookingGuestTypesSeedc Cs6g}tjjtjtjdkjtjdkjdkrTtdddd}tjj||j dtjjtjtjdkjtjdkjdkrtdddd}tjj||j d tjjtjtjdkjtjd kjdkrtd d dd}tjj||j d tjjtjtjdkjtjd kjdkrFtd ddd}tjj||j dtjjtjtjdkjtjdkjdkrtdddd}tjj||j dtjjtjtjdkjtjdkjdkrtdddd}tjj||j dtjjtjtjdkjtjdkjdkrBookingGuestTypesSeed.seed_default_booking_guest_types_methodsN)r?r@rArxrrrrrtsrtc@seZdZddZdS) GatesSeedcCs,g}tjjtjtjdkjtjdkjdkrTtdddd}tjj||j dtjjtjtjdkjtjdkjdkrtdddd}tjj||j d y,tjj t t|j d t d |id fSt k r&}z8t|tjjt tg}|j d t d |idfSd}~XnXdS)NZ05e7ee16rzGolf 2r)gate_public_id gate_namer!z&Golf 2 has been added to the database.Z9ac19eb6zGolf 3z&Golf 3 has been added to the database.z1The gates table has been seeded. Please carry on.r+r,z_It's us, not you. There was an error while seeding the gates table. :-( Please try again later.i)r rr-rr.r/rzr0r1r2r3rrr4r5r6)r7Zgate1Zgate2r=rrrseed_default_gates3sB            zGatesSeed.seed_default_gatesN)r?r@rAr|rrrrry2sryc@seZdZddZdS)FacilityPricingTypeSeedcCsg}tjjtjtjdkjtjdkjdkrVtddddd}tjj||j dtjjtjtjdkjtjdkjdkrtddddd}tjj||j d tjjtjtjdkjtjd kjdkrtd d ddd}tjj||j d y,tjj t t|j d t d|idfSt k r|}z8t|tjjt tg}|j dt d|idfSd}~XnXdS)N266677c3rz Fully Cateredr)facility_pricing_type_public_idfacility_pricing_namefacility_pricing_specialr!z-Fully Catered has been added to the database.9a9a77ebz Self-cateredz,Self-catered has been added to the database.377788d4zSelf-catered plus Chefz6Self-catered plus Chef has been added to the database.zBThe facility pricing types table has been seeded. Please carry on.r+r,zpIt's us, not you. There was an error while seeding the facility pricing types table. :-( Please try again later.i)r rr-rr.r/rr0r1r2r3rrr4r5r6)r7Z fully_cateredZ self_cateredZchefr=rrr#seed_default_facility_pricing_typesds\                z;FacilityPricingTypeSeed.seed_default_facility_pricing_typesN)r?r@rArrrrrr}csr})*flaskrrrrrrrr r pymysqlosmathrequestsuuidroutesr database.booking_typesr database.payment_methodsr database.booking_statusrdatabase.mandatory_paymentsrdatabase.vehiclerdatabase.booking_guest_typesr database.gaterdatabase.facility_pricing_typerrrrBrQrXrmrtryr}rrrrs2$(          G 1