Page MenuHomeSoftware Heritage

Improve direct sql queries to the archive
ClosedPublic

Authored by aeviso on Jan 6 2022, 3:04 PM.

Details

Summary

Original directory_ls query is cleaned up to avoid retrieving
unnecesary information. Specific query is added for the case where
no file filtering by size is done.

Diff Detail

Repository
rDPROV Provenance database
Lint
Automatic diff as part of commit; lint not applicable.
Unit
Automatic diff as part of commit; unit tests not applicable.

Event Timeline

Build is green

Patch application report for D6886 (id=24972)

Rebasing onto 97816340f6...

Current branch diff-target is up to date.
Changes applied before test
commit b11c921582b4e2eddfc1f576c390794eefd7cf44
Author: Andres Ezequiel Viso <aeviso@softwareheritage.org>
Date:   Thu Jan 6 15:02:56 2022 +0100

    Improve direct sql queries to the archive
    
    Original `directory_ls` query is cleaned up to avoid retrieving
    unnecesary information. Specific query is added for the case where
    no file filtering by size is done.

See https://jenkins.softwareheritage.org/job/DPROV/job/tests-on-diff/557/ for more details.

aeviso requested review of this revision.Jan 6 2022, 3:10 PM

Build is green

Patch application report for D6886 (id=24974)

Rebasing onto 97816340f6...

Current branch diff-target is up to date.
Changes applied before test
commit da626a6edd9ecd5253b606f9f6a3993c713ed411
Author: Andres Ezequiel Viso <aeviso@softwareheritage.org>
Date:   Thu Jan 6 15:02:56 2022 +0100

    Improve direct sql queries to the archive
    
    Original `directory_ls` query is cleaned up to avoid retrieving
    unnecesary information. Specific query is added for the case where
    no file filtering by size is done.

See https://jenkins.softwareheritage.org/job/DPROV/job/tests-on-diff/558/ for more details.

olasd added a subscriber: olasd.

Great, thanks!

This revision is now accepted and ready to land.Jan 6 2022, 3:34 PM
This revision was automatically updated to reflect the committed changes.