setInstallPlugins(); //TODO plugins install to handle in a better way
Piwik::loadPlugins();
// Create auth object
$auth = Zend_Auth::getInstance();
$authAdapter = new Piwik_Auth();
$authAdapter->setTableName(Piwik::prefixTable('user'))
->setIdentityColumn('login')
->setCredentialColumn('password')
->setCredentialTreatment('MD5(?)');
// Set the input credential values (e.g., from a login form)
$authAdapter->setIdentity('root')
->setCredential('nintendo');
// Perform the authentication query, saving the result
$access = new Piwik_Access($authAdapter);
Zend_Registry::set('access', $access);
Zend_Registry::get('access')->loadAccess();
Zend_Loader::loadClass('Piwik_Archive');
Zend_Loader::loadClass('Piwik_Date');
$test = new Piwik_Archive;
$period = new Piwik_Period_Day( Piwik_Date::today() );
$site = new Piwik_Site(1);
$test->setPeriod($period);
$test->setSite($site);
$test->get('toto0');
$test->get('toto1');
$test = new Piwik_Archive;
$period = new Piwik_Period_Day(Piwik_Date::today());
$site = new Piwik_Site(12);
$test->setPeriod($period);
$test->setSite($site);
$test->get('nb_visits');
$test->get('toto12');
echo "
Piwik_Period_Day" . $timer;
//$period = new Piwik_Period_Month(new Piwik_Date('2007-02-02'));
//$site = new Piwik_Site(2);
//$test->setPeriod($period);
//$test->setSite($site);
//$test->get('toto2');
//$test->get('toto3');
//echo "
Piwik_Period_Month" . $timer;
//$period = new Piwik_Period_Year(new Piwik_Date('2007-02-02'));
//$site = new Piwik_Site(2);
//$test->setPeriod($period);
//$test->setSite($site);
//$test->get('toto2');
//$test->get('toto3');
//echo "Piwik_Period_Year" . $timer;
main();
//Piwik::uninstall();
//Piwik_Log::dump( Zend_Registry::get('db')->getProfiler()->getQueryProfiles() );
function displayProfiler()
{
$profiler = Zend_Registry::get('db')->getProfiler();
$totalTime = $profiler->getTotalElapsedSecs();
$queryCount = $profiler->getTotalNumQueries();
$longestTime = 0;
$longestQuery = null;
foreach ($profiler->getQueryProfiles() as $query) {
if ($query->getElapsedSecs() > $longestTime) {
$longestTime = $query->getElapsedSecs();
$longestQuery = $query->getQuery();
}
}
echo '
Executed ' . $queryCount . ' queries in ' . $totalTime . ' seconds' . "\n";
echo '
Average query length: ' . $totalTime / $queryCount . ' seconds' . "\n";
echo '
Queries per second: ' . $queryCount / $totalTime . "\n";
echo '
Longest query length: ' . $longestTime . "\n";
echo "
Longest query: \n" . $longestQuery . "\n";
}
function main()
{
Piwik::log("Start process...");
$api = Piwik_PublicApi::getInstance();
$api->registerClass("Piwik_SitesManager");
$api->registerClass("Piwik_UsersManager");
$api->SitesManager->getSiteUrlsFromId(1);
$api->SitesManager->addSite("test name site", array("http://localhost", "http://test.com"));
Zend_Registry::get('access')->loadAccess();
$api->UsersManager->deleteUser("login");
$api->UsersManager->addUser("login", "password", "email@geage.com");
}
displayProfiler();
echo $timer;
?>
test download
test download - without name var
test link php
test link php - without name var