def get_trade_history(username):
user_id = model.get_user_id(username)
history = model.get_trade_history(user_id)
if history == None:
return 0
else:
return history
def get_portfolio(username):
user_id = model.get_user_id(username)
portfolio = model.get_portfolio(user_id)
if portfolio == None:
return 0
else:
return portfolio
def buy_stock(symbol, qty, username):
user_id = model.get_user_id(username)
last_price = get_quote(symbol)
if last_price == False:
response = 500
return (0, 0, 0, response)
else:
total_price = qty * last_price
if model.get_balance(user_id) < total_price:
response = 400
return (0, 0, 0, response)
else:
response = 200
model.buy_stock(user_id, symbol, last_price, total_price, qty)
return last_price, total_price, model.get_balance(user_id), response
def review():
if request.method == 'POST':
user_name = '%s' % escape(session['username'])
business_id = request.form['business_id']
review = request.form['review']
star = int(request.form['star'])
user_name = model.get_user_id(business_id, star, user_name)
#star = model.get_star(review)
model.add_review_to_db(user_name, business_id, star, review)
restaurants = model.get_restaurants(user_name)
random.shuffle(restaurants)
return render_template(
'dashboard.html',
restaurants=restaurants[:10],
message=
"Jungle recommends these fine establishments based on your profile!"
)
def sell_stock(symbol, qty, username):
user_id = model.get_user_id(username)
last_price = get_quote(symbol)
if last_price == False:
response = 500
return (0, 0, 0, response)
else:
total_price = qty * last_price
if model.get_stock_qty(user_id, symbol) == None:
response = 401
return (0, 0, 0, response)
elif model.get_stock_qty(user_id, symbol) < qty:
response = 400
return (0, 0, 0, response)
else:
response = 200
model.sell_stock(user_id, symbol, last_price, total_price, qty)
return last_price, total_price, model.get_balance(user_id), response
def view_user(username):
user_id = (model.get_user_id(username))[0]
row = model.get_wall_posts(user_id)
return render_template("wall.html", posts = row, username=username)
def get_user_id(username):
user_id = model.get_user_id(username)
return user_id