Sha256: 5a66922716920429c2fe214fdd2a7a4def94780747b353ef1212edb7715391ea
Contents?: true
Size: 1.27 KB
Versions: 107
Compression:
Stored size: 1.27 KB
Contents
Sequel.migration do
up do
# The most recent verification for each pact_version
# provider_version column is DEPRECATED, use provider_version_number
# Think this can be replaced by latest_verification_id_for_pact_version_and_provider_version?
v = :verifications
create_or_replace_view(:latest_verifications,
from(v)
.select(
Sequel[v][:id],
Sequel[v][:number],
Sequel[v][:success],
Sequel[:s][:number].as(:provider_version),
Sequel[v][:build_url],
Sequel[v][:pact_version_id],
Sequel[v][:execution_date],
Sequel[v][:created_at],
Sequel[v][:provider_version_id],
Sequel[:s][:number].as(:provider_version_number),
Sequel[:s][:order].as(:provider_version_order),
Sequel[v][:test_results])
.join(:latest_verification_numbers,
{
Sequel[v][:pact_version_id] => Sequel[:lv][:pact_version_id],
Sequel[v][:number] => Sequel[:lv][:latest_number]
}, { table_alias: :lv })
.join(:versions,
{
Sequel[v][:provider_version_id] => Sequel[:s][:id]
}, { table_alias: :s })
)
end
down do
# do nothing - you can't drop columns from a postgres view
end
end
Version data entries
107 entries across 107 versions & 1 rubygems