def test_no_players_one_game_slot(self): with self.db_context(): db.insert_game(self.make_game('1A')) [players_table] = self.parse_tables(self.client.get('/players/')) self.assert_table_values(players_table, [ ['name', 'team', '1A'], ])
def test_insert_game(self): self.assert_query([], 'SELECT * FROM games;') db.insert_game(Game( '1A', 'Game 1A', 'Author 1A', 'System 1A', 'Blurb 1A', 4, 6)) self.assert_query( [('1A', 'Game 1A', 'Author 1A', 'System 1A', 'Blurb 1A', 4, 6)], GAME_QUERY)
def test_one_game_5_players(self): with self.db_context(): db.insert_game(self.make_game('1A', min_players=5, max_players=5)) [games_table] = self.parse_tables(self.client.get('/games/')) self.assert_table_values(games_table, [ ['slot', 'name', 'author', 'system', 'players'], [self.slot_link('1A'), 'Game 1A', 'Author 1A', 'System 1A', '5'], ])
def test_one_player_one_game_slot(self): with self.db_context(): db.insert_game(self.make_game('1A')) db.insert_player(Player('Gary Gygax', 'TSR', {})) [players_table] = self.parse_tables(self.client.get('/players/')) self.assert_table_values(players_table, [ ['name', 'team', '1A'], ['Gary Gygax', 'TSR', ''], ])
def test_game_5_players_no_tables(self): with self.db_context(): db.insert_game(self.make_game('1A', min_players=5, max_players=5)) response = self.client.get('/games/1A/') self.assertEqual(response.status_code, 200) self.assert_response_contains(response, '1A: Game 1A') self.assert_response_contains(response, 'Author: Author 1A') self.assert_response_contains(response, 'System: System 1A') self.assert_response_contains(response, 'Blurb: Blurb 1A') self.assert_response_contains(response, 'Players: 5') [tables_table] = self.parse_tables(response) self.assert_table_values(tables_table, [['tables'], []])
def test_import_games(self): db.insert_game(Game( '1X', 'Game 1X', 'Author 1X', 'System 1X', 'Blurb 1X', 4, 6)) db.commit_db() self.assert_query( [('1X', 'Game 1X', 'Author 1X', 'System 1X', 'Blurb 1X', 4, 6)], GAME_QUERY) db.import_games(Games([ Game('1A', 'Game 1A', 'Author 1A', 'System 1A', 'Blurb 1A', 4, 6), Game('1B', 'Game 1B', 'Author 1B', 'System 1B', 'Blurb 1B', 4, 6), ])) self.assert_query([ ('1A', 'Game 1A', 'Author 1A', 'System 1A', 'Blurb 1A', 4, 6), ('1B', 'Game 1B', 'Author 1B', 'System 1B', 'Blurb 1B', 4, 6), ], GAME_QUERY)