A handy gem to help with testing postgresql related scripts or anything PostgreSQL related.
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
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',
})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 resultRemember to teardown the database to stop PostgreSQL:
psql.teardown # Cluster is torn down and dir in /tmp deletedExecute the block and teardown database after block execution:
psql.exec(query) do |result|
# ... do some expectation on result
endPass custom arguments and execute query in block:
PgTester.new({
port: '312',
data_dir: '/tmp/',
}).exec(query) { |result| # some expectation }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
endYou can run the tests by doing
bundle exec rspec
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 [email protected] with any additional questions or comments.
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent