async function onHealthCheck () { return client.query('SELECT 1') }
app.get('/', async (req, res) => { const result = await client.query('SELECT $1::text as message', ['Hello world!']) res.send(result.rows[0].message) })
listenTo(channel) { const database = this.client.database; this.client.query(`LISTEN ${channel}`).then(() => { logger.info(msg.STARTED_LISTENING, green(database + ':' + channel)); // Warn if handlers are not registered for the channels being listened to if (!Array.isArray(this.handlers[channel])) { logger.warn(msg.WARN_NO_HANDLERS_FOUND, channel); } }); }
function getWorkerTokens(){ db.query('SELECT access_token FROM users WHERE general_purpose=True;').then(result => { tokens = tokens.concat(result.rows.map(r => { return r.access_token })); iter(); }).catch(err => { console.log(err); }) }
db.connect((err, client) => { db.query(` CREATE TABLE IF NOT EXISTS snippets ( id SERIAL, PRIMARY KEY(id), body text ); ` , (err, result) => { if (err) throw err; console.log('Created table "snippets"'); db.end(); }); });
client.query(grantPrivilegesSql, function(err, result) { if (err) { console.log('error: ', err); process.exit(1); } console.log(`Granted privileges to '${userName}' successfully:`, result); console.log("Database creation success!"); process.exit(0); });
db.query(query).then(result => { if(result.rows.length == 1){ lastID = result.rows[0].checkin_id; getWorkerTokens(); }else{ getWorkerTokens(); } }).catch(err => { console.log(err); })
router.get('/sales', async (req, res) => { const { rows } = await pgClient.query('SELECT id, uuid, total, sale_date, created_at FROM sales'); res.status(200).json(rows); });
let createDb = () => { client.connect() return client.query('CREATE DATABASE postapp') }
client.query(alterPrivilegesTablesSql, function(err, result) { if (err) { console.log('error: ', err); process.exit(1); } console.log(`Altered privileges to '${userName}' tables successfully:`, result); });
app.get('/', async (req, res) => { const result = await client.query('SELECT $1::text as message', ['Hello world!']) res.send(result.rows[0].message) })
async function onHealthCheck () { return client.query('SELECT 1') }
// write a checkpoint to keep track of where we got to // with each table const writeCheckpoint = async (tablename, seq) => { const sql = 'INSERT INTO couchwarehouse_checkpoints (tablename,seq) VALUES ($1,$2)' await client.query(sql, [tablename, seq]) }
client.query(alterPrivilegesSequencesSql, function(err, result) { if (err) { console.log('error: ', err); process.exit(1); } console.log(`Altered privileges to '${userName}' sequences successfully:`, result); });
client.query(createDatabaseSql, function(err, result) { if (err) { console.log('error: ', err); process.exit(1); } console.log(`User '${userName}' created successfully:`, result); });