Page MenuHomeSoftware Heritage

storage: Refactor OriginVisitStatus instantiation
ClosedPublic

Authored by ardumont on Feb 4 2021, 5:41 PM.

Details

Diff Detail

Repository
rDSTO Storage manager
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 D5021 (id=17898)

Could not rebase; Attempt merge onto 9a9f234e0a...

Updating 9a9f234e..abb7184d
Fast-forward
 sql/upgrades/167.sql              | 11 +++++++++++
 swh/storage/backfill.py           | 10 ++--------
 swh/storage/postgresql/db.py      | 18 ++++++------------
 swh/storage/postgresql/storage.py | 31 ++++++-------------------------
 swh/storage/sql/30-schema.sql     |  4 ++--
 5 files changed, 27 insertions(+), 47 deletions(-)
 create mode 100644 sql/upgrades/167.sql
Changes applied before test
commit abb7184dc49cdd35d57d7f357ea76357b5745f73
Author: Antoine R. Dumont (@ardumont) <ardumont@softwareheritage.org>
Date:   Thu Feb 4 17:16:57 2021 +0100

    storage: Refactor OriginVisitStatus instantiation

commit 4b4f423bf571ce3c625c5feb1733b189e1a25877
Author: Antoine R. Dumont (@ardumont) <ardumont@softwareheritage.org>
Date:   Thu Feb 4 17:11:18 2021 +0100

    db: Unify sql joins on origin_visit_status using "USING"

commit 3ad3ac12d46285bb1befd91806f4986b74da7812
Author: Antoine R. Dumont (@ardumont) <ardumont@softwareheritage.org>
Date:   Thu Feb 4 17:08:33 2021 +0100

    storage.postgresql: Use origin_visit_status.type value as source
    
    This stops using the origin_visit.type as fallback values as now, the database has been
    migrated.
    
    So this makes the origin_visit_status.type a not nullable column.
    
    This also drops now redundant join instructions on origin_visit table when reading.
    
    Related to T2968

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

This revision is now accepted and ready to land.Feb 4 2021, 6:12 PM

Build was aborted

Patch application report for D5021 (id=17911)

Could not rebase; Attempt merge onto efd8815b89...

Updating efd8815b..89cf1e51
Fast-forward
 sql/upgrades/167.sql              | 11 +++++++++++
 swh/storage/backfill.py           | 10 ++--------
 swh/storage/postgresql/db.py      | 18 ++++++------------
 swh/storage/postgresql/storage.py | 31 ++++++-------------------------
 swh/storage/sql/30-schema.sql     |  4 ++--
 5 files changed, 27 insertions(+), 47 deletions(-)
 create mode 100644 sql/upgrades/167.sql
Changes applied before test
commit 89cf1e51cbbc01d61c159dcd24f98f4afd834953
Author: Antoine R. Dumont (@ardumont) <ardumont@softwareheritage.org>
Date:   Thu Feb 4 17:16:57 2021 +0100

    storage: Refactor OriginVisitStatus instantiation

commit 37df1a5c75a5cd7528b9f155cb184e9b5a6d1cfa
Author: Antoine R. Dumont (@ardumont) <ardumont@softwareheritage.org>
Date:   Thu Feb 4 17:11:18 2021 +0100

    db: Unify sql joins on origin_visit_status using "USING"

commit 67bc71ddd9d59a21fb4e5270f29d9cb67d0f711a
Author: Antoine R. Dumont (@ardumont) <ardumont@softwareheritage.org>
Date:   Thu Feb 4 17:08:33 2021 +0100

    storage.postgresql: Use origin_visit_status.type value as source
    
    This stops using the origin_visit.type as fallback values as now, the database has been
    migrated.
    
    So this makes the origin_visit_status.type a not nullable column.
    
    This also drops now redundant join instructions on origin_visit table when reading.
    
    Related to T2968

Link to build: https://jenkins.softwareheritage.org/job/DSTO/job/tests-on-diff/1133/
See console output for more information: https://jenkins.softwareheritage.org/job/DSTO/job/tests-on-diff/1133/console

Build is green

Patch application report for D5021 (id=18009)

Could not rebase; Attempt merge onto 046fe57c15...

Updating 046fe57c..e0e88b2f
Fast-forward
 swh/storage/postgresql/db.py      | 12 ++++--------
 swh/storage/postgresql/storage.py | 31 ++++++-------------------------
 2 files changed, 10 insertions(+), 33 deletions(-)
Changes applied before test
commit e0e88b2f579ea73132af04eff32ae32a95cb3a2f
Author: Antoine R. Dumont (@ardumont) <ardumont@softwareheritage.org>
Date:   Thu Feb 4 17:16:57 2021 +0100

    storage: Refactor OriginVisitStatus instantiation

commit d30ca93839655c1d1310a529dc8df3568afcab2f
Author: Antoine R. Dumont (@ardumont) <ardumont@softwareheritage.org>
Date:   Thu Feb 4 17:11:18 2021 +0100

    db: Unify sql joins on origin_visit_status using "USING"

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