Sha256: 0fcafcea5db28a33019cd0766320ea6a4805ae716cd509068acbb9e79be6c869

Contents?: true

Size: 913 Bytes

Versions: 47

Compression:

Stored size: 913 Bytes

Contents

def latest_verifications_for_pact_versions_v4(connection)
  v = :verifications
  connection.from(v)
    .select(
      Sequel[v][:id],
      Sequel[v][:number],
      Sequel[v][:success],
      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],
      Sequel[v][:consumer_id],
      Sequel[v][:provider_id],
    )
    .join(:latest_verification_ids_for_pact_versions,
      {
        Sequel[v][:pact_version_id] => Sequel[:lv][:pact_version_id],
        Sequel[v][:id] => Sequel[:lv][:latest_verification_id]
      }, { table_alias: :lv })
    .join(:versions,
      {
        Sequel[v][:provider_version_id] => Sequel[:s][:id]
      }, { table_alias: :s })
end

Version data entries

47 entries across 47 versions & 1 rubygems

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