Page MenuHomePhabricator
Differential D19814

Continue cleaning up queries in the wake of changes to "%Q"
ClosedPublic
Actions

Authored by epriestley on Nov 15 2018, 2:00 PM.
Tags
None
Referenced Files
F13213716: D19814.diff
Fri, May 17, 8:01 AM
F13199582: D19814.diff
Mon, May 13, 4:07 PM
F13199574: D19814.diff
Mon, May 13, 3:59 PM
Unknown Object (File)
Tue, May 7, 9:20 AM
Unknown Object (File)
Mon, May 6, 12:11 PM
Unknown Object (File)
Sat, May 4, 6:59 AM
Unknown Object (File)
Sun, Apr 21, 3:55 PM
Unknown Object (File)
Fri, Apr 19, 8:07 PM
View All Files
Subscribers
yelirekim

Details

Reviewers
amckinley
Maniphest Tasks
T13216: 2018 Week 45-47 Bonus Content
T13217: Upgrading: Hardening of qsprintf()
Commits
rP933462b4873b: Continue cleaning up queries in the wake of changes to "%Q"
Summary

Depends on D19810. Ref T13217. Ref T13216. I mostly used grep implode | grep OR and grep implode | grep AND to find these -- not totally exhaustive but should be a big chunk of the callsites that are missing %LO / %LA.

Test Plan

These are tricky to test exhaustively, but I made an attempt to hit most of them:

  • Browsed Almanac interfaces.
  • Created/browsed Calendar events.
  • Enabled/disabled/showed the lock log.
  • Browsed repositories.
  • Loaded Facts UI.
  • Poked at Multimeter.
  • Used typeahead for users and projects.
  • Browsed Phriction.
  • Ran various fulltext searches.

Not sure these are reachable:

  • All the lint stuff might be dead/unreachable/nonfunctional?

Diff Detail

Repository
rP Phabricator
Lint
Lint Not Applicable
Unit
Tests Not Applicable

Event Timeline

epriestley created this revision.Nov 15 2018, 2:00 PM
Herald added a subscriber: yelirekim. · View Herald TranscriptNov 15 2018, 2:00 PM
Harbormaster completed remote builds in B21165: Diff 47316.Nov 15 2018, 2:02 PM
epriestley requested review of this revision.Nov 15 2018, 2:02 PM
epriestley added a child revision: D19816: Unify intracluster sync and Drydock working copy construction timeouts as a repository "copy time limit".Nov 16 2018, 5:19 PM
amckinley accepted this revision.Nov 16 2018, 7:36 PM
amckinley added inline comments.
src/infrastructure/query/policy/PhabricatorCursorPagedPolicyAwareQuery.php
1749

We clearly need an`%L+` operator for this extremely common pattern.

This revision is now accepted and ready to land.Nov 16 2018, 7:36 PM
epriestley added a comment.Nov 16 2018, 8:41 PM

Haha, yeah. Differential had one UNION ALL too but %LU seemed a little ridiculous.

MySQL has a SUM() function but it only works on aggregates and I couldn't find any way to express this as ADD_THESE_UP(%LQ).

Closed by commit rP933462b4873b: Continue cleaning up queries in the wake of changes to "%Q" (authored by epriestley). · Explain WhyNov 16 2018, 8:49 PM
This revision was automatically updated to reflect the committed changes.

Revision Contents
Changeset List

PathSize
src/
applications/
almanac/
query/
2 lines
calendar/
query/
4 lines
daemon/
management/
4 lines
diffusion/
8 lines
conduit/
4 lines
controller/
12 lines
query/
4 lines
fact/
query/
4 lines
multimeter/
controller/
8 lines
packages/
query/
2 lines
people/
query/
2 lines
phrequent/
query/
4 lines
phriction/
query/
8 lines
project/
query/
2 lines
infrastructure/
query/
policy/
35 lines

Diff 47329

View Options

src/applications/almanac/query/AlmanacInterfaceQuery.php

Loading...
View Options

src/applications/calendar/query/PhabricatorCalendarEventQuery.php

Loading...
View Options

src/applications/daemon/management/PhabricatorLockLogManagementWorkflow.php

Loading...
View Options

src/applications/diffusion/DiffusionLintSaveRunner.php

Loading...
View Options

src/applications/diffusion/conduit/DiffusionBrowseQueryConduitAPIMethod.php

Loading...
View Options

src/applications/diffusion/controller/DiffusionLintController.php

Loading...
View Options

src/applications/diffusion/query/DiffusionCachedResolveRefsQuery.php

Loading...
View Options

src/applications/fact/query/PhabricatorFactDatapointQuery.php

Loading...
View Options

src/applications/multimeter/controller/MultimeterSampleController.php

Loading...
View Options

src/applications/packages/query/PhabricatorPackagesQuery.php

Loading...
View Options

src/applications/people/query/PhabricatorPeopleQuery.php

Loading...
View Options

src/applications/phrequent/query/PhrequentUserTimeQuery.php

Loading...
View Options

src/applications/phriction/query/PhrictionDocumentQuery.php

Loading...
View Options

src/applications/project/query/PhabricatorProjectQuery.php

Loading...
View Options

src/infrastructure/query/policy/PhabricatorCursorPagedPolicyAwareQuery.php

Loading...
Phabricator · Built by Phacility