sequelize模型关联_Nodejs ORM框架Sequelize（模型，关联表，事务，循环，及常见问题）...

1.建立连接

const Sequelize = require('sequelize');

const sequelize = new Sequelize('database', 'username', 'password', {

host: 'host',

port: 'port',

pool: {

max: 50,

min: 0,

//建立连接最长时间

acquire: 30000,

//空闲最长连接时间

idle: 10000

},

//默认输出执行sql语句

logging: console.log,

define: {

//默认创建表有 createAt, updateAt

timestamps: false,

//可以给表设置别名

freezeTableName: true,

// 字段以下划线(_)来分割(默认是驼峰命名风格)

underscored: false

},

//sequelize v4 必须设置方言

dialect: 'mysql',

//默认DECIMAL and NEWDECIMAL 返回 String

dialectOptions: {

decimalNumbers: true

},

//设置别名，否则不识别$like等关键词($like: Op.like对应关系)

operatorsAliases: 'object',

//时间上的统一

timezone: "+08:00",

})

2.模型定义

const DataTypes = Sequelize.DataTypes;

const user = sequelize.define('u', {

userId: {

type: DataTypes.INTEGER,

primaryKey: true,

autoIncrement: true

},

userName: {

type: DataTypes.STRING,

allowNull: true

},

birthDay: {

type: 'TIMESTAMP',

allowNull: false

},

gender: {

type: DataTypes.INTEGER,

allowNull: true,

defaultValue: 0

},

ctime: {

type: 'TIMESTAMP',

all