Node Report Server (MySQL only now!)
Simple MySQL DB SQL to JSON mapping module, and also provide web function to render table.
npm install noderpt
Few steps to build the report...
Step1: Config the DB and SQL mapping file
The database config file's path need to export to environment and the config will like:
You need to create a config file inside your project, in our sample we create the report config in $project/report.
You can use json format config
Or using xml format config
queryUserInfoselect * from user where 1=1USERNAME and username = ?USER_ID and user_id = ?order by 1
In the configuration, the fields are:
- name: report name
- sql: the main sql block, that is static and will combined with conditions and endsql directly
- conditions: you can have many conditions to let query bring into query, in the api, if you specify a query string in the end of rest url and the parameter will combine the condition to sql
- endsql: the final sql, like "order by", "group by"..., that will combine to the end of sql statement
Testing your configure (test.js)
var rpt = ;rpt;rpt;rptdatasource;
After run the test.js, you will get a query result of the configure file as a json array format.