def create_player(cls, player):
"""
Create a player in database
:param player: Player
"""
DAO.execute_not_read_only_query(
"INSERT INTO PLAYER (NAME, CREATED_AT)"
" VALUES (%s, %s)", (player.name, player.created_at))
def create_tournament(cls, tournament):
"""
Create the tournament
:param tournament: Tournament
"""
DAO.execute_not_read_only_query(
"INSERT INTO TOURNAMENT "
"(NAME, START_AT, CREATED_AT) "
"VALUES (%s, %s, %s)",
(tournament.name, tournament.start_at, tournament.created_at))
def register_player(cls, tournament, player, created_at):
"""
Register a player in a tournament
:param tournament: Tournament
:param player: Player
:param created_at: Creation date
"""
DAO.execute_not_read_only_query(
"INSERT INTO RANK (ID_TOURNAMENT, ID_PLAYER, POINTS, CREATED_AT) "
"VALUES (%s, %s, %s, %s)",
(tournament[0], player[0], 0, created_at))
def delete_players(cls):
"""
Remove all the players records from the database.
"""
DAO.execute_not_read_only_query("DELETE FROM PLAYER")
def delete_tournaments(cls):
"""
Remove all tournament from the database.
"""
DAO.execute_not_read_only_query("DELETE FROM TOURNAMENT")
def delete_ranks(cls):
"""
Remove all the ranks records from the database.
"""
DAO.execute_not_read_only_query("DELETE FROM RANK")
def delete_matches(cls):
"""
Remove all the matches records from the database.
"""
DAO.execute_not_read_only_query("DELETE FROM MATCH")