def ss_input():
#db2 = mdb.connect(user="******", host="localhost", passwd='hats', db="ssf_db", charset='utf8')
bottom_games, alternatives = support.recommend_games(10,60.00)
'''not really dry, but works for now'''
left_g = bottom_games[0] #left,center,right are the appids fed into the html template for the graphics call
center_g = bottom_games[1]
right_g = bottom_games[2]
_cps, left_p, _dc, _osc = support.get_rec_price(left_g,alternatives)
_cps, center_p, _dc, _osc = support.get_rec_price(center_g,alternatives)
_cps, right_p, _dc, _osc = support.get_rec_price(right_g,alternatives)
return render_template("ssinput.html",left_id = left_g, cent_id = center_g,
right_id = right_g,left_price = left_p, right_price = left_p,
center_price = center_p,
option_list = OPTION_LIST) #currently the index
def ss_output():
game_id = int(request.args.get('option')) #get the game_id from the option selected by the user
appid= game_id # merged two different functions, for the rest of it, use appid until I can make sure everything works exactly as intended
db2 = mdb.connect(user="******", host="localhost", passwd=pw, db="ssf_db", charset='utf8')
with db2:
cur = db2.cursor(mdb.cursors.DictCursor)
cur.execute("SELECT * FROM website_table WHERE appid = %d" % appid)
ginfo = cur.fetchone() #there should only be one, but better safe
gname = ginfo['game_name']
adisc_num = ginfo['avg_discount']
asavings_num = ginfo['avg_savings']
if adisc_num == None:
adisc_num = 0
if asavings_num == None:
asavings_num = 0
adiscount = "%0.1f%%" % (adisc_num)
asavings = "$%0.2f" % (asavings_num)
sale_prob = ginfo['sale_prob_y']*100
if sale_prob == 0:
sale_prob = 1 #correction so that a sale is never 0 percent
elif sale_prob == 100:
sale_prob = 90 #correction so that a sale is never going to be reported as 100%
cur_price_str,cur_price,cur_disc, on_sale_currently = support.get_current_price(appid) #from steam, get the most current price
percent = "%0.1f%%" % (sale_prob)
if percent == '1.0%':
percent = '< 1%' #change from reporting 1% to less than 1%
recomendation_score = support.rec_val(asavings_num,sale_prob * 0.01)
if recomendation_score < 0.5:
buy_time = 'buy %s now, since it is not likely to go on sale soon.' % (gname)
else:
buy_time = 'wait for a sale.'
bottom_games, alternatives = support.recommend_games(appid,float(cur_price.strip('$')))
'''not really dry, but works for now'''
left_g = bottom_games[0] #left,center,right are the appids fed into the html template for the graphics call
center_g = bottom_games[1]
right_g = bottom_games[2]
_cps, left_p, _dc, _osc = '','','',''#support.get_rec_price(left_g,alternatives) #fix later if needed
_cps, center_p, _dc, _osc = '','','','' #support.get_rec_price(center_g,alternatives)
_cps, right_p, _dc, _osc = '','','',''#support.get_rec_price(right_g,alternatives)
return render_template("ssoutput3.html",
appid = appid,option_list = OPTION_LIST,
name = gname, discount = adiscount,
savings = asavings, percent = percent,
buy_time = buy_time, cur_discount = cur_disc,
cur_price = cur_price,
left_id = left_g, cent_id = center_g,
right_id = right_g,
left_price = left_p, right_price = right_p,
center_price = center_p) #add back in "game info" later