diff options
author | zlg <zlg@zlg.space> | 2018-09-08 19:07:36 -0700 |
---|---|---|
committer | zlg <zlg@zlg.space> | 2018-09-08 19:07:36 -0700 |
commit | 14162a862e50c35f44370daf1f525b27f3bafc85 (patch) | |
tree | 0f00b1de33516aff75f4a96f5eaeba1cb52b1a40 | |
parent | Update LICENSE to match setup.py (diff) | |
download | vgstash-14162a862e50c35f44370daf1f525b27f3bafc85.tar.gz vgstash-14162a862e50c35f44370daf1f525b27f3bafc85.tar.bz2 vgstash-14162a862e50c35f44370daf1f525b27f3bafc85.tar.xz vgstash-14162a862e50c35f44370daf1f525b27f3bafc85.zip |
Add remaining filters to vgstash package
-rwxr-xr-x | src/vgstash/__init__.py | 13 |
1 files changed, 11 insertions, 2 deletions
diff --git a/src/vgstash/__init__.py b/src/vgstash/__init__.py index 61ae9e6..71b5981 100755 --- a/src/vgstash/__init__.py +++ b/src/vgstash/__init__.py @@ -34,8 +34,17 @@ DEFAULT_CONFIG = { FILTERS = { 'allgames': "SELECT * FROM games ORDER BY system, title", - 'backlog': "SELECT * FROM games WHERE ownership > 0 AND progress = 0 OR progress = 1 ORDER BY system, title", - 'playlog': "SELECT * FROM games WHERE ownership > 0 AND progress = 2 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): |