---
id: TST-ACC-PRD-041
title: Catalogue product queries
kind: integration
product_area: accounting
module: products
revision: 1
status: draft
product_intent: proposed
implementation_evidence: observed
source_sha:
  services-accounting: f47cb263875bbc0c5640fba7dae6785ec32695f8
repository: services-accounting
files:
  - modules/products/tests/integration/services/persistence/products.queries.integration.spec.js
implements:
  - ATS-ACC-PRD-003-01
environment: local
implementation_state: implemented
latest_result: not-run
latest_run_at: null
latest_run_ref: null
conformance: not-verified
estimated_minutes: 3
estimation_note: Planning estimate; no runtime measurement is claimed.
isolation: 'Suite-named local workspaces, isolated fixture records and explicit cleanup or rollback.'
evidence:
  - >-
    services-accounting:modules/products/tests/integration/services/persistence/products.queries.integration.spec.js
assertion_bindings:
  - scenario: ATS-ACC-PRD-003-01
    assertions:
      - >-
        services-accounting:modules/products/tests/integration/services/persistence/products.queries.integration.spec.js#answers
        an exactly full last page without more
    provenance: test
    source: >-
      services-accounting:modules/products/tests/integration/services/persistence/products.queries.integration.spec.js
coverage_note: Scenario references name existing assertion evidence; broader unexecuted variants remain findings.
---

# Catalogue product queries

## Verification Boundary

The suite exercises real PostgreSQL and Accounting persistence or database functions with isolated local workspace fixtures.

## What This Suite Proves

Queries map complete products and summaries, combine filters and search, and check cursor ordering and workspace isolation.

## What It Does Not Prove

Local execution does not prove deployed infrastructure, downstream purchase behavior, real domain extension completion or atomic remote-template recovery.

## Real Dependencies and Test Doubles

PostgreSQL, transaction context, constraints, foreign keys and Accounting persistence are real. The test owns its workspace fixtures and clock.

## Must Not Be Doubled

Do not double PostgreSQL, row-level security, transaction boundaries, constraints or the persistence implementation when claiming these local guarantees.