diff --git a/resources/sql/patches/20131118.ownerorder.php b/resources/sql/patches/20131118.ownerorder.php index 61192c8c2..35433f8e1 100644 --- a/resources/sql/patches/20131118.ownerorder.php +++ b/resources/sql/patches/20131118.ownerorder.php @@ -1,38 +1,42 @@ <?php $table = new ManiphestTask(); $conn_w = $table->establishConnection('w'); +$user_table = new PhabricatorUser(); +$user_conn = $user_table->establishConnection('r'); + foreach (new LiskMigrationIterator($table) as $task) { $id = $task->getID(); echo "Checking task T{$id}...\n"; $owner_phid = $task->getOwnerPHID(); if (!$owner_phid && !$task->getOwnerOrdering()) { // No owner and no ordering; we're all set. continue; } - $owner_handle = id(new PhabricatorHandleQuery()) - ->setViewer(PhabricatorUser::getOmnipotentUser()) - ->withPHIDs(array($owner_phid)) - ->executeOne(); + $owner_row = queryfx_one( + $user_conn, + 'SELECT * FROM %T WHERE phid = %s', + $user_table->getTableName(), + $owner_phid); - if ($owner_handle) { - $value = $owner_handle->getName(); + if ($owner_row) { + $value = $owner_row['userName']; } else { $value = null; } if ($value !== $task->getOwnerOrdering()) { queryfx( $conn_w, 'UPDATE %T SET ownerOrdering = %ns WHERE id = %d', $table->getTableName(), $value, $task->getID()); } } echo "Done.\n";