Differential D19869 Diff 47447 src/applications/diffusion/query/pathchange/DiffusionPathChangeQuery.php
Changeset View
Changeset View
Standalone View
Standalone View
src/applications/diffusion/query/pathchange/DiffusionPathChangeQuery.php
| Show All 37 Lines | protected function executeQuery() { | ||||
| $drequest = $this->getRequest(); | $drequest = $this->getRequest(); | ||||
| $repository = $drequest->getRepository(); | $repository = $drequest->getRepository(); | ||||
| $commit = $drequest->loadCommit(); | $commit = $drequest->loadCommit(); | ||||
| $conn_r = $repository->establishConnection('r'); | $conn_r = $repository->establishConnection('r'); | ||||
| $limit = ''; | |||||
| if ($this->limit) { | if ($this->limit) { | ||||
| $limit = qsprintf( | $limit = qsprintf( | ||||
| $conn_r, | $conn_r, | ||||
| 'LIMIT %d', | 'LIMIT %d', | ||||
| $this->limit + 1); | $this->limit + 1); | ||||
| } else { | |||||
| $limit = qsprintf($conn_r, ''); | |||||
| } | } | ||||
| $raw_changes = queryfx_all( | $raw_changes = queryfx_all( | ||||
| $conn_r, | $conn_r, | ||||
| 'SELECT c.*, p.path pathName, t.path targetPathName, | 'SELECT c.*, p.path pathName, t.path targetPathName, | ||||
| i.commitIdentifier targetCommitIdentifier | i.commitIdentifier targetCommitIdentifier | ||||
| FROM %T c | FROM %T c | ||||
| LEFT JOIN %T p ON c.pathID = p.id | LEFT JOIN %T p ON c.pathID = p.id | ||||
| ▲ Show 20 Lines • Show All 57 Lines • Show Last 20 Lines | |||||