Use connect-logger to log to a database

connect-db-logger.js

// use like this
// var logger = require('connect-db-logger')
// app.use(logger.db("AppName"))
// RequestLog is super simple, but I don't provide it here

var express = require('express') 
var logger = express.logger
var RequestLog = require('reports/model/RequestLog')
express.logger.token('route', function(req, res){
	return req.route.path;
})

exports.db = function(appName, out) {

	appName = appName || "api"
	if (typeof out === "undefined") out = process.stdout
	var format = ":method|appName|:url|:route:|:response-time"
	var fmt = compile(logger.default) // default logger format
	
	return function(req, res, next) {
		logger({
			buffer: true
			, format: format
			, stream: { write: dbLogger(out)}
		})(req, res, next)
		var line = fmt(logger, req, res)
		if (null == line) return;
		out.write(line + '\n', 'ascii');
	}

	function dbLogger(out) {
		return function(string, encoding) {
			var reqs = string.split("\n")
			var len = reqs.length - 1
			var arr = []
			for (var i = 0; i < len; i++) {
				arr = reqs[i].replace("appName", appName).split("|")
				RequestLog.saveLog.apply(RequestLog, arr)
			}
		}
	}
}

function compile(fmt) {
  fmt = fmt.replace(/"/g, '\\"');
  var js = '  return "' + fmt.replace(/:([-\w]{2,})(?:\[([^\]]+)\])?/g, function(_, name, arg){
    return '"\n    + (tokens["' + name + '"](req, res, "' + arg + '") || "-") + "';
  }) + '";'
  return new Function('tokens, req, res', js);
};