Пример #1
0
def current_projections(mobile, carrier, manager, prob):
    rate_win = '{:.2%}'.format(prob)
    message = "{0}, you are projected a {1} chance of victory".format(manager, rate_win)

    for mob, car in zip(mobile, carrier):
        send_text(mob, message, car)


if __name__ == "__main__":
    token, y3 = get_yahoo_auth()
    year = datetime.now().year
    update_model(year)

    query = "select max(year), sport_id, league_id, type from leagues"
    year, sport_id, league_id, type = db.fetch_line(query)

    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]