Contents

Sequel.migration do
  up do
    # provider_version is DEPRECATED, use provider_version_number
    create_or_replace_view(:all_verifications,
      from(:verifications).select(
        Sequel[:verifications][:id],
        Sequel[:verifications][:number],
        :success,
        :provider_version_id,
        Sequel[:v][:number].as(:provider_version_number),
        Sequel[:v][:order].as(:provider_version_order),
        :build_url,
        :pact_version_id,
        :execution_date,
        Sequel[:verifications][:created_at]
        ).join(:versions, {id: :provider_version_id}, {:table_alias => :v})
    )
  end

  down do
    drop_view(:all_verifications)
  end
end

Version data entries

152 entries across 152 versions & 1 rubygems

Version	Path
pact_broker-2.96.0	db/migrations/000047_create_all_verifications.rb
pact_broker-2.95.1	db/migrations/000047_create_all_verifications.rb
pact_broker-2.95.0	db/migrations/000047_create_all_verifications.rb
pact_broker-2.94.0	db/migrations/000047_create_all_verifications.rb
pact_broker-2.93.4	db/migrations/000047_create_all_verifications.rb
pact_broker-2.93.3	db/migrations/000047_create_all_verifications.rb
pact_broker-2.93.2	db/migrations/000047_create_all_verifications.rb
pact_broker-2.93.1	db/migrations/000047_create_all_verifications.rb
pact_broker-2.93.0	db/migrations/000047_create_all_verifications.rb
pact_broker-2.92.0	db/migrations/000047_create_all_verifications.rb
pact_broker-2.91.0	db/migrations/000047_create_all_verifications.rb
pact_broker-2.90.0	db/migrations/000047_create_all_verifications.rb
pact_broker-2.89.1	db/migrations/000047_create_all_verifications.rb
pact_broker-2.89.0	db/migrations/000047_create_all_verifications.rb
pact_broker-2.88.0	db/migrations/000047_create_all_verifications.rb
pact_broker-2.87.0	db/migrations/000047_create_all_verifications.rb
pact_broker-2.86.0	db/migrations/000047_create_all_verifications.rb
pact_broker-2.85.1	db/migrations/000047_create_all_verifications.rb
pact_broker-2.85.0	db/migrations/000047_create_all_verifications.rb
pact_broker-2.84.0	db/migrations/000047_create_all_verifications.rb