infrataster-plugin-oracledb
Oracle Database plugin for Infrataster
Installation
Requires:
Add this line to your Gemfile:
gem 'infrataster-plugin-oracledb'
And then add the following line to your spec_helper.rb:
require 'infrataster-plugin-oracledb'
Usage
describe server(:orcl) do
describe oracledb_query('select name,display_value from v$parameter') do
# check db_block_size
it "initialization parameter 'db_block_size' should equal 8192" do
row = results.find { |r| r['NAME'] == 'db_block_size' }
expect(row['DISPLAY_VALUE'].to_i).to eq 8192
end
end
endYou can specify database connection and credential details by options passed to Infrataster::Server.define:
Infrataster::Server.define(
:orcl,
'192.168.56.101',
oracledb: {user: 'system', password: 'oracle', service_name: 'orcl'},
)