server.js

var express = require('express');
var bodyParser = require('body-parser');
var _ = require('underscore');
var db = require ('./db.js');


var app = express();
var PORT = process.env.PORT || 3000;
var todos =[];
var todoNextId=1;

app.use(bodyParser.json());

app.get('/',function(req,res){
	res.send('Todo API Root')
});

app.get('/todos',function(req,res){
	var query = req.query;

	var where = {};

	if(query.hasOwnProperty('completed') && query.completed === 'true'){
		where.completed = true;
	}else if (query.hasOwnProperty('completed') && query.completed === 'false'){
		where.completed =false;
	}
	
	if(query.hasOwnProperty('q') && query.q.length > 0){
		where.description = {
			$like: '%' + query.q + '%'	
		};
	}
	
	db.todo.findAll({where:where}).then(function (todos) {
		res.json(todos);
	},function (e) {
		res.status(500).send();
	});




	// var filterTodos = todos;
    //
	// if (queryParams.hasOwnProperty('completed') && queryParams.completed === 'true'){
	// 	filterTodos = _.where(filterTodos,{completed:true});
	// } else if(queryParams.hasOwnProperty('completed') && queryParams.completed === 'false'){
	// 	filterTodos = _.where(filterTodos,{completed:false});
	// }
    //
	// if (queryParams.hasOwnProperty('q') && queryParams.q.length > 0 ){
	// 	filterTodos = _.filter(filterTodos, function (todo) {
	// 		return todo.description.toLowerCase().indexOf(queryParams.q.toLowerCase()) > -1;
	// 	})
	// }
    //
    //
	// res.json(filterTodos);
});

app.get('/todos/:id',function(req,res){
	var todoId= parseInt(req.params.id, 10);
	
	db.todo.findById(todoId).then(function (todo) {
		if (!!todo){
			res.json(todo.toJSON());
		} else{
			res.status(404).send()
		}
	}, function (e) {
		res.status(500).send();
	});
	
	// var matchedTodo = _.findWhere(todos,{id:todoId});
    //
	// if(matchedTodo){
	// 	res.json(matchedTodo);
	// } else{
	// 	res.status(404).send();
	// }
});


// POST /todos:

app.post('/todos', function(req,res){
	var body = _.pick(req.body,'description','completed');
	
	db.todo.create(body).then(function (todo) {
		res.json(todo.toJSON());
	}, function (e) {
		res.status(400).json(e);
	});

	// if(!_.isBoolean(body.completed) || !_.isString(body.description) || body.description.trim().length === 0){
	// 	return res.status(400).send();
	// }
	// body.id = todoNextId++;
	// body.description = body.description.trim();
    //
	// todos.push(body);
    //
	// res.json(body);
});


// Delete /Todos:

app.delete('/todos/:id',function (req,res) {
	var todoId= parseInt(req.params.id, 10);
	var matchedTodo = _.findWhere(todos,{id:todoId});

	if(!matchedTodo){
		res.status(400).json({"error":"ID not found"})
	}

	todos = _.without(todos,matchedTodo);

	res.json(matchedTodo);
});


// Edit /Todos:

app.put('/todos/:id',function (req,res){
	var todoId= parseInt(req.params.id, 10);
	var matchedTodo = _.findWhere(todos,{id:todoId});
	var body = _.pick(req.body,'description','completed');
	var validAttributes = {};

	if(!matchedTodo){
		res.status(400).json({"error":"ID not found"})
	}

    
	if(body.hasOwnProperty('completed') && _.isBoolean(body.completed)){
		 validAttributes.completed = body.completed;
	 } else if(body.hasOwnProperty('completed')){
		 return res.status(400).send();
	 }
    
	if(body.hasOwnProperty('description') && _.isString(body.description) && body.description.trim().length > 0){
		validAttributes.description = body.description;
	} else if(body.hasOwnProperty('description')){
		return res.status(400).send();
	}
    
	_.extend(matchedTodo,validAttributes);
	res.json(matchedTodo);

});


db.sequelize.sync().then(function () {
	app.listen(PORT, function(){
		console.log('Server Started on Port: ' + PORT)
	});
});