From dc2797941701af6f36482203355b3fbd24777143 Mon Sep 17 00:00:00 2001 From: zlg Date: Mon, 22 Oct 2018 02:47:47 -0700 Subject: vgstash: let backlog filter ignore unbeatable games To migrate, run these two commands: sqlite3 /path/to/vgstash.db 'DROP VIEW backlog;' vgstash init --- src/vgstash/__init__.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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", -- cgit v1.2.3-54-g00ecf