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 updateWonPlayers(game_id): return dbutils.updateOrInsert( "UPDATE playergame SET status = 'won' WHERE game = '{}' AND status <> 'failed'" .format(game_id))
def setFirstTurn(game_id): return dbutils.updateOrInsert( "UPDATE playergame SET status = 'turn' WHERE game = '{}' ORDER BY created ASC LIMIT 1" .format(game_id))
def updatePlayerStatus(game_id, player_id, status): return dbutils.updateOrInsert( "UPDATE playergame SET status = '{}' WHERE game = '{}' AND player='{}'" .format(status, game_id, player_id))
def newPlayer(player_name, avatar): return dbutils.updateOrInsert( "INSERT INTO player (id, avatar) VALUES ('{}', '{}')".format( player_name, avatar))
def updateGameStatus(game_id, status): return dbutils.updateOrInsert( "UPDATE game SET status = '{}' WHERE id = '{}' ".format( status, game_id))
def updateGameStep(game_id, new_step): return dbutils.updateOrInsert( "UPDATE game SET step = '{}' WHERE id = '{}'".format( new_step, game_id))
def newGame(name, creator, sequence): return dbutils.updateOrInsert( "INSERT INTO game (name, sequence, creator) VALUES ('{}', '{}', '{}')". format(name, sequence, creator))
def joinGame(game_id, player_id): return dbutils.updateOrInsert( "INSERT INTO playergame (game, player) VALUES ('{}', '{}')".format( game_id, player_id))
def joinGame(game_id, player_id, avatar): print("db.joinGame") return dbutils.updateOrInsert( "INSERT INTO playergame (game, player, avatar) VALUES ('{}', '{}', '{}')" .format(game_id, player_id, avatar))
def gameIsClosed(game_id): return dbutils.updateOrInsert( "UPDATE game SET closed=1 WHERE id = {} ".format(game_id))
def deleteGame(game_id): delete_from_playergame = dbutils.updateOrInsert( "DELETE FROM playergame WHERE game = '{}'".format(game_id)) delete_from_game = dbutils.updateOrInsert( "DELETE FROM game WHERE id = '{}'".format(game_id)) return delete_from_game and delete_from_playergame