sequelize-models

Node.js SequelizeJS ORM model utilities.

sequelize-models will try to load all your database tables and associations in Sequelize JS models automatically, but if you want define your models explicitly, just create a model file and sequelize-models will skip the models automatic definition for that table and will use your model file, use models.path to specify the models directory to read.

Warnings

Node.js 4.0 or latest is required to use this module.

Sequelize Models Version 1.3.x uses SequelizeJS 4.0.0 which is currently unstable

sequelize-models is in active (but slow) development so feel free to report issues or submit a PR with fixes and enhancements.

Installation

$ npm install --save sequelize-models

# MySQL
$ npm install --save mysql2

# PostgreSQL
$ npm install --save pg
$ npm install --save pg-hstore

Features

• Auto load of Sequelize models from database schema.

• Auto load models associations from database schema.

• Simplified and meaningful model files syntax.

• One place models and associations definitions.

• MySQL and PSQL support for now (support for MSSQL as soon as possible).

Usage

Config and get schema

const SequelizeModels = require("sequelize-models");

var seqModels  = new SequelizeModels({
  // Database connection options
  connection : {
    host     : "127.0.0.1",
    dialect  : "mysql",
    username : "root",
    schema   : "sequelize_test",
    password : ""
  },

  // Models loading options
  models : {
    autoLoad : true,
    path     : "/models"
  },

  // Sequelize options passed directly to Sequelize constructor
  sequelizeOptions : {
    define : {
      freezeTableName : true,
      underscored     : true
    }
  }
});


seqModels.getSchema().then( schema => {
  // schema.models and schema.db available here
})
.catch( err => {
  // throwing error out of the promise
  setTimeout( () => { throw err });
});

Model Definition , file models/User.js

module.exports = {

  // Following http://docs.sequelizejs.com/en/latest/docs/models-definition/
  tableName : "user",

  attributes : {
    name : {
      type : "string"
    },
    last_name : {
      type : "string"
    },
    born_date : {
      type : "date"
    }
  },


  // Associations -> http://docs.sequelizejs.com/en/latest/docs/scopes/#associations
  associations : [{
    type    : "belongsTo",
    target  : "Profile",
    options : {
      foreignKey : "profile_id"
    }
  }],

  validate : {},
  indexes  : []
};

Build and open code documentation

$ npm install -g gulp && gulp docs

Run Tests

You need edit test/mysql/config.js and test/psql/config.js with your own databases connection params, before run the steps below which are assuming that you will create a database with the name sequelize_test on each database.

$ npm install gulp -g && npm install
$ mysql -e 'create database sequelize_test;'
$ psql  -c 'create database sequelize_test;' -U postgres

# create mysql config files
$ gulp config-mysql
# test data for mysql
$ ./node_modules/sequelize-cli/bin/sequelize db:migrate

# create psql config files
$ gulp config-psql
# test data for postgres
$ ./node_modules/sequelize-cli/bin/sequelize db:migrate

# run test
$ gulp test

License

MIT