config/initializers/migrate.rb

   1 # frozen_string_literal: true
   2
   3 if defined?(ActiveRecord::ConnectionAdapters::AbstractAdapter)
   4   module OpenStreetMap
   5     module PostgreSQL
   6       module Quoting
   7         def quote_column_name(name)
   8           Array(name).map { |n| super(n) }.join(", ")
   9         end
  10       end
  11
  12       module SchemaStatements
  13         def add_primary_key(table_name, column_name, options = {})
  14           constraint_name = "#{table_name}_pkey"
  15
  16           options = options.merge(:name => constraint_name, :unique => true)
  17
  18           add_index(table_name, column_name, **options)
  19           set_primary_key table_name, constraint_name
  20         end
  21
  22         def remove_primary_key(table_name)
  23           constraint_name = quote_table_name("#{table_name}_pkey")
  24           table_name = quote_table_name(table_name)
  25
  26           execute "ALTER TABLE #{table_name} DROP CONSTRAINT #{constraint_name}"
  27         end
  28
  29         def alter_primary_key(table_name, column_name, options = {})
  30           constraint_name = "#{table_name}_pkey"
  31           tmp_constraint_name = "#{table_name}_pkey_tmp"
  32
  33           options = options.merge(:name => tmp_constraint_name, :unique => true)
  34
  35           add_index(table_name, column_name, **options)
  36           remove_primary_key table_name
  37           set_primary_key table_name, tmp_constraint_name
  38           rename_index table_name, tmp_constraint_name, constraint_name
  39         end
  40
  41         def set_primary_key(table_name, constraint_name)
  42           constraint_name = quote_table_name(constraint_name)
  43           table_name = quote_table_name(table_name)
  44
  45           execute "ALTER TABLE #{table_name} ADD PRIMARY KEY USING INDEX #{constraint_name}"
  46         end
  47       end
  48     end
  49   end
  50
  51   ActiveRecord::ConnectionAdapters::PostgreSQL::Quoting.prepend(OpenStreetMap::PostgreSQL::Quoting)
  52   ActiveRecord::ConnectionAdapters::PostgreSQL::SchemaStatements.prepend(OpenStreetMap::PostgreSQL::SchemaStatements)
  53 end