Noiseless Party Machine

    sequelize-views-support

    1.2.2 • Public • Published

    Add Views support to Sequelize

    NPM version

    This package adds support to Views in Sequelize.

    NOTE: Currently it's only supported in PostgreSQL.

    Motivation

    I've been using PostgreSQL and other RDBMS for a long time, and I can't stress enough about how useful is the View mechanism. For that reason (and others that you'd get bored reading them) an ORM without Views support is incomplete.

    This package needs a lot of further work, tests, discussion... but for the moment it works as expected and fulfills its purpose. Feel free of discuss changes, ideas, or whatever you think. Thanks.

    Read

    Install

    npm install --save sequelize-views-support
    

    How to use

    First, when creating the sequelize instance, you have to do it using this package and not the Sequelize's:

    sequelize.js:

    const Sequelize = require('sequelize-views-support');
     
    const sequelize = new Sequelize(
      // Use the same construction call you've been using so far
    );
     
    module.exports = sequelize;

    Then, when creating your view models you have to set two more options (let's call this view Foo):

    models/foo.js:

    module.exports = (sequelize, DataTypes) => {
      const Foo = sequelize.define('foo', {
        field1: DataTypes.DATE,
        field2: DataTypes.STRING,
        // etc...
      }, {
        treatAsView: true,
        viewDefinition: `
          CREATE VIEW "foo" AS
            -- Put here your view's definition
            -- DO NOT USE "CREATE OR REPLACE", JUST "CREATE"
            -- You can create complex Views using any of the PostgreSQL DSL's supported features
        `
      });
     
      return Foo;
    };

    That's it. Now you can sync your models including views. Take into account that views will be created after syncing all your models. This is because your views may depend on models.

    Migrations

    The next step is to maintain your views. You're going to need to write migrations to change your views' definition, as well as changing it in the viewDefinition option.

    You can ignore the viewDefinition option, but you won't be able to sync that view.

    Mantainers

    Install

    npm i sequelize-views-support

    DownloadsWeekly Downloads

    228

    Version

    1.2.2

    License

    MIT

    Unpacked Size

    10.8 kB

    Total Files

    11

    Last publish

    Collaborators

    • aosorio