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