Advertisement
shapoval

maxQueryCountData

Mar 28th, 2018
248
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.13 KB | None | 0 0
  1.         $logger = new \Doctrine\DBAL\Logging\DebugStack();
  2.         \Bingo::$em->getConfiguration()->setSQLLogger($logger);
  3.         register_shutdown_function(function() use ($logger) {
  4.             $pageUrl = \Bingo\Routing::$uri;
  5.             $maxQueryCountData = \Bingo::$em->createQuery('SELECT l.field3 FROM Ersties\Models\Log l WHERE l.type = :type AND l.field4 = :page_url')
  6.                                         ->setParameters(['type' => 'pageQueriesData', 'page_url' => $pageUrl])
  7.                                         ->getOneOrNullResult();
  8.             $maxQueryCount = !empty($maxQueryCountData) ? (int)$maxQueryCountData['field3'] : null;
  9.             $updatePageQueriesData = false;
  10.             if (!$maxQueryCount) {
  11.                 $updatePageQueriesData = true;
  12.             } else {
  13.                 $currentQueryCount = count($logger->queries);
  14.                 if ($currentQueryCount > $maxQueryCount)
  15.                     $updatePageQueriesData = true;
  16.             }
  17.            
  18.             if ($updatePageQueriesData)
  19.                 \Ersties\Models\Log::updatePageQueriesData($pageUrl, $logger->queries);
  20.         });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement