def get_all_game_tables(games=None, players=None):
if games is None:
games = get_games()
if players is None:
players = get_players()
rows = query_db('SELECT slot, data FROM game_tables;')
game_table_dicts = []
for row in rows:
data = json.loads(row['data'])
game_table_dicts.append({
'slot': row['slot'],
'gm': data['gm'],
'players': data['players'],
})
return GameTables.from_dicts(games, players, game_table_dicts)
def get_game_tables(slot, game=None, players=None):
if game is None:
game = get_game(slot)
games = {slot: game}
if players is None:
players = get_players()
rows = query_db('SELECT data FROM game_tables WHERE slot=?;', (slot,))
game_table_dicts = []
for row in rows:
data = json.loads(row['data'])
game_table_dicts.append({
'slot': slot,
'gm': data['gm'],
'players': data['players'],
})
return GameTables.from_dicts(games, players, game_table_dicts)[slot]
