aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorzlg <zlg@zlg.space>2019-01-03 05:40:16 -0800
committerzlg <zlg@zlg.space>2019-01-03 05:40:16 -0800
commit6c59e9df6dcbf3cc2daaac9b40cdfe8a6859c690 (patch)
treea0f3798fe64e61f634289c6a38ee63d43b0d5324 /src
parentPrepare for distribution (diff)
downloadvgstash-6c59e9df6dcbf3cc2daaac9b40cdfe8a6859c690.tar.gz
vgstash-6c59e9df6dcbf3cc2daaac9b40cdfe8a6859c690.tar.bz2
vgstash-6c59e9df6dcbf3cc2daaac9b40cdfe8a6859c690.tar.xz
vgstash-6c59e9df6dcbf3cc2daaac9b40cdfe8a6859c690.zip
vgstash: Add "notes" filter to schema
The notes filter will return every game whose notes field is non-empty. Useful for client-building and/or automation. Run `vgstash init` after upgrading to recreate any missing (or new) filters.
Diffstat (limited to '')
-rwxr-xr-xsrc/vgstash/__init__.py3
1 files changed, 2 insertions, 1 deletions
diff --git a/src/vgstash/__init__.py b/src/vgstash/__init__.py
index 37fe582..4c1df3b 100755
--- a/src/vgstash/__init__.py
+++ b/src/vgstash/__init__.py
@@ -33,7 +33,7 @@ DEFAULT_CONFIG = {
}
FILTERS = {
- 'allgames': "SELECT * FROM games ORDER BY system, title",
+ 'allgames': "SELECT * FROM games ORDER BY system, title ASC",
'backlog': "SELECT * FROM games WHERE ownership > 0 AND progress > 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",
@@ -41,6 +41,7 @@ FILTERS = {
'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",
+ 'notes': "SELECT * FROM games WHERE notes NOT LIKE '' 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",