Personally, I prefer to keep each database query in its own function, i.e. const getUser or updateItem or checkUserExists:
const getUse = (username, cb) => {
dbConnection.query(
'SELECT * FROM users WHERE username = $1',
[username],
(err, res) => {
if (err) {
cb(err);
console.log(err);
} else {
cb(null, res.rows);
}
}
);
};
It makes it easier to read and can also assist with better error handling
Personally, I prefer to keep each database query in its own function, i.e. const getUser or updateItem or checkUserExists:
It makes it easier to read and can also assist with better error handling