[chef] Re: how best to create and fill a database in an idempotent fashion?

[Klaas Jan Wierenga < >]

Hi Dmitry,

This snippet from cookbooks/wordpress/recipes/default.rb might give you an 
idea. Look at the not_if clause.

execute "create #{node[:wordpress][:db][:database]} database" do
  command "/usr/bin/mysqladmin -u root 
-p#{node[:mysql][:server_root_password]} create 
#{node[:wordpress][:db][:database]}"
  not_if do
    m = Mysql.new("localhost", "root", node[:mysql][:server_root_password])
    m.list_dbs.include?(node[:wordpress][:db][:database])
  end
end

Regards,
KJ

Op 1 jul 2010, om 12:19 heeft Dmitry V'yal het volgende geschreven:

> Hello list,
> 
> I'm writing a receipt which creates a mysql database for my mail server.
> I wrote a sql script and call it like this:
> 
> ***
> 
> root_pass = node[:mysql][:server_root_password]
> 
> scheme_path = "/tmp/scheme.sql"
> 
> template scheme_path do
>  mode "600"
>  source "mysql-scheme.sql.erb"
> end
> 
> execute "mysql-scheme" do
>  command "cat #{scheme_path} | mysql -u root -p#{root_pass}"
> end
> 
> file scheme_path do
>  action :delete
> end
> 
> ***
> 
> Of course, this worked only the first time, the next chef run mysql 
> complained the database already exists.
> 
> How do you handle similar situations? What're the pros and cons of various 
> approaches?
> 
> Thanks,
> Dmitry