query-config.js 1.0 KB

1234567891011121314151617181920212223242526272829303132333435
  1. 'use strict'
  2. const assert = require('assert')
  3. const Cursor = require('../')
  4. const pg = require('pg')
  5. describe('query config passed to result', () => {
  6. it('passes rowMode to result', (done) => {
  7. const client = new pg.Client()
  8. client.connect()
  9. const text = 'SELECT generate_series as num FROM generate_series(0, 5)'
  10. const cursor = client.query(new Cursor(text, null, { rowMode: 'array' }))
  11. cursor.read(10, (err, rows) => {
  12. assert(!err)
  13. assert.deepStrictEqual(rows, [[0], [1], [2], [3], [4], [5]])
  14. client.end()
  15. done()
  16. })
  17. })
  18. it('passes types to result', (done) => {
  19. const client = new pg.Client()
  20. client.connect()
  21. const text = 'SELECT generate_series as num FROM generate_series(0, 2)'
  22. const types = {
  23. getTypeParser: () => () => 'foo',
  24. }
  25. const cursor = client.query(new Cursor(text, null, { types }))
  26. cursor.read(10, (err, rows) => {
  27. assert(!err)
  28. assert.deepStrictEqual(rows, [{ num: 'foo' }, { num: 'foo' }, { num: 'foo' }])
  29. client.end()
  30. done()
  31. })
  32. })
  33. })