def _sailors_who_sailed():
with get_db() as conn:
bname = request.form['boat-name']
rows = sailors_who_sailed(conn, bname)
return render_template("table.html",
name=f"Sailors who sailed '{bname}'",
rows=rows)
def _sailors_on_date():
with get_db() as conn:
date = request.form['date']
rows = sailors_on_date(conn, date)
return render_template("table.html",
name=f"Sailors who sailed on {date}",
rows=rows)
def _get_all_sailors_name_from_date():
with get_db() as conn:
date = request.args.get('date')
rows = get_all_sailors_name_from_date(conn, date)
return render_template("table.html",
name="Sailors Who Sailed On %s" % date,
rows=rows)
def _get_all_sailors_name_from_boat():
with get_db() as conn:
boat_name = request.args.get('boat-name')
rows = get_all_sailors_name_from_boat(conn, boat_name)
return render_template("table.html",
name="Sailors Who Sailed %s" % boat_name,
rows=rows)
def _voyages_added():
with get_db() as conn:
voy_sid = request.form["voyage_sid"]
voy_bid = request.form["voyage_bid"]
voy_dov = request.form["voyage_date"]
rows = add_voyage(conn, voy_sid, voy_bid, voy_dov)
return redirect('/voyages')
def _sailors_who_sailed_certain_color_boat():
with get_db() as conn:
color = request.form['color']
rows = sailors_who_sailed_certain_color_boat(conn, color)
return render_template("table.html",
name=f"Sailors who sailed a {color} boat",
rows=rows)
def _get_b_input():
if request.method == "POST":
s_name = request.form['sailor-name']
with get_db() as conn:
rows = which_sailor(conn, s_name)
return render_template("table.html", rows=rows, name="Sailors")
def pop_houses():
with get_db() as conn:
rows = getMostPopularHouse(conn)
print(currentDate(conn)[0]['CURRENT_TIMESTAMP'].split()[0])
return render_template("table.html",
rows=rows,
name="Most Popular Houses")
def add_boat_name() :
if request.method == "POST":
add_boat_name = request.form['add-boat-name']
add_boat_color = request.form['add-color-name']
with get_db() as conn:
_adding_boats(conn,add_boat_name,add_boat_color)
return redirect("/boats")
def _get_colors():
if request.method == "POST":
b_color = request.form['color']
with get_db() as conn:
rows = which_color(conn, b_color)
return render_template("table.html", rows=rows, name="Colors")
def _get_boats_by_popularity():
with get_db() as conn:
rows = get_boats_by_popularity(conn)
return render_template(
"table.html",
name="Boats ordered by popularity (Num of Voyages): ",
rows=rows)
def _get_sailors_from_boat_name():
with get_db() as conn:
boat_name = request.args.get('boat-name')
rows = get_sailors_from_boat_name(conn, boat_name)
return render_template("table.html",
name="Sailors who sailed boat: " + boat_name,
rows=rows)
def _get_dates():
if request.method == "POST":
v_date = request.form['date']
with get_db() as conn:
rows = which_date(conn, v_date)
return render_template("table.html", rows=rows, name="Dates")
def _boats_add():
with get_db() as conn:
name = request.form['name']
color = request.form['color']
boats_add(conn, name, color)
rows = boats(conn)
return render_template("table.html", name="Boats", rows=rows)
def _get_boats_from_sailors_name():
with get_db() as conn:
sailor_name = request.args.get('sailor-name')
rows = get_boats_from_sailor_name(conn, sailor_name)
return render_template("table.html",
name="Boats sailed by sailor: " + sailor_name,
rows=rows)
def _boats_sailed_by():
with get_db() as conn:
sname = request.form['sailor-name']
rows = boats_sailed_by(conn, sname)
return render_template("table.html",
name=f"Boats Sailed By {sname}",
rows=rows)
def _get_boats():
with get_db() as conn:
sailorName = request.form["sailor-name"]
rows = sailed_boats(conn, sailorName)
return render_template("table.html",
name=sailorName + " sailed these boats",
rows=rows)
def _get_input():
if request.method == "POST":
b_name = request.form['boat-name']
with get_db() as conn:
rows = who_sailed(conn, b_name)
return render_template("table.html", rows=rows, name="Boats")
def _getMyRes():
with get_db() as conn:
if(request.method == "GET"):
return render_template("/myReservations.html")
if(request.method == "POST"):
guestname = request.form['guestname']
rows = getMyRes(conn, guestname)
return render_template("table.html", name="Your Reservations", rows=rows)
def sailorsSailedBoatColorPage():
if request.method == 'POST':
with get_db() as conn:
b_color = request.form["boat-color"]
rows = sailorsSailedBoatColor(conn, b_color)
return render_template("table.html",
name='Boat Color: ' + b_color,
rows=rows)
def sailorsSailedOnDatePage():
if request.method == 'POST':
with get_db() as conn:
date = request.form["date"]
rows = sailorsSailedOnDate(conn, date)
return render_template("table.html",
name='Reserved on: ' + date,
rows=rows)
def sailorsSailedPage():
if request.method == 'POST':
with get_db() as conn:
b_name = request.form["boat-name"]
rows = sailorsSailed(conn, b_name)
return render_template("table.html",
name=b_name + ' reserved by:',
rows=rows)
def popularity():
with get_db() as conn:
x = request.args.get(" ")
print(x)
rows = boat_popular(conn, x)
return render_template("table.html",
name=" Boat Popularity ",
rows=rows)
def sail_date_Color_page():
with get_db() as conn:
x = request.args.get("color")
print(x)
rows = boat_color(conn, x)
return render_template("table.html",
name="Sailor Who sailed on a boat of color ",
rows=rows)
def _add_voyage_name():
if request.method == "POST":
add_sid = request.form["add-sid"]
add_bid = request.form["add-bid"]
add_date = request.form["add-date"]
with get_db() as conn:
_adding_voyages(conn,add_sid,add_bid,add_date)
return redirect("/voyages")
def sail_boat():
with get_db() as conn:
x = request.args.get("boat-name")
print(x)
rows = sail_boat(conn, x)
return render_template("table.html",
name="Sailor Who Sailed ",
rows=rows)
def billPage():
if(request.method == "GET"):
return render_template("viewBill.html", name="View Your Bill")
if request.method == 'POST':
with get_db() as conn:
resID = request.form["res_id"]
rows = viewBill(conn, resID)
return render_template("table.html", name='Your Bill', rows=rows)
def sail_date_page():
with get_db() as conn:
x = request.args.get("date")
print(x)
rows = sail_date(conn, x)
return render_template("table.html",
name="Sailor Who Sailed on Date ",
rows=rows)
def _sailors_add():
with get_db() as conn:
name = request.form['name']
age = request.form['age']
exp = request.form['exp']
sailors_add(conn, name, age, exp)
rows = sailors(conn)
return render_template("table.html", name="Sailors", rows=rows)
def _add_sailor_name():
if request.method == "POST":
add_sailor_name = request.form['add-sailor-name']
add_sailor_age = request.form['add-sailor-age']
add_sailor_experience = request.form['add-sailor-experience']
with get_db() as conn:
_adding_sailor_name(conn, add_sailor_name,add_sailor_age,add_sailor_experience)
return redirect("/sailors")
