kobotoolbox / kpi / 25713831207

82%

master: 76%

Build Type

push

github

Committed by web-flow

Commit Message

feat(nlp): add models for subsequence bulk action and item tracking  DEV-1421 (#7043)

### 📣 Summary
This PR introduces the database tables required to support bulk
transcription and translation jobs within the subsequences app.

### 📖 Description
This PR implements the models necessary for orchestrating and tracking
bulk processing tasks.

- `SubsequenceBulkAction`: A parent model is created to represent a
batch execution, storing deterministic parameters and global status.

- `SubsequenceBulkActionItem`: A child model is implemented to track
individual submission processing within a bulk job, including an
external `service_id` for tracking Google operations.

- Idempotency via Hashing: A deterministic SHA-256 hash of job
parameters is utilized to prevent duplicate active jobs for the same
submission and action.

- Integrity Guarantees: Atomic creation logic is provided via
`create_with_items`, and status propagation is implemented to
synchronize parent and child states.

- Database Constraints: A `UniqueConstraint` is enforced to ensure only
one active job item exists per submission/action/hash combination.

Coverage Stats

9147 of 12311 branches covered (74.3%)

45 of 72 new or added lines in 1 file covered. (62.5%)

30 existing lines in 2 files now uncovered.

30147 of 36796 relevant lines covered (81.93%)

5.75 hits per line