# limitations under the License.
#
+use_inline_resources
+
def load_current_resource
@pg = Chef::PostgreSQL.new(new_resource.cluster)
@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)
+ elsif new_resource.owner != @current_resource.owner
+ @pg.execute(:command => "ALTER DATABASE \"#{new_resource.database}\" OWNER TO \"#{new_resource.owner}\"")
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}")
- new_resource.updated_by_last_action(true)
- end
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