Hapi.js plugin for the Sequelize ORM.
Compatible with hapi.js version 17.x
and sequelize 4.x
.
npm install --save @bakjs/sequelize
Simply pass in your sequelize instance and a few basic options and voila. Options accepts a single object or an array for multiple dbs.
server.register([
{
register: require('@bakjs/sequelize'),
options: [
{
// identifier
name: 'dbname',
// paths/globs to model files
models: ['./server/models/**/*.js'],
// sequelize: new Sequelize(/* ... */), // sequelize instance
// or connection string
connection: 'sqlite:dbname.db',
// or connection options
// connection: {
// dialect: '',
// username: '',
// password: ''
// },
// sync models - default false
sync: true,
// force sync (drops tables) - default false
forceSync: false,
},
],
},
]);
A model should export a function that returns a Sequelize model definition (http://docs.sequelizejs.com/en/latest/docs/models-definition/).
module.exports = function(sequelize, DataTypes) {
const Category = sequelize.define('Category', {
name: DataTypes.STRING,
rootCategory: DataTypes.BOOLEAN,
});
return Category;
};
Using the sequelize model instance, define a method called associate
, that is a function, and receives as parameter all models defined.
module.exports = function(sequelize, DataTypes) {
const Category = sequelize.define('Category', {
name: DataTypes.STRING,
rootCategory: DataTypes.BOOLEAN,
});
Category.associate = function(models) {
models.Category.hasMany(models.Product);
};
return Category;
};
Each registration adds a DB instance to the server.plugins['sequelize']
object with the
name option as the key.
function DB(sequelize, models) {
this.sequelize = sequelize;
this.models = models;
}
// smth like this
server.plugins['sequelize'][opts.name] = new DB(opts.sequelize, models);
The request object gets decorated with the method getDb
. This allows you to easily grab a
DB instance in a route handler. If you have multiple registrations pass the name of the one
you would like returned or else the single or first registration will be returned.
handler(request, reply) {
const db1 = request.getDb('db1');
console.log(db1.sequelize);
console.log(db1.models);
}
Returns single model that matches the passed argument or null if the model doesn't exist.
Returns all models on the db instance
MIT
Based on: