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
