public function testUniqueEncodedTitles()
{
// SELECT encodedtitle, COUNT(newsid) AS articles FROM typef_news GROUP BY encodedtitle HAVING articles > 1
$articles = new Model_News_Article();
$articles->selectFields('encodedtitle', 'COUNT(newsid) AS articles');
$articles->group('encodedtitle');
$articles->having('articles > 1');
$titles = array();
foreach ($articles->select() as $article) {
$titles[] = "'{$article['encodedtitle']}' ({$article['articles']})";
}
$this->assertTrue(count($titles) == 0, "The following encoded titles are not unique: " . implode(',', $titles));
}
