<?php
if (@(!(include __DIR__ . '/vendor/autoload.php'))) {
echo 'Install Nette using `composer install`';
exit(1);
}
$useCache = TRUE;
date_default_timezone_set('Europe/Prague');
$connection = new Nette\Database\Connection('mysql:dbname=blog', 'root', '');
$cacheStorage = new Nette\Caching\Storages\FileStorage(__DIR__ . '/temp');
$connection->setCacheStorage($useCache ? $cacheStorage : NULL);
$connection->setDatabaseReflection(new Nette\Database\Reflection\DiscoveredReflection($useCache ? $cacheStorage : NULL));
$dao = $connection;
$time = -microtime(TRUE);
ob_start();
foreach ($dao->table('user') as $user) {
echo "{$user->name}:\n";
foreach ($user->related('article')->order('created')->limit(20) as $article) {
echo "\t", $article->title, ' in ', $article->category->name, ' (', $article->related('comment')->count(), ")\n";
}
}
ob_end_clean();
echo 'Time: ', sprintf('%0.3f', $time + microtime(TRUE)), ' s | ', 'Memory: ', memory_get_peak_usage() >> 20, ' MB | ', 'PHP: ', PHP_VERSION, ' | ', 'Nette: ', Nette\Framework::VERSION;
/**
* @return Nette\Database\Connection
*/
protected function createServiceNette__database__default()
{
$service = new Nette\Database\Connection('mysql:host=87.197.23.74;dbname=atlasMineralov', 'cujan', 'cujan', NULL);
$service->setCacheStorage($this->getService('cacheStorage'));
Nette\Diagnostics\Debugger::$blueScreen->addPanel('Nette\\Database\\Diagnostics\\ConnectionPanel::renderException');
$service->setDatabaseReflection(new Nette\Database\Reflection\DiscoveredReflection($this->getService('cacheStorage')));
$service->onQuery[] = array($this->getService('nette.database.defaultConnectionPanel'), 'logQuery');
return $service;
}
