db_host = node['pgd']['database']['host']
db_port = node['pgd']['database']['port']

server_user = node['pgd']['database']['user']
server_password = node['pgd']['database']['password']

db_user = node['pgd']['database']['user']
db_pass = node['pgd']['database']['password']

# Myql connect info
mysql_connection_info = {
    :host => db_host,
    :port => db_port,
    :username => server_user || 'root',
    :password => node['mysql']['server_root_password']
}

# Postgres Connection info
postgresql_connection_info = {
  :host => db_host,
  :username => server_user || 'postgres',
  :password => server_password
}

case node['pgd']['database']['engine'].split('.').last
when 'mysql'
  include_recipe "mysql::client"
  include_recipe "database::mysql"
  db_provider = Chef::Provider::Database::Mysql
  db_user_provider = Chef::Provider::Database::MysqlUser
  connection_info = mysql_connection_info
when 'psycopg2', 'postgresql_psycopg2'
  include_recipe "postgresql"
  include_recipe "database::postgres"
  db_provider = Chef::Provider::Database::Postgresql
  db_user_provider = Chef::Provider::Database::PostgresqlUser
  connection_info = postgresql_connection_info
end

# Creating database
log "Creating Database with name #{node['pgd']['database']['name']}"
database node['pgd']['database']['name'] do
  provider db_provider
  connection connection_info
  action :create
end

# Create our user
database_user db_user do
  provider db_provider
  connection connection_info
  database_name node['pgd']['database']['name']
  password db_pass
  action :create
end

# Give our user permissions to the DB
database_user db_user do
  provider db_user_provider
  connection connection_info
  database_name node['pgd']['database']['name']
  privileges [:all]
  action :grant
end