your_creatures_breed.ts

import pool from '../utilities/database';

import { log } from '../utilities/logging';

import { determineSelectedCreature, getYourCreatures } from '../reusable';

import speciesIndex from '../gameplay/species.json';

export const apiYourCreaturesBreed = (req, res) => {
	//handle all outcomes
	const handleRejection = (obj) => {
		res.status(400).write(log(obj.msg, obj.extra ? obj.extra.toString() : ''));
		res.end();
	}

	const handleSuccess = (obj) => {
//		log(obj.msg, obj.extra.toString());
		res.status(200).json(obj.msg);
		res.end();
	}

	return new Promise((resolve, reject) => resolve(req.body))
		.then(checkBreedingTotal)
		.then(determineSelectedCreature)
		.then(checkNotBattling)
		.then(checkNotTraining)
		.then(markAsBreeding)
		.then(getYourCreatures)
		.then(fields => { return { msg: fields, extra: ''}; })
		.then(handleSuccess)
		.catch(handleRejection)
	;
};

export const checkBreedingTotal = (fields) => new Promise((resolve, reject) => {
	const query = 'SELECT COUNT(*) AS total FROM creatures WHERE profileId IN (SELECT id FROM profiles WHERE accountId = ?) AND breeding = TRUE;';
	return pool.promise().query(query, [fields.id])
		.then(results => results[0][0].total)
		.then(total => total < 2 ? resolve(fields) : reject({ msg: 'You can breed two creatures at a time', extra: total }))
		.catch(e => reject({ msg: 'checkBreedingTotal error', extra: e }))
	;
});

//more