How to use the pg.Query function in pg

To help you get started, we’ve selected a few pg examples, based on popular ways it is used in public projects.

Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.

github keymetrics / pm2-io-apm / src / census / plugins / __tests__ / pg.spec.ts View on Github external
tracer.startRootSpan({ name: 'selectEventRootSpan' }, (rootSpan: RootSpan) => {
        const q = 'SELECT 4 as value'
        // Must use new Query for eventemitter
        // https://node-postgres.com/guides/upgrading#client-query-submittable-
        const query = client.query(new pg.Query(q))
        query.on('end', res => {
          assert.strictEqual(rootSpanVerifier.endedRootSpans.length, 0)
          rootSpan.end()
          assert.strictEqual(rootSpanVerifier.endedRootSpans.length, 1)
          assert.strictEqual(rootSpanVerifier.endedRootSpans[0].spans.length, 1)
          assert.strictEqual(rootSpanVerifier.endedRootSpans[0].spans[0].attributes.query, q)
          assertSpan(rootSpanVerifier, 'pg-query', SpanKind.CLIENT)
          done()
        })
      })
    })
github joyent / moray / lib / pg.js View on Github external
self.removeListener('conn-error', onConnError);
        clearTimeout(timer);

        res.emit(event, arg);
    }

    function onConnError(err) {
        dtrace['query-conn-error'].fire(function () {
            return ([reqid, sql, err.toString()]);
        });

        setImmediate(done, 'error', err);
    }

    req = new pg.Query(sql, args);

    req.on('row', function onRow(row) {
        dtrace['query-row'].fire(function () {
            return ([reqid, sql, row]);
        });

        log.debug({
            req_id: reqid,
            client: self,
            row: row
        }, 'query: row');

        if (ended) {
            return;
        }
github C2FO / patio / lib / adapters / postgres.js View on Github external
query: function (query) {
            var ret = new Promise();
            if (!this.closed) {
                try {
                    this.connection.setMaxListeners(0);
                    var fields = [], rows = [];
                    var q = this.connection.query(new pg.Query(query))
                        .on("error", ret.errback)
                        .on("row", function(row){
                            rows.push(row);
                        })
                        .on("end", function(){
                        ret.callback(rows, fields);
                    });
                    var orig = q.handleRowDescription;
                    q.handleRowDescription = function (msg) {
                        fields = msg.fields;
                        q.handleRowDescription = orig;
                        return orig.apply(q, arguments);
                    };
                } catch (e) {
                    ret.errback(e);
                }
github askmike / gekko / plugins / postgresql / reader.js View on Github external
this.db.connect((err,client,done) => {
    var query = client.query(new Query(`
    SELECT COUNT(*) as count from ${postgresUtil.table('candles')}
    `));
    var rows = [];
    query.on('row', function(row) {
      rows.push(row);
    });

    query.on('end',function(){
      done();
      next(null, _.first(rows).count);
    });
  });  
}