Age | Commit message (Collapse) | Author | Files | Lines |
|
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.
|
|
Yeah, tests have been borked this whole time without me noticing.
Wonderful. :(
|
|
This script targets the old vgstash implementation and it repeats a lot
of work that vgstash_cli does now.
|
|
The vgsys function does the same thing and is housed in a single script
the user can source.
|
|
|
|
|
|
ZLG-Bug: 6
|
|
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.
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
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
|
|
I took this opportunity to remove the 'json' in requires since it was
breaking things.
|
|
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
|
|
ZLG-Bug: 4
|
|
ZLG-Bug: 2
|
|
This release brings JSON import and export support.
|
|
|
|
|
|
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.
|
|
setup.py wasn't being included, preventing distros from easily building
it. Whoops.
|
|
To migrate, run these two commands:
sqlite3 /path/to/vgstash.db 'DROP VIEW backlog;'
vgstash init
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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
|
|
|
|
|
|
Also tweaked the export command to report correctly.
|
|
The export command is like the import command; currently supporting YAML
output, but ready to be expanded as needed.
|
|
Currently the import command will only accept YAML files, but is ready
for expansion to other formats as needed.
|
|
|
|
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.
|
|
|
|
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.
|
|
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.
|
|
The sqlite database already uses a game's title and system as the
primary keys. Row IDs are redundant.
|
|
|
|
|
|
Also add the "--width" option to specify the maximum width of the table.
|
|
|
|
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.
|
|
|
|
Whoops.
|