w4ab/NodeJS/correction_tp5/controllers/person.js

const
db = require('../models'),
Sequelize = require('sequelize');

module.exports = {
	
	get_all: (req, res, next) => {
		let where = {};
		if (req.query.name) {
			where.lastname = {
				[Sequelize.Op.like]: '%'+req.query.name+'%'
			};
		}
		return db.Person.findAll({
			order: [ 'lastname' ],
			where
		})
		.then((people) => res.json(people))
		.catch((err) => next(err));
	},
	
	load_by_id: (req, res, next) => {
		return db.Person.findByPk(req.params.person_id)
		.then((person) => {
			if (!person) {
				throw { status: 404, message: 'Requested Person not found' };
			}
			req.person = person;
			return next();
		})
		.catch((err) => next(err));
	},
	
	get_by_id: (req, res, next) => {
		return db.Person.findByPk(req.params.person_id)
		.then((person) => {
			if (!person) {
				throw { status: 404, message: 'Requested Person not found' };
			}
			return res.json(person);
		})
		.catch((err) => next(err));
	},
	
	create: (req, res, next) => {
		const data = {
			firstname: req.body.firstname || '',
			lastname: req.body.lastname || ''
		};
		return db.Person.create(data)
		.then((person) => res.json(person))
		.catch((err) => next(err));
	},
	
	update_by_id: (req, res, next) => {
		return db.Person.findByPk(req.params.person_id)
		.then((person) => {
			if (!person) {
				throw { status: 404, message: 'Requested Person not found' };
			}
			Object.assign(person, req.body);
			return person.save();
		})
		.then((person) => res.json(person))
		.catch((err) => next(err));
	},
	
	delete_by_id: (req, res, next) => {
		return db.Person.findByPk(req.params.person_id)
		.then((person) => {
			if (!person) {
				throw { status: 404, message: 'Requested Person not found' };
			}
			return person.destroy();
		})
		.then(() => res.status(200).end())
		.catch((err) => next(err));
	}

};