Notes

/**
* A simple example of how to use Waterline v0.10 with Express
*/

var express = require('express'),
_ = require('lodash'),
app = express(),
Waterline = require('waterline'),
bodyParser = require('body-parser'),
methodOverride = require('method-override');



// Instantiate a new instance of the ORM
var orm = new Waterline();


//////////////////////////////////////////////////////////////////
// WATERLINE CONFIG
//////////////////////////////////////////////////////////////////

// Require any waterline compatible adapters here
var mssqlAdapter = require('sails-sqlserver');


// Build A Config Object
var config = {

// Setup Adapters
// Creates named adapters that have have been required
adapters: {
mssql : mssqlAdapter
},

// Build Connections Config
// Setup connections using the named adapter configs
connections: {

myMsSql : {
adapter: 'mssql',
user: 'liftee',
password: "dL,`Ye'SFhx5-8U.",
host: 'nf06u28iwe.database.windows.net', // azure database
database: 'liftee-development',
options: {
encrypt: true // use this for Azure databases
}
}
},

defaults: {
migrate: 'alter'
}

};


//////////////////////////////////////////////////////////////////
// WATERLINE MODELS
//////////////////////////////////////////////////////////////////

var User = Waterline.Collection.extend({

identity: 'test_users',
connection: 'myMsSql',

attributes: {
firstname: 'string',
lastname: 'string'
}
});

// Load the Models into the ORM
orm.loadCollection(User);



//////////////////////////////////////////////////////////////////
// EXPRESS SETUP
//////////////////////////////////////////////////////////////////


// Setup Express Application
app.use(bodyParser.urlencoded({ extended: false }));
app.use(bodyParser.json());
app.use(methodOverride());

// Build Express Routes (CRUD routes for /users)

app.get('/users', function(req, res) {
app.models.user.find().exec(function(err, models) {
if(err) return res.json({ err: err }, 500);
res.json(models);
});
});

app.post('/users', function(req, res) {
app.models.user.create(req.body, function(err, model) {
if(err) return res.json({ err: err }, 500);
res.json(model);
});
});

app.get('/users/:id', function(req, res) {
app.models.user.findOne({ id: req.params.id }, function(err, model) {
if(err) return res.json({ err: err }, 500);
res.json(model);
});
});

app.delete('/users/:id', function(req, res) {
app.models.user.destroy({ id: req.params.id }, function(err) {
if(err) return res.json({ err: err }, 500);
res.json({ status: 'ok' });
});
});

app.put('/users/:id', function(req, res) {
// Don't pass ID to update
delete req.body.id;

app.models.user.update({ id: req.params.id }, req.body, function(err, model) {
if(err) return res.json({ err: err }, 500);
res.json(model);
});
});



//////////////////////////////////////////////////////////////////
// START WATERLINE
//////////////////////////////////////////////////////////////////

// Start Waterline passing adapters in
orm.initialize(config, function(err, models) {
if(err) throw err;

app.models = models.collections;
app.connections = models.connections;

// Start Server
app.listen(3000);

console.log("To see saved users, visit http://localhost:3000/users");
});