Sha256: bf3a407e4680df08a37d2c632f09dbab03c9b2d523f2045f6d1185226d19c83b
Contents?: true
Size: 1.73 KB
Versions: 30
Compression:
Stored size: 1.73 KB
Contents
describe 'Gratan::Client#apply' do
before(:each) do
apply {
<<-RUBY
user 'scott', 'localhost', identified: 'tiger', required: 'SSL' do
on '*.*' do
grant 'SELECT'
grant 'INSERT'
end
on 'test.*' do
grant 'UPDATE'
grant 'DELETE'
end
on 'mysql.user' do
grant 'SELECT (user)'
end
end
user 'bob', 'localhost' do
on '*.*' do
grant 'USAGE'
end
on 'test.*' do
grant 'ALL PRIVILEGES'
end
end
RUBY
}
end
context 'when drop user' do
subject { client(dry_run: true) }
it do
apply(subject) {
<<-RUBY
user 'bob', 'localhost' do
on '*.*' do
grant 'USAGE'
end
on 'test.*' do
grant 'ALL PRIVILEGES'
end
end
RUBY
}
expect(show_grants).to match_array [
"GRANT ALL PRIVILEGES ON `test`.* TO 'bob'@'localhost'",
"GRANT SELECT (user) ON `mysql`.`user` TO 'scott'@'localhost'",
"GRANT SELECT, INSERT ON *.* TO 'scott'@'localhost' IDENTIFIED BY PASSWORD '*F2F68D0BB27A773C1D944270E5FAFED515A3FA40' REQUIRE SSL",
"GRANT UPDATE, DELETE ON `test`.* TO 'scott'@'localhost'",
"GRANT USAGE ON *.* TO 'bob'@'localhost'",
]
end
end
context 'when drop all users' do
subject { client(dry_run: true) }
it do
apply(subject) { '' }
expect(show_grants).to match_array [
"GRANT ALL PRIVILEGES ON `test`.* TO 'bob'@'localhost'",
"GRANT SELECT (user) ON `mysql`.`user` TO 'scott'@'localhost'",
"GRANT SELECT, INSERT ON *.* TO 'scott'@'localhost' IDENTIFIED BY PASSWORD '*F2F68D0BB27A773C1D944270E5FAFED515A3FA40' REQUIRE SSL",
"GRANT UPDATE, DELETE ON `test`.* TO 'scott'@'localhost'",
"GRANT USAGE ON *.* TO 'bob'@'localhost'",
]
end
end
end
Version data entries
30 entries across 30 versions & 1 rubygems