def setUp(self):
self.database = 'test.sqlite'
if os.path.exists(self.database):
os.unlink(self.database)
self.service = CardstoriesService({'db': self.database})
self.service.startService()
self.db = sqlite3.connect(self.database)
self.game = CardstoriesGame(self.service)
def load(self, c):
c.execute("SELECT id, sentence FROM games WHERE state != 'complete' AND state != 'canceled'")
for (id, sentence) in c.fetchall():
game = CardstoriesGame(self, id)
game.load(c)
# Notify listeners of the game, but use the 'load' notification to signal
# that the game is being loaded, not created
# Note that the db is not accessible during that stage
self.game_init(game, sentence, init_type='load')
def load(self, c):
c.execute(
"SELECT id, sentence FROM games WHERE state != 'complete' AND state != 'canceled'"
)
for (id, sentence) in c.fetchall():
game = CardstoriesGame(self, id)
game.load(c)
# Notify listeners of the game, but use the 'load' notification to signal
# that the game is being loaded, not created
# Note that the db is not accessible during that stage
self.game_init(game, sentence, init_type='load')
def create(self, args):
self.required(args, 'create', 'owner_id')
owner_id = int(args['owner_id'][0])
# Keep track of consecutive games
if 'previous_game_id' in args:
previous_game_id = args['previous_game_id'][0]
else:
previous_game_id = None
game = CardstoriesGame(self)
game_id = yield game.create(owner_id)
yield self.game_init(game, '', previous_game_id=previous_game_id)
defer.returnValue({'game_id': game_id})
def create(self, args):
self.required(args, "create", "owner_id")
owner_id = int(args["owner_id"][0])
# Keep track of consecutive games
if "previous_game_id" in args:
previous_game_id = args["previous_game_id"][0]
else:
previous_game_id = None
game = CardstoriesGame(self)
game_id = yield game.create(owner_id)
yield self.game_init(game, "", previous_game_id=previous_game_id)
defer.returnValue({"game_id": game_id})
def create(self, args):
self.required(args, 'create', 'owner_id')
owner_id = int(args['owner_id'][0])
# Keep track of consecutive games
if 'previous_game_id' in args:
previous_game_id = args['previous_game_id'][0]
else:
previous_game_id = None
game = CardstoriesGame(self)
game_id = yield game.create(owner_id)
yield self.game_init(game, '', previous_game_id=previous_game_id)
defer.returnValue({'game_id': game_id})
def game(self, args):
self.required(args, 'game')
game_id = self.required_game_id(args)
if args.has_key('player_id'):
player_id = int(args['player_id'][0])
else:
player_id = None
if self.games.has_key(game_id):
return self.games[game_id].game(player_id)
else:
game = CardstoriesGame(self, game_id)
d = game.game(player_id)
def destroy(game_info):
game.destroy()
return game_info
d.addCallback(destroy)
return d
def game(self, args):
self.required(args, 'game')
game_id = self.required_game_id(args)
if args.has_key('player_id'):
player_id = int(args['player_id'][0])
else:
player_id = None
if self.games.has_key(game_id):
return self.games[game_id].game(player_id)
else:
game = CardstoriesGame(self, game_id)
d = game.game(player_id)
def destroy(game_info):
game.destroy()
return game_info
d.addCallback(destroy)
return d
class CardstoriesEventLogTest(unittest.TestCase):
def setUp(self):
self.database = 'test.sqlite'
if os.path.exists(self.database):
os.unlink(self.database)
self.service = CardstoriesService({'db': self.database})
self.service.startService()
self.db = sqlite3.connect(self.database)
self.game = CardstoriesGame(self.service)
def tearDown(self):
self.game.destroy()
self.db.close()
os.unlink(self.database)
return self.service.stopService()
# Since the logging is all async, the tests would be a nightmare without
# enforcing events to be logged serially as they happen.
# In order to do this, we wait by poking at the DB in a loop until the
# expected number of records exists in the DB.
def wait_for_logs(self, game_id, expected_nr):
c = self.db.cursor()
while True:
time.sleep(0.005)
c.execute('SELECT COUNT(*) FROM event_logs WHERE game_id = ?', [game_id])
if c.fetchone()[0] == expected_nr:
break
@defer.inlineCallbacks
def test01_log_game_events(self):
owner_id = 42
player1_id = 84
player2_id = 86
sentence = 'The Sentence.'
# 1 - Should log creation.
game_id = yield self.game.create(owner_id)
self.wait_for_logs(game_id, 1)
# 2 - Should log card set.
owner = yield self.game.player2game(owner_id)
winner_card = owner['cards'][0]
yield self.game.set_card(owner_id, winner_card)
self.wait_for_logs(game_id, 2)
# 3 -Should log sentence set.
yield self.game.set_sentence(owner_id, sentence)
self.wait_for_logs(game_id, 3)
# 4 - Should log invitation (player1 only).
yield self.game.invite([player1_id])
self.wait_for_logs(game_id, 4)
# 5 & 6 - Should log joining (both players).
yield self.game.participate(player1_id)
self.wait_for_logs(game_id, 5)
yield self.game.participate(player2_id)
self.wait_for_logs(game_id, 6)
# 7 & 8 - Should log players picking cards.
player1 = yield self.game.player2game(player1_id)
picked_card1 = player1['cards'][0]
yield self.game.pick(player1_id, picked_card1)
self.wait_for_logs(game_id, 7)
player2 = yield self.game.player2game(player2_id)
picked_card2 = player1['cards'][0]
yield self.game.pick(player2_id, picked_card2)
self.wait_for_logs(game_id, 8)
# 9 - Should log game moved into voting.
yield self.game.voting(owner_id)
self.wait_for_logs(game_id, 9)
# 10 & 11 - Should log players voting for cards.
yield self.game.vote(player1_id, winner_card)
self.wait_for_logs(game_id, 10)
yield self.game.vote(player2_id, picked_card1)
self.wait_for_logs(game_id, 11)
# 12 - Should log game completed.
yield self.game.complete(owner_id)
self.wait_for_logs(game_id, 12)
# Now lets check the logs table.
c = self.db.cursor()
# Wait until the logs are written (they're written asynchronously)
c.execute('SELECT event_type, player_id, data FROM event_logs WHERE game_id = ? ORDER BY timestamp', [game_id])
# Twelve events should be logged.
rows = c.fetchall()
self.assertEqual((event_log.GAME_CREATED, owner_id, None), rows[0])
self.assertEqual((event_log.OWNER_CHOSE_CARD, owner_id, str(winner_card)), rows[1])
self.assertEqual((event_log.OWNER_WROTE_STORY, owner_id, sentence), rows[2])
self.assertEqual((event_log.PLAYER_INVITED, owner_id, str(player1_id)), rows[3])
self.assertEqual((event_log.PLAYER_JOINED, player1_id, None), rows[4])
self.assertEqual((event_log.PLAYER_JOINED, player2_id, None), rows[5])
self.assertEqual((event_log.PLAYER_PICKED_CARD, player1_id, str(picked_card1)), rows[6])
self.assertEqual((event_log.PLAYER_PICKED_CARD, player2_id, str(picked_card2)), rows[7])
self.assertEqual((event_log.GAME_MOVED_TO_VOTING, owner_id, None), rows[8])
self.assertEqual((event_log.PLAYER_VOTED, player1_id, str(winner_card)), rows[9])
self.assertEqual((event_log.PLAYER_VOTED, player2_id, str(picked_card1)), rows[10])
self.assertEqual((event_log.GAME_COMPLETED, owner_id, None), rows[11])
c.close()
@defer.inlineCallbacks
def test02_log_canceled_game_events(self):
owner_id = 4
player_id = 8
sentence = 'Some Sentence.'
# 1 - Should log creation.
game_id = yield self.game.create(owner_id)
self.wait_for_logs( game_id, 1)
# 2 - Should log card set.
owner = yield self.game.player2game(owner_id)
winner_card = owner['cards'][0]
yield self.game.set_card(owner_id, winner_card)
self.wait_for_logs( game_id, 2)
# 3 -Should log sentence set.
yield self.game.set_sentence(owner_id, sentence)
self.wait_for_logs( game_id, 3)
# 4 - Should log joining.
yield self.game.participate(player_id)
self.wait_for_logs( game_id, 4)
# 5 - Should log player leaving.
yield self.game.leave([player_id])
self.wait_for_logs( game_id, 5)
# 6 - Should log game cancelation.
yield self.game.cancel()
self.wait_for_logs(game_id, 6)
# Now lets check the logs table.
c = self.db.cursor()
c.execute('SELECT event_type, player_id, data FROM event_logs WHERE game_id = ? ORDER BY timestamp', [game_id])
# Twelve events should be logged.
rows = c.fetchall()
self.assertEqual((event_log.GAME_CREATED, owner_id, None), rows[0])
self.assertEqual((event_log.OWNER_CHOSE_CARD, owner_id, str(winner_card)), rows[1])
self.assertEqual((event_log.OWNER_WROTE_STORY, owner_id, sentence), rows[2])
self.assertEqual((event_log.PLAYER_JOINED, player_id, None), rows[3])
self.assertEqual((event_log.PLAYER_LEFT, player_id, None), rows[4])
self.assertEqual((event_log.GAME_CANCELED, owner_id, None), rows[5])
c.close()
def test03_log_query_functions(self):
c = self.db.cursor()
game1 = 99
game2 = 199
player1 = 11
player2 = 12
invitee = 878
# Define some datetimes.
now = datetime.now()
an_hour_ago = now - timedelta(hours=1)
six_hours_ago = now - timedelta(hours=6)
yesterday = now - timedelta(days=1)
two_days_ago = now - timedelta(days=2)
# Fill in some log data.
data = [
# Game 1
[game1, two_days_ago, event_log.GAME_CREATED, player1, ''],
[game1, two_days_ago, event_log.OWNER_CHOSE_CARD, player1, 22],
[game1, two_days_ago, event_log.OWNER_WROTE_STORY, player1, 'This story'],
[game1, six_hours_ago, event_log.PLAYER_JOINED, player2, 33],
[game1, now, event_log.PLAYER_VOTED, player2, 33],
# Game 2
[game2, yesterday, event_log.GAME_CREATED, player1, ''],
[game2, yesterday, event_log.OWNER_CHOSE_CARD, player1, 34],
[game2, six_hours_ago, event_log.OWNER_WROTE_STORY, player1, 'The Story'],
[game2, an_hour_ago, event_log.PLAYER_INVITED, player1, invitee],
[game2, an_hour_ago, event_log.PLAYER_JOINED, invitee, ''],
[game2, now, event_log.PLAYER_PICKED_CARD, invitee, 23]
]
for d in data:
c.execute('INSERT INTO event_logs (game_id, timestamp, event_type, player_id, data) VALUES (?, ?, ?, ?, ?)', d)
# Player's last activity.
result = event_log.get_players_last_activity(c, player1)
self.assertEquals(result['timestamp'], str(an_hour_ago))
self.assertEquals(result['game_id'], game2)
self.assertEquals(result['event_type'], event_log.PLAYER_INVITED)
self.assertEquals(result['data'], invitee)
result = event_log.get_players_last_activity(c, player2)
self.assertEquals(result['timestamp'], str(now))
self.assertEquals(result['game_id'], game1)
self.assertEquals(result['event_type'], event_log.PLAYER_VOTED)
self.assertEquals(result['data'], 33)
result = event_log.get_players_last_activity(c, invitee)
self.assertEquals(result['timestamp'], str(now))
self.assertEquals(result['game_id'], game2)
self.assertEquals(result['event_type'], event_log.PLAYER_PICKED_CARD)
self.assertEquals(result['data'], 23)
# Game activities.
result = event_log.get_game_activities(c, game1, since=yesterday)
self.assertEquals(len(result), 2)
self.assertEquals(result[0]['event_type'], event_log.PLAYER_JOINED)
self.assertEquals(result[0]['timestamp'], str(six_hours_ago))
self.assertEquals(result[1]['event_type'], event_log.PLAYER_VOTED)
self.assertEquals(result[1]['player_id'], player2)
result = event_log.get_game_activities(c, game1, since=an_hour_ago)
self.assertEquals(len(result), 1)
self.assertEquals(result[0]['event_type'], event_log.PLAYER_VOTED)
self.assertEquals(result[0]['player_id'], player2)
result = event_log.get_game_activities(c, game2, since=two_days_ago)
self.assertEquals(len(result), 6)
self.assertEquals(result[5]['event_type'], event_log.PLAYER_PICKED_CARD)
self.assertEquals(result[5]['timestamp'], str(now))
self.assertEquals(result[5]['player_id'], invitee)
