Something went wrong. Try again.
[READ-ONLY] Mirror of https://github.com/glacials/splits-io. a speedrunning data store and analysis engine splits.io
Something went wrong. Try again.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230'use strict'const expect = require('expect.js')const _ = require('lodash')
const describe = require('mocha').describeconst it = require('mocha').it
const Pool = require('../')
describe('pool', function () { describe('with callbacks', function () { it('works totally unconfigured', function (done) { const pool = new Pool() pool.connect(function (err, client, release) { if (err) return done(err) client.query('SELECT NOW()', function (err, res) { release() if (err) return done(err) expect(res.rows).to.have.length(1) pool.end(done) }) }) })
it('passes props to clients', function (done) { const pool = new Pool({ binary: true }) pool.connect(function (err, client, release) { release() if (err) return done(err) expect(client.binary).to.eql(true) pool.end(done) }) })
it('can run a query with a callback without parameters', function (done) { const pool = new Pool() pool.query('SELECT 1 as num', function (err, res) { expect(res.rows[0]).to.eql({ num: 1 }) pool.end(function () { done(err) }) }) })
it('can run a query with a callback', function (done) { const pool = new Pool() pool.query('SELECT $1::text as name', ['brianc'], function (err, res) { expect(res.rows[0]).to.eql({ name: 'brianc' }) pool.end(function () { done(err) }) }) })
it('passes connection errors to callback', function (done) { const pool = new Pool({ port: 53922 }) pool.query('SELECT $1::text as name', ['brianc'], function (err, res) { expect(res).to.be(undefined) expect(err).to.be.an(Error) // a connection error should not polute the pool with a dead client expect(pool.totalCount).to.equal(0) pool.end(function (err) { done(err) }) }) })
it('does not pass client to error callback', function (done) { const pool = new Pool({ port: 58242 }) pool.connect(function (err, client, release) { expect(err).to.be.an(Error) expect(client).to.be(undefined) expect(release).to.be.a(Function) pool.end(done) }) })
it('removes client if it errors in background', function (done) { const pool = new Pool() pool.connect(function (err, client, release) { release() if (err) return done(err) client.testString = 'foo' setTimeout(function () { client.emit('error', new Error('on purpose')) }, 10) }) pool.on('error', function (err) { expect(err.message).to.be('on purpose') expect(err.client).to.not.be(undefined) expect(err.client.testString).to.be('foo') err.client.connection.stream.on('end', function () { pool.end(done) }) }) })
it('should not change given options', function (done) { const options = { max: 10 } const pool = new Pool(options) pool.connect(function (err, client, release) { release() if (err) return done(err) expect(options).to.eql({ max: 10 }) pool.end(done) }) })
it('does not create promises when connecting', function (done) { const pool = new Pool() const returnValue = pool.connect(function (err, client, release) { release() if (err) return done(err) pool.end(done) }) expect(returnValue).to.be(undefined) })
it('does not create promises when querying', function (done) { const pool = new Pool() const returnValue = pool.query('SELECT 1 as num', function (err) { pool.end(function () { done(err) }) }) expect(returnValue).to.be(undefined) })
it('does not create promises when ending', function (done) { const pool = new Pool() const returnValue = pool.end(done) expect(returnValue).to.be(undefined) })
it('never calls callback syncronously', function (done) { const pool = new Pool() pool.connect((err, client) => { if (err) throw err client.release() setImmediate(() => { let called = false pool.connect((err, client) => { if (err) throw err called = true client.release() setImmediate(() => { pool.end(done) }) }) expect(called).to.equal(false) }) }) }) })
describe('with promises', function () { it('connects, queries, and disconnects', function () { const pool = new Pool() return pool.connect().then(function (client) { return client.query('select $1::text as name', ['hi']).then(function (res) { expect(res.rows).to.eql([{ name: 'hi' }]) client.release() return pool.end() }) }) })
it('executes a query directly', () => { const pool = new Pool() return pool .query('SELECT $1::text as name', ['hi']) .then(res => { expect(res.rows).to.have.length(1) expect(res.rows[0].name).to.equal('hi') return pool.end() }) })
it('properly pools clients', function () { const pool = new Pool({ poolSize: 9 }) const promises = _.times(30, function () { return pool.connect().then(function (client) { return client.query('select $1::text as name', ['hi']).then(function (res) { client.release() return res }) }) }) return Promise.all(promises).then(function (res) { expect(res).to.have.length(30) expect(pool.totalCount).to.be(9) return pool.end() }) })
it('supports just running queries', function () { const pool = new Pool({ poolSize: 9 }) const text = 'select $1::text as name' const values = ['hi'] const query = { text: text, values: values } const promises = _.times(30, () => pool.query(query)) return Promise.all(promises).then(function (queries) { expect(queries).to.have.length(30) return pool.end() }) })
it('recovers from query errors', function () { const pool = new Pool()
const errors = [] const promises = _.times(30, () => { return pool.query('SELECT asldkfjasldkf') .catch(function (e) { errors.push(e) }) }) return Promise.all(promises).then(() => { expect(errors).to.have.length(30) expect(pool.totalCount).to.equal(0) expect(pool.idleCount).to.equal(0) return pool.query('SELECT $1::text as name', ['hi']).then(function (res) { expect(res.rows).to.eql([{ name: 'hi' }]) return pool.end() }) }) }) })})