def ten_winners():
winners = dbutils.queryAll(
"""SELECT player, count(*) as c FROM playergame WHERE
status = 'won'
GROUP BY player
ORDER BY c desc
limit 10""")
print(winners)
return winners
def getAllGames():
return dbutils.queryAll("SELECT * FROM game")
def getReadyPlayers(game_id):
return dbutils.queryAll(
"SELECT * FROM playergame WHERE game = '{}' AND status = 'ready'".
format(game_id))
def getGamePlayers(game_id):
return dbutils.queryAll(
"SELECT * FROM playergame where game = {} ORDER BY created".format(
game_id))
def getOpenGames():
return dbutils.queryAll("SELECT * FROM game WHERE status = 'open'")
def getFailedGames():
return dbutils.queryAll("SELECT * FROM game WHERE status = 'failed'")
def getWonGames():
return dbutils.queryAll("SELECT * FROM game WHERE status = 'won'")
def getHighScores():
high_scores = dbutils.queryAll(
"SELECT * FROM (SELECT player, count(status) as wins FROM playergame WHERE status = \"won\" GROUP BY player) AS ct ORDER BY ct.wins desc LIMIT 10"
)
return high_scores
