public function testCountingAllMessagesOfAllAutorespondersAndNewslettersThatExist()
{
//define an autoresponder
global $wpdb;
//add an autoresponder that has a newsletter associated with it.
$addAutoresponderQuery = sprintf("INSERT INTO %swpr_autoresponders (nid, name) VALUES (%d,'%s' )", $wpdb->prefix, $this->newsletter1_id, md5(microtime()));
$results = $wpdb->query($addAutoresponderQuery);
$autoresponder1_id = $wpdb->insert_id;
for ($iter = 0; $iter < 12; $iter++) {
$addAutoresponderMessageQuery = sprintf("INSERT INTO %swpr_autoresponder_messages (aid, subject, textbody, sequence)\n VALUES (%d, '%s', '%s', %d)", $wpdb->prefix, $autoresponder1_id, md5($iter . microtime() . "auto"), md5(microtime() . $iter . 'test'), $iter);
$wpdb->query($addAutoresponderMessageQuery);
$autoresponderMessagesIds[] = $wpdb->insert_id;
}
//add another autoresponder that has another newsletter associated with it.
$addAutoresponderQuery = sprintf("INSERT INTO %swpr_autoresponders (nid, name) VALUES (%d,'%s' )", $wpdb->prefix, $this->newsletter2_id, md5(microtime()));
$results = $wpdb->query($addAutoresponderQuery);
$autoresponder2_id = $wpdb->insert_id;
for ($iter = 0; $iter < 13; $iter++) {
$addAutoresponderMessageQuery = sprintf("INSERT INTO %swpr_autoresponder_messages (aid, subject, textbody, sequence)\n VALUES (%d, '%s', '%s', %d)", $wpdb->prefix, $autoresponder2_id, md5($iter . microtime() . "auto"), md5(microtime() . $iter . 'test'), $iter);
$wpdb->query($addAutoresponderMessageQuery);
$autoresponderMessagesIds[] = $wpdb->insert_id;
}
//add a autoresponder with no newsletter associated with it.
$addAutoresponderQuery = sprintf("INSERT INTO %swpr_autoresponders (nid, name) VALUES (%d,'%s' )", $wpdb->prefix, 9801, md5(microtime()));
$results = $wpdb->query($addAutoresponderQuery);
$autoresponder3_id = $wpdb->insert_id;
for ($iter = 0; $iter < 13; $iter++) {
$addAutoresponderMessageQuery = sprintf("INSERT INTO %swpr_autoresponder_messages (aid, subject, textbody, sequence)\n VALUES (%d, '%s', '%s', %d)", $wpdb->prefix, $autoresponder3_id, md5($iter . microtime() . "auto"), md5(microtime() . $iter . 'test'), $iter);
$wpdb->query($addAutoresponderMessageQuery);
$autoresponderMessagesIds[] = $wpdb->insert_id;
}
$addAutoresponderQuery = sprintf("INSERT INTO %swpr_autoresponders (nid, name) VALUES (%d,'%s' )", $wpdb->prefix, 9801, md5(microtime()));
$results = $wpdb->query($addAutoresponderQuery);
$autoresponder3_id = $wpdb->insert_id;
for ($iter = 0; $iter < 13; $iter++) {
$addAutoresponderMessageQuery = sprintf("INSERT INTO %swpr_autoresponder_messages (aid, subject, textbody, sequence)\n VALUES (%d, '%s', '%s', %d)", $wpdb->prefix, $autoresponder3_id, md5($iter . microtime() . "auto"), md5(microtime() . $iter . 'test'), $iter);
$wpdb->query($addAutoresponderMessageQuery);
$autoresponderMessagesIds[] = $wpdb->insert_id;
}
//add messages for an autoresponder that doesn't exist
for ($iter = 0; $iter < 13; $iter++) {
$addAutoresponderMessageQuery = sprintf("INSERT INTO %swpr_autoresponder_messages (aid, subject, textbody, sequence)\n VALUES (%d, '%s', '%s', %d)", $wpdb->prefix, 9000, md5($iter . microtime() . "auto"), md5(microtime() . $iter . 'test'), $iter);
$wpdb->query($addAutoresponderMessageQuery);
$autoresponderMessagesIds[] = $wpdb->insert_id;
}
$count = (int) AutoresponderMessage::getAllMessagesCount();
$this->assertEquals(25, $count);
}
private function getNumberOfAutoresponderMessages()
{
return AutoresponderMessage::getAllMessagesCount();
}
