def createGame(channel_id, player_1, player_2):
'''
Create a new game for Player1 and Player2 in the given Channel
'''
db_handle = None
db_cursor = None
created_game_id = None
try:
db_handle = get_database_handle()
create_query = '''
INSERT INTO ttt_games
(channel_id, player1_id, player2_id, current_player, status, date_created)
VALUES
('%s', '%s', '%s', '%s', %s, %s)
''' % (channel_id, player_1, player_2, player_1,
TTTGame.GAME_STATUS_IN_PROGRESS, 'now()')
db_cursor = db_handle.cursor(MySQLdb.cursors.DictCursor)
db_cursor.execute(create_query)
created_game_id = db_cursor.lastrowid
db_handle.commit()
except Exception as e:
print "Exception: %s" % e
finally:
if db_cursor is not None:
db_cursor.close()
if db_handle is not None:
db_handle.close()
return created_game_id
def updateGameAsCompleted(game_id, game_status):
'''
Update status for given game ID with provided game_status
'''
db_handle = None
db_cursor = None
ret_status = True
try:
db_handle = get_database_handle()
update_query = '''
UPDATE ttt_games
SET status=%s
where id = %s''' % (game_status, game_id)
db_cursor = db_handle.cursor(MySQLdb.cursors.DictCursor)
db_cursor.execute(update_query)
db_handle.commit()
except Exception as e:
print e
ret_status = False
finally:
if db_cursor is not None:
db_cursor.close()
if db_handle is not None:
db_handle.close()
return ret_status
def getGameDetailsByChannelId(channel_id):
'''
get the latest game details for a channel_id
'''
db_handle = None
db_cursor = None
row = None
if not channel_id:
return None
try:
db_handle = get_database_handle()
db_cursor = db_handle.cursor(MySQLdb.cursors.DictCursor)
status_query = '''
SELECT * FROM ttt_games
WHERE channel_id = '%(channel_id)s'
ORDER BY id desc
LIMIT 1
''' % {
'channel_id': channel_id
}
db_cursor.execute(status_query)
row = db_cursor.fetchone()
except Exception as e:
print e
finally:
if db_cursor is not None:
db_cursor.close()
if db_handle is not None:
db_handle.close()
return row
def getGameDetails(game_id=None):
'''
given a game_id retrieve its game details
'''
db_handle = None
db_cursor = None
row = None
if not game_id:
return None
try:
db_handle = get_database_handle()
db_cursor = db_handle.cursor(MySQLdb.cursors.DictCursor)
status_query = '''
SELECT * FROM ttt_games
WHERE game_id = %(game_id)s
''' % {
'game_id': game_id
}
db_cursor.execute(status_query)
row = db_cursor.fetchone()
finally:
if db_cursor is not None:
db_cursor.close()
if db_handle is not None:
db_handle.close()
return row
def updateGameAsCompletedWithWinner(game_id, winner):
'''
Update winner and status for given game ID
'''
db_handle = None
db_cursor = None
ret_status = True
try:
db_handle = get_database_handle()
update_query = '''
UPDATE ttt_games
SET winner='%s', status=%s
where id = %s''' % (winner, TTTGame.GAME_STATUS_COMPLETED, game_id)
db_cursor = db_handle.cursor(MySQLdb.cursors.DictCursor)
db_cursor.execute(update_query)
db_handle.commit()
except Exception as e:
print e
ret_status = False
finally:
if db_cursor is not None:
db_cursor.close()
if db_handle is not None:
db_handle.close()
return ret_status
def updateGameDetails(game_id, current_player):
'''
Update game details by game ID.
'''
db_handle = None
db_cursor = None
ret_status = True
try:
db_handle = get_database_handle()
update_query = '''
UPDATE ttt_games
SET current_player='%s'
where id = %s''' % (current_player, game_id)
db_cursor = db_handle.cursor(MySQLdb.cursors.DictCursor)
db_cursor.execute(update_query)
db_handle.commit()
except Exception as e:
print e
ret_status = False
finally:
if db_cursor is not None:
db_cursor.close()
if db_handle is not None:
db_handle.close()
return ret_status
def getLatestGameState(game_id):
'''
Add a game move to the given game_id made by the specified player_id
'''
db_handle = None
db_cursor = None
row = None
try:
db_handle = get_database_handle()
db_cursor = db_handle.cursor(MySQLdb.cursors.DictCursor)
query = '''
SELECT * FROM game_moves
WHERE game_id = %s
ORDER BY ID DESC
LIMIT 1 ''' % (game_id)
db_cursor.execute(query)
row = db_cursor.fetchone()
except Exception as e:
print e
finally:
if db_cursor is not None:
db_cursor.close()
if db_handle is not None:
db_handle.close()
return row
def addMove(game_id, player_id, move_num, game_board):
'''
Add a game move to the given game_id made by the specified player_id
'''
db_handle = None
db_cursor = None
ret_status = False
try:
db_handle = get_database_handle()
db_cursor = db_handle.cursor(MySQLdb.cursors.DictCursor)
query = '''
INSERT INTO game_moves
(game_id, player_id, move_number, game_board)
VALUES
(%s, '%s', %s, '%s')''' % (game_id, player_id, move_num,
json.dumps(game_board))
db_cursor.execute(query)
db_handle.commit()
ret_status = True
except Exception as e:
print e
ret_status = False
finally:
if db_cursor is not None:
db_cursor.close()
if db_handle is not None:
db_handle.close()
return ret_status