sybase_session resource
Use the sybase_session
Chef InSpec audit resource to test the SQL commands run against an SAP Adaptive Server Enterprise (ASE) database.
Availability
Install
This resource is distributed with Chef InSpec and is automatically available for use.Requirements
The isql
command line tool must be installed on the target system.
Syntax
A sybase_session
resource block declares the server, database, username and password to use for the session, and then the command to be run:
describe sybase_session(database: 'pubs2', server: 'SYBASE', username: 'USERNAME', password: 'PASSWORD').query('QUERY').row(0).column('RESULT') do
its('value') { should eq('EXPECTED') }
end
where
sybase_session
declares a server, database, username, and password with permission to run the query.query('QUERY')
contains the query to be run.its('value') { should eq('expected') }
compares the results of the query against the expected result in the test.
Optional Parameters
bin
You may use the bin
parameter to specify the path to the isql
cli tool.
describe sybase_session(database: 'pubs2',
server: 'SYBASE',
username: 'USERNAME',
password: 'PASSWORD',
bin: '/opt/sap/OCS-16_0/bin/isql',
).query('QUERY').row(0).column('RESULT') do
its('value') { should eq('EXPECTED') }
end
sybase_home
You may use the sybase_home
parameter to specify the path to the sybase installation.
describe sybase_session(database: 'pubs2',
server: 'SYBASE',
username: 'USERNAME',
password: 'PASSWORD',
sybase_home: '/opt/sap',
).query('QUERY').row(0).column('RESULT') do
its('value') { should eq('EXPECTED') }
end
Examples
The following examples show how to use this Chef InSpec audit resource.
Test for matching values in the pubs2 sample database
sql = sybase_session(database: 'pubs2', server: 'SYBASE', username: 'MY_USER', password: 'PASSWORD')
describe sql.query("SELECT au_lname FROM authors").row(0).column('AU_LNAME') do
its("value") { should eq 'BENNET' }
end