public function test_getAllKnownUrlsForAllSites_shouldReturnAllUrls()
{
$idSite = $this->createMeasurable('website', 'http://apache.piwik');
$this->model->insertSiteUrl($idSite, 'http://example.apache.piwik');
$this->model->insertSiteUrl($idSite, 'http://example.org');
$idSite2 = $this->createMeasurable('website');
$this->model->insertSiteUrl($idSite2, 'http://example.org');
$this->model->insertSiteUrl($idSite2, 'http://example.com');
$idSite3 = $this->createMeasurable('website', 'http://example.pro');
$expected = array(array('idsite' => $idSite, 'url' => 'http://apache.piwik'), array('idsite' => $idSite2, 'url' => 'http://piwik.net'), array('idsite' => $idSite3, 'url' => 'http://example.pro'), array('idsite' => $idSite, 'url' => 'http://example.apache.piwik'), array('idsite' => $idSite, 'url' => 'http://example.org'), array('idsite' => $idSite2, 'url' => 'http://example.com'), array('idsite' => $idSite2, 'url' => 'http://example.org'));
$this->assertEquals($expected, $this->model->getAllKnownUrlsForAllSites());
}
public function getAllSiteUrls()
{
$model = new Model();
$siteUrls = $model->getAllKnownUrlsForAllSites();
if (empty($siteUrls)) {
return array();
}
$urls = array();
foreach ($siteUrls as $siteUrl) {
$siteId = (int) $siteUrl['idsite'];
if (!isset($urls[$siteId])) {
$urls[$siteId] = array();
}
$urls[$siteId][] = $siteUrl['url'];
}
return $urls;
}