pg-action.js

bad.js

exports.randomRow = {
  name: 'randomFirstName',
  description: 'I will return a random first name from the users table',
  outputExample: {},

  run: function(api, data, next){
    pg.connect(api.config.pg.url, function(error, client, done){
      if(error){ return next(error); }
      var query = 'select * from usersorer by random() limit 1';
      client.query(query, function(error, results){
        if(error){ return next(error); }
        data.connection.response.randomFirstName = results.rows[0].firstName;
        done();
        next();
      });
    });
  }

};

good.js

exports.randomRow = {
  name: 'randomFirstName',
  description: 'I will return a random first name from the users table',
  outputExample: {},

  run: function(api, data, next){
    pg.connect(api.config.pg.url, function(error, client, done){
      if(error){ 
        done();
        return next(error); 
      }
      var query = 'select * from usersorer by random() limit 1';
      client.query(query, function(error, results){
        if(error){ 
          done();
          return next(error); 
        }
        data.connection.response.randomFirstName = results.rows[0].firstName;
        done();
        next();
      });
    });
  }

};