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