app.get('/', async (req, res) => { const result = await client.query('SELECT $1::text as message', ['Hello world!']) res.send(result.rows[0].message) })
const getUsers = (request, response) => { pool.query('SELECT * FROM users ORDER BY id ASC', (error, results) => { if (error) { throw error } response.status(200).json(results.rows) }) }
const getUserById = (request, response) => { const id = parseInt(request.params.id) pool.query('SELECT * FROM users WHERE id = $1', [id], (error, results) => { if (error) { throw error } response.status(200).json(results.rows) }) }
pgPool.connect((err, client, done) => { if (err) {console.error(err);} client.query('SELECT EXISTS (SELECT 1 FROM information_schema.tables WHERE table_catalog = \''+options.database+'\' AND table_name = \'sessions\');', (err, res) => { if (err) {console.error(err.stack)} else if(!res.rows[0].exists) { // Postgres sessions table do not exist, creating it... client.query(fs.readFileSync(__dirname + "/sql/sessions-for-postgres.sql", "utf8"), (err, res) => { if (err) {console.error(err)} else {console.log("Postgres sessions table created !");} }); } }) })
//Edit posts router.put('/api/put/post', (req, res, next) => { const values = [req.body.title, req.body.body, req.body.uid, req.body.pid, req.body.username] pool.query('UPDATE posts SET title = $1, body = $2, user_id = $3, author= $5, date_created = NOW() WHERE pid = $4', values, (q_err, q_res) => { if (q_err) return next(q_err); console.log(q_res) res.json(q_res.rows); }); });
router.delete('/api/delete/post', (req, res, next) => { post_id = req.body.post_id pool.query('DELETE FROM posts WHERE pid = $1', [ post_id ], (q_err, q_res) => { if (q_err) return next(q_err); console.log(q_res) res.json(q_res.rows); }); });
router.get('/:id', (request, response, next) => { const { id } = request.params; pool.query('SELECT * FROM monsters WHERE id = $1', [id], (err, res) => { if (err) return next(err); response.json(res.rows); }); });
function getUser(id) { return pool_1.default .query( 'SELECT id, "displayName", email, "photoURL", source FROM users WHERE "id" = $1', [id] ) .then((res) => array_to_maybe_1.default(res.rows)); }
router.get('/', (request, response, next) => { pool.query('SELECT * FROM monsters ORDER BY id ASC', (err, res) => { if (err) return next(err); response.json(res.rows); }); });
const getUserById = async (req, res) => { const id = parseInt(req.params.id); const response = await pool.query(GETID , [id]); res.json(response.rows); }
//Delete comment router.delete('/api/delete/comment', (req, res, next) => { cid = req.body.cid pool.query('DELETE FROM comments where cid = $1', [ cid ], (q_err, q_res) => { if (q_err) return next(q_err); console.log(q_res) res.json(q_res.rows); }); });
app.get('/', async (req, res) => { const result = await client.query('SELECT $1::text as message', ['Hello world!']) res.send(result.rows[0].message) })
db.query('SELECT * FROM users WHERE ID = $1', [id], (error, value) => { if (error) { throw error; } res.status(201).json( value.rows ); });