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