def get_latest_session(): session = database.fetchone( "SELECT * FROM training_sessions WHERE episodeCount > 0 ORDER BY startTime DESC" ) if session: return formatter.format(session)
def get_active_session(): session = database.fetchone( "SELECT * FROM training_sessions WHERE deactivated = 0 AND endTime IS NULL AND startTime IS NOT NULL LIMIT 1" ) if session: return formatter.format(session)
def get_next(): tournament = database.fetchone( "SELECT * FROM tournaments WHERE startTime IS NULL ORDER BY id ASC") if tournament: return formatter.format(tournament)
def get(id): tournament = database.fetchone("SELECT * FROM tournaments WHERE id = ?", id) return formatter.format(tournament)
def is_active(id): return not not database.fetchone( "SELECT id FROM training_sessions WHERE deactivated = 0 AND endTime IS NULL AND startTime IS NOT NULL" )
def get(id): game = database.fetchone("SELECT * FROM tournament_games WHERE id = ?", (id, )) return formatter.format(game)