Page MenuHomePhabricator
Differential D21617

Update table schema for "AffectedPath" table
ClosedPublic
Actions

Authored by epriestley on Mar 15 2021, 10:37 PM.
Tags
None
Referenced Files
F13326556: D21617.diff
Sat, Jun 15, 7:36 AM
F13318088: D21617.diff
Thu, Jun 13, 10:13 AM
F13314436: D21617.diff
Tue, Jun 11, 8:05 PM
F13303667: D21617.diff
Sat, Jun 8, 7:04 AM
F13290457: D21617.diff
Tue, Jun 4, 6:14 PM
F13278063: D21617.diff
Fri, May 31, 6:27 PM
F13262090: D21617.diff
Mon, May 27, 1:46 AM
F13191920: D21617.diff
May 12 2024, 2:32 AM
View All Files
Subscribers
Restricted Owners Package

Details

Reviewers
None
Maniphest Tasks
T13639: Allow revisions to be queried by affected path via the API
Commits
rP01ea84029d88: Update table schema for "AffectedPath" table
Summary

Ref T13639. Make schema changes:

  • Make repositoryID nullable, for revisions with no repository.
  • Remove "epoch", which has no readers and no clear use.
  • Change the ordering of the key, since "pathID" has more unique values and no queries ever issue without it.
Test Plan
  • Ran bin/storage upgrade, got a clean schema.
  • Reindexed all revisions with an external script.
  • Reviewed index via debug UI, saw appropriate index for non-repositoy revisions.

Diff Detail

Repository
rP Phabricator
Branch
recent6
Lint
Lint Passed
Unit
Tests Passed
Build Status
Buildable 25261
Build 34868: Run Core Tests
Build 34867: arc lint + arc unit

Event Timeline

epriestley created this revision.Mar 15 2021, 10:37 PM
Owners added a subscriber: Restricted Owners Package.Mar 15 2021, 10:37 PM
Harbormaster completed remote builds in B25261: Diff 51453.Mar 15 2021, 10:38 PM
epriestley requested review of this revision.Mar 15 2021, 10:38 PM
This revision was not accepted when it landed; it landed in state Needs Review.Mar 15 2021, 11:16 PM
Closed by commit rP01ea84029d88: Update table schema for "AffectedPath" table (authored by epriestley). · Explain Why
This revision was automatically updated to reflect the committed changes.
epriestley added a commit: rP01ea84029d88: Update table schema for "AffectedPath" table.

Revision Contents
Changeset List

PathSize
resources/
sql/
autopatches/
2 lines
2 lines
src/
applications/
differential/
engine/
7 lines
storage/
8 lines

Diff 51453

View Options

resources/sql/autopatches/20210315.affectedpath.01.epoch.sql

Loading...
View Options

resources/sql/autopatches/20210315.affectedpath.02.repositoryid.sql

Loading...
View Options

src/applications/differential/engine/DifferentialAffectedPathEngine.php

Loading...
View Options

src/applications/differential/storage/DifferentialAffectedPath.php

Loading...
Phabricator · Built by Phacility