// server.js
const Hapi = require('hapi');
const server = new Hapi.Server();//注册到 hapi server
server.register([{register: require('hapi-sequelize'),options: {database: '',user: '',pass: '',dialect: 'mysql',port: 3306,models: 'Models/**/*.js',sequelize: {define: {underscoredAll: true}}}},], (err) => {if (err) {console.error('failed to load plugin');}}
);

// Models/user.js
function userModel(sequelize, DataTypes) {var User = sequelize.define('User', {user_name: { //定义User表中的每一个字段type: DataTypes.STRING, //字段数据类型allowNull: false //是否允许为空},user_level: {type: DataTypes.INTEGER,allowNull: false},user_proj: {type: DataTypes.STRING}});return User;
}module.exports = userModel;

// server.js
server.plugins['hapi-sequelize'].db.sequelize.sync().then(function () {console.log('models synced');});
//sync方法如果配置{force: true}时，如果数据库是否有该表，如果有则会删除表，再重建。

// Route/index.js
function index(req, res) {var models = req.server.plugins['hapi-sequelize'].db.sequelize.models;models.User.find({...}).then({...});
}module.exports = {method: 'GET',path: '/',handler: index
}];

models.User.create({user_name: 'John',user_level: 9
}).then((data) => {//...
});

var user = models.User.findOne({//...
}).then((data) => {//...
});
这是一个异步过程，sequelize 内部使用了 bluebird 对异步流程控制。变量user得到的是 Promise 对象，并非查询结果。

models.User.destroy({where: {id: 1}
}).then(function(rowDeleted) {if(rowDeleted === 0){console.log('成功删除记录');}
}, function(err){console.log(err); 
});//软删除操作：
// models.User.destroy({where: {id: userId}}, {force: false});
// 恢复软删除，使用 restore 方法 http://sequelize.readthedocs.org/en/latest/api/instance 

//1:1
// user model
var user = sequelize.define('User', {/*attribute*/});
User.hasOne(userInfo);// userInfo model
var userInfo = sequelize.define('userInfo', {/*attribute*/});
userInfo.belongsTo(User);// 查
var userInfo = yield user.getUserInfo();

var sequelize = req.server.plugins['hapi-sequelize'].db.sequelize;sequelize.query('SELECT * ...');