Contents

Sequel.migration do
  up do
    [:transformations, :transformations_versions].each do |name|
      alter_table(name) do
        rename_column(:field_id, :source_field_id)
        add_column(:result_field_id, Integer)
        add_column(:position, Integer)
      end
      self[name].update(:result_field_id => :source_field_id)

      position = nil
      last_resource_id = nil
      self[name].order(:id).each do |record|
        if record[:resource_id] != last_resource_id
          position = 0
          last_resource_id = record[:resource_id]
        end
        position += 1
        self[name].filter(:id => record[:id]).update(:position => position)
      end
    end
  end

  down do
    [:transformations, :transformations_versions].each do |name|
      alter_table(name) do
        rename_column(:source_field_id, :field_id)
        drop_column(:result_field_id)
        drop_column(:position)
      end
    end
  end
end

Version data entries

8 entries across 8 versions & 1 rubygems

Version	Path
coupler-0.0.9-java	db/migrate/008_add_result_field_to_transformations.rb
coupler-0.0.8-java	db/migrate/008_add_result_field_to_transformations.rb
coupler-0.0.7-java	db/migrate/008_add_result_field_to_transformations.rb
coupler-0.0.6-java	db/migrate/008_add_result_field_to_transformations.rb
coupler-0.0.4-java	db/migrate/008_add_result_field_to_transformations.rb
coupler-0.0.3-java	db/migrate/008_add_result_field_to_transformations.rb
coupler-0.0.2-java	db/migrate/008_add_result_field_to_transformations.rb
coupler-0.0.1-java	db/migrate/008_add_result_field_to_transformations.rb