node-postgres/packages/pg-cursor/test/no-data-handling.js
2019-12-18 13:42:47 -06:00

35 lines
878 B
JavaScript

const assert = require('assert')
const pg = require('pg')
const Cursor = require('../')
describe('queries with no data', function() {
beforeEach(function(done) {
const client = (this.client = new pg.Client())
client.connect(done)
})
afterEach(function() {
this.client.end()
})
it('handles queries that return no data', function(done) {
const cursor = new Cursor('CREATE TEMPORARY TABLE whatwhat (thing int)')
this.client.query(cursor)
cursor.read(100, function(err, rows) {
assert.ifError(err)
assert.strictEqual(rows.length, 0)
done()
})
})
it('handles empty query', function(done) {
let cursor = new Cursor('-- this is a comment')
cursor = this.client.query(cursor)
cursor.read(100, function(err, rows) {
assert.ifError(err)
assert.strictEqual(rows.length, 0)
done()
})
})
})