routes/health.js
const express = require('express');
const db = require('../lib/db');
const router = express.Router();
router.get('/healthz', async (_req, res) => {
try {
const r = await db.query('SELECT 1 AS ok');
res.json({ ok: r.rows[0].ok === 1, db: 'up', pid: process.pid });
} catch (err) {
res.status(500).json({ ok: false, db: 'down', error: err.message });
}
});
module.exports = router;