sample custom node repl

work_repl.js

var repl = require('repl');
var path = require('path');

var r = repl.start();

require('repl.history')(r, path.join(process.env.HOME, '.node_history');

var caterDir = '../cater-api-server' || process.argv[2];

r.context.models = require(path.join(caterDir, 'models');
r.context.db     = require(path.join(caterDir, 'db');
r.context.utils  = require(path.join(caterDir, 'utils');
r.context.config = require(path.join(caterDir, 'config');

/**
* raw sql query helper
* @param {String} query
*/
r.context.sql = function (query) {
  r.context.db.query(query, function (error, results) {
    if (error) return console.log(error);
    
    // set results to the context variable 'results'
    return r.context.results = results;
  });
}