sequelize Model hooks for sharded-table that like [tablename]_yyyy_mm...( table should be created before)
use sequelize original hooks as a "AOP" to change target table name
user => user_2018_01,user_2018_02, ... ,user_2018_11,user_2018_12
-
npm install sequelize -
npm install [email protected]:cclient/sequelize-sharding.gitor add dependenciessequelize-sharding":[email protected]:cclient/sequelize-sharding.gitthennpm install
const Sequelize = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
host: 'localhost',
dialect: 'mysql',
pool: {
max: 5,
min: 0,
acquire: 30000,
idle: 10000
},
// SQLite only
storage: 'path/to/database.sqlite',
// http://docs.sequelizejs.com/manual/tutorial/querying.html#operators
operatorsAliases: false
});
const User = sequelize.define('user', {
id: { type: Sequelize.INTEGER, autoIncrement: true, primaryKey: true },
name: Sequelize.STRING,
birthday: Sequelize.DATE
}, { freezeTableName: true, createdAt: false, updatedAt: false, deletedAt: false });
let user = {
name: "china",
birthday: new Date("2018-10-01")
}
const sequelizeSharding = require('sequelize-sharding');
sequelizeSharding.useCustomTableName(sequelize, User, "birthday", true)
User.insertOrUpdate(user)import { useCustomTableName} from 'sequelize-sharding';
useCustomTableName(sequelize, User, "birthday", true)
User.insertOrUpdate(user)useCustomTableName(sequelize, User, null, false, function(value) {
return getYYMM(new Date())
})
more detail see test/test.js