Contents

require 'spec_helper_system'

describe 'postgresql::server::database_grant:' do
  after :all do
    # Cleanup after tests have ran
    puppet_apply("class { 'postgresql::server': ensure => absent }") do |r|
      r.exit_code.should_not == 1
    end
  end

  it 'should grant access so a user can create objects in a database' do
    begin
      pp = <<-EOS.unindent
        $db = 'postgres'
        $user = 'psql_grant_tester'
        $password = 'psql_grant_pw'

        class { 'postgresql::server': }

        # Since we are not testing pg_hba or any of that, make a local user for ident auth
        user { $user:
          ensure => present,
        }

        postgresql::server::role { $user:
          password_hash => postgresql_password($user, $password),
        }

        postgresql::server::database { $db: }

        postgresql::server::database_grant { 'grant create test':
          privilege => 'CREATE',
          db        => $db,
          role      => $user,
        }
      EOS

      puppet_apply(pp) do |r|
        r.exit_code.should_not == 1
        r.refresh
        r.exit_code.should == 0
      end

      # Check that the user can create a table in the database
      psql('--command="create table foo (foo int)" postgres', 'psql_grant_tester') do |r|
        r.stdout.should =~ /CREATE TABLE/
        r.stderr.should == ''
        r.exit_code.should == 0
      end
    ensure
      psql('--command="drop table foo" postgres', 'psql_grant_tester')
    end
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
freighthop-0.3.3	modules/postgresql/spec/system/server/database_grant_spec.rb
freighthop-0.3.2	modules/postgresql/spec/system/server/database_grant_spec.rb
freighthop-0.3.1	modules/postgresql/spec/system/server/database_grant_spec.rb
freighthop-0.3.0	modules/postgresql/spec/system/server/database_grant_spec.rb
freighthop-0.2.1	modules/postgresql/spec/system/server/database_grant_spec.rb
freighthop-0.2.0	modules/postgresql/spec/system/server/database_grant_spec.rb
freighthop-0.1.0	modules/postgresql/spec/system/server/database_grant_spec.rb