Is it possible to have nested queries in Postgres pg module

Question

Here is my code that tries to update a record in the db. But if the record is not there then I want to insert it. Is it OK to call client.query again? Or what's the best way to do it?

const {Pool} = require('pg');
const pool   = new Pool(POSTGRES_CONFIG);

pool.connect((err, client, release) => {
    if (err) {
        return console.error('Error acquiring client', err.stack)
    }

    ………

    client.query(query, queryValues, (err, result) => {
        release();

        if(result.rowCount<=0){
            //**** CAN I CALL IT AGAIN WITH OTHER PARAMETERS TO INSERT? ****
            client.query(....... => {
                release();

                if (err) {
                    if(err.code === POSTGRES_ERRORS.UNIQUE_VIOLATION){
                        return console.error('KEY ALREADY EXISTS');
                    } else {
                        return console.error('query error', err);
                    }
                }
            }
        }
    });
});

Daniel Conde Marin · Accepted Answer · 2018-01-24 21:55:29Z

3

It is perfectly OK as long as you call release after you're done with the client. From the docs:

You must call the releaseCallback or client.release (which points to the releaseCallback) when you are finished with a client.

So, you could do this:

client.query(query, queryValues, (err, result) => {
        // don't release just yet 

        if(result.rowCount<=0){
            //**** CAN I CALL IT AGAIN WITH OTHER PARAMETERS TO INSERT? ****
            client.query(....... => {
                release(); // now you're done with the client so you can release it

                if (err) {
                    if(err.code === POSTGRES_ERRORS.UNIQUE_VIOLATION){
                        return console.error('KEY ALREADY EXISTS');
                    } else {
                        return console.error('query error', err);
                    }
                }
            }
        }
    });

answered Jan 24, 2018 at 21:55

Daniel Conde Marin

7,7324 gold badges38 silver badges44 bronze badges

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

1 Comment

John Glabb Over a year ago

Works perfect.. Thank you Daniel

Collectives™ on Stack Overflow

Is it possible to have nested queries in Postgres pg module

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related