vgstash/src, branch nextManage your game collection and knock out that backlog!https://git.zlg.space/vgstash/atom/src?h=next2025-07-30T03:37:57ZThe big VGStash-Web commit!2025-07-30T03:37:57Zzlgzlg@zlg.space2025-07-30T02:11:50Zurn:sha1:9b0bda1a13ebac7866099c325b7ab103520ea40b
This commit introduces a templated HTML file to insert your username,
and a set of files that, when combined with your exported VGStash in
JSON format, can be used to display (and browse) your game collection in
your Web browser!
Finish integrating support for p_date, et al2025-07-28T03:42:03Zzlgzlg@zlg.space2025-07-28T03:42:03Zurn:sha1:b86e8271edde41c8527cdadb0b32505376afb5dc
* Tightened up update_game() to use explicit fields
* 'unowned' and 'unbeatable' status now show as blank fields in
list_game() output
* Results are counted and a proper message is emitted instead of
erroring when there are no results.
* Support p_date, b_date, and c_date in the CLI
Add support for p_date, b_date, c_date to CLI2025-01-24T15:43:37Zzlgzlg@zlg.space2025-01-24T15:38:48Zurn:sha1:0ba91dd3034cadfb7e80bcc4a1f64a2b67a85368
The library and CLI tool both can handle the new schema v2 that includes
these columns. Please use the schema migration script in the "scripts"
directory to continue using VGStash.
The list_games function has been completely re-worked to handle
arbitrary tabular data. Raw mode has remained, but the width switch (-w)
for default table view is no longer present.
The first VIEW supporting these columns is also available in FILTERS:
the backlog_age filter, which will show you the amount of time games
with a purchase date value have been sitting in your collection
unbeaten.
vgstash_cli: 'export' with no filename prints to stdout2021-10-17T01:33:48Zzlgzlg@zlg.space2021-10-17T01:33:48Zurn:sha1:269aecb4478c4ed6e15e1b155f259d978b178d2e
ZLG-Bug: 6
vgstash: Support 'member' ownership status2021-10-17T01:26:14Zzlgzlg@zlg.space2021-10-17T01:26:14Zurn:sha1:e23f6da1fb50b28f63283852dc89046b468dd644
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.
vgstash_cli: Show what happens to note data2020-08-02T23:57:26Zzlgzlg@zlg.space2020-08-02T23:57:26Zurn:sha1:bc6fd1e41c3e362c42414b4f582f5ebd2613a8a4
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
Avoid a backtrace when editing notes on an invalid game2020-03-03T05:32:45Zzlgzlg@zlg.space2020-03-03T05:32:45Zurn:sha1:6342e1479d6390a3101e715ff67c4983753cc7db
ZLG-Bug: 4
Avoid a backtrace when updating an invalid game2020-03-03T05:09:00Zzlgzlg@zlg.space2020-03-03T05:09:00Zurn:sha1:284b5946c61cc39d8aa880554ce5ba363285c5fc
ZLG-Bug: 2
Release version 0.3 beta 42019-05-01T03:34:15Zzlgzlg@zlg.space2019-05-01T03:34:15Zurn:sha1:cee2897b1e5ace4a697d40450d87d53d0ef3a853
This release brings JSON import and export support.
vgstash: Add "notes" filter to schema2019-01-03T13:40:16Zzlgzlg@zlg.space2019-01-03T13:40:16Zurn:sha1:6c59e9df6dcbf3cc2daaac9b40cdfe8a6859c690
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.
vgstash: let backlog filter ignore unbeatable games2018-10-22T09:47:47Zzlgzlg@zlg.space2018-10-22T09:47:47Zurn:sha1:dc2797941701af6f36482203355b3fbd24777143
To migrate, run these two commands:
sqlite3 /path/to/vgstash.db 'DROP VIEW backlog;'
vgstash init
vgstash.DB.__init__: fix error output formatting2018-10-19T04:14:38Zzlgzlg@zlg.space2018-10-19T04:14:38Zurn:sha1:93f42bbcbf2c5a17f92b3d8f0b1ec9a767fd210bcli: show msg if game to be deleted is not in DB2018-10-19T04:02:53Zzlgzlg@zlg.space2018-10-19T04:02:53Zurn:sha1:69373e362637b5e89ee347c9874f5f8c4ec6a294cli: Tell the user when a game lacks notes2018-10-19T01:14:52Zzlgzlg@zlg.space2018-10-19T01:14:52Zurn:sha1:09e2c47970a02be5a7e79a67b335f274f4c2c866Catch when an invalid list filter is passed2018-10-18T23:36:39Zzlgzlg@zlg.space2018-10-18T23:36:39Zurn:sha1:3ec2a2902caaf3e70deea650425339299af5d821
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
cli: Add zero-game import/export messages2018-10-13T00:50:53Zzlgzlg@zlg.space2018-10-13T00:50:53Zurn:sha1:c7d09704fb911d59139aff5ad0ab4c35a2ed9493Move tests and data to dedicated directory2018-10-11T04:29:08Zzlgzlg@zlg.space2018-10-11T04:29:08Zurn:sha1:8775fcd12876f3acc5f9b919afe1cf3be238a186
Also tweaked the export command to report correctly.
cli: Add "export" command2018-10-11T03:49:02Zzlgzlg@zlg.space2018-10-11T03:49:02Zurn:sha1:411e47351c996aa1d1f19dc10366ee824d091b40
The export command is like the import command; currently supporting YAML
output, but ready to be expanded as needed.
cli: Add "import" command2018-10-11T02:44:18Zzlgzlg@zlg.space2018-10-11T02:44:18Zurn:sha1:669aed9ec7261c49c49ed26c31f218e42faa491a
Currently the import command will only accept YAML files, but is ready
for expansion to other formats as needed.
cli: Add "notes" command2018-10-10T06:32:23Zzlgzlg@zlg.space2018-10-10T06:32:23Zurn:sha1:2fad4b705166d8bd8cd9783c16856d07c470d3e0
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.
update_game: ensure notes are also saved2018-10-10T06:30:29Zzlgzlg@zlg.space2018-10-10T06:30:29Zurn:sha1:bf567438a9720c18f7e0045f4b198cf143fa7053cli: add 'update' command2018-10-09T11:33:52Zzlgzlg@zlg.space2018-10-09T11:33:52Zurn:sha1:ac3e84c9438ef964a08f2acf40ab58fe1c04675e
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.
cli: Add "delete" command2018-10-07T05:28:40Zzlgzlg@zlg.space2018-10-07T05:28:40Zurn:sha1:9da20483b8aa26a3090093212d007e6dc756b2d2
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.
Remove ID field from DB2018-10-07T05:26:21Zzlgzlg@zlg.space2018-10-07T05:26:21Zurn:sha1:e5875bb6b73f91db5a9982e2816de649e9bc4ef6
The sqlite database already uses a game's title and system as the
primary keys. Row IDs are redundant.
cli: change "Status" heading to "Progress"2018-10-07T05:04:53Zzlgzlg@zlg.space2018-10-07T05:04:53Zurn:sha1:9de7357d758ab2253061ce7d68fb3942b52ee7a3cli: Add pretty printing to 'list' command2018-09-30T06:34:35Zzlgzlg@zlg.space2018-09-30T06:27:05Zurn:sha1:7288560c5678991527c7b2c2ed0d7f3979f70c67
Also add the "--width" option to specify the maximum width of the table.
cli: add '--raw' option to list command2018-09-09T02:15:48Zzlgzlg@zlg.space2018-09-09T02:15:48Zurn:sha1:b2d47d2ca978e2cd62be4cb6fe0471598427b8b7
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.
Add remaining filters to vgstash package2018-09-09T02:07:36Zzlgzlg@zlg.space2018-09-09T02:07:36Zurn:sha1:14162a862e50c35f44370daf1f525b27f3bafc85Branch off from master with pytest, tox, click2018-09-03T09:55:21Zzlgzlg@zlg.space2018-09-03T09:52:57Zurn:sha1:565812a92cd22d41aa6f5f85a6b451386422fb4a
This commit is huge, but contains everything needed for a "proper" build
system built on pytest + tox and a CLI built with click.
For now, this branch will contain all new vgstash development activity
until it reaches feature parity with master.
The CLI is installed to pip's PATH. Only the 'init', 'add', and 'list'
commands work, with only two filters. This is pre-alpha software, and is
therefore not stable yet.