def btn_click_saveFlight( save_Btn, user ): #.............................................................................. save_Btn.config(state='disabled') save_Btn.config(text="Flight Created!") date = global_year_entry + "-" + global_mon_entry + "-" + global_day_entry db.create_flights(global_airline_Name, date, global_time_entry, global_from_Airport, global_to_Airport, global_capacity_entry, global_fare_entry, 'ON-TIME')
import DB_UTIL as db #import numpy as np con = db.db_connect() #""" #Here, I simply test the functionality of the DB. Give it a shot db.create_flights('MANEMARS', '3030-30-30', '22:30:30', 'Area51', 'MarsRover', 1, 0, 'ON-TIME') a = db.get_Flights('To_Airport') print(a) #db.queryexec("DELETE FROM Cust_Flight;") #con.commit() #print(db.book_a_flight('paul', 1, 'GUI')) #print(db.book_a_flight('paul', 420, 'SEARCH')) db.cancel_flight_admin(420) #Now check reservations print('\n\n') print(db.get_full_user_reservation('paul')) db.cancel_reservation_passenger('paul', 420) print(db.get_full_user_reservation('paul')) #""" #Lets test my new work here #for i in range(1, 10): #print(db.get_user_reservation('paul')) #flight_from_jfk = db.queryexec("SELECT * FROM Flights WHERE From_Airport = 'KJFK-New York' ORDER BY Airline_Name ASC") #print(flight_from_jfk)
import randdata as rd conobj = DB_UTIL.db_connect() #Connect to the DB #So now that we're connected, lets start adding things. #for i in range(0, len(customers)): # DB_UTIL.create_customer(conobj, customers[i]) for i in range(0, len(rd.airports)): DB_UTIL.create_airports(rd.airports[i][0], rd.airports[i][1], rd.airports[i][2]) for i in range(0, len(rd.airlines)): DB_UTIL.create_airlines(rd.airlines[i]) for i in range(0, len(rd.flights)): DB_UTIL.create_flights(rd.flights[i][0], rd.flights[i][1], rd.flights[i][2], rd.flights[i][3], rd.flights[i][4], rd.flights[i][5], rd.flights[i][6], rd.flights[i][7]) #Now, lets see if we've successfully added all these to the DB. print(DB_UTIL.queryexec('SELECT * FROM Flights')) #This is hardcoded SQL, not the best way to do this, but it'll give us a glimpse at whether this works or not. Do avoid sing this though. """ If console returns something like: $ python ex1.py 2.6.0 [(1, 'Paul', 'Pluszczewicz'), (2, 'Martin', 'Sendrowicz'), (3, 'Mohammed', 'Rahat'), (4, 'Sateesh', 'Mane'), (5, 'Joe', 'Schmo'), (6, 'Duncan', 'Donut'), (7, 'Bill', 'Gates')] This means all is working well. Excellent! """ #conobj.commit() conobj.close()