Contents

class AddGoogleToIdentityProviderServiceEnum < ActiveRecord::Migration[6.0]
  disable_ddl_transaction!

  def up
    execute <<-SQL
      ALTER TYPE identity_provider_service ADD VALUE 'GOOGLE';
    SQL
  end
  
  def down
    execute <<~SQL
      CREATE TYPE identity_provider_service_new AS ENUM ('AZURE', 'OKTA', 'ONELOGIN');

      -- Remove values that won't be compatible with new definition
      DELETE FROM identity_providers WHERE service = 'GOOGLE';
      
      -- Convert to new type, casting via text representation
      ALTER TABLE identity_providers 
        ALTER COLUMN service TYPE identity_provider_service_new 
          USING (service::text::identity_provider_service_new);
      
      -- and swap the types
      DROP TYPE identity_provider_service;
      
      ALTER TYPE identity_provider_service_new RENAME TO identity_provider_service;
    SQL
  end
end

Version data entries

21 entries across 21 versions & 1 rubygems

Version	Path
osso-0.0.5.pre.alpha	lib/osso/db/migrate/20200916125543_add_google_to_identity_provider_service_enum.rb