Differential D19869 Diff 47449 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 |