summaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorzlg <zlg@zlg.space>2018-10-22 02:47:47 -0700
committerzlg <zlg@zlg.space>2018-10-22 02:47:47 -0700
commitdc2797941701af6f36482203355b3fbd24777143 (patch)
treed3a6660db982435c15420aaa195194dce52bb168 /src
parentBump to 0.3beta2 for PyPI (diff)
downloadvgstash-dc2797941701af6f36482203355b3fbd24777143.tar.gz
vgstash-dc2797941701af6f36482203355b3fbd24777143.tar.bz2
vgstash-dc2797941701af6f36482203355b3fbd24777143.tar.xz
vgstash-dc2797941701af6f36482203355b3fbd24777143.zip
vgstash: let backlog filter ignore unbeatable games
To migrate, run these two commands: sqlite3 /path/to/vgstash.db 'DROP VIEW backlog;' vgstash init
Diffstat (limited to 'src')
-rwxr-xr-xsrc/vgstash/__init__.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/vgstash/__init__.py b/src/vgstash/__init__.py
index 2adea4e..37fe582 100755
--- a/src/vgstash/__init__.py
+++ b/src/vgstash/__init__.py
@@ -34,7 +34,7 @@ DEFAULT_CONFIG = {
FILTERS = {
'allgames': "SELECT * FROM games ORDER BY system, title",
- 'backlog': "SELECT * FROM games WHERE ownership > 0 AND progress < 3 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",
'digital': "SELECT * FROM games WHERE ownership = 2 ORDER BY system, title ASC",