public function testDeleteMessage()
{
$uniq = mt_rand();
$queue = 'test_queue';
$message1 = $this->getTestMessage($uniq);
// Store a second message for a good time, and make sure we delete the
// right one.
$message2 = $this->getTestMessage($uniq);
$this->db->storeMessage($message1, $queue);
// store message 2 with a
$this->db->storeMessage($message2, $queue);
// Confirm work without using the API.
$pdo = $this->db->getDatabase();
$result = $pdo->query("\n\t\t\tSELECT * FROM damaged\n\t\t\tWHERE gateway='test'\n\t\t\t\tAND order_id = '{$message1['order_id']}'");
$rows = $result->fetchAll(PDO::FETCH_ASSOC);
$this->assertEquals(2, count($rows), 'Both records were stored.');
$this->assertNotNull($rows[0]['id'], 'Record includes a primary row id');
$this->assertNotEquals($rows[0]['id'], $rows[1]['id'], 'Records have unique primary ids');
$message2['damaged_id'] = $rows[1]['id'];
$this->db->deleteMessage($message2);
// Confirm work without using the API.
$pdo = $this->db->getDatabase();
$result = $pdo->query("\n\t\t\tSELECT * FROM damaged\n\t\t\tWHERE gateway='test'\n\t\t\t\tAND order_id = '{$message1['order_id']}'");
$rowsAfter = $result->fetchAll(PDO::FETCH_ASSOC);
$this->assertEquals(1, count($rowsAfter), 'Not only one row deleted.');
$this->assertEquals($rowsAfter[0]['id'], $rows[0]['id'], 'Deleted the wrong row.');
}
/**
* Do the actual work of the script.
*/
public function execute()
{
$this->damagedDatabase = DamagedDatabase::get();
$messages = $this->damagedDatabase->fetchRetryMessages($this->getOption('max-messages'));
$stats = array();
$config = Configuration::getDefaultConfig();
foreach ($messages as $message) {
$queueName = $message['original_queue'];
// FIXME: getting it by alias, this will be annoying cos -new
$queue = BaseQueueConsumer::getQueue($queueName);
unset($message['original_queue']);
$queue->push($message);
$this->damagedDatabase->deleteMessage($message);
if (isset($stats[$queueName])) {
$stats[$queueName]++;
} else {
$stats[$queueName] = 1;
}
}
foreach ($stats as $queueName => $count) {
Logger::info("Requeued {$count} messages to {$queueName}.");
}
}