sequelize-extension-view
v0.0.1
Published
This extension allows the creation of virtual table views
Downloads
3
Maintainers
Readme
sequelize-extension-view
Installation
$ npm install --save sequelize-extension-view
Usage
This library uses sequelize-extension to extend sequelize models. Models with the method createViews
will be called to create table views (virtual models). The virtual model/instance inherits all the methods created by Sequelize.
const Sequelize = require('sequelize');
const extendSequelize = require('sequelize-extension');
const enhanceView = require('sequelize-extension-view');
const sequelize = new Sequelize(...);
const db = {}
db.Task = sequelize.define('task', {
name: Sequelize.STRING(255),
status: Sequelize.ENUM('PENDING', 'COMPLETED'),
});
Task.createViews = (create) => {
db.PendingTask = create({
where: { status: 'PENDING' },
});
db.CompletedTask = create({
where: { status: 'COMPLETED' },
});
};
extendSequelize([Task], {
view: enhanceView(),
});
// ...
// Now you can call .findById(), .find(), .findOne() and
// .findAll() and they will only return instances that
// respect the view where statement.
db.PendingTask.find(options).then((pendingTask) => {
// Do something with pending task
pendingTask.name = 'new name';
pendingTask.save().then(...);
});
Other Extensions
sequelize-extension-graphql - Create GraphQL schema based on sequelize models.
sequelize-extension-tracking - Automatically track sequelize instance updates.
sequelize-extension-createdby - Automatically set createdBy
with options.user.id
option.
sequelize-extension-updatedby - Automatically set updatedBy
with options.user.id
option.
sequelize-extension-deletedby - Automatically set deletedBy
with options.user.id
option.