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)