@cond/sequelize-models
v0.0.4
Published
Node.js SequelizeJS ORM model utilities
Downloads
12
Maintainers
Readme
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