Nodejs / Express / Postgres query blocks

Question

I have tried a simple query to my Postgresql database, with Express and pg, but my query blocks the server before the console.log

It starts with : node app.js

Here is extract of the code of app.js

var router = express.Router()
const { Client } = require('pg')

const client = new Client({
    user: 'dev', 
    host: 'localhost',
    database: 'fransua',
    password: 'azerty123456789',
    port: 5432
})

client.connect()

router.get('/database', async (req, res) => {
    client.query("SELECT * FROM employees WHERE first_name= $1", ['Roam']), (err,res) => {
        console.log(err ? err.stack : res.rows)
        res.render("database", {title: "Database", posts: posts})
    }
})

ardritkrasniqi · Accepted Answer · 2022-07-21 14:26:04Z

1

Try it like this:

Create a query statement:

const query = {
   // give the query a unique name
   name: 'fetch-employee',
   text: 'SELECT * FROM employees WHERE first_name= $1',
   values: ['Roam'],
  }

Than run the operation with a promise:

// promise
 client
  .query(query)
  .then(res => console.log(res.rows[0]))
  .catch(e => console.error(e.stack))

answered Jul 21, 2022 at 14:26

ardritkrasniqi

8596 silver badges14 bronze badges

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

Comments

Heiko Theißen · Accepted Answer · 2022-07-21 14:38:00Z

1

You made a typo. Delete the closing parenthesis after ['Roam'] and insert one after the closing brace:

client.query("SELECT * FROM employees WHERE first_name= $1", ['Roam'], (err,res) => {
  console.log(err ? err.stack : res.rows)
  res.render("database", {title: "Database", posts: posts})
})

answered Jul 21, 2022 at 14:38

Heiko Theißen

18.3k2 gold badges14 silver badges50 bronze badges

Collectives™ on Stack Overflow

Nodejs / Express / Postgres query blocks

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related