def get_games(searches=None, filters=None, excludes=None, sorts=None): return sql.filtered_query(PGA_DB, "games", searches=searches, filters=filters, excludes=excludes, sorts=sorts)
def on_game_updated(self, game): db_games = sql.filtered_query(PGA_DB, "service_games", filters=({ "service": self.service_media.service, "appid": game.appid })) for db_game in db_games: GLib.idle_add(self.update, db_game)
def on_icon_loaded(self, media_loader, appid, path): """Callback signal for when a icon has downloaded. Update the image in the view. """ games = sql.filtered_query(PGA_DB, "service_games", filters=({ "service": self.service_media.service, "appid": appid })) for game in games: GLib.idle_add(self.update, game)
def on_game_updated(self, game): if self.service: db_games = sql.filtered_query(settings.PGA_DB, "service_games", filters=({ "service": self.service_media.service, "appid": game.appid })) else: db_games = sql.filtered_query(settings.PGA_DB, "games", filters=({ "id": game.id })) for db_game in db_games: GLib.idle_add(self.update, db_game) return True
def get_game(cls, service, appid): """Return a single game refered by its appid""" if not service: raise ValueError("No service provided") if not appid: raise ValueError("No appid provided") results = sql.filtered_query(PGA_DB, "service_games", filters={ "service": service, "appid": appid }) if not results: return if len(results) > 1: logger.warning("More than one game found for %s on %s", appid, service) return results[0]
def get_for_service(cls, service): if not service: raise ValueError("No service provided") return sql.filtered_query(PGA_DB, "service_games", filters={"service": service})