Sha256: 2e45b67d374d506167e49206d635e9ee098ffb80f7814b4f33c32a1c2869de83
Contents?: true
Size: 1.2 KB
Versions: 123
Compression:
Stored size: 1.2 KB
Contents
Sequel.migration do
up do
create_or_replace_view(:latest_verification_ids_for_consumer_version_tags,
"select
v.provider_id,
v.consumer_id,
t.name as consumer_version_tag_name,
max(v.verification_id) as latest_verification_id
from latest_verification_id_for_pact_version_and_provider_version v
join latest_pact_publication_ids_for_consumer_versions lpp
on v.pact_version_id = lpp.pact_version_id
join tags t
on lpp.consumer_version_id = t.version_id
group by v.provider_id, v.consumer_id, t.name")
end
down do
# The latest verification id for each consumer version tag
create_or_replace_view(:latest_verification_ids_for_consumer_version_tags,
"select
pv.pacticipant_id as provider_id,
lpp.consumer_id,
t.name as consumer_version_tag_name,
max(v.id) as latest_verification_id
from verifications v
join latest_pact_publications_by_consumer_versions lpp
on v.pact_version_id = lpp.pact_version_id
join tags t
on lpp.consumer_version_id = t.version_id
join versions pv
on v.provider_version_id = pv.id
group by pv.pacticipant_id, lpp.consumer_id, t.name")
end
end
Version data entries
123 entries across 123 versions & 1 rubygems