Contents

class AddThreeStateBooleanType < ActiveRecord::Migration[5.2]
  def up
  end
  def up
    execute <<-SQL
      DO $$
        BEGIN
          IF NOT EXISTS (SELECT 1 FROM pg_type WHERE typname = 'three_state') THEN
            CREATE TYPE three_state AS ENUM ('Y', 'N', 'U');
          END IF;
        END
      $$;
    SQL
  end

  def down
    execute "DROP TYPE IF EXISTS three_state;"
  end
end

Version data entries

21 entries across 21 versions & 1 rubygems

Version	Path
better_record-0.21.2	db/migrate/20190416215152_add_three_state_boolean_type.rb