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})