sequelize-models

[![NPM version][npm-image]][npm-url] [![Build Status][travis-image]][travis-url] [![Dependency Status][daviddm-image]][daviddm-url]  

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.

$3

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.

$3

``sh
$ npm install --save sequelize-models

MySQL

$ npm install --save mysql2

PostgreSQL

$ npm install --save pg
$ npm install --save pg-hstore
`

$3

* 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).

$3

Config and get schema

`js

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

`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 : []
};


`

$3


`bash
$ npm install -g gulp && gulp docs
`

$3

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.

`bash
$ 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

[npm-image]: https://badge.fury.io/js/sequelize-models.svg
[npm-url]: https://npmjs.org/package/sequelize-models
[travis-image]: https://travis-ci.org/gbahamondezc/sequelize-models.svg?branch=master
[travis-url]: https://travis-ci.org/gbahamondezc/sequelize-models
[daviddm-image]: https://david-dm.org/gbahamondezc/sequelize-models.svg?theme=shields.io
[daviddm-url]: https://david-dm.org/gbahamondezc/sequelize-models
[coveralls-image]: https://coveralls.io/repos/gbahamondezc/sequelize-models/badge.svg
[coveralls-url]: https://coveralls.io/r/gbahamondezc/sequelize-models