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")