def get_previous_season(season_id, **kwargs):
conn = kwargs["conn"]
start_date_query = f"select start_date, division_id from season_table where id={season_id};"
(start_date, division_id) = fetchone(start_date_query, conn)
query = f"select id from season_table where end_date < '{start_date}' and division_id={division_id} order by end_date desc;"
return fetchone(query, conn)
def get_for_match(match_id, description, **kwargs):
query = f"select home_win, draw, away_win from odds_table where match_id={match_id} and description='{description}'"
return fetchone(query, kwargs["conn"])
def get_id_for_game(home_team, away_team, date, **kwargs):
query = f"select id from match_table where HomeTeam='{home_team}' and AwayTeam='{away_team}' and Date='{date}';"
return fetchone(query, kwargs["conn"])
def select_latest_for_season(season_id, **kwargs):
asc = kwargs.get("asc", True)
query = f"SELECT elo, id FROM elo_table WHERE season_id=? ORDER BY elo {'asc' if asc else 'desc'};"
return fetchone((query, (season_id, )), kwargs["conn"])
def select_latest_for_team(team, date, season_id, **kwargs):
query = 'SELECT elo, id FROM elo_table WHERE team=? AND date < ? AND season_id=? ORDER BY date DESC;'
return fetchone((query, (team, date, season_id)), kwargs["conn"])
def insert(table_name, conn, **kwargs):
query = build_insert_query(kwargs, table_name)
values = get_value_tuple(kwargs)
execute_statement((query, values), conn)
return fetchone("select last_insert_rowid()", conn)[0]
def get_id_by_goalcom_url(url, **kwargs):
query = f"select fifa_id from player_identity_table where goalcom_url='{url}'"
return fetchone(query, kwargs["conn"])