mirror of
https://github.com/brianc/node-postgres.git
synced 2025-12-08 20:16:25 +00:00
fe88e825e5
I didn't do much to "modernize" the pg-native codebase other than running it through the standard eslint --fix that is applied to the rest of the code. There's some easy opportunities there to update it to es6 and so on...it still uses some pretty antiquated coding styles in places. This PR re-introduces the native tests on node v20, and updates test matrix to drop unsupported versions of node & add in node v22.
42 lines
1.2 KiB
JavaScript
42 lines
1.2 KiB
JavaScript
var Client = require('../')
|
|
var assert = require('assert')
|
|
|
|
describe('multiple commands in a single query', function () {
|
|
before(function (done) {
|
|
this.client = new Client()
|
|
this.client.connect(done)
|
|
})
|
|
|
|
after(function (done) {
|
|
this.client.end(done)
|
|
})
|
|
|
|
it('all execute to completion', function (done) {
|
|
this.client.query("SELECT '10'::int as num; SELECT 'brian'::text as name", function (err, rows) {
|
|
assert.ifError(err)
|
|
assert.equal(rows.length, 2, 'should return two sets rows')
|
|
assert.equal(rows[0][0].num, '10')
|
|
assert.equal(rows[1][0].name, 'brian')
|
|
done()
|
|
})
|
|
})
|
|
|
|
it('inserts and reads at once', function (done) {
|
|
var txt = 'CREATE TEMP TABLE boom(age int);'
|
|
txt += 'INSERT INTO boom(age) VALUES(10);'
|
|
txt += 'SELECT * FROM boom;'
|
|
this.client.query(txt, function (err, rows, results) {
|
|
assert.ifError(err)
|
|
assert.equal(rows.length, 3)
|
|
assert.equal(rows[0].length, 0)
|
|
assert.equal(rows[1].length, 0)
|
|
assert.equal(rows[2][0].age, 10)
|
|
|
|
assert.equal(results[0].command, 'CREATE')
|
|
assert.equal(results[1].command, 'INSERT')
|
|
assert.equal(results[2].command, 'SELECT')
|
|
done()
|
|
})
|
|
})
|
|
})
|