Node postgres constraints

Question

I'm trying to write a constraint code that will display a message when someone tries to search for an id that doesn't exist in the database (PostgreSQL) but the if statement code below doesn't seem to do anything I keep getting status 200 ok on postman even though the id doesn't seem to exist. How can I fix this?

Code below:

Database query:

const findFruit = async (req, res) => {

    const {id } = req.params;
    try {
        const findfru = await pool.query("SELECT * FROM fruits WHERE fruit_id=$1", [id]);

        if (!findfru ) {
            return res.status(400).send(e)
        }

        res.json(findfru .rows[0])

    } catch (e) {
        res.status(500).send(e)

    }
}

Route API:

router.get("Fruits/:id", findFruit )

What is e in res.status(400).send(e)?

Bergi
– Bergi

2021-06-27 19:01:43 +00:00
Commented Jun 27, 2021 at 19:01 — Bergi
– Bergi, Commented Jun 27, 2021 at 19:01
This has nothing to do with database constraints.

Bergi
– Bergi

2021-06-27 19:02:16 +00:00
Commented Jun 27, 2021 at 19:02 — Bergi
– Bergi, Commented Jun 27, 2021 at 19:02

Mureinik · Accepted Answer · 2021-06-27 18:54:05Z

3

If the ID isn't in the database the query still succeeds, it just returns no rows. You should check the number of rows explcitily:

if (findfru.rows.length === 0) {
    return res.status(400).send(`${id} not found`);
}

answered Jun 27, 2021 at 18:54

Mureinik

316k54 gold badges402 silver badges406 bronze badges

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

1 Comment

Michael Evans Over a year ago

I see, it works perfectly fine now thanks!

Collectives™ on Stack Overflow

Node postgres constraints

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