kobotoolbox / kpi / 25713831207 / 9

82%

master: 76%

push

github

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.

6914 of 12295 branches covered (56.23%)

25071 of 36796 relevant lines covered (68.14%)

0.68 hits per line