github.com/quay/claircore@v1.5.28/datastore/postgres/migrations/matcher/10-delete-osv.sql (about)

     1  -- Delete all update_operations for osv updater and vulns
     2  DELETE FROM update_operation WHERE updater = 'osv';
     3  
     4  DELETE FROM vuln v1 USING
     5  	vuln v2
     6  	LEFT JOIN uo_vuln uvl
     7  		ON v2.id = uvl.vuln
     8  	WHERE uvl.vuln IS NULL
     9  	AND v2.updater = 'osv'
    10  AND v1.id = v2.id;