A handy gem to help with testing postgresql related scripts or anything postgresql related
Ruby Shell
Switch branches/tags
Nothing to show
Clone or download
negul Merge pull request #4 from unindented/patch-1
Minor tweaks, plus CoC
Latest commit 95a7a9f Jun 22, 2016
Permalink
Failed to load latest commit information.
bin
lib
spec
.gitignore
.travis.yml remove the postgres Jun 14, 2016
Gemfile
LICENSE.txt
README.md Minor tweaks in README, plus CoC Jun 22, 2016
Rakefile
pg_tester.gemspec

README.md

PgTester Build Status Dependency Status

A handy gem to help with testing postgresql related scripts or anything PostgreSQL related.

Installation

Add this line to your application's Gemfile (source https://rubygems.org):

gem 'pg_tester'

And then execute:

$ bundle

Or install it yourself as:

$ gem install pg_tester

Usage

Initialize a PgTester instance:

require 'pg_tester'

psql = PgTester.new({

  port:             '312',
  host:             'localhost',
  db_name:          'testpostgresql',
  user_name:        'testpostgresql',
  data_dir:         '/tmp/',
  initdb_path:      '/usr/local/bin/initdb',
  pgctl_path:       '/usr/local/bin/which pg_ctl',
  createuser_path:  '/usr/local/bin/which createuser',
  createdb_path:    '/usr/local/bin/which createdb',
  })

Case 1

Create a test PostgreSQL cluster in /tmp, connect as testpostgresql user and database name testpostgresql, and run queries against the test database:

psql.setup 
result = psql.exec(query)
# ... do some expectation on result

Remember to teardown the database to stop PostgreSQL:

psql.teardown # Cluster is torn down and dir in /tmp deleted

Case 2

Execute the block and teardown database after block execution:

psql.exec(query) do |result|
  # ... do some expectation on result
end

Case 3

Pass custom arguments and execute query in block:

PgTester.new({
  port:             '312',
  data_dir:         '/tmp/',
}).exec(query) { |result| # some expectation }

Case 4

Use inside rspec specs:

context 'run query in block' do
  it 'should run exec query in a block' do
    PgTester.new().exec('SELECT 2') do |result|
      expect(result.getvalue(0,0)).to eq("2")
    end
  end

  it 'should run exec query in a curly block' do
    PgTester.new().exec('SELECT 3') { |result| expect(result.getvalue(0,0)).to eq("3") }
  end
end

Tests

You can run the tests by doing

bundle exec rspec

Contributing

Pull requests are welcome!

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact opencode@microsoft.com with any additional questions or comments.