@current_resource = Chef::Resource::PostgresqlDatabase.new(new_resource.name)
@current_resource.database(new_resource.database)
@current_resource.cluster(new_resource.cluster)
- if pg_database = @pg.databases[@current_resource.database]
+ if (pg_database = @pg.databases[@current_resource.database])
@current_resource.owner(pg_database[:owner])
@current_resource.encoding(pg_database[:encoding])
@current_resource.encoding(pg_database[:collate])
end
action :create do
- unless @pg.databases.include?(new_resource.database)
- @pg.execute(:command => "CREATE DATABASE #{new_resource.database} OWNER #{new_resource.owner} TEMPLATE template0 ENCODING '#{new_resource.encoding}' LC_COLLATE '#{new_resource.collation}' LC_CTYPE '#{new_resource.ctype}'")
+ if !@pg.databases.include?(new_resource.database)
+ @pg.execute(:command => "CREATE DATABASE \"#{new_resource.database}\" OWNER \"#{new_resource.owner}\" TEMPLATE template0 ENCODING '#{new_resource.encoding}' LC_COLLATE '#{new_resource.collation}' LC_CTYPE '#{new_resource.ctype}'")
new_resource.updated_by_last_action(true)
else
if new_resource.owner != @current_resource.owner
- @pg.execute(:command => "ALTER DATABASE #{new_resource.database} OWNER TO #{new_resource.owner}")
+ @pg.execute(:command => "ALTER DATABASE \"#{new_resource.database}\" OWNER TO \"#{new_resource.owner}\"")
new_resource.updated_by_last_action(true)
end
end
action :drop do
if @pg.databases.include?(new_resource.database)
- @pg.execute(:command => "DROP DATABASE #{new_resource.database}")
+ @pg.execute(:command => "DROP DATABASE \"#{new_resource.database}\"")
new_resource.updated_by_last_action(true)
end
end