test

index.js

var Hapi = require('hapi');
var Sequelize = require('sequelize');


var sequelize = new Sequelize('AdventureWorks', 'test1', 'test', {
  dialect: 'mssql',
  host: 'localhost'
});

var Person = sequelize.define('Person', {
    id: { type: Sequelize.INTEGER, field: 'BusinessEntityID' },
    firstName: { type: Sequelize.STRING, field: 'FirstName' },
    middleName: { type: Sequelize.STRING, field: 'MiddleName' },  
    lastName: { type: Sequelize.STRING, field: 'LastName' }
  }, {
    timestamps: false,
    tableName: 'Person'
  }
);

// Create a server with a host and port
var server = new Hapi.Server();

server.connection({
  host: 'localhost',
  port: 8000
});

// Add the route
server.route({
  method: 'GET',
  path: '/hello',
  handler: function (request, reply) {

    Person.findAll({ where: { firstName: { $like: 'z%' } } }).then(function (people) {
      reply(people);
    });
  }
});

// Start the server
server.start();