async testConnection() { try { return await this.pool.query('SELECT $1::int AS number', ['1']); } catch (e) { if (e.toString().indexOf('no pg_hba.conf entry for host') !== -1) { throw new Error(`Please use CUBEJS_DB_SSL=true to connect: ${e.toString()}`); } throw e; } }
function getUserByExternalDetails(source, sourceId) { return pool_1.default .query( 'SELECT id, "displayName", email, "photoURL", source, "sourceId" FROM users WHERE "sourceId" = $1 AND source = $2', [sourceId, source] ) .then((res) => array_to_maybe_1.default(res.rows)); }
router.post('/', (request, response, next) => { const { name, personality } = request.body; pool.query( 'INSERT INTO monsters(name, personality) VALUES($1, $2)', [name, personality], (err, res) => { if (err) return next(err); response.redirect('/monsters'); } ); });
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) }) }
//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); }); });
const getEmployees = (request, response) => { pool.query('SELECT * FROM Employee ORDER BY emp_id ASC', (error, results) => { if (error) { throw error } response.status(200).json(results.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); }); });
/* USER PROFILE ROUTES SECTION */ //Save user profile data to the db router.post('/api/post/userprofiletodb', (req, res, next) => { const values = [req.body.profile.nickname, req.body.profile.email, req.body.profile.email_verified] pool.query('INSERT INTO users(username, email, date_created, email_verified) VALUES($1, $2, NOW(), $3) ON CONFLICT DO NOTHING', values, (q_err, q_res) => { if (q_err) return next(q_err); console.log(q_res) res.json(q_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); }); });
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); }); });
//save posts to db router.post('/api/post/poststodb', (req, res, next) => { const values = [req.body.title, req.body.body, req.body.uid, req.body.username] pool.query('INSERT INTO posts(title, body, user_id, author, date_created) VALUES($1, $2, $3, $4, NOW())', values, (q_err, q_res) => { if (q_err) return next(q_err); console.log(q_res) res.json(q_res.rows); }); });
async function getOperationsByPermissionId(permissionId) { const result = await pool.query( `SELECT op.* FROM permission_operations AS pop LEFT JOIN operations op ON op.id = pop.operation_id WHERE pop.permission_id = $1`, [permissionId] ); if (!result || !result.rows || !result.rows.length) return []; return result.rows; }
const deleteUser = (request, response) => { const id = parseInt(request.params.id) pool.query('DELETE FROM users WHERE id = $1', [id], (error, results) => { if (error) { throw error } response.status(200).send(`User deleted with ID: ${id}`) }) }
async function getOrgUnitNameById(id) { const result = await pool.query( `SELECT name FROM org_units WHERE id = $1`, [id] ); if (!result || !result.rows || !result.rows.length) return null; return result.rows[0]["name"]; }
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) }) }