Skip to content
TheChatArchiveThe Chat Archive
gpt-4-1106-preview· openaiHugging Face Suzhen/CodeChat

I’m trying to implement a stock trading webapp. For some reason my current stocks…

  1. User

    I’m trying to implement a stock trading webapp. For some reason my current stocks overview implementation doesn’t work. Please fix it. Here’s the flask code: import os

    from cs50 import SQL from flask import Flask, flash, redirect, render_template, request, session from flask_session import Session from werkzeug.security import check_password_hash, generate_password_hash

    from helpers import apology, login_required, lookup, usd

    Configure application

    app = Flask(name)

    Custom filter

    app.jinja_env.filters["usd"] = usd

    Configure session to use filesystem (instead of signed cookies)

    app.config["SESSION_PERMANENT"] = False app.config["SESSION_TYPE"] = "filesystem" Session(app)

    Configure CS50 Library to use SQLite database

    db = SQL("sqlite:///finance.db")

    @app.after_request def after_request(response): """Ensure responses aren't cached""" response.headers["Cache-Control"] = "no-cache, no-store, must-revalidate" response.headers["Expires"] = 0 response.headers["Pragma"] = "no-cache" return response

    @app.route("/") @login_required def index(): # Assume db.execute() returns a dict or a list of dicts if request.method == "GET": user_cash = db.execute("SELECT cash FROM users WHERE id = :id;" id=session['user_id'])[0]['cash'] purchases = db.execute(""" SELECT symbol, SUM(shares) as shares, AVG(price) as price FROM purchases WHERE user_id = :id GROUP BY symbol HAVING SUM(shares) > 0; """, id=session['user_id']) # Calculate totals for each purchase for purchase in purchases: purchase['total'] = purchase['shares'] * purchase['price'] # Calculate the total value of stocks plus cash total_assets = sum(purchase['total'] for purchase in purchases) + user_cash

    return render_template("index.html", cash=user_cash, purchases=purchases, total_assets=total_assets)
    

    @app.route("/buy", methods=["GET", "POST"]) @login_required def buy(): if request.method == "GET": return render_template("buy.html") elif request.method == "POST": my_symbb = request.form.get('symbolb') my_quant = request.form.get('quantity')

        try:
            my_quant = int(my_quant)
            if my_quant <= 0:
                return apology("more than 0, idiot", 400)
    
            db.execute("INSERT INTO purchases (symbol, shares, price) VALUES (:symbol, :shares, 12)", symbol=my_symbb, shares=my_quant)
    
            # Handle success or add a redirection here
            return render_template("success.html")  # Assuming there is a success.html template
    
        except ValueError:
            return apology("invalid quantity", 400)
        except Exception as e:
            return apology("An error occurred: " + str(e), 400)
    

    @app.route("/history") @login_required def history(): """Show history of transactions""" return apology("TODO")

    @app.route("/login", methods=["GET", "POST"]) def login(): """Log user in"""

    # Forget any user_id
    session.clear()
    
    # User reached route via POST (as by submitting a form via POST)
    if request.method == "POST":
    
        # Ensure username was submitted
        if not request.form.get("username"):
            return apology("must provide username", 403)
    
        # Ensure password was submitted
        elif not request.form.get("password"):
            return apology("must provide password", 403)
    
        # Query database for username
        rows = db.execute("SELECT * FROM users WHERE username = ?", request.form.get("username"))
    
        # Ensure username exists and password is correct
        if len(rows) != 1 or not check_password_hash(rows[0]["hash"], request.form.get("password")):
            return apology("invalid username and/or password", 403)
    
        # Remember which user has logged in
        session["user_id"] = rows[0]["id"]
    
        # Redirect user to home page
        return redirect("/")
    
    # User reached route via GET (as by clicking a link or via redirect)
    else:
        return render_template("login.html")
    

    @app.route("/logout") def logout(): """Log user out"""

    # Forget any user_id
    session.clear()
    
    # Redirect user to login form
    return redirect("/")
    

    @app.route("/quote", methods=["GET", "POST"]) @login_required def quote(): """Get stock quote.""" if request.method == "GET": return render_template("quote.html") elif request.method == "POST": my_symbol = request.form.get('symbol') if not my_symbol: flash("symbol is required", "error") return redirect("/quote") stock = lookup(my_symbol) if stock: return render_template("quoted.html", stock=stock) else: flash("Could not retrive stock info", "error") return redirect("/quote") else: flash("Invalid reuqest method", "error") return redirect("/quote")

    @app.route("/quoted", methods=["GET", "POST"]) @login_required def quoted(): if request.method == "POST": return render_template("quoted.html", stock) if request.method == "GET": return render_template("quoted.html", stock)

    @app.route("/register", methods=["GET", "POST"]) def register():

    # Forget any user_id
    session.clear()
    
    # User reached route via POST (as by submitting a form via POST)
    if request.method == "POST":
    
        # Ensure username was submitted
        if not request.form.get("username"):
            return apology("must provide username", 403)
    
        # Ensure password was submitted
        elif not request.form.get("password"):
            return apology("must provide password", 403)
    
        # Query database for username
        username = request.form.get("username")
        rows = db.execute("SELECT * FROM users WHERE username = :username", username=username)  # :username is a named placeholder
        if rows:
            return apology("username already exists", 403)
    
          # Hash user's password
        hashed_password = generate_password_hash(request.form.get("password"))
    
                # Insert new user into the database
        db.execute("INSERT INTO users (username, hash) VALUES (:username, :hash)", username=username, hash=hashed_password)  # :username and :hash are named placeholders
    
    
        # Redirect user to login page or some other page
        flash("Registered successfully, please log in.")
        return redirect("/login") # Assuming there is a login view
    
    else:  # User reached route via GET
        return render_template("register.html") # Assuming there is a 'register.html' template
    

    @app.route("/sell", methods=["GET", "POST"]) @login_required def sell(): """Sell shares of stock""" return apology("TODO")

    Here's layout.html

    <head>
    
        <meta charset="utf-8">
        <meta name="viewport" content="initial-scale=1, width=device-width">
    
        <!-- http://getbootstrap.com/docs/5.1/ -->
        <link crossorigin="anonymous" href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" integrity="sha384-1BmE4kWBq78iYhFldvKuhfTAU6auU8tT94WrHftjDbrCEXSU1oBoqyl2QvZ6jIW3" rel="stylesheet">
        <script crossorigin="anonymous" src="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/js/bootstrap.bundle.min.js" integrity="sha384-ka7Sk0Gln4gmtz2MlQnikT1wXgYsOg+OMhuP+IlRH9sENBO0LRn5q+8nbTov4+1p"></script>
    
        <!-- https://favicon.io/emoji-favicons/money-bag/ -->
        <link href="/static/trade.png" rel="icon">
    
        <link href="/static/styles.css" rel="stylesheet">
    
        <title>C$50 Finance: {% block title %}{% endblock %}</title>
    
    </head>
    
    <body>
    
        <nav class="bg-light border navbar navbar-expand-md navbar-light">
            <div class="container-fluid">
                <a class="navbar-brand" href="/"><span class="blue">C</span><span class="red">$</span><span class="yellow">5</span><span class="green">0</span> <span class="red">Finance</span></a>
                <button aria-controls="navbar" aria-expanded="false" aria-label="Toggle navigation" class="navbar-toggler" data-bs-target="#navbar" data-bs-toggle="collapse" type="button">
                    <span class="navbar-toggler-icon"></span>
                </button>
                <div class="collapse navbar-collapse" id="navbar">
                    {% if session["user_id"] %}
                        <ul class="navbar-nav me-auto mt-2">
                            <li class="nav-item"><a class="nav-link" href="/quote">Quote</a></li>
                            <li class="nav-item"><a class="nav-link" href="/buy">Buy</a></li>
                            <li class="nav-item"><a class="nav-link" href="/sell">Sell</a></li>
                            <li class="nav-item"><a class="nav-link" href="/history">History</a></li>
                        </ul>
                        <ul class="navbar-nav ms-auto mt-2">
                            <li class="nav-item"><a class="nav-link" href="/logout">Log Out</a></li>
                        </ul>
                    {% else %}
                        <ul class="navbar-nav ms-auto mt-2">
                            <li class="nav-item"><a class="nav-link" href="/register">Register</a></li>
                            <li class="nav-item"><a class="nav-link" href="/login">Log In</a></li>
                        </ul>
                    {% endif %}
                </div>
            </div>
        </nav>
    
        {% if get_flashed_messages() %}
            <header>
                <div class="alert alert-primary mb-0 text-center" role="alert">
                    {{ get_flashed_messages() | join(" ") }}
                </div>
            </header>
        {% endif %}
    
        <main class="container-fluid py-5 text-center">
            {% block main %}{% endblock %}
        </main>
    
        <footer class="mb-5 small text-center text-muted">
            Data provided by <a href="https://iexcloud.io/">IEX</a>
        </footer>
    
    </body>
    
  2. Assistant

    It appears there are several issues in your Flask webapp code. I'll go through the / route (index function) as this seems to be your main area of concern for the current stocks overview and provide corrections and explanations for you to understand what needs to be fixed.

    1. The index function within your Flask app seems to have an indentation error. In Python, indentation is critical as it defines the scopes/block of code. The line where you calculate purchase['total'] needs to be indented one level deeper:
    # Before
    for purchase in purchases:
    purchase['total'] = purchase['shares'] * purchase['price']
    # After
    for purchase in purchases:
        purchase['total'] = purchase['shares'] * purchase['price']
    
    1. There is a missing comma in the SQL query. In the query string for the index route, you're missing a comma between "SELECT cash FROM users WHERE id = :id;" and id=session['user_id'].

    The corrected line should look like this:

    user_cash = db.execute("SELECT cash FROM users WHERE id = :id", id=session['user_id'])[0]['cash']
    
    1. The method check in the index function is unnecessary because you've defined the route without specifying methods, so it defaults to just GET. Therefore, you don't need the conditional if request.method == "GET":. You can remove this line.

    After making the above corrections, the index function should look something like this:

    @app.route("/")
    @login_required
    def index():
        user_cash = db.execute("SELECT cash FROM users WHERE id = :id", id=session['user_id'])[0]['cash']
        purchases = db.execute("""
            SELECT symbol, SUM(shares) as shares, AVG(price) as price
            FROM purchases WHERE user_id = :id
            GROUP BY symbol
            HAVING SUM(shares) > 0;
            """, id=session['user_id'])
    
        # Calculate totals for each purchase
        for purchase in purchases:
            purchase['total'] = purchase['shares'] * purchase['price']
    
        # Calculate the total value of stocks plus cash
        total_assets = sum(purchase['total'] for purchase in purchases) + user_cash
    
        return render_template("index.html", cash=user_cash, purchases=purchases, total_assets=total_assets)
    

    Be sure to also review other parts of your code to ensure that the logic, error handling, and features are implemented as intended.

    Lastly, I suggest referencing your HTML templates to ensure they are expecting the correct context variables that you're passing from your views, as discrepancies here can also lead to unexpected or non-functioning behavior.