Sha256: 1a1fd702a07aa5fa1cde7dd6a79794700cac28eb3fa9773d4042ea705c7c2b78
Contents?: true
Size: 984 Bytes
Versions: 3
Compression:
Stored size: 984 Bytes
Contents
Sequel.migration do change do create_view(:all_pacts, "select pact.id, c.id as consumer_id, c.name as consumer_name, cv.number as consumer_version_number, cv.`order` as consumer_version_order, p.id as provider_id, p.name as provider_name, pact.json_content from pacts pact join versions cv on pact.version_id = cv.id join pacticipants c on cv.pacticipant_id = c.id join pacticipants p on pact.provider_id = p.id") create_view(:latest_pact_consumer_version_orders, "select provider_id, consumer_id, max(consumer_version_order) as latest_consumer_version_order from all_pacts group by provider_id, consumer_id" ) create_view(:latest_pacts, "select ap.* from all_pacts ap inner join latest_pact_consumer_version_orders lp on ap.consumer_id = lp.consumer_id and ap.provider_id = lp.provider_id and ap.consumer_version_order = latest_consumer_version_order" ) end end
Version data entries
3 entries across 3 versions & 1 rubygems
Version | Path |
---|---|
pact_broker-1.2.0 | db/migrations/08_create_latest_pact_view.rb |
pact_broker-1.1.0 | db/migrations/08_create_latest_pact_view.rb |
pact_broker-1.0.0 | db/migrations/08_create_latest_pact_view.rb |