selectAll: function(table) {

  var ret = new comb.Promise();

  var sql = 'SELECT * FROM ' + table + ';';

  this.connection.query(sql, ret.resolve.bind(ret));
  return ret.promise();

}

createPrl: function (req, res) {

    var promises = [];
    var Data     = {};
    var tables   = ['patterns', 'domains', 'cpas', 'networks', 'geos'];

    new comb.Promise().callback().
    chain(function () {


        tables.forEach(function (table) {

            promises[table] = Mysql.selectAll(table);
        });


        return promises;
    }).
    chain(function (promises) {

        var sa   = [];
        var keys = _.keys(promises);

        tables.forEach(function (table) {

            sa.push(promises[table]);
        });

        new comb.when(sa).then(function (results) {
            console.log('results');

            keys.forEach(function (key, index) {
                Data[key] = results[index][0];
            });

            res.view('./home/createPrl/index.ejs', {

            layout: './home/createPrl/layout.ejs',
            data: Data
        });
        });

    });


}

tables.forEach(function (table) {

Mysql.selectAll(table).then(function (result) {

   Data[table] = result; }); }