Skip to content
This repository has been archived by the owner on Feb 25, 2024. It is now read-only.
/ reportsdb Public archive

Create reports from SQLite with Pug and JavaScript templates.

License

Notifications You must be signed in to change notification settings

lil5/reportsdb

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

GitHub license npm XO code style

ReportsDB

Create reports from an sqlite datebase and a template using SQL and Pug with Big.js JavaScript math.

These reports can be rendered in:

  • PDF
  • CSV
  • HTML

Install

$ npm i -g reportsdb

Commands

Help

$ 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

Create report

Generating a report will read the html.pug and query.sql inside the given template directory. Output file is located in reports.

Filtering is possible by year -y <YYYY> (and quater -q <Q>). A --select <column> option is required. The --select option will also reorder by said column date (with or without year (& quater) filter).

PDF

$ reportsdb toPDF ./examples/templates/Food/

CSV

$ reportsdb toCSV ./examples/templates/Food/

HTML

$ reportsdb toHTML ./examples/templates/Food/

Releases

No releases published

Packages

No packages published