def book(): name = request.form.get("name").strip() if name == '': return render_template("error_p.html", message="Empty name not allowed !!") try: flight_id = int(request.form.get("flight_id")) except: return render_template( "error_p.html", message="Invalid flight ID(DO NOT TEMPER WITH HTML) !!!") if db.execute("SELECT * FROM flights WHERE id=:id", { "id": flight_id }).rowcount == 0: return render_template("error_p.html", message="No such flight exist !!!") db.execute( "INSERT INTO passengers(name, flight_id) VALUES (:name, :flight_id)", { "name": name, "flight_id": flight_id }) db.commit() # no change commited untill this command execute... return render_template("success_p.html")
def main(): # List all flights. flights = db.execute( "SELECT id, origin, destination, duration FROM flights").fetchall() for flight in flights: print( f"Flight {flight.id}: {flight.origin} to {flight.destination}, {flight.duration} minutes." ) # Prompt user to choose a flight. flight_id = int(input("\nFlight ID: ")) flight = db.execute( "SELECT origin, destination, duration FROM flights WHERE id = :id", { "id": flight_id }).fetchone() print(flight) # Make sure flight is valid. if flight is None: print("Error: No such flight.") return # List passengers. passengers = db.execute( "SELECT name FROM passengers WHERE flight_id = :flight_id", { "flight_id": flight_id }).fetchall() print("\nPassengers:") for passenger in passengers: print(passenger.name) if len(passengers) == 0: print("No passengers.")
def flight(flight_id): flight = db.execute("SELECT * FROM flights WHERE id=:id", { "id": flight_id }).fetchone() if flight is None: return render_template("error_p.html", message="No such flight exist !!!") passengers = db.execute( "SELECT name from passengers WHERE flight_id=:flight_id", {"flight_id": flight_id}) return render_template("passenger_in_flight.html", flight=flight, passengers=passengers)
def main(): flights = db.execute( "SELECT origin, destination, duration FROM flights").fetchall() # print(f"type :: {type(flights)}, {type(flights[0])}") for flight in flights: print( f"{flight.origin} to {flight.destination}, {flight.duration} minutes." )
def passengers(): passengers_list = db.execute("SELECT * FROM passengers JOIN flights ON\ flights.id=passengers.flight_id").fetchall() # for passenger in passengers_list: # print(passenger) # print(passenger.name) # print(passenger.origin) # print(passenger.destination) return render_template("passengers_list.html", passengers_list=passengers_list)
def index_p(): flights = db.execute("SELECT * FROM flights").fetchall() return render_template("index_p.html", flights=flights)