egg-mssql2webapi
将mssql的sql、pro转为webapi
Install
$ npm i egg-mssql2webapi --save
Usage
// {app_root}/config/plugin.jsexportsmssql2webapi = enable: true package: 'egg-mssql2webapi';
Configuration
// {app_root}/config/config.default.jsexportsmssql2webapi = urlprefix: '/api/' apitable: emr: // api/emr/ db: server: 'd.vy01.com' user: 'sa' password: 'test.123456' database: 'db1' apis: name: 'getuser' //http://127.0.0.1:7001/api/emr/getuser?usercode=2 sql: 'api_getuser' type: 'pro' result:'object' name: 'findusers'//http://127.0.0.1:7001/api/emr/findusers sql: 'select * from users where objectstatus>0' type: 'sql' result:'array' ris: db: {} apis: ;
http://127.0.0.1:7001/api/emr/getuser?usercode=2
http://127.0.0.1:7001/api/emr/findusers
see config/config.default.js for more detail.
Example
Questions & Suggestions
Please open an issue here.