def get_all_registered_players(cls, tournament):
"""
Return all registered players
:param tournament: Tournament
:return: List of registered players
"""
return DAO.execute_fetch_all(
"SELECT * FROM RANK "
"WHERE ID_TOURNAMENT = %s", ([tournament[0]]))
def player_ranks(cls, tournament):
"""
Returns a list of the players and their win records, sorted by wins.
:return: List of rank
"""
return DAO.execute_fetch_all(
"SELECT P.NAME, R.* FROM RANK R"
" JOIN PLAYER P ON R.ID_PLAYER = P.ID "
"WHERE ID_TOURNAMENT = %s "
"ORDER BY POINTS DESC", ([tournament[0]]))
def get_all_players(cls):
"""
Returns the all players currently registered.
:return: List of Player
"""
return DAO.execute_fetch_all("SELECT * FROM PLAYER ")