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)