Express and node-mysql connection pool test with nodeunit

app.js

var mysql   	= require('mysql');
var express 	= require('express');
var app 		= express();
var controllers	= module.exports.controllers = {};
var models		= module.exports.models = {};

if (!process.env.dbpass){
	app.use(express.logger('dev'));
}

app.set('port', process.env.PORT || 3000);

var dbConfig = module.exports.dbConfig = {
	host     			: 'localhost',
	user     			: process.env.dbuser || 'root',
	password 			: process.env.dbpass || 'password',
	database 			: process.env.dbname || 'mysql',
	insecureAuth		: process.env.dbpass? false : true,
	connectionLimit		: 20,
	supportBigNumbers	: true
};

var pool = module.exports.pool = mysql.createPool( dbConfig );

app.get('/', function(req, res){
	models.default( function( rows ){
		res.send( rows );
	} );
});

process.on('exit', function () {
	console.log('Express server exiting.');
});

module.exports.server = app.listen( app.get('port') );
console.log('Express server listening on port ' + app.get('port'));

models.default = function(next){
	pool.getConnection(function(err, dbh) {
		if (err) throw err;
		dbh.query('SELECT * FROM user LIMIT 1', function(err, rows, fields) {
			if (err) throw err;
			dbh.release();
			if (next) next( rows );
		});
	});

}

package.json

{
  "name": "express-mysql-nodeunit-experiment",
  "preferGlobal": false,
  "version": "0.0.1",
  "author": "Lee Goddard <[email protected]>",
  "description": "A quick test of mysql connection pooling in Express with nodeunit",
  "scripts": {
    "start": "node lib/app.js",
    "test": "nodeunit tests.js"
  },
  "main": "./lib/app.js",
  "dependencies" : {
    "express"   : "3.4.4",
    "mysql" :  "2.0.0-alpha9"
  },
  "analyze": false,
  "devDependencies": {
	"nodeunit" :  "0.8.2"
  }
}

tests.js

var nodeunit = require('nodeunit');
var app;

exports['The DB'] = nodeunit.testCase({

	setUp: function(cb){
		app = require('./app');
		cb();
	},

	tearDown: function(cb){
		app.server.close();
		app.pool.end( function(){
			console.log('MySQL cx pool terminating');
			cb();
		});
	},

	'scripted user': function (test){
		test.expect(1);
		app.models.default( function( rows ){
			test.ok(
				rows[0].User == app.dbConfig.user,
				"is in mysql.user"
			);
			test.done();
		});

	}
});