bcgov / vc-common-service / 30112878052

72%

Build Type

push

github

Committed by web-flow

Commit Message

Operation tracking model and JSONB storage (#143)

feat(operation): add operation tracking model and JSONB storage (PE-07)

Closes #30.

Implement the Operation persistence layer that tracks async credential and
connection operations with flexible JSONB request/result storage and TTL-based
expiry.

- Add Operation entity: tenant FK (ON DELETE RESTRICT), nullable self-referential
  batch_id FK (ON DELETE CASCADE), type, state enum, request/result JSONB,
  external_id, viewed_at, expires_at, and timestamps.
- Add migration 000004_create-operation-entity with the operation_state enum,
  table, both foreign keys, and six indexes. Use a plain btree on expires_at
  instead of the spec's `WHERE expires_at < now()` predicate, since now() is not
  IMMUTABLE and Postgres rejects it in an index predicate.
- Add OperationRepository with create, save, findById, updateState, updateResult,
  findByExternalId, findByTenantWithFilters (created_at DESC cursor pagination),
  and countByBatchGroupedByState for batch aggregation.
- Add OperationService with the shared computeExpiresAt TTL helper (pending 24h,
  processing/completed-unviewed 72h, completed-viewed 1h, failed-viewed 24h,
  failed-unviewed 7d), plus createOperation (72h at creation), idempotent
  markViewed, and transitionState.
- Wire OperationModule into AppModule and register the migration in data-source.
- Add unit tests for the service (all TTL branches + orchestration) and repository.

Per-tenant TTL config and the scheduled purge job are deferred to PE-08 (#31);
operation polling endpoints are deferred to AG-02 (#76).

Signed-off-by: Gavin Jaeger-Freeborn <gavinfreeborn@gmail.com>

Coverage Stats

515 of 684 branches covered (75.29%)

Branch coverage included in aggregate %.

87 of 110 new or added lines in 7 files covered. (79.09%)

1 existing line in 1 file now uncovered.

879 of 1245 relevant lines covered (70.6%)

2.6 hits per line