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"])