infrataster-plugin-pgsql
PgSQL plugin for Infrataster
Pre-requisite
- postgresql-libs and postgresql-devel should be installed
Installation
Install infrataster-plugin-pgsql by following command
$ gem install infrataster-plugin-pgsql
Add this line to your Gemfile:
gem 'infrataster-plugin-pgsql'
And then add the following line to your spec_helper.rb:
require 'infrataster-plugin-pgsql'
Usage
describe server(:db) do
describe pgsql_query('SELECT * from pg_stat_activity') do
it 'should allowed connection' do
connection.status.should == PG::CONNECTION_OK
end
it 'should show database name' do
row = result.find{|r| r['usename'] == 'postgres'}
expect(row['datname']).to be == 'postgres'
end
end
end
describe server(:dbtest) do
describe pgsql_query('SHOW PORT') do
it 'connection refused' do
expect { connection.status }.to raise_error( PG::ConnectionBad, /could not connect to server: Connection refused/ )
end
end
endYou can specify username and password by options passed to Infrataster::Server.define in spec_helper.rb:
Infrataster::Server.define(
:db,
'172.26.126.70',
pgsql: {user: 'postgres', password: 'postgres'},
)Contributing
- Fork it ( https://github.com/SnehaM/infrataster-plugin-pgsql/fork )
- Create your feature branch (git checkout -b my-new-feature)
- Commit your changes (git commit -am 'Add some feature')
- Push to the branch (git push origin my-new-feature)
- Create a new Pull Request