diff options
Diffstat (limited to 'src/vgstash/__init__.py')
-rwxr-xr-x | src/vgstash/__init__.py | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/src/vgstash/__init__.py b/src/vgstash/__init__.py index 798a062..71b5981 100755 --- a/src/vgstash/__init__.py +++ b/src/vgstash/__init__.py @@ -33,18 +33,18 @@ DEFAULT_CONFIG = { } FILTERS = { - 'allgames': "SELECT rowid,* FROM games ORDER BY system, title", - 'backlog': "SELECT rowid,* FROM games WHERE ownership > 0 AND progress < 3 ORDER BY system, title ASC", - 'borrowing': "SELECT rowid,* FROM games WHERE ownership = 0 AND progress = 2 ORDER BY system, title ASC", - 'complete': "SELECT rowid,* FROM games WHERE progress = 4 ORDER BY system, title ASC", - 'digital': "SELECT rowid,* FROM games WHERE ownership = 2 ORDER BY system, title ASC", - 'done': "SELECT rowid,* FROM games WHERE progress > 2 ORDER BY system, title ASC", - 'incomplete': "SELECT rowid,* FROM games WHERE progress = 3 AND ownership > 0 ORDER BY system, title ASC", - 'new': "SELECT rowid,* FROM games WHERE progress = 1 ORDER BY system, title ASC", - 'owned': "SELECT rowid,* FROM games WHERE ownership > 0 ORDER BY system, title ASC", - 'physical': "SELECT rowid,* FROM games WHERE ownership = 1 ORDER BY system, title ASC", - 'playlog': "SELECT rowid,* FROM games WHERE ownership > 0 AND progress = 2 ORDER BY system, title ASC", - 'unowned': "SELECT rowid,* FROM games WHERE ownership = 0 ORDER BY system, title ASC", + 'allgames': "SELECT * FROM games ORDER BY system, title", + 'backlog': "SELECT * FROM games WHERE ownership > 0 AND progress < 3 ORDER BY system, title ASC", + 'borrowing': "SELECT * FROM games WHERE ownership = 0 AND progress = 2 ORDER BY system, title ASC", + 'complete': "SELECT * FROM games WHERE progress = 4 ORDER BY system, title ASC", + 'digital': "SELECT * FROM games WHERE ownership = 2 ORDER BY system, title ASC", + 'done': "SELECT * FROM games WHERE progress > 2 ORDER BY system, title ASC", + 'incomplete': "SELECT * FROM games WHERE progress = 3 AND ownership > 0 ORDER BY system, title ASC", + 'new': "SELECT * FROM games WHERE progress = 1 ORDER BY system, title ASC", + 'owned': "SELECT * FROM games WHERE ownership > 0 ORDER BY system, title ASC", + 'physical': "SELECT * FROM games WHERE ownership = 1 ORDER BY system, title ASC", + 'playlog': "SELECT * FROM games WHERE ownership > 0 AND progress = 2 ORDER BY system, title ASC", + 'unowned': "SELECT * FROM games WHERE ownership = 0 ORDER BY system, title ASC", } def kvmatch(arg, dict_map, fallback): |