Add by_cve_enrichment_id scope to FindingEnrichment

What does this MR do and why?

This MR adds the by_cve_enrichment_id scope to Security::FindingEnrichment.

This new scope will be used in a new worker to update MR approvals for recently updated CVE enrichments.

query

SELECT
    "security_finding_enrichments".*
FROM
    "security_finding_enrichments"
WHERE
    "security_finding_enrichments"."cve_enrichment_id" IN (1000100, 1000109, 1000113, 1000117, 1000121, 1000127, 1000128, 1000139, 1000150, 1000151, 1000154, 1000155, 1000159, 1000160, 1000161, 1000162, 1000163, 1000164, 1000168, 1000169, 1000170, 1000171, 1000172, 1000173, 1000174, 1000175, 1000176, 1000177, 1000178, 1000179, 1000181, 1000183, 1000184, 1000185, 1000186, 1000187, 1000194, 1000195, 1000198, 1000200, 1000201, 1000202, 1000204, 1000205, 1000206, 1000207, 1000216, 1000226, 1000227, 1000228, 1000231, 1000240, 1000249, 1000259, 1000269, 1000278, 1000281, 1000289, 1000290, 1000292, 1000300, 1000308, 1000310, 1000330, 1000334, 1000335, 1000487, 1000515, 1000525, 1000526, 1000530, 1000543, 1000557, 1000565, 1000569, 1000584, 1000586, 1000593, 1000617, 1000675, 1000683, 1000686, 1000687, 1000810, 1000842, 1000896, 1000897, 1000926, 1000927, 1000954, 1000955, 1000956, 1000957, 1001037, 1001040, 1001048, 1001049, 1001067, 1001078, 1001088)

https://postgres.ai/console/gitlab/gitlab-production-sec/sessions/48497/commands/145719

References

Related to: #585514

MR acceptance checklist

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

Edited by Marcos Rocha

Merge request reports

Loading