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(); }