<?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; }