Contents

Sequel.migration do
  change do

    # This view includes all the latest pacts, as well as the latest pacts
    # for each tag.
    # If a pact publication is the latest AND the latest tagged version
    # there will be two rows in this view for it - one for the top
    # query,and one for the bottom.
    create_view(:head_pact_publications,
      "select lp.*, null as tag_name, 1 as latest
      from latest_pact_publications lp

      UNION

      select ltp.*, null as latest
      from latest_tagged_pact_publications ltp
      "
    )

  end
end

Version data entries

143 entries across 143 versions & 1 rubygems

Version	Path
pact_broker-2.114.0	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.113.2	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.113.1	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.113.0	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.112.0	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.111.0	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.109.1	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.109.0	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.108.0	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.107.1	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.107.0	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.107.0.beta.1	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.106.0	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.105.0	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.104.0	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.103.0	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.102.2	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.102.1	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.102.0	db/migrations/20180122_create_head_pact_publications.rb
pact_broker-2.101.0	db/migrations/20180122_create_head_pact_publications.rb