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.');
}
/**
* @param array $message The data
* @param Exception $ex The problem
* @param int| null $retryDate If provided, retry after this timestamp
* @return int ID of message in damaged database
*/
protected function sendToDamagedStore($message, Exception $ex, $retryDate = null)
{
if ($retryDate) {
Logger::notice('Message not fully baked. Sticking it back in the oven, to ' . "retry at {$retryDate}", $message);
} else {
Logger::error('Error processing message, moving to damaged store.', $message, $ex);
}
return $this->damagedDb->storeMessage($message, $this->queueName, $ex->getMessage(), $ex->getTraceAsString(), $retryDate);
}
