Sha256: 93869c6905f69fa862b99b437ed047cb2e16db0cdb43c391a3f7308a80443b01

Contents?: true

Size: 865 Bytes

Versions: 36

Compression:

Stored size: 865 Bytes

Contents

def all_verifications_v2(connection)
  # Need to fully qualify build_url because versions now has a build_url too.
  # We don't use this view any more but we get an error when modifying other tables and views
  # if we don't update this, so it must force some re-calculation to be done.
  # See https://github.com/pact-foundation/pact_broker/issues/521
  connection
    .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),
      Sequel[:verifications][:build_url],
      :pact_version_id,
      :execution_date,
      Sequel[:verifications][:created_at],
      :test_results
    ).join(:versions, { id: :provider_version_id }, { :table_alias => :v })
end

Version data entries

36 entries across 36 versions & 1 rubygems

Version Path
pact_broker-2.114.0 db/ddl_statements/all_verifications.rb
pact_broker-2.113.2 db/ddl_statements/all_verifications.rb
pact_broker-2.113.1 db/ddl_statements/all_verifications.rb
pact_broker-2.113.0 db/ddl_statements/all_verifications.rb
pact_broker-2.112.0 db/ddl_statements/all_verifications.rb
pact_broker-2.111.0 db/ddl_statements/all_verifications.rb
pact_broker-2.109.1 db/ddl_statements/all_verifications.rb
pact_broker-2.109.0 db/ddl_statements/all_verifications.rb
pact_broker-2.108.0 db/ddl_statements/all_verifications.rb
pact_broker-2.107.1 db/ddl_statements/all_verifications.rb
pact_broker-2.107.0 db/ddl_statements/all_verifications.rb
pact_broker-2.107.0.beta.1 db/ddl_statements/all_verifications.rb
pact_broker-2.106.0 db/ddl_statements/all_verifications.rb
pact_broker-2.105.0 db/ddl_statements/all_verifications.rb
pact_broker-2.104.0 db/ddl_statements/all_verifications.rb
pact_broker-2.103.0 db/ddl_statements/all_verifications.rb
pact_broker-2.102.2 db/ddl_statements/all_verifications.rb
pact_broker-2.102.1 db/ddl_statements/all_verifications.rb
pact_broker-2.102.0 db/ddl_statements/all_verifications.rb
pact_broker-2.101.0 db/ddl_statements/all_verifications.rb