Node.js Report Utility
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...
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:
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.