api.get('/all', async (req: Request, res: Response) => {
		try {
			res.send(await findAll<Product>(DB_PRODUCTS));
		} catch (err) {
			res.status(409).json(err);
		}
	});

	return new Promise<CoinbaseLookup>(async (resolve, reject) => {
		try {
			const allCompleted = await findAll<CoinbaseCharge>(DB_COMPLETED_COINBASE_TRANSACTIONS);
			const allProblems = await findAll<CoinbaseCharge>(DB_PROBLEM_COINBASE_CHARGES);
			const allPending = await findAll<CoinbaseCharge>(DB_PENDING_COINBASE_CHARGES);
			const address = new Address(xemOrTokenAddress).plain();
			const filterCompleted = filterChargesByAddress(allCompleted, address);
			const filterProblems = filterChargesByAddress(allProblems, address);
			const filterPending = filterChargesByAddress(allPending, address);
			const results: CoinbaseLookup = {
				completed: filterCompleted,
				problems: filterProblems,
				pending: filterPending
			};
			resolve(results);
		} catch (err) {
			reject(err);
		}
	});

	api.get('/tokens-sold', async (req: Request, res: Response) => {
		try {
			const usdTotals: Array<UsdTotal> = await findAll<UsdTotal>(DB_USD_TOTALS);
			if (req.query.currency === 'usd' && usdTotals.length > 0) {
				return res.send({amount: precisionRound(usdTotals[0].currentRaised, 2), milestone: usdTotals[0].nextMilestone });
			}
			res.status(409).json({ message: 'object or parameter not found.'});
		} catch (err) {
			res.status(409).json(err);
		}
	});

export const checkPendingTransactions = async () => {
	try {
		const charges = await findAll<CoinbaseCharge>(DB_PENDING_COINBASE_CHARGES);
		if (charges) {
			if (charges.length > 0) {
				for (const charge of charges) {
					fetchCharge(charge);
				}
			}
		}
	} catch (err) {}
	await sleep(10000);
	checkPendingTransactions();
};