24 lines
986 B
Python
24 lines
986 B
Python
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) |