diff options
| author | zlg <zlg@zlg.space> | 2018-10-22 02:47:47 -0700 |
|---|---|---|
| committer | zlg <zlg@zlg.space> | 2018-10-22 02:47:47 -0700 |
| commit | dc2797941701af6f36482203355b3fbd24777143 (patch) | |
| tree | d3a6660db982435c15420aaa195194dce52bb168 | |
| parent | Bump to 0.3beta2 for PyPI (diff) | |
| download | vgstash-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
| -rwxr-xr-x | src/vgstash/__init__.py | 2 |
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", |