from flask import Flask, redirect, render_template, request
from cs50 import sql

app = Flask(__name__)
db = sql.SQL("sqlite:///gremlin.db")

@app.route("/")
def index():
    return render_template("index.html")

@app.route("/products")
def products():
    products = db.execute('SELECT Partnumber,Option,Description,"Current Month Price(EUR)" FROM pricelist WHERE Partnumber = (?);', request.args.get("partnumber"))
    return render_template("products.html", products=products)

@app.route("/accounts")
def accounts():
    accounts = db.execute('SELECT Name,Street,City,"Postal Code" FROM accounts WHERE Name = (?);', request.args.get("accountname"))
    return render_template("accounts.html", accounts=accounts)

@app.route("/contacts")
def contacts():
    contacts = db.execute('SELECT "Last Name","First Name","Acct Name 1 and 2","E-mail","Phone" FROM contacts WHERE "Last Name" = (?);', request.args.get("lastname"))
    return render_template("contacts.html", contacts=contacts)