def complete(id, player1_win_count, player2_win_count, draw_count):
time = datetime.datetime.now().strftime(date_format)
inputs = (time, player1_win_count, player2_win_count, draw_count, id)
database.execute(
"UPDATE tournaments SET endTime = ?, player1_win_count = ?, player2_win_count = ?, draw_count = ? WHERE id = ?",
inputs)
def create(player1, player2, episode_count):
inputs = (player1, player2, episode_count)
database.execute("DELETE FROM tournaments where 1")
return database.insert(
"INSERT INTO tournaments (player1, player2, episodeCount) VALUES (?, ?, ?)",
inputs)
def start(id):
time = datetime.datetime.now().strftime(date_format)
database.execute("UPDATE tournaments SET startTime = ? WHERE id = ?",
(time, id))
def finish(id):
database.execute("UPDATE training_sessions SET endTime = ? WHERE id = ?",
(database.get_current_time(), id))
def stop_active_sessions():
database.execute(
"UPDATE training_sessions SET deactivated = 1 WHERE deactivated = 0 AND endTime IS NULL AND startTime IS NOT NULL"
)
def boost_episode_count(id, episodes):
database.execute(
"UPDATE training_sessions SET episodeCount = episodeCount + ?, latestLessonTime = ? WHERE id = ?",
(episodes, database.get_current_time(), id))
def activate(id):
database.execute("UPDATE training_sessions SET startTime = ? WHERE id = ?",
(database.get_current_time(), id))