def getgame(id=0):
if 'user' in session and session['user']:
if id == 0:
return json.dumps(utils.getGames(session['user']))
else:
return json.dumps(utils.getGame(id))
else:
return json.dumps(utils.getGame(id))
def startGame(msg, db, gameMsg):
gameId = msg['gameId']
gameResult = db.fetchone('SELECT gameJSON FROM games WHERE id=%d; ' % gameId)
players = db.fetchall('SELECT name, handJSON FROM players WHERE gameId = %d AND joined=1; ' % gameId)
game = json.loads(gameResult[0])
players = [parsePlayer(i) for i in players]
if (not game['hasStarted']) and len(players) > 1:
game['hasStarted'] = True
deck = hanabi.startGameAndGetDeck(game, players)
queries = []
for player in players:
queries.append("UPDATE players SET handJSON='%s' WHERE gameId=%d AND name='%s'"
% (json.dumps(player['hand']), gameId, player['name']))
queries.append("UPDATE games SET gameJSON='%s', deckJSON='%s' WHERE id=%s"
% (json.dumps(game), json.dumps(deck), gameId))
db.bulkExecute(queries)
game = getGame(db, gameId)
gameMsg.buildStartGame()
send({
'event': 'startGame',
'message' : gameMsg.message,
'game': game
}, json=True, room=gameId)
else:
send({
'error': {
'event': 'startGame',
'reason': 'game already started'
}
}, json=True)
def joinGame(msg, db, gameMsg):
gameId = msg['gameId']
name = msg['name']
numPlayers = db.fetchone('SELECT COUNT(id) FROM players WHERE gameId=%d AND joined=1; ' % gameId)[0]
gameRes = db.fetchone('SELECT gameJSON FROM games WHERE id=%d; ' % gameId)
game = json.loads(gameRes[0])
if numPlayers < hanabi.MAX_PLAYERS and not game['hasStarted']:
db.execute("UPDATE players SET joined=1 WHERE gameId=%d AND name='%s'" % (gameId, name))
game = getGame(db, gameId)
gameMsg.buildJoinGame()
send({
'event': 'joinGame',
'message' : gameMsg.message,
'game': game
}, json=True, room=gameId)
else:
send({
'error': {
'event': 'joinGame',
'reason': 'max players exceeded'
}
}, json=True)
def resumeGame(msg, db, gameMsg):
gameId = msg['gameId']
name = msg['name']
players = db.fetchall("SELECT name FROM players WHERE gameId = %d AND name='%s'" % (gameId, name))
if len(players) != 0:
game = getGame(db, gameId)
gameMsg.buildResumeGame()
send({
'event': 'resumeGame',
'message' : gameMsg.message,
'game': game
}, json=True, room=gameId)
join_room(gameId)
messages = [parseMessage(i) for i in db.fetchall("SELECT name, type, messageJSON, time FROM messages WHERE gameId = %d; " % gameId)]
gameMsg.message['elements']['messages'] = messages
send({
'event': 'resumeGame',
'message' : gameMsg.message,
'game': game
}, json=True)
else:
send({
'error': {
'event': 'resumeGame',
'reason': 'no player with name exists'
}
}, json=True)
def joinGame(msg, db, gameMsg):
gameId = msg['gameId']
name = msg['name']
numPlayers = db.fetchone(
'SELECT COUNT(id) FROM players WHERE gameId=%d AND joined=1; ' %
gameId)[0]
gameRes = db.fetchone('SELECT gameJSON FROM games WHERE id=%d; ' % gameId)
game = json.loads(gameRes[0])
if numPlayers < hanabi.MAX_PLAYERS and not game['hasStarted']:
db.execute(
"UPDATE players SET joined=1 WHERE gameId=%d AND name='%s'" %
(gameId, name))
game = getGame(db, gameId)
gameMsg.buildJoinGame()
send({
'event': 'joinGame',
'message': gameMsg.message,
'game': game
},
json=True,
room=gameId)
else:
send(
{'error': {
'event': 'joinGame',
'reason': 'max players exceeded'
}},
json=True)
def enterGame(msg, db, gameMsg):
gameId = msg['gameId']
name = msg['name']
sameNameExists = False
players = [parsePlayer(i) for i in db.fetchall('SELECT name, handJSON FROM players WHERE gameId = %d; ' % gameId)]
for player in players:
if player['name'] == name:
sameNameExists = True
send({
'error': {
'event': 'enterGame',
'reason': 'same name exists'
}
}, json=True)
break
if not sameNameExists:
db.execute("INSERT INTO players (gameId, name, handJSON, joined) VALUES (%d, '%s', '%s', 0)" % (gameId, name, '[]'))
game = getGame(db, gameId)
gameMsg.buildEnterGame()
send({
'event': 'enterGame',
'message' : gameMsg.message,
'game': game
}, json=True, room=gameId)
join_room(gameId)
messages = [parseMessage(i) for i in db.fetchall("SELECT name, type, messageJSON, time FROM messages WHERE gameId = %d; " % gameId)]
gameMsg.message['elements']['messages'] = messages
send({
'event': 'enterGame',
'message' : gameMsg.message,
'game': game
}, json=True)
def playCard(msg, db, gameMsg):
gameId = msg['gameId']
name = msg['name']
cardIndex = msg['cardIndex']
gameRes = db.fetchone('SELECT gameJSON, deckJSON FROM games WHERE id=%d; ' % gameId)
playerRes = db.fetchone("SELECT name, handJSON FROM players WHERE gameId = %d AND name='%s'" % (gameId, name))
game = json.loads(gameRes[0])
deck = json.loads(gameRes[1])
player = parsePlayer(playerRes)
playedCard = hanabi.playCard(game, deck, player, cardIndex)
hanabi.endTurn(game)
queries = []
queries.append("UPDATE games SET gameJSON='%s', deckJSON='%s' WHERE id=%s" % (json.dumps(game), json.dumps(deck), gameId))
queries.append("UPDATE players SET handJSON='%s' WHERE gameId=%d AND name='%s'"
% (json.dumps(player['hand']), gameId, player['name']))
db.bulkExecute(queries)
game = getGame(db, gameId)
gameMsg.buildPlay(playedCard)
send({
'event': 'playCard',
'message' : gameMsg.message,
'game': game
}, json=True, room=gameId)
def giveHint(msg, db, gameMsg):
gameId = msg['gameId']
hintType = msg['hintType']
name = msg['name']
toName = msg['toName']
hint = int(msg['hint']) if hintType == 'NUMBER' else msg['hint']
gameRes = db.fetchone('SELECT gameJSON FROM games WHERE id=%d; ' % gameId)
toPlayerRes = db.fetchone("SELECT name, handJSON FROM players WHERE gameId = %d AND name='%s'" % (gameId, toName))
game = json.loads(gameRes[0])
toPlayer = parsePlayer(toPlayerRes)
if hanabi.canHint(game, name):
cardsHinted = hanabi.giveHint(game, toPlayer, hintType, hint)
db.execute("UPDATE games SET gameJSON='%s' WHERE id=%s" % (json.dumps(game), gameId))
db.execute("UPDATE players SET handJSON='%s' WHERE name='%s'" % (json.dumps(toPlayer['hand']), toPlayer['name']))
game = getGame(db, gameId)
gameMsg.buildHint(toName, hintType, hint, cardsHinted)
send({
'event': 'giveHint',
'message' : gameMsg.message,
'game': game
}, json=True, room=gameId)
else:
send({
'error': {
'event': 'giveHint',
'reason': 'invalid hint'
}
}, json=True)
def enterGame(msg, db, gameMsg):
gameId = msg['gameId']
name = msg['name']
sameNameExists = False
players = [
parsePlayer(i) for i in db.fetchall(
'SELECT name, handJSON FROM players WHERE gameId = %d; ' % gameId)
]
for player in players:
if player['name'] == name:
sameNameExists = True
send(
{
'error': {
'event': 'enterGame',
'reason': 'same name exists'
}
},
json=True)
break
if not sameNameExists:
db.execute(
"INSERT INTO players (gameId, name, handJSON, joined) VALUES (%d, '%s', '%s', 0)"
% (gameId, name, '[]'))
game = getGame(db, gameId)
gameMsg.buildEnterGame()
send({
'event': 'enterGame',
'message': gameMsg.message,
'game': game
},
json=True,
room=gameId)
join_room(gameId)
messages = [
parseMessage(i) for i in db.fetchall(
"SELECT name, type, messageJSON, time FROM messages WHERE gameId = %d; "
% gameId)
]
gameMsg.message['elements']['messages'] = messages
send({
'event': 'enterGame',
'message': gameMsg.message,
'game': game
},
json=True)
def createGame(msg, db, gameMsg):
rainbow = msg['isRainbow']
name = msg['name']
game = hanabi.newGameObject(rainbow)
gameId = db.executeWithId("INSERT INTO games (gameJSON) VALUES ('%s') RETURNING id" % json.dumps(game))
db.execute("INSERT INTO players (gameId, name, handJSON, joined) VALUES (%d, '%s', '%s', 0)" % (gameId, name, '[]'))
join_room(gameId)
game = getGame(db, gameId)
gameMsg.buildEnterGame()
send({
'event': 'enterGame',
'message' : gameMsg.message,
'game': game
}, json=True, room=gameId)
def startGame(msg, db, gameMsg):
gameId = msg['gameId']
gameResult = db.fetchone('SELECT gameJSON FROM games WHERE id=%d; ' %
gameId)
players = db.fetchall(
'SELECT name, handJSON FROM players WHERE gameId = %d AND joined=1; ' %
gameId)
game = json.loads(gameResult[0])
players = [parsePlayer(i) for i in players]
if (not game['hasStarted']) and len(players) > 1:
game['hasStarted'] = True
deck = hanabi.startGameAndGetDeck(game, players)
queries = []
for player in players:
queries.append(
"UPDATE players SET handJSON='%s' WHERE gameId=%d AND name='%s'"
% (json.dumps(player['hand']), gameId, player['name']))
queries.append(
"UPDATE games SET gameJSON='%s', deckJSON='%s' WHERE id=%s" %
(json.dumps(game), json.dumps(deck), gameId))
db.bulkExecute(queries)
game = getGame(db, gameId)
gameMsg.buildStartGame()
send({
'event': 'startGame',
'message': gameMsg.message,
'game': game
},
json=True,
room=gameId)
else:
send(
{
'error': {
'event': 'startGame',
'reason': 'game already started'
}
},
json=True)
def resumeGame(msg, db, gameMsg):
gameId = msg['gameId']
name = msg['name']
players = db.fetchall(
"SELECT name FROM players WHERE gameId = %d AND name='%s'" %
(gameId, name))
if len(players) != 0:
game = getGame(db, gameId)
gameMsg.buildResumeGame()
send({
'event': 'resumeGame',
'message': gameMsg.message,
'game': game
},
json=True,
room=gameId)
join_room(gameId)
messages = [
parseMessage(i) for i in db.fetchall(
"SELECT name, type, messageJSON, time FROM messages WHERE gameId = %d; "
% gameId)
]
gameMsg.message['elements']['messages'] = messages
send({
'event': 'resumeGame',
'message': gameMsg.message,
'game': game
},
json=True)
else:
send(
{
'error': {
'event': 'resumeGame',
'reason': 'no player with name exists'
}
},
json=True)
def createGame(msg, db, gameMsg):
rainbow = msg['isRainbow']
name = msg['name']
game = hanabi.newGameObject(rainbow)
gameId = db.executeWithId(
"INSERT INTO games (gameJSON) VALUES ('%s') RETURNING id" %
json.dumps(game))
db.execute(
"INSERT INTO players (gameId, name, handJSON, joined) VALUES (%d, '%s', '%s', 0)"
% (gameId, name, '[]'))
join_room(gameId)
game = getGame(db, gameId)
gameMsg.buildEnterGame()
send({
'event': 'enterGame',
'message': gameMsg.message,
'game': game
},
json=True,
room=gameId)
def giveHint(msg, db, gameMsg):
gameId = msg['gameId']
hintType = msg['hintType']
name = msg['name']
toName = msg['toName']
hint = int(msg['hint']) if hintType == 'NUMBER' else msg['hint']
gameRes = db.fetchone('SELECT gameJSON FROM games WHERE id=%d; ' % gameId)
toPlayerRes = db.fetchone(
"SELECT name, handJSON FROM players WHERE gameId = %d AND name='%s'" %
(gameId, toName))
game = json.loads(gameRes[0])
toPlayer = parsePlayer(toPlayerRes)
if hanabi.canHint(game, name):
cardsHinted = hanabi.giveHint(game, toPlayer, hintType, hint)
db.execute("UPDATE games SET gameJSON='%s' WHERE id=%s" %
(json.dumps(game), gameId))
db.execute("UPDATE players SET handJSON='%s' WHERE name='%s'" %
(json.dumps(toPlayer['hand']), toPlayer['name']))
game = getGame(db, gameId)
gameMsg.buildHint(toName, hintType, hint, cardsHinted)
send({
'event': 'giveHint',
'message': gameMsg.message,
'game': game
},
json=True,
room=gameId)
else:
send({'error': {
'event': 'giveHint',
'reason': 'invalid hint'
}},
json=True)
def playCard(msg, db, gameMsg):
gameId = msg['gameId']
name = msg['name']
cardIndex = msg['cardIndex']
gameRes = db.fetchone(
'SELECT gameJSON, deckJSON FROM games WHERE id=%d; ' % gameId)
playerRes = db.fetchone(
"SELECT name, handJSON FROM players WHERE gameId = %d AND name='%s'" %
(gameId, name))
game = json.loads(gameRes[0])
deck = json.loads(gameRes[1])
player = parsePlayer(playerRes)
playedCard = hanabi.playCard(game, deck, player, cardIndex)
hanabi.endTurn(game)
queries = []
queries.append(
"UPDATE games SET gameJSON='%s', deckJSON='%s' WHERE id=%s" %
(json.dumps(game), json.dumps(deck), gameId))
queries.append(
"UPDATE players SET handJSON='%s' WHERE gameId=%d AND name='%s'" %
(json.dumps(player['hand']), gameId, player['name']))
db.bulkExecute(queries)
game = getGame(db, gameId)
gameMsg.buildPlay(playedCard)
send({
'event': 'playCard',
'message': gameMsg.message,
'game': game
},
json=True,
room=gameId)
def loadGame(gameId):
return jsonify(**getGame(db, gameId))
def loadGame(gameId):
return jsonify(**getGame(db, gameId))