def getNextPlayer(game_id, last_player): player = dbutils.queryOne("""SELECT * FROM playergame WHERE game = '{game_id}' AND player <> '{last_player}' AND status <> 'failed' AND created > (SELECT created FROM playergame WHERE player ='{last_player}' AND game = {game_id}) ORDER BY created ASC LIMIT 1 """.format(game_id = game_id, last_player=last_player)) if not player: player = dbutils.queryOne("SELECT * FROM playergame WHERE game = '{game_id}' AND status <> 'failed' ORDER BY created ASC LIMIT 1".format(game_id = game_id)) if player: return player["player"] return None
def joinGame(game_id, player_id): avatar = dbutils.queryOne( "SELECT avatar FROM player WHERE id=('{}')".format(player_id)) avatar = avatar['avatar'] return dbutils.updateOrInsert( "INSERT INTO playergame (game, player, avatar) VALUES ('{}', '{}', '{}')" .format(game_id, player_id, avatar))
def getGame(game_id): return dbutils.queryOne("SELECT * FROM game where id = {}".format(game_id))
def isGameFull(game_id): actual_players = dbutils.queryOne("SELECT COUNT(player) FROM playergame WHERE game = {}".format(game_id)) print(actual_players['COUNT(player)']) return actual_players['COUNT(player)'] >= utils.GAME_LENGTH
def getAvatar(player_name): print("getAv") return dbutils.queryOne( "SELECT avatar FROM player where id = '{}'".format(player_name))