config.sequelize = {
datasources: [
{
delegate: 'model', // 加载所有的模型到 app.model and ctx.model
baseDir: 'model', // 要加载的模型目录`app/model/*.js`
database: 'db',
dialect: 'mysql',
host: 'ip',
port: 'port',
username: 'root',
password: 'root',
timezone: 'Asia/Shanghai', // 时间差
benchmark: true,
define: {
freezeTableName: true, // 禁止数据读写时给表赋别名(as)
underscored: true,
timestamps: false, // 为模型添加createdAt和updatedAt字段
},
},
{
delegate: 'logModel', // 加载所有的模型到 app.logModel and ctx.logModel
baseDir: 'model_log', // 要加载的模型目录 `app/model_log/*.js`
database: 'db_log',
dialect: 'mysql',
host: 'ip',
port: 'port',
username: 'root',
password: 'root',
timezone: 'Asia/Shanghai',
benchmark: true,
define: {
freezeTableName: true, // 禁止数据读写时给表赋别名(as)
underscored: true,
timestamps: false, // 为模型添加createdAt和updatedAt字段
},
},
]
};
05-26
4019