application.py - shared from CS50 IDE

application.py

def index():
    total = 0
    cash = db.execute("SELECT cash FROM users WHERE id=:id", id=session["user_id"])
    symbol = db.execute("SELECT symbol FROM tracker where id=:id", id=session["user_id"])
    rows=lookup(symbol[0])
    shares = db.execute("SELECT shares FROM tracker where id=:id", id=session["user_id"])
    price = db.execute("SELECT price FROM tracker where id=:id", id=session["user_id"])
    
    return render_template("index.html", cash=usd(cash[0]["cash"]), symbol=symbol[0]["symbol"], \
                            shares=shares[0]["shares"], price=price[0]["price"], \
                            cost=price[0]["price"])