def get_category(name):
"""Return a category by name"""
categories = sql.db_select(settings.PGA_DB,
"categories",
condition=("name", name))
if categories:
return categories[0]
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"):
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'}
]
schema.create_table('testing', fields)
sql.db_insert(settings.PGA_DB, 'testing', {'name': "testok"})
results = sql.db_select(settings.PGA_DB, 'testing',
fields=['id', 'name'])
self.assertEqual(results[0]['name'], "testok")
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_categories():
"""Get the list of every category in database."""
return sql.db_select(
settings.PGA_DB,
"categories",
)
