经过比较个人感觉sequelize 比其他orm好用些,用了半天时间终于搞定了,直接上代码
1、利用sequelize model生成table
applicationMysql.js文件------------
var Sequelize = require('sequelize');
var sequelize = new Sequelize('db', 'root', 'root', {
host: 'localhost',
dialect: 'mysql',
pool: {
max: 5,
min: 0,
idle: 10000
},
Sequelize :Sequelize
});
function ApplicationMysql(){
return sequelize;
}
module.exports = new ApplicationMysql();
user.js文件-----------------
var app = require('../server/applicationMysql.js');
User = app.define('user',{
firstName: {
type: app.Sequelize.STRING,
// field: 'first_name' // Will result in an attribute that is firstName when user facing but first_name in the database