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", )