Sha256: 637935468e1bd1dadb84141c2351af6392e5b191f96be77823fae41fff35d76e
Contents?: true
Size: 1.8 KB
Versions: 23
Compression:
Stored size: 1.8 KB
Contents
Sequel.migration do
up do
# Latest pact_publication details for each provider/consumer version
create_or_replace_view(:latest_pact_publications_by_consumer_versions,
"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"
)
# Latest consumer version order for consumer/provider
# Recreate latest_pact_publication_ids_for_consumer_versions view
lpp = :latest_pact_publication_ids_for_consumer_versions
latest_pact_consumer_version_orders = from(lpp).select_group(
Sequel[lpp][:provider_id],
Sequel[:cv][:pacticipant_id].as(:consumer_id))
.select_append{ max(order).as(latest_consumer_version_order) }
.join(:versions, { Sequel[lpp][:consumer_version_id] => Sequel[:cv][:id] }, { table_alias: :cv })
create_or_replace_view(:latest_pact_consumer_version_orders, latest_pact_consumer_version_orders)
end
down do
# Latest pact_publication details for each provider/consumer version
create_or_replace_view(:latest_pact_publications_by_consumer_versions,
"select app.*
from all_pact_publications app
inner join latest_pact_publication_revision_numbers lr
on app.consumer_id = lr.consumer_id
and app.provider_id = lr.provider_id
and app.consumer_version_order = lr.consumer_version_order
and app.revision_number = lr.latest_revision_number"
)
create_or_replace_view(:latest_pact_consumer_version_orders,
"select provider_id, consumer_id, max(consumer_version_order) as latest_consumer_version_order
from all_pact_publications
group by provider_id, consumer_id"
)
end
end
Version data entries
23 entries across 23 versions & 1 rubygems