def get_game_by_slug(slug, field='slug'):
if field not in ('slug', 'installer_slug'):
raise ValueError("Invalid field name: %s", field)
game_result = sql.db_select(PGA_DB, "games", condition=(field, slug))
if game_result:
return game_result[0]
return {}
def get_game_by_slug(slug, field='slug'):
if field not in ('slug', 'installer_slug'):
raise ValueError("Invalid field name: %s", field)
game_result = sql.db_select(PGA_DB, "games", condition=(field, slug))
if game_result:
return game_result[0]
return {}
def get_game_by_field(value, field="slug"):
"""Query a game based on a database field"""
if field not in ("slug", "installer_slug", "id", "configpath", "steamid"):
raise ValueError("Can't query by field '%s'" % field)
game_result = sql.db_select(PGA_DB, "games", condition=(field, value))
if game_result:
return game_result[0]
return {}
def get_game_by_field(value, field='slug'):
"""Query a game based on a database field"""
if field not in ('slug', 'installer_slug', 'id', 'configpath', 'steamid'):
raise ValueError("Can't query by field '%s'" % field)
game_result = sql.db_select(PGA_DB, "games", condition=(field, value))
if game_result:
return game_result[0]
return {}
def test_can_create_table(self):
fields = [
{'name': 'id', 'type': 'INTEGER', 'indexed': True},
{'name': 'name', 'type': 'TEXT'}
]
pga.create_table('testing', fields)
sql.db_insert(TEST_PGA_PATH, 'testing', {'name': "testok"})
results = sql.db_select(TEST_PGA_PATH, 'testing',
fields=['id', 'name'])
self.assertEqual(results[0]['name'], "testok")
def get_game_by_field(value, field='slug', all=False):
"""Query a game based on a database field"""
if field not in ('slug', 'installer_slug', 'id', 'configpath', 'steamid'):
raise ValueError("Can't query by field '%s'" % field)
game_result = sql.db_select(PGA_DB, "games", condition=(field, value))
if game_result:
if all:
return game_result
else:
return game_result[0]
return {}
def get_game_by_slug(slug):
game_result = sql.db_select(PGA_DB, "games", condition=('slug', slug))
if game_result:
return game_result[0]
def get_games_by_slug(slug):
"""Return all games using a specific slug"""
return sql.db_select(PGA_DB, "games", condition=("slug", slug))
def get_games_by_runner(runner):
"""Return all games using a specific runner"""
return sql.db_select(PGA_DB, "games", condition=("runner", runner))
def get_category(name):
"""Return a category by name"""
categories = sql.db_select(PGA_DB, "categories", condition=("name", name))
if categories:
return categories[0]
def get_categories():
"""Get the list of every category in database."""
return sql.db_select(
PGA_DB,
"categories",
)
def get_games_by_slug(slug):
return sql.db_select(PGA_DB, "games", condition=("slug", slug))
