These reports can be rendered in:
$ npm i -g reportsdb
$ reportsdb -h$ reportsdb toPDF -h
Create project by copying the example
$ reportsdb init .
This will create a boilerplate on which to work on.
/db.sqlite /.editorconfig /files/ /reports/ /scripts/ /scripts/inputFood.sh /templates/ /templates/Food/ /templates/Food/html.pug /templates/Food/query.sql
Generating a report will read the
query.sql inside the given template directory. Output file is located in
Filtering is possible by year
-y <YYYY>(and quater
-q <Q>). A
--select <column>option is required. The
--selectoption will also reorder by said column date (with or without year (& quater) filter).
$ reportsdb toPDF ./examples/templates/Food/
$ reportsdb toCSV ./examples/templates/Food/
$ reportsdb toHTML ./examples/templates/Food/