---
id: TST-PFM-DJE-134
title: File job persistence queries
kind: integration
product_area: platform
module: data-job-engine
revision: 1
status: draft
source_sha:
  services-platform: ad3f6a6582843008ed0f5a17b131878d15829af1
  macroservice-libraries: 54536a441935c6e09fdb7f96f0bec71c52ba4e03
  services-crm: a8d1364f1dd44b723bb5f9acba12f983e9ec8d69
  services-membership: 5994c270e8a37a30f848e99ba5b5ee6b87c08893
  react-console: baf6dae382d6f41dce976c7f848667ccc37e076f
repository: services-crm
files:
  - >-
    modules/data-jobs/tests/integration/services/persistence/bulk-data-jobs.queries.integration.spec.js
implements: []
environment: local
implementation_state: implemented
latest_result: not-run
latest_run_at: null
latest_run_ref: null
conformance: not-verified
estimated_minutes: 5
isolation: >-
  Suite-owned fixture records, job identifiers and workspace contexts; teardown removes the fixture
  data.
evidence:
  - >-
    services-crm:modules/data-jobs/tests/integration/services/persistence/bulk-data-jobs.queries.integration.spec.js
assertion_inventory:
  - reading the bulk jobs admission contends with
  - 'plans two batches for each job, so the counts below are of real batches'
  - >-
    lists both tenants’ open executions from one tenant’s context, each with its tenant and its data
    job
  - 'counts the admitted job’s one batch in flight and one waiting, with its submission instant'
  - >-
    counts the other tenant’s job with both batches waiting and none in flight, and since when it
    has waited, in that tenant
  - 'counts nothing of another tenant’s job named from this tenant, though that tenant counts it'
  - answers no counts for no jobs without a statement
registration_note: Registration describes existing source; the suite is not executed by this documentation job.
---

# File job persistence queries

## Verification Boundary

The suite checks the production service or shared engine against its database fixture. The structured assertion inventory records the checks present at the pinned revision.

## What This Suite Proves

The existing checks exercise file job persistence queries. The specification bindings identify the narrower outcomes supported by those assertions.

## What It Does Not Prove

Local execution does not establish deployed queue, storage or service behavior. Independent test cases do not establish a complete cross-feature process.

## Real Dependencies and Test Doubles

The owning service exercises production persistence and domain behavior against real Postgres. The fixture supplies caller contexts; queue delivery, storage and external calls are doubled where the file installs a test port.

## Must Not Be Doubled

The database effects, security context and production operation under examination remain real. Their outcomes cannot be replaced with canned success responses.