From 6c59e9df6dcbf3cc2daaac9b40cdfe8a6859c690 Mon Sep 17 00:00:00 2001 From: zlg Date: Thu, 3 Jan 2019 05:40:16 -0800 Subject: 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. --- src/vgstash/__init__.py | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) 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", -- cgit v1.2.3-70-g09d2 e='hidden' name='id' value='27249a10e801816810ec553ab4308cd7fb9c34dd'/>
path: root/ch1/1-01_hello-world.c (unfollow)
'left'>Author
AgeCommit message (Expand)AuthorFilesLines
FilesLines
2020-03-08helpers.sh: Add vgub, vgmulti, vgrandzlg1-0/+29
2020-03-02Avoid a backtrace when editing notes on an invalid gamezlg2-1/+24
2020-03-02Avoid a backtrace when updating an invalid gamezlg2-4/+8
2019-04-30Release version 0.3 beta 4zlg4-42/+100
2019-04-29README.md: Clarify a few detailszlg1-4/+2
2019-04-29setup.py: Remove obsolete informationzlg1-1/+0
2019-01-03vgstash: Add "notes" filter to schemazlg1-1/+2
2018-11-21Prepare for distributionzlg2-1/+3
2018-10-22vgstash: let backlog filter ignore unbeatable gameszlg1-1/+1
2018-10-18Bump to 0.3beta2 for PyPIzlg1-3/+3
2018-10-18vgstash.DB.__init__: fix error output formattingzlg1-1/+1
2018-10-18README: fix inline <code> formattingzlg1-3/+4
2018-10-18cli: show msg if game to be deleted is not in DBzlg2-2/+12
2018-10-18README: expand on usage, cover shell quotingzlg1-7/+99
2018-10-18cli: Tell the user when a game lacks noteszlg2-3/+15
2018-10-18Catch when an invalid list filter is passedzlg4-3/+24
2018-10-12cli: Add zero-game import/export messageszlg2-11/+18
2018-10-10Bump to 0.3beta1 for PyPIzlg1-1/+1
2018-10-10Move tests and data to dedicated directoryzlg7-10/+26
2018-10-10cli: Add "export" commandzlg2-5/+54
2018-10-10cli: Add "import" commandzlg5-1/+76
2018-10-09Bump to 0.3alpha6 for PyPIzlg1-1/+1
2018-10-09cli: Add "notes" commandzlg2-4/+74
2018-10-09update_game: ensure notes are also savedzlg1-2/+2
2018-10-09cli: add 'update' commandzlg3-20/+92
2018-10-06cli: Add "delete" commandzlg2-0/+19
2018-10-06Remove ID field from DBzlg3-38/+46
2018-10-06cli: change "Status" heading to "Progress"zlg2-36/+40
2018-09-29Bump to 0.3alpha5 for PyPIzlg1-1/+1
2018-09-29cli: Add pretty printing to 'list' commandzlg3-17/+107
2018-09-08setup.py: Bump to alpha4 for PyPIzlg1-1/+1
2018-09-08cli: add '--raw' option to list commandzlg2-9/+45
2018-09-08Add remaining filters to vgstash packagezlg1-2/+11
2018-09-04Update LICENSE to match setup.pyzlg1-80/+67
2018-09-03Branch off from master with pytest, tox, clickzlg16-778/+779
2018-03-18Flesh out filter types and ownership statuszlg3-82/+144
2018-03-18README.mdown: break line correctlyzlg1-1/+1
2018-03-18add 'playlog' list filterzlg2-2/+9
2018-03-13Update helpers a bitzlg1-2/+9
2018-03-13Make VGSTASH_DB_LOCATION point to a filezlg2-21/+20
2016-11-18Remove settings from helpers.shZe Libertine Gamer1-5/+0
2016-11-15Correct phrasing in README.Ze Libertine Gamer1-4/+4
2016-11-13DerpZe Libertine Gamer1-0/+1
2016-11-03Improve error handling in shell scriptsZe Libertine Gamer4-3/+23
2016-10-24Correct run_again, add recursionZe Libertine Gamer1-0/+4
2016-10-21Add quotes to correct behavior for arglistZe Libertine Gamer1-1/+1
2016-10-14updater.sh: add recursion, error handlingZe Libertine Gamer1-43/+101
2016-10-14Correct pipe-handling behaviorZe Libertine Gamer1-1/+9
2016-10-12Clarify a method to move between platformsZe Libertine Gamer1-2/+5