Skip to content

Logic to reset archived column of vulnerability_reads

Gregory Havenga (is on PTO from 19 July to 30 July) requested to merge 437669-implement-logic-to-reset-traversal_ids-and-archived-columns-of-the-vulnerability_reads-table into master

What does this MR do and why?

This MR uses a feature flag to safely implement the tethering of project archival events to the updating of the denormalised archived column on the vulnerability_reads table so that these values are synced appropriately.

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

How to set up and validate locally

  1. Enable update_vuln_reads_archived_via_event
  2. Archive a project
  3. Use the rails console to check that all Vulnerability::Read records associated with the project have their archived value set to true.
  4. Unarchive the project
  5. Confirm that the Read records archived value is all false.

Related to #437669 (closed)

Edited by Gregory Havenga (is on PTO from 19 July to 30 July)

Merge request reports