router.get('/company/:name', function(req: any, res: any): void {
	console.log(sprintf('Getting information on company %s', req.params.name));
	let company: Pipeline.Company;
	let availablePetrol: Pipeline.Petrol[] = [];

	db.query('\
		SELECT c.id, c.name AS companyName, p.name AS petrolName, t.name AS type, r.price, r.last_updated AS lastUpdated\
		FROM companies AS c, petrol AS p, petroltypes AS t,\
			(SELECT petrol_id, price, last_updated\
			FROM petrolprices\
			WHERE id IN\
				(SELECT MAX(id)\
				FROM petrolprices\
				GROUP BY petrol_id)\
			ORDER BY petrol_id ASC) AS r\
		WHERE c.name = LOWER(?)\
			AND c.id = p.company_id\
			AND p.type = t.id\
			AND p.id = r.petrol_id\
		', [req.params.name], function(err: any, rows: any, fields: any) {
			if (err) {
				db.handleMySQLError(res, err);
			} else if (rows.length > 0) {
				rows.forEach((row: any) => {
					let petrol = new Pipeline.Petrol(row.petrolName, row.type, row.price, row.lastUpdated);
					availablePetrol.push(petrol);
				});
				company = new Pipeline.Company(rows[0].id, rows[0].companyName, availablePetrol);

				res.status(200).send(company);
			} else {
				res.status(404);
			}
		});
});

databaseConnection.handleMySQLError = function(res: any, err: any) {
	var error = sprintf('Error %d: %s', err.errno, err.code)
	console.error(error);
	var status = 500;
	switch (err.code) {
		case 'ER_NO_REFERENCED_ROW_2':
			status = 404;
			break;
	}
	res.status(status).send(error);
}

app.all('*', function (req: any, res: any, next: any) {
	console.log(sprintf('%s called on endpoint %s with query: %s', req.method, req.path, JSON.stringify(req.query)));
	passport.authenticate('localapikey', function(err: any, user: any, info: any) {
		if (err) {
			return next(err);
		} else if (!user) {
		} else {
			req.user = user;
		}
		return next();
	})(req, res, next);
});

// Load configuration file
var config = require('./config.json');

// Load modules
var sprintf = require('sprintf').sprintf;
var mysql = require('mysql');

// Initialise database connection
var databaseConnection = mysql.createConnection({
	host: config.mysql.host,
	port: config.mysql.port,
	user: config.mysql.user,
	password: config.mysql.password,
	database: config.mysql.schema
});
console.log(sprintf("Connecting to database at %s:%d...", config.mysql.host, config.mysql.port));
databaseConnection.connect(function(err: any) {
	if (err) {
		console.error('Error connecting: %s', err.stack);
		return;
	}

	console.log('Connected as id: %d', databaseConnection.threadId);
});

databaseConnection.handleMySQLError = function(res: any, err: any) {
	var error = sprintf('Error %d: %s', err.errno, err.code)
	console.error(error);
	var status = 500;
	switch (err.code) {
		case 'ER_NO_REFERENCED_ROW_2':