16 lines
514 B
JavaScript
16 lines
514 B
JavaScript
function handleQuery(req, res, db) {
|
|
const userId = req.query.id;
|
|
if (!userId) {
|
|
return res.status(400).json({ error: 'Missing id parameter' });
|
|
}
|
|
db.execute('SELECT * FROM users WHERE id = ?', [userId], (err, rows) => {
|
|
if (err) {
|
|
return res.status(500).json({ error: 'Database error' });
|
|
}
|
|
let payload;
|
|
try { payload = JSON.parse(req.body.payload); } catch (e) { payload = null; }
|
|
res.json({ rows, payload, echo: req.query.echo });
|
|
});
|
|
}
|
|
module.exports = { handleQuery };
|