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

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

Matchers