lib/torque/postgresql/adapter/schema_statements.rb in torque-postgresql-1.0.1 vs lib/torque/postgresql/adapter/schema_statements.rb in torque-postgresql-1.1.0

- old
+ new

@@ -7,19 +7,19 @@ # Drops a type. def drop_type(name, options = {}) force = options.fetch(:force, '').upcase check = 'IF EXISTS' if options.fetch(:check, true) - execute <<-SQL + execute <<-SQL.squish DROP TYPE #{check} #{quote_type_name(name, options[:schema])} #{force} SQL end # Renames a type. def rename_type(type_name, new_name) - execute <<-SQL + execute <<-SQL.squish ALTER TYPE #{quote_type_name(type_name)} RENAME TO #{Quoting::Name.new(nil, new_name.to_s).quoted} SQL end @@ -30,11 +30,11 @@ # create_enum 'status', ['foo', 'bar'], prefix: true # create_enum 'status', ['foo', 'bar'], suffix: 'test' # create_enum 'status', ['foo', 'bar'], force: true def create_enum(name, values, options = {}) drop_type(name, options) if options[:force] - execute <<-SQL + execute <<-SQL.squish CREATE TYPE #{quote_type_name(name, options[:schema])} AS ENUM (#{quote_enum_values(name, values, options).join(', ')}) SQL end @@ -54,10 +54,10 @@ after = quote(after) unless after == false quote_enum_values(name, values, options).each do |value| reference = "BEFORE #{before}" unless before == false reference = "AFTER #{after}" unless after == false - execute <<-SQL + execute <<-SQL.squish ALTER TYPE #{quote_type_name(name, options[:schema])} ADD VALUE #{value} #{reference} SQL before = false