docs/resources/oracledb_session.md.erb in inspec-1.40.0 vs docs/resources/oracledb_session.md.erb in inspec-1.41.0

- old
+ new

@@ -4,10 +4,12 @@ # oracledb_session Use the `oracledb_session` InSpec audit resource to test SQL commands run against a Oracle database. +<br> + ## Syntax A `oracledb_session` resource block declares the username and password to use for the session with an optional service to connect to, and then the command to be run: describe oracledb_session(user: 'username', password: 'password', service: 'ORCL.localdomain').query('QUERY').row(0).column('result') do @@ -18,22 +20,12 @@ * `oracledb_session` declares a username and password with permission to run the query (required), and an optional parameters for host (default: `localhost`), SID (default: `nil`, which uses the default SID, and path to the sqlplus binary (default: `sqlplus`). * `query('QUERY')` contains the query to be run * `its('value') { should eq('') }` compares the results of the query against the expected result in the test -## Matchers +<br> -This InSpec audit resource has the following matchers: - -### cmp - -<%= partial "/shared/matcher_cmp" %> - -### eq - -<%= partial "/shared/matcher_eq" %> - ## Examples The following examples show how to use this InSpec audit resource. ### Test for matching databases @@ -49,5 +41,11 @@ sql = oracledb_session(user: 'my_user', pass: 'password', host: 'oraclehost', sid: 'mysid', sqlplus_bin: '/u01/app/oracle/product/12.1.0/dbhome_1/bin/sqlplus') describe sql.query('SELECT NAME FROM v$database;').row(0).column('name') do its('value') { should cmp 'ORCL' } end + +<br> + +## Matchers + +For a full list of available matchers please visit our [matchers page](https://www.inspec.io/docs/reference/matchers/).