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)