about summary refs log tree commit diff
path: root/tools/mpd-stats/README.org (unfollow)
Commit message (Collapse)AuthorFilesLines
2022-06-11scrobbler: record how long a song was playedFranck Cuny2-1/+16
Add a column `playtime` to the records table to keep track of how long a song was played. With this information, in the future, we will be able to sum up how long we listen to music, but also which songs were skipped.
2022-06-11mpd-scrobbler: proper default argumentsFranck Cuny1-2/+31
The program needs two arguments: the mpd host and port, which can be passed as flags (default is to use the local instance of mpd). We store the database in `XDG_CONFIG_HOME/mpd-scrobbler`, and we create the path if needed.
2022-06-11scrobbler: use helper function EqualAttrsFranck Cuny1-3/+1
To compare the current attributes with the current record, we can use the helper `EqualAttrs` which will tell us if we need to create a new record or not.
2022-06-11record: add some basic testingFranck Cuny2-0/+59
2022-06-11mpd-stats: pass database path to the scrobblerFranck Cuny2-5/+31
When creating a scrobbler, we provide the path to the database. The scrobbler then get a handler to the database. When a new record is created, we persist it to the database using the `save` function.
2022-06-11scrobbler: add timestamp to the recordFranck Cuny1-9/+11
When we create a new record, let's capture when this was created.
2022-06-11scrobbler: add interface to the sqlite3 databaseFranck Cuny3-0/+57
We want to persist the records in a database, so we can extract statistics and an history. The module for the database is straightforward: it opens the database if it exists and return an handler to it. If the database does not exists, we create it and we create the only table we need (records).