Node.js SequelizeJS ORM model utilities
npm install @cond/sequelize-modelsNode.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.
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.
``sh
$ npm install --save sequelize-models
$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
`jsconst 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 postgrescreate mysql config files
$ gulp config-mysql
test data for mysql
$ ./node_modules/sequelize-cli/bin/sequelize db:migratecreate psql config files
$ gulp config-psql
test data for postgres
$ ./node_modules/sequelize-cli/bin/sequelize db:migraterun test
$ gulp test
``[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