Contents

# frozen_string_literal: true
Sequel.migration do
  up do
    alter_table(:dynflow_execution_plans) do
      if @db.database_type == :mysql
        set_column_type :started_at, 'datetime(3)'
        set_column_type :ended_at, 'datetime(3)'
      end
    end

    alter_table(:dynflow_steps) do
      if @db.database_type == :mysql
        set_column_type :started_at, 'datetime(3)'
        set_column_type :ended_at, 'datetime(3)'
      end
    end

    alter_table(:dynflow_delayed_plans) do
      if @db.database_type == :mysql
        set_column_type :start_at, 'datetime(3)'
        set_column_type :start_before, 'datetime(3)'
      end
    end
  end

  down do
    alter_table(:dynflow_steps) do
      if @db.database_type == :mysql
        set_column_type :started_at, Time
        set_column_type :ended_at, Time
      end
    end

    alter_table(:dynflow_steps) do
      if @db.database_type == :mysql
        set_column_type :started_at, Time
        set_column_type :ended_at, Time
      end
    end

    alter_table(:dynflow_delayed_plans) do
      if @db.database_type == :mysql
        set_column_type :start_at, Time
        set_column_type :start_before, Time
      end
    end
  end
end

Version data entries

25 entries across 25 versions & 1 rubygems

Version	Path
dynflow-1.4.4	lib/dynflow/persistence_adapters/sequel_migrations/019_update_mysql_time_precision.rb
dynflow-1.4.3	lib/dynflow/persistence_adapters/sequel_migrations/019_update_mysql_time_precision.rb
dynflow-1.4.2	lib/dynflow/persistence_adapters/sequel_migrations/019_update_mysql_time_precision.rb
dynflow-1.4.1	lib/dynflow/persistence_adapters/sequel_migrations/019_update_mysql_time_precision.rb
dynflow-1.4.0	lib/dynflow/persistence_adapters/sequel_migrations/019_update_mysql_time_precision.rb