Contents

class AddIsoAndIso3ValidationOnPresenceAndUniqueness < ActiveRecord::Migration[5.2]
  def up
    Spree::Country.where.not(id: Spree::Country.group(:iso).select("min(id)")).destroy_all
    Spree::Country.where.not(id: Spree::Country.group(:iso3).select("min(id)")).destroy_all

    change_column_null(:spree_countries, :iso, false)
    change_column_null(:spree_countries, :iso3, false)
    add_index :spree_countries, :iso, unique: true
    add_index :spree_countries, :iso3, unique: true
  end

  def down
    change_column_null(:spree_countries, :iso, true)
    change_column_null(:spree_countries, :iso3, true)
    remove_index :spree_countries, :iso, unique: true
    remove_index :spree_countries, :iso3, unique: true
  end
end

Version data entries

57 entries across 57 versions & 1 rubygems

Version	Path
spree_core-4.0.9	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.1.15	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.2.7	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.3.3	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.2.6	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.3.2	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.3.1	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.3.0	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.3.0.rc3	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.3.0.rc2	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.3.0.rc1	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.2.5	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.1.14	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.0.8	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.2.4	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.2.3.1	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.1.13.1	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.0.7.1	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.2.3	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb
spree_core-4.2.2	db/migrate/20190305121659_add_iso_and_iso3_validation_on_presence_and_uniqueness.rb