query = "select * from fantasysports.leagues where league_key='{}'".format(sport_id + ".l." + league_id)
data_yql = y3.execute(query, token=token).rows
current_week = int(data_yql[0]['current_week'])
predictions = predict_today(year, current_week)
query = "select manager1_name, manager2_name, type from scoreboard_all where year={0} and week={1};".format(year, current_week)
results = db.fetch_all(query)
predictions_interpolated = linear_interpolation(results, predictions)
for manager, type in predictions_interpolated.keys():
query = "select number, carrier from mobile where nickname = '{0}' and type = '{1}'".format(manager, type)
result = db.fetch_all(query)
mobile, carrier = zip(*result)
prob = predictions_interpolated[manager, type]
try:
query = "select manager2_name from scoreboard_all where manager1_name='{0}' and year={1} and \
week = {2} and type = '{3}';".format(manager, year, current_week, type)
opponent = str(db.fetch_one(query))
except TypeError:
query = "select manager1_name from scoreboard_all where manager2_name='{0}' and year={1} and \
week = {2} and type = '{3}';".format(manager, year, current_week, type)
opponent = str(db.fetch_one(query))
career_record(mobile, carrier, manager, opponent, current_week, year, type)
current_projections(mobile, carrier, manager, prob)
