class Object
Public Instance Methods
from_uuid(table_name, column_name)
click to toggle source
# File lib/dynflow/persistence_adapters/sequel_migrations/011_add_uuid_column.rb, line 5 def from_uuid(table_name, column_name) set_column_type table_name, column_name, String, primary_key: true, size: 36, fixed: true end
to_uuid(table_name, column_name)
click to toggle source
# File lib/dynflow/persistence_adapters/sequel_migrations/011_add_uuid_column.rb, line 1 def to_uuid(table_name, column_name) set_column_type(table_name, column_name, :uuid, :using => "#{column_name}::uuid") end
with_foreign_key_recreation(&block)
click to toggle source
# File lib/dynflow/persistence_adapters/sequel_migrations/011_add_uuid_column.rb, line 9 def with_foreign_key_recreation(&block) # Drop the foreign key constraints so we can change the column type alter_table :dynflow_actions do drop_foreign_key [:execution_plan_uuid] end alter_table :dynflow_steps do drop_foreign_key [:execution_plan_uuid] drop_foreign_key [:execution_plan_uuid, :action_id], :name => :dynflow_steps_execution_plan_uuid_fkey1 end alter_table :dynflow_delayed_plans do drop_foreign_key [:execution_plan_uuid] end block.call # Recreat the foreign key constraints as they were before alter_table :dynflow_actions do add_foreign_key [:execution_plan_uuid], :dynflow_execution_plans end alter_table :dynflow_steps do add_foreign_key [:execution_plan_uuid], :dynflow_execution_plans add_foreign_key [:execution_plan_uuid, :action_id], :dynflow_actions, :name => :dynflow_steps_execution_plan_uuid_fkey1 end alter_table :dynflow_delayed_plans do add_foreign_key [:execution_plan_uuid], :dynflow_execution_plans, :name => :dynflow_scheduled_plans_execution_plan_uuid_fkey end end