Contents

require 'spec_helper_acceptance'

describe 'postgresql_psql:' do
  after :all do
    # Cleanup after tests have ran
    apply_manifest("class { 'postgresql::server': ensure => absent }", :catch_failures => true)
  end

  it 'should run some SQL when the unless query returns no rows' do
    pp = <<-EOS.unindent
      class { 'postgresql::server': }

      postgresql_psql { 'foobar':
        db        => 'postgres',
        psql_user => 'postgres',
        command   => 'select 1',
        unless    => 'select 1 where 1=2',
        require   => Class['postgresql::server'],
      }
    EOS

    apply_manifest(pp, :catch_failures => true)
    apply_manifest(pp, :catch_failures => true)
  end

  it 'should not run SQL when the unless query returns rows' do
    pp = <<-EOS.unindent
      class { 'postgresql::server': }

      postgresql_psql { 'foobar':
        db        => 'postgres',
        psql_user => 'postgres',
        command   => 'select * from pg_database limit 1',
        unless    => 'select 1 where 1=1',
        require   => Class['postgresql::server'],
      }
    EOS

    apply_manifest(pp, :catch_failures => true)
    apply_manifest(pp, :catch_changes => true)
  end

end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
freighthop-0.6.1	modules/postgresql/spec/acceptance/postgresql_psql_spec.rb
freighthop-0.6.0	modules/postgresql/spec/acceptance/postgresql_psql_spec.rb
freighthop-0.5.2	modules/postgresql/spec/acceptance/postgresql_psql_spec.rb
freighthop-0.5.1	modules/postgresql/spec/acceptance/postgresql_psql_spec.rb
freighthop-0.5.0	modules/postgresql/spec/acceptance/postgresql_psql_spec.rb
freighthop-0.4.1	modules/postgresql/spec/acceptance/postgresql_psql_spec.rb
freighthop-0.4.0	modules/postgresql/spec/acceptance/postgresql_psql_spec.rb