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 = ;const extendSequelize = ;const enhanceView = ; const sequelize = ...; const db = {}dbTask = sequelize;Task { dbPendingTask = ; dbCompletedTask = ;}; ; // ... // Now you can call .findById(), .find(), .findOne() and // .findAll() and they will only return instances that // respect the view where statement.dbPendingTask;
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.