node/express last active middleware

middleware-last-active.js

module.exports = function() {

  return function(req, res, next) {

    if (!req.user) return next();

    var sql = req.app.services.sql;

    sql
      .query('update users set last_active = $1 where id = $2;', [new Date(), req.user.id])
      .on('error', function(err) {
        console.error(err);
      });

    next();

  };

};