public function loadPage()
{
$answer = new PonderAnswer();
$conn_r = $answer->establishConnection('r');
$data = queryfx_all($conn_r, 'SELECT a.* FROM %T a %Q %Q %Q', $answer->getTableName(), $this->buildWhereClause($conn_r), $this->buildOrderClause($conn_r), $this->buildLimitClause($conn_r));
return $answer->loadAllFromArray($data);
}
public function execute()
{
$answer = new PonderAnswer();
$conn_r = $answer->establishConnection('r');
$select = qsprintf($conn_r, 'SELECT r.* FROM %T r', $answer->getTableName());
$where = $this->buildWhereClause($conn_r);
$order_by = $this->buildOrderByClause($conn_r);
$limit = $this->buildLimitClause($conn_r);
return $answer->loadAllFromArray(queryfx_all($conn_r, '%Q %Q %Q %Q', $select, $where, $order_by, $limit));
}
<?php
$map = array();
echo pht('Merging duplicate answers by authors...') . "\n";
$atable = new PonderAnswer();
$conn_w = $atable->establishConnection('w');
$conn_w->openTransaction();
$answers = new LiskMigrationIterator(new PonderAnswer());
foreach ($answers as $answer) {
$aid = $answer->getID();
$qid = $answer->getQuestionID();
$author_phid = $answer->getAuthorPHID();
echo pht('Processing answer ID #%d...', $aid) . "\n";
if (empty($map[$qid][$author_phid])) {
echo pht('Answer is unique.') . "\n";
$map[$qid][$author_phid] = $answer;
continue;
} else {
echo pht('Merging answer.') . "\n";
$target = $map[$qid][$author_phid];
queryfx($conn_w, 'UPDATE %T SET content = %s WHERE id = %d', $target->getTableName(), $target->getContent() . "\n\n" . "---" . "\n\n" . "> (This content was automatically merged from another answer by the " . "same author.)" . "\n\n" . $answer->getContent(), $target->getID());
queryfx($conn_w, 'DELETE FROM %T WHERE id = %d', $target->getTableName(), $answer->getID());
queryfx($conn_w, 'UPDATE %T SET targetPHID = %s WHERE targetPHID = %s', 'ponder_comment', $target->getPHID(), $answer->getPHID());
}
}
$conn_w->saveTransaction();
echo pht('Done.') . "\n";
