sails-hook-sequelize-blueprints

Sails blueprints for sequelize ORM


The blueprints waterline replaced with sequelize.

#Install

Install sails-hook-sequelize first:
``sh
$ npm install sails-hook-sequelize --save
`

Install this hook with:

`sh
$ npm install sails-hook-sequelize-blueprints --save
`

Sequelize dependencies:

`sh
$ npm install --save sequelize
$ npm install --save pg pg-hstore // in case of PostgreSQL
$ npm install --save continuation-local-storage
`

Configuration

.sailsrc
``
"hooks": {
"blueprints": false,
"orm": false,
"pubsub": false
}
`

Blueprints

Default blueprints configurations

`javascript
module.exports.blueprints = {
actions: true,
index: true,
shortcuts: true,
rest: true,
prefix: '',
restPrefix: '',
pluralize: false,
populate: true,
defaultLimit: 30,
populateLimit: 30,
autoWatch: true,
}
`

Connections


Sequelize connection
`javascript
somePostgresqlServer: {
user: 'postgres',
password: '',
database: 'sequelize',
dialect: 'postgres',
options: {
dialect: 'postgres',
host : 'localhost',
port : 5432,
logging: true
}
}
`

Models

Sequelize model definition
models/user.js
`javascript
module.exports = {
attributes: {
name: {
type: Sequelize.STRING,
allowNull: false
},
age: {
type: Sequelize.INTEGER
}
},
associations: function() {
user.hasMany(image, {
foreignKey: {
name: 'owner',
allowNull: false
}
});
user.belongsToMany(affiliation, {
as: 'affiliations',
to: 'users', // must be named as the alias in the related Model
through: 'UserAffiliation',
foreignKey: {
name: 'userId',
as: 'affiliations'
}
});
},
options: {
tableName: 'user',
classMethods: {},
instanceMethods: {},
hooks: {}
}
};
``

#Credits
A big thanks to festo/sailsjs-sequelize-example and Manuel Darveau's answer that turn this possible with thier sequelize implementations.

Munkacsy.me

#Contributions

1. Fork it!
2. Create your feature branch: git checkout -b my-new-feature
3. Commit your changes: git commit -m 'Add some feature'
4. Push to the branch: git push origin my-new-feature
5. Submit a pull request

#License
MIT