Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- @app.route("/")
- @login_required
- def index():
- users_info = db.execute("SELECT * FROM users WHERE id=:uid", uid=session["user_id"])
- transactions_info = db.execute("SELECT * FROM user_stocks WHERE user_id=:uid GROUP BY stock_symbol ORDER BY id", uid=session["user_id"])
- grand_total = 0
- total_price = []
- for i in range(len(users_info)):
- grand_total = users_info[i]["cash"]
- no_of_shares_dict = {}
- current_price_dict = {}
- stock_names_dict = {}
- if len(transactions_info) != 0:
- for i in range(len(transactions_info)):
- for j in range(len(users_info)):
- cash = users_info[j]["cash"]
- total_shares = 0
- for i in range(len(transactions_info)):
- if transactions_info[i]["stock_symbol"] not in no_of_shares_dict:
- for j in range(i, len(transactions_info)):
- if transactions_info[i]["stock_symbol"] == transactions_info[j]["stock_symbol"]:
- total_shares += transactions_info[j]["no_of_shares"]
- no_of_shares_dict.update({
- transactions_info[i]["stock_symbol"]: total_shares
- })
- total_shares = 0
- for key in no_of_shares_dict:
- current_price_dict.update({
- key: lookup(key)["price"]
- })
- for key in no_of_shares_dict:
- stock_names_dict.update({
- key: lookup(key)["name"]
- })
- for key in no_of_shares_dict:
- total_price.append(lookup(key)["price"] * no_of_shares_dict.get(key))
- for i in range(len(total_price)):
- grand_total += total_price[i]
- return render_template("index.html", users_info=users_info, current_price_dict=current_price_dict, grand_total=grand_total,
- no_of_shares_dict=no_of_shares_dict, stock_names_dict=stock_names_dict, total_price=total_price)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement