DB_ROOT_CONNECTION      = [ "mysql",
                            "--user='root'",
                            "--host='localhost'",
                            "--password='#{node['drupal-solr']['mysql_root_password']}'",
                            "--database='#{node['drupal-solr']['drupal_db']}'"
                          ].join(' ')

UPDATE_SOLR_SERVER_SQL  = [ "UPDATE apachesolr_environment",
                            "SET url=",
                            "'localhost:#{node['tomcat']['port']}/#{node['drupal-solr']['app_name']}'",
                            "WHERE env_id = 'solr'"
                          ].join(' ')
case node['drupal-solr']['drupal_version']
when /^7/
  # update the apachesolr_environment table to contain
  # url of the installed solr server
  execute "connect-drupal7-solr" do
    command "#{DB_ROOT_CONNECTION} -e \"#{UPDATE_SOLR_SERVER_SQL}\""
  end
when /^6/
  bash "connect-drupal6-solr" do
    code <<-EOH
      #{DRUSH} variable-set apachesolr_port #{node['tomcat']['port']}
      #{DRUSH} variable-set apachesolr_path /#{node['drupal-solr']['app_name']}
    EOH
  end
end

  execute "connect-drupal7-solr" do
    command "#{DRUSH} sql-query \"#{UPDATE_SOLR_SERVER_SQL}\""
  end