Contents

class UseUuid < ActiveRecord::Migration[5.0]
  # PostgreSQL has a special column type for storing UUIDs.
  # Using this type instead of generic string should lead to having
  #  smaller DB and possibly better overall performance.
  def up
    if on_postgresql?
      change_table :foreman_tasks_tasks do |t|
        t.change :id, :uuid, :using => 'id::uuid'
        t.change :parent_task_id, :uuid, :using => 'parent_task_id::uuid'
      end

      change_table :foreman_tasks_task_group_members do |t|
        t.change :task_id, :uuid, :using => 'task_id::uuid'
      end

      change_table :foreman_tasks_locks do |t|
        t.change :task_id, :uuid, :using => 'task_id::uuid'
      end
    end
  end

  def down
    if on_postgresql?
      change_table :foreman_tasks_tasks do |t|
        t.change :id, :string
        t.change :parent_task_id, :string
      end

      change_table :foreman_tasks_task_group_members do |t|
        t.change :task_id, :string
      end

      change_table :foreman_tasks_locks do |t|
        t.change :task_id, :string
      end
    end
  end

  private

  def on_postgresql?
    ActiveRecord::Base.connection.adapter_name == 'PostgreSQL'
  end
end

Version data entries

108 entries across 108 versions & 1 rubygems

Version	Path
foreman-tasks-8.1.2	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-8.1.1	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-8.1.0	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-8.0.2	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-8.0.1	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-8.0.0	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-7.2.1	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-7.1.1	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-7.2.0	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-7.1.0	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-6.0.3	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-7.0.0	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-6.0.2	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-4.1.6	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-5.2.3	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-6.0.1	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-5.2.2	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-6.0.0	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-5.2.1	db/migrate/20180216092715_use_uuid.rb
foreman-tasks-5.3.0	db/migrate/20180216092715_use_uuid.rb