From 14162a862e50c35f44370daf1f525b27f3bafc85 Mon Sep 17 00:00:00 2001 From: zlg Date: Sat, 8 Sep 2018 19:07:36 -0700 Subject: Add remaining filters to vgstash package --- src/vgstash/__init__.py | 13 +++++++++++-- 1 file 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): -- cgit v1.2.3-54-g00ecf