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

55 entries across 55 versions & 1 rubygems

Version	Path
pact_broker-2.65.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.64.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.63.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.62.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.61.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.60.1	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.60.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.59.2	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.59.1	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.59.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.58.3	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.58.2	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.58.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.57.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.56.1	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.56.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.55.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.54.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.53.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.52.2	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb