how to call PostgreSQL function with parameter using node JS?

Question

I am new to PostgreSQL and node JS. I am creating web service using node js . I have created function in PostgreSQL and its execute successfully. Now what I want that I am calling this function through node JS but I am not getting how to send value in parameter. I want to insert two value "task_name" and "task_type" in table through node JS. How can I achieve this ?

PostgreSQL function --

CREATE FUNCTION inserttask(task_name text, task_type text)
  RETURNS void AS
  $BODY$
      BEGIN
        INSERT INTO tasklist(taskname, tasktype)
        VALUES(task_name, task_type);
      END;
  $BODY$
  LANGUAGE 'plpgsql' VOLATILE
  COST 100;

Node js code --

app.param(['task_name', 'task_type'], function (req, res, next, value) {
  console.log('CALLED ONLY ONCE with', value);
  next();
});

app.get('/inserttask/:task_name/:task_type', function (req, res, next) {
    console.log('vivek');
// var task_name=req.query.task_name;
// var task_type=req.query.task_type;
var task_name='vivek';
var tast_type='singh';
db.any('select inserttask(task_name,task_type)')
//db.any('select getFriends()')
    .then(function (data) {
      res.status(200)
        .json({
          status: 'success',
          message: 'Insert Task',
          data: data
        });
    })
    .catch(function (err) {
      return next(err);
    });

})

vitaly-t · Accepted Answer · 2017-05-02 14:29:02Z

9

According to documents values go as array | value after qry, try:

db.any('select inserttask($1, $2)', ['task_name','task_type'])

Edit by pg-promise author. The best way to do it is via method func:

db.func('inserttask', ['task_name','task_type'])

edited May 2, 2017 at 14:29

vitaly-t

26.1k17 gold badges129 silver badges151 bronze badges

answered May 2, 2017 at 7:22

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to call PostgreSQL function with parameter using node JS?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related