Auto generate models from views

[sequelize]

Auto generate models from views

[steveschmitt]

Added -v or --views option in release 0.6.7

[atulhm]

i'm using mysql and the views generate models.

[schleumer]

Same, views from Postgres are ignored 😢

[xorbis]

Seems you are wrong.
https://www.postgresql.org/docs/9.2/static/sql-createview.html

If I can SELECT it, it can be a model, no?

[eriendel]

In postgres there are no models for views generated

[lpatoyst]

In postgresql views seem to be ignored...

[xcxooxl]

apply this with patch-package:
should allow you to use views.

diff --git a/node_modules/sequelize-auto/lib/index.js b/node_modules/sequelize-auto/lib/index.js
index 182763b..f128330 100644
--- a/node_modules/sequelize-auto/lib/index.js
+++ b/node_modules/sequelize-auto/lib/index.js
@@ -69,15 +69,22 @@ AutoSequelize.prototype.build = function(callback) {
     }, _callback);
   }
 
-  if (this.dialect.showTablesQuery) {
-    const showTablesSql = this.dialect.showTablesQuery(self.options.schema);
-    self.sequelize.query(showTablesSql, {
-      raw: true,
-      type: self.sequelize.QueryTypes.SELECT
-    }).then(processTables, callback);
-  } else {
-    this.queryInterface.showAllTables().then(processTables, callback);
-  }
+  this.queryInterface.showAllSchemas().then(schemas => {
+    let tablesAndViews = [];
+    schemas.forEach(async schema => {
+      const showAllTablesAndViewsQuery =
+          'SELECT table_name FROM ' +
+          'information_schema.tables WHERE' +
+          ' (table_type LIKE \'%TABLE\' or table_type LIKE \'%VIEW\')\n' + 'AND table_name != \'spatial_ref_sys\' and table_schema = ' + schema
+
+      tablesAndViews =  [...await self.sequelize.query(showTablesSql, {
+        raw: true,
+        type: self.sequelize.QueryTypes.SELECT
+      }),...tablesAndViews]
+    });
+    return tablesAndViews;
+  }).then(processTables,callback)
+
 
   function processTables(tables) {
     function compareFn(a, b) {

[steveschmitt]

Some people want models generated from views, and some don't.
I'm going to add a command-line flag to control whether views are generated.

[polarspark]

Please add this for mssql as well. I make heavy use of MSSQL views that I need to pull data from.

[BibbyChung]

i change file and test it in postgre. it's working. maybe it's useful for you.

# node_modules/sequelize-auto/lib/dialects/index.js

function showTablesGeneric(schemaName) {
  return `SELECT table_name, table_schema
            FROM information_schema.tables
           WHERE (table_type = 'BASE TABLE'
                 ${makeCondition("table_schema", schemaName)})
                 OR (table_type = 'VIEW' AND table_schema = 'public')`;
}