abelosorio / sequelize-views-support Goto Github PK

View creation works as expected but when I try to issue a model.findAll on the view I get a UnhandledPromiseRejectionWarning: SequelizeDatabaseError: relation "my_view" does not exist.

Am I using the package in a way that was not intended?

Thanks!

"dependencies": {
"pg": "^8.5.1",
"sequelize": "^6.5.0"
},

If I upgrade to the latest version of pg and sequelize, queryInterface becomes camelCase.

 static drop(options) {
    const method = this.options.treatAsView ? 'dropView' : 'dropTable';

    return this.queryInterface[method](
      this.getTableName(options), options
    );
  }

static syncView(options) {
    return this.queryInterface.createView(
      this.getTableName(options),
      this.getViewDefinition(),
      options
    );
  }

In some specific cases you may need sync the model individually MyModel.sync. For some reasons you disabled this capability for views.
https://github.com/abelosorio/sequelize-views-support/blob/master/src/model-views-support.js#L15s
Is there a reason for that?

My specific situation is related to my other issue #4.
After seeing that I cannot do soft sync, I thought I can sync the view individually and catch that exception and ignore it.

I couldn't create a view. Below is my code.

Model.js

module.exports = (sequelize, DataTypes) => {
    const VwBackscattering = sequelize.define('vw_backscattering', {
            capture_datetime:  DataTypes.DATE,
            bb_470nm:DataTypes.DOUBLE,
            bb_532nm:DataTypes.DOUBLE,
            bb_650nm: DataTypes.DOUBLE,
            boat_datetime:  DataTypes.DATE,
            rainfall: DataTypes.DOUBLE,
            temperature: DataTypes.DOUBLE,
            latitude: DataTypes.DOUBLE,
            longitude: DataTypes.DOUBLE
        },
        {
            treatAsView: true,
            viewDefinition: `
              CREATE VIEW "vw_backscattering" AS
            'SELECT t1.*, t2.*,
            'ST_SetSRID(ST_MakePoint(t2.longitude, t2.latitude), 4326) as point_geom
            'FROM backscatterings t1 INNER JOIN 
            '    ancillary_data t2 ON t1.capture_datetime = t2.boat_datetime;`
        });
    return VwBackscattering;
};

index.js

const Sequelize = require('sequelize-views-support');
const view = require('./models/VwBackscattering');
const VwBackscattering = view(db, Sequelize.DataTypes)
VwBackscattering.sync().then(() => {
    console.log('VwBackscattering table created');
});
module.exports = VwBackscattering;

When I installed this package, I got this dependency tree:

info All dependencies
├─ @types/[email protected]
├─ [email protected]
├─ [email protected]
├─ [email protected]
├─ [email protected]
├─ [email protected]
├─ [email protected]
└─ [email protected]

However in the package.json of this package sequelize@^6.0.0 is in the dependencies. And Sequelize 6 is not even out yet. Can someone explain this discrepancy?

I am currently using Sequelize 5 in my project. Is this package only compatible with Sequelize 4?

import Sequelize from 'sequelize-views-support';
^^^^^^

SyntaxError: Unexpected token import

$ node -v
v8.2.0

Is there any reason why you are using the pg@7 package. That package has known issues with Sequelize. Would you be willing to set your package.json file to ^6.1.2

Inside query-interface-views-support.js, on line 4, you have

const sql = DROP VIEW IF EXISTS "${viewName}"${options.cascade && ' CASCADE'};

That creates "DROP VIEW IF EXISTS someViewundefined"

It should be
const sql = DROP VIEW IF EXISTS "${viewName}" ${options.cascade ? 'CASCADE': ''};

The situation is that i have a already defined schema so I cannot do force sync. On normal table the soft sync does work. You even can add a view on a already existent schema. But when trying to do a soft sync when you have already, the error is thrown: Table 'myView' already exists.