public static function getMessage($message_id)
{
global $wpdb;
if ("integer" != gettype($message_id)) {
throw new InvalidArgumentException();
}
$getAutoresponderMessageRecordQuery = sprintf("SELECT * FROM {$wpdb->prefix}wpr_autoresponder_messages WHERE id=%d", $message_id);
$results = $wpdb->get_results($getAutoresponderMessageRecordQuery);
if (0 == count($results)) {
throw new NonExistentMessageException();
}
$autoresponderId = $results[0]->aid;
if (!Autoresponder::whetherAutoresponderExists(intval($autoresponderId))) {
throw new NonExistentAutoresponderException();
}
$message = new AutoresponderMessage($results[0]);
return $message;
}
public function testDeleteAutoresponderDeletesIntendedAutoresponder()
{
global $wpdb;
$autoresponder_id = 1;
$addAutoresponderQuery = sprintf("INSERT INTO {$wpdb->prefix}wpr_autoresponders (`nid`, `id`, `name`) VALUES (%d,%d, 'Test Autoresponder')", $this->newsletterId, $autoresponder_id);
$wpdb->query($addAutoresponderQuery);
$addAutoresponderQuery = sprintf("INSERT INTO {$wpdb->prefix}wpr_autoresponders (`nid`, `id`, `name`) VALUES (%d,%d, 'Test Autoresponder2')", $this->newsletterId, 2);
$wpdb->query($addAutoresponderQuery);
$this->assertTrue(Autoresponder::whetherAutoresponderExists($autoresponder_id));
$this->assertTrue(Autoresponder::whetherAutoresponderExists(2));
Autoresponder::delete(Autoresponder::getAutoresponder($autoresponder_id));
$this->assertFalse(Autoresponder::whetherAutoresponderExists($autoresponder_id));
$this->assertTrue(Autoresponder::whetherAutoresponderExists(2));
}
