w4ab/TP_note/server/controllers/participant.js

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

module.exports = {
	
	get_all: (req, res, next) => {
		let where = {};
		if (req.query.nom) {
			where.nom = {
				[Sequelize.Op.like]: '%'+req.query.nom+'%'
			};
		}
		return db.Participant.findAll({
			order: [ 'nom' ],
			where
		})
		.then((participants) => res.json(participants))
		.catch((err) => next(err));
	},
	
	load_by_id: (req, res, next) => {
		return db.Participant.findByPk(req.params.participant_id)
		.then((participant) => {
			if (!participant) {
				throw { status: 404, message: 'Requested Participant not found' };
			}
			req.participant = participant;
			return next();
		})
		.catch((err) => next(err));
	},
	
	get_by_id: (req, res, next) => {
		return db.Participant.findByPk(req.params.participant_id)
		.then((participant) => {
			if (!participant) {
				throw { status: 404, message: 'Requested Participant not found' };
			}
			return res.json(participant);
		})
		.catch((err) => next(err));
	},
	
	create: (req, res, next) => {
		const data = {
			nom: req.body.nom || '',
			prenom: req.body.prenom || ''
		};
		return db.Participant.create(data)
		.then((participant) => res.json(participant))
		.catch((err) => next(err));
	},
	
	delete_by_id: (req, res, next) => {
		return db.Participant.findByPk(req.params.participant_id)
		.then((participant) => {
			if (!participant) {
				throw { status: 404, message: 'Requested Participant not found' };
			}
			return participant.destroy();
		})
		.then(() => res.status(200).end())
		.catch((err) => next(err));
	}

};