github.com/anchore/syft@v1.38.2/syft/pkg/cataloger/nix/test-fixtures/image-nixos-jq-pkg-db/clean_db.sql (about)

     1  -- Delete DerivationOutputs where path is not in RequiredPaths
     2  DELETE FROM DerivationOutputs
     3  WHERE path NOT IN (SELECT path FROM RequiredPaths);
     4  
     5  -- Delete ValidPaths where path is not in RequiredPaths
     6  DELETE FROM ValidPaths
     7  WHERE path NOT IN (SELECT path FROM RequiredPaths);
     8  
     9  DELETE FROM Refs
    10  WHERE referrer NOT IN (SELECT id FROM ValidPaths WHERE path IN (SELECT path FROM RequiredPaths))
    11     OR reference NOT IN (SELECT id FROM ValidPaths WHERE path IN (SELECT path FROM RequiredPaths));
    12  
    13  
    14  -- Run VACUUM to clean up the database file
    15  VACUUM;