Contents

def latest_pact_publications_by_consumer_versions_v2(_connection = nil)
  "select app.*
  from latest_pact_publication_ids_for_consumer_versions lpp
  inner join all_pact_publications app
  on lpp.consumer_version_id = app.consumer_version_id
  and lpp.pact_publication_id = app.id
  and lpp.provider_id = app.provider_id"
end

# Don't need all the join keys, just pact_publication_id
def latest_pact_publications_by_consumer_versions_v3(_connection)
  "select app.*
  from latest_pact_publication_ids_for_consumer_versions lpp
  inner join all_pact_publications app
  on lpp.pact_publication_id = app.id"
end

Version data entries

45 entries across 45 versions & 1 rubygems

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