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:
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.