线上效果：http://172.104.79.155:4000/restful/admin/#/user/list
示例代码仓库：https://github.com/postor/mysql-restful-api-example
给每个表生成对应的restful接口文件，作为Router使用在你的express项目中。|generate files for restful api for each table, require them as routers and use in your app
- 可用于现有的express项目|designed for an working express
- 所有的逻辑都是生成的，都可以改|more flexable
用到的项目|related projects
- bookshelf.js http://www.bookshelfjs.org/
- ng-admin https://ng-admin-book.marmelab.com/
mkdir myproj
cd myproj
npm init
npm install express --save
vi app.js #copy code into app.js
node app.jsapp.js
var express = require('express');
var app = express();
// respond with "hello world" when a GET request is made to the homepage
app.get('/', function(req, res) {
res.send('hello world');
});
app.listen(80)npm install mysql-restful-api --save
node node_modules/mysql-restful-api/cli.js
#path_for_generated_files
#host
#user
#password
#db
#done!
vi app.jsapp.js
var express = require('express');
var app = express();
app.use('/restful',require('./restful/default-router'))
// respond with "hello world" when a GET request is made to the homepage
app.get('/', function(req, res) {
res.send('hello world');
});
app.listen(80)定制情况（自由发挥）|cases
//default
app.use('/restful',require('./restful/default-router'))
//only table
app.use('/table1',require('./restful/routers/table1')))定制Router的实现（具体修改自由发挥）|customize table router/actions
vi path_for_generated_files/table_name #and modify it- listView => GET /users
- creationView => POST /users
- showView => GET /users/:id
- editionView => PUT /users/:id
- deletionView => DELETE /users/:id
/restful/test_table/1
{"id":1,"name":"2017-01-13 12:56:25"}/restful/admin/
- using ng-admin https://github.com/marmelab/ng-admin
mysql终端
update user set authentication_string=password(''), plugin='mysql_native_password' where user='root';
flush privileges;