Contents

Sequel.migration do
  up do
    latest_version_orders = from(:versions)
                              .select_group(:pacticipant_id)
                              .select_append{ max(order).as(latest_version_order) }

    create_or_replace_view(:latest_version_orders, latest_version_orders)

    join = {
      Sequel[:versions][:pacticipant_id] => Sequel[:latest_version_orders][:pacticipant_id],
      Sequel[:versions][:order] => Sequel[:latest_version_orders][:latest_version_order]
    }

    latest_versions = from(:versions)
      .select(Sequel[:versions].*)
      .join(:latest_version_orders, join)

    create_or_replace_view(:latest_versions, latest_versions)
  end

  down do
    drop_view(:latest_versions)
    drop_view(:latest_version_orders)
  end
end

Version data entries

85 entries across 85 versions & 1 rubygems

Version	Path
pact_broker-2.113.0	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.112.0	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.111.0	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.109.1	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.109.0	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.108.0	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.107.1	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.107.0	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.107.0.beta.1	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.106.0	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.105.0	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.104.0	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.103.0	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.102.2	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.102.1	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.102.0	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.101.0	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.100.0	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.99.0	db/migrations/20180828_create_latest_versions.rb
pact_broker-2.98.0	db/migrations/20180828_create_latest_versions.rb