Finalize the batched background migration BackfillHasVulnerabilityResolutionCwe78Cwe89
Why are we doing this work
We support resolving certain vulnerabilities via the "Resolve with AI" feature in the vulnerability details view. This is based on a predefined list of supported CWEs.
As part of this effort, we have added support for, see :
- CWE-78: OS Command Injection
- CWE-89: SQL Injection
To support this feature, the column, has_vulnerability_resolution, in the vulnerabilities table, flags whether a given vulnerability is eligible for AI-based resolution based on this list.
We implemented a batched background migration BackfillHasVulnerabilityResolutionCwe78Cwe89 to backfill this column with the correct values, see !188420 (merged).
Now, the final step is to finalise the batched background migration to avoid technical debt and ensure the system remains in a consistent state.
Implementation plan
backend database finalise the batched background migration according to docs