Mercurial > repos > other > Puppet
view modules/mysql/spec/acceptance/mysql_db_spec.rb @ 244:48d3a1948e4d
Update MySQL module
author | IBBoard <dev@ibboard.co.uk> |
---|---|
date | Sat, 21 Dec 2019 14:11:43 -0500 |
parents | 58d1818c2ded |
children |
line wrap: on
line source
require 'spec_helper_acceptance' describe 'mysql::db define' do describe 'creating a database' do let(:pp) do <<-MANIFEST class { 'mysql::server': root_password => 'password', service_enabled => 'true', service_manage => 'true', } mysql::db { 'spec1': user => 'root1', password => 'password', } MANIFEST end it 'behaves idempotently' do idempotent_apply(pp) end it 'Checking exit code and stdout' do result = run_shell("mysql -e 'show databases;'") expect(result.exit_code).to eq 0 expect(result.stdout).to match %r{^spec1$} end end describe 'creating a database with post-sql' do let(:pp) do <<-MANIFEST class { 'mysql::server': override_options => { 'root_password' => 'password' } } file { '/tmp/spec.sql': ensure => file, content => 'CREATE TABLE table1 (id int);', before => Mysql::Db['spec2'], } mysql::db { 'spec2': user => 'root1', password => 'password', sql => '/tmp/spec.sql', } MANIFEST end it 'behaves idempotently' do idempotent_apply(pp) end it 'Checking exit code and stdout' do result = run_shell("mysql -e 'show tables;' spec2") expect(result.exit_code).to eq 0 expect(result.stdout).to match %r{^table1$} end end describe 'creating a database with dbname parameter' do let(:check_command) { ' | grep realdb' } let(:pp) do <<-MANIFEST class { 'mysql::server': override_options => { 'root_password' => 'password' } } mysql::db { 'spec1': user => 'root1', password => 'password', dbname => 'realdb', } MANIFEST end it 'behaves idempotently' do idempotent_apply(pp) end it 'Checking exit code and stdout' do result = run_shell("mysql -e 'show databases;'") expect(result.exit_code).to eq 0 expect(result.stdout).to match %r{^realdb$} end end end