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-70-g09d2 ='2b68c3d06fb2961ae3797d1ef461cff655f328b2'/>
path: root/ch5/5-08_error-checking.c (unfollow)
AgeCommit message (Expand)AuthorFilesLines
2018-12-22Solve Exercise 8-2: fopen and fillbufzlg3-0/+181
2018-08-22AUTHORS: update contact infozlg1-1/+1
2017-05-20perfeeerrrrrmzlg1-1/+1
2017-05-208-1: Correct superfluous increment, commentzlg1-2/+1