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.79.1	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.79.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.78.1	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.78.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.77.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.76.2	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.76.1	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.76.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.75.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.74.1	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.74.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.73.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.72.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.71.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.70.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.69.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.68.1	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.68.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.67.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb
pact_broker-2.66.0	db/ddl_statements/latest_pact_publications_by_consumer_versions.rb