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))