aboutsummaryrefslogtreecommitdiff
AgeCommit message (Collapse)AuthorFilesLines
2023-09-22scripts: Add schema v1->v2 migration scriptnextzlg2-9/+85
This script adds three columns to the schema, supporting the "Purchased", "Beaten", and "Completed" note headers. They are now converted to a UNIX timestamp and stored in a separate column so queries made against that metadata are easier. The library itself still needs to support all the new columns.
2023-09-22tests: Add long-lost test_import.jsonzlg1-0/+23
Yeah, tests have been borked this whole time without me noticing. Wonderful. :(
2021-10-24scripts/updater.sh: removezlg1-121/+0
This script targets the old vgstash implementation and it repeats a lot of work that vgstash_cli does now.
2021-10-24system-search.sh: removezlg1-43/+0
The vgsys function does the same thing and is housed in a single script the user can source.
2021-10-24README.md: Flesh out and reorganizezlg2-75/+315
2021-10-23setup.py: bump to 0.3beta7 for PyPIv0.3b7zlg1-1/+1
2021-10-16vgstash_cli: 'export' with no filename prints to stdoutzlg2-5/+61
ZLG-Bug: 6
2021-10-16vgstash: Support 'member' ownership statuszlg2-8/+11
Games marked as a 'member' are members of a collection or bundle of *other* games. For example, Castlevania Advance Collection is available for PS4, Switch, and Xbox X, but the games contained within it are on GBA and SNES. This means the original games should be marked 'member' on ownership (and their progress tracked) while the collection entry should have its ownership tracked, but be marked unbeatable. As such, the 'owned' filter has been updated to exclude 'member' games, and there is a new 'members' filter to target *only* member games.
2021-10-16tox.ini: update to use Python 3.9 for virtualenvzlg1-1/+1
2021-10-16helpers.sh: improve vgmultizlg1-10/+2
2020-12-05helpers.sh: Add vgsyszlg1-0/+24
vgsys - filters vgstash's output by system. Optionally allows one to specify the filter name to pass to vgstash. The default filter is 'allgames'. For example, to show every game needed to be beaten on Steam, you'd use something like this: vgsys backlog Steam This is a handy feature to have when you want to narrow down your options for what-to-play.
2020-08-02setup.py: Bump to 0.3b6 for PyPIv0.3b6zlg1-1/+1
2020-08-02TODO.txt: remove distro-related packaging goalzlg1-1/+0
2020-08-02README.md: Tidy up prose, rearrange milestoneszlg1-27/+28
2020-08-02vgstash_cli: Show what happens to note datazlg2-5/+43
The 'notes -e' command used to always tell the user that the notes had been updated. This was incorrect. Now 'notes -e' will detect three states: * The note has been changed * The note has not been changed * The editor can't be loaded (set via EDITOR) ZLG-Bug: 3
2020-08-02setup.py: Bump to 0.3b5 for PyPIv0.3b5zlg1-2/+1
I took this opportunity to remove the 'json' in requires since it was breaking things.
2020-03-08helpers.sh: Add vgub, vgmulti, vgrandzlg1-0/+29
vgub - Games that are beaten or complete, excluding rereleases i.e. Super Mario Bros on NES and Wii VC will only show one or the other. vgmulti - Games you own on more than one system vgrand - Suggests a random game to play from your 'playlog' filter
2020-03-02Avoid a backtrace when editing notes on an invalid gamezlg2-1/+24
ZLG-Bug: 4
2020-03-02Avoid a backtrace when updating an invalid gamezlg2-4/+8
ZLG-Bug: 2
2019-04-30Release version 0.3 beta 4zlg4-42/+100
This release brings JSON import and export support.
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
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.
2018-11-21Prepare for distributionzlg2-1/+3
setup.py wasn't being included, preventing distros from easily building it. Whoops.
2018-10-22vgstash: let backlog filter ignore unbeatable gameszlg1-1/+1
To migrate, run these two commands: sqlite3 /path/to/vgstash.db 'DROP VIEW backlog;' vgstash init
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
Before, vgstash.DB.list_games() would default to 'allgames' and silently hide it when a filter wasn't found. This commit ensures that the vgstash package and CLI both indicate when an invalid filter is passed to them: * vgstash.DB.list_games() will return False on a failure to match; * vgstash_cli uses Click's Choice object to enforce the constraint
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
Also tweaked the export command to report correctly.
2018-10-10cli: Add "export" commandzlg2-5/+54
The export command is like the import command; currently supporting YAML output, but ready to be expanded as needed.
2018-10-10cli: Add "import" commandzlg5-1/+76
Currently the import command will only accept YAML files, but is ready for expansion to other formats as needed.
2018-10-09Bump to 0.3alpha6 for PyPIzlg1-1/+1
2018-10-09cli: Add "notes" commandzlg2-4/+74
The "notes" command will show the user what their notes for a particular game are. The output can be piped anywhere the user wants, such as a pager or a file. If "notes" is passed with the "--edit" or "-e" flag, vgstash will open a temporary file with the game's notes already inside and edit it using the program pointed to by the EDITOR environment variable. When the editor is closed (with a successful exit status), vgstash updates the game's notes and exits. The defaults for the testing environment ("cat" for non-interactive, "vim" for interactive) may need tweaking on other operating systems. Patches for these platforms are very welcome.
2018-10-09update_game: ensure notes are also savedzlg1-2/+2
2018-10-09cli: add 'update' commandzlg3-20/+92
Two helper functions were also added to the vgstash package to ease client workflows. This commit marks the final core function necessary to manipulate a vgstash DB on the command line.
2018-10-06cli: Add "delete" commandzlg2-0/+19
Unlike the old version of vgstash, the new one does not accept row IDs as arguments for removal. Instead, it accepts two mandatory arguments: the title of the game, and the system it's on. This is in line with the database itself, using the title and system as primary keys.
2018-10-06Remove ID field from DBzlg3-38/+46
The sqlite database already uses a game's title and system as the primary keys. Row IDs are redundant.
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
Also add the "--width" option to specify the maximum width of the table.
2018-09-08setup.py: Bump to alpha4 for PyPIzlg1-1/+1
2018-09-08cli: add '--raw' option to list commandzlg2-9/+45
Add '--raw' option to the list command, in addition to proper note expansion. Newline characters in notes are escaped to be friendly to scripting. This option may be shortened to '-r' at the user's convenience. In raw output mode, the information is formatted in plain pipe-delimited strings, one line per row: title|system|ownership|progress|notes ownership and progress are printed in their numeric form, consistent with the OWNERSHIP and PROGRESS dictionaries in the vgstash package. An empty notes field will result in a line ending with a pipe and no whitespace following it.
2018-09-08Add remaining filters to vgstash packagezlg1-2/+11
2018-09-04Update LICENSE to match setup.pyzlg1-80/+67
Whoops.