Sha256: 4769d2099b1e1f2a3e495b1a83e5f2612d19277d86cc42ff09562d4b68d1532b
Contents?: true
Size: 1.53 KB
Versions: 53
Compression:
Stored size: 1.53 KB
Contents
def latest_tagged_pact_consumer_version_orders_v2(connection)
pp = :pact_publications
connection.from(pp)
.select_group(
Sequel[pp][:provider_id],
Sequel[:cv][:pacticipant_id].as(:consumer_id),
Sequel[:t][:name].as(:tag_name))
.select_append{ max(order).as(latest_consumer_version_order) }
.join(:versions, { Sequel[pp][:consumer_version_id] => Sequel[:cv][:id] }, { table_alias: :cv} )
.join(:tags, { Sequel[:t][:version_id] => Sequel[pp][:consumer_version_id] }, { table_alias: :t })
end
def latest_tagged_pact_consumer_version_orders_v3(connection)
view = Sequel.as(:latest_pact_publication_ids_for_consumer_versions, :lp)
connection.from(view)
.select_group(
Sequel[:lp][:provider_id],
Sequel[:lp][:consumer_id],
Sequel[:t][:name].as(:tag_name))
.select_append{ max(order).as(latest_consumer_version_order) }
.join(:versions, { Sequel[:lp][:consumer_version_id] => Sequel[:cv][:id] }, { table_alias: :cv} )
.join(:tags, { Sequel[:t][:version_id] => Sequel[:lp][:consumer_version_id] }, { table_alias: :t })
end
def latest_tagged_pact_consumer_version_orders_v4(connection)
view = Sequel.as(:latest_pact_publication_ids_for_consumer_versions, :lp)
connection.from(view)
.select_group(
Sequel[:lp][:provider_id],
Sequel[:lp][:consumer_id],
Sequel[:t][:name].as(:tag_name))
.select_append{ max(version_order).as(latest_consumer_version_order) }
.join(:tags, { Sequel[:t][:version_id] => Sequel[:lp][:consumer_version_id] }, { table_alias: :t })
end
Version data entries
53 entries across 53 versions & 1 rubygems