X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/550c4a3a45814fde5c809334c85f1ebc47659a82..4f2789c73c3ac9c3af3e4a4ae08f2f37cb78ddf1:/config/initializers/migrate.rb diff --git a/config/initializers/migrate.rb b/config/initializers/migrate.rb index add6aaea9..1af67dd10 100644 --- a/config/initializers/migrate.rb +++ b/config/initializers/migrate.rb @@ -1,50 +1,51 @@ if defined?(ActiveRecord::ConnectionAdapters::AbstractAdapter) module OpenStreetMap - module ActiveRecord - module PostgreSQLAdapter + module PostgreSQL + module Quoting def quote_column_name(name) Array(name).map { |n| super(n) }.join(", ") end + end - def add_primary_key(table_name, column_name, _options = {}) - table_name = quote_table_name(table_name) - column_name = quote_column_name(column_name) + module SchemaStatements + def add_primary_key(table_name, column_name, options = {}) + constraint_name = "#{table_name}_pkey" - execute "ALTER TABLE #{table_name} ADD PRIMARY KEY (#{column_name})" - end - - def remove_primary_key(table_name) - table_name = quote_table_name(table_name) + options = options.merge(:name => constraint_name, :unique => true) - execute "ALTER TABLE #{table_name} DROP PRIMARY KEY" + add_index(table_name, column_name, **options) + set_primary_key table_name, constraint_name end - def alter_primary_key(table_name, new_columns) + def remove_primary_key(table_name) constraint_name = quote_table_name("#{table_name}_pkey") table_name = quote_table_name(table_name) - new_columns = quote_column_name(new_columns) execute "ALTER TABLE #{table_name} DROP CONSTRAINT #{constraint_name}" - execute "ALTER TABLE #{table_name} ADD PRIMARY KEY (#{new_columns})" end - def create_enumeration(enumeration_name, values) - execute "CREATE TYPE #{enumeration_name} AS ENUM ('#{values.join '\',\''}')" - end + def alter_primary_key(table_name, column_name, options = {}) + constraint_name = "#{table_name}_pkey" + tmp_constraint_name = "#{table_name}_pkey_tmp" - def drop_enumeration(enumeration_name) - execute "DROP TYPE #{enumeration_name}" + options = options.merge(:name => tmp_constraint_name, :unique => true) + + add_index(table_name, column_name, **options) + remove_primary_key table_name + set_primary_key table_name, tmp_constraint_name + rename_index table_name, tmp_constraint_name, constraint_name end - def rename_enumeration(old_name, new_name) - old_name = quote_table_name(old_name) - new_name = quote_table_name(new_name) + def set_primary_key(table_name, constraint_name) + constraint_name = quote_table_name(constraint_name) + table_name = quote_table_name(table_name) - execute "ALTER TYPE #{old_name} RENAME TO #{new_name}" + execute "ALTER TABLE #{table_name} ADD PRIMARY KEY USING INDEX #{constraint_name}" end end end end - ActiveRecord::ConnectionAdapters::PostgreSQLAdapter.prepend(OpenStreetMap::ActiveRecord::PostgreSQLAdapter) + ActiveRecord::ConnectionAdapters::PostgreSQL::Quoting.prepend(OpenStreetMap::PostgreSQL::Quoting) + ActiveRecord::ConnectionAdapters::PostgreSQL::SchemaStatements.prepend(OpenStreetMap::PostgreSQL::SchemaStatements) end