public function testPragmaIgnored()
{
$debug = new DebugStack();
$data = new DatabaseDataCollector($debug);
$debug->startQuery('PRAGMA test');
$debug->stopQuery();
$app = $this->getApp();
$request = Request::create('/', 'GET');
$response = $app->handle($request);
$data->collect($request, $response);
$this->assertEquals(0, $data->getQueryCount());
}
public function logSql($sql, array $params = null)
{
parent::logSql($sql, $params);
if (null !== $this->logger) {
$this->log($sql . ' (' . str_replace("\n", '', var_export($params, true)) . ')');
}
}
/**
* {@inheritdoc}
*/
public function stopQuery()
{
parent::stopQuery();
if (null !== $this->stopwatch) {
$this->stopwatch->stop('doctrine');
}
}
/**
* {@inheritdoc}
*/
public function startQuery($sql, array $params = null, array $types = null)
{
parent::startQuery($sql, $params, $types);
if (null !== $this->logger) {
$this->log($sql . ' (' . json_encode($params) . ')');
}
}
/**
* {@inheritdoc}
*/
public function invoke(MethodInvocation $invocation)
{
$object = $invocation->getThis();
$method = $invocation->getMethod();
$write = ['onPut', 'onDelete', 'onPost'];
$connectionParams = in_array($method->name, $write) ? $this->masterDb : $this->slaveDb;
$pagerAnnotation = $this->reader->getMethodAnnotation($method, 'BEAR\\Sunday\\Annotation\\DbPager');
$db = $this->getDb($pagerAnnotation, $connectionParams);
/* @var $db \BEAR\Package\Module\Database\Dbal\PagerConnection */
if ($this->sqlLogger instanceof SQLLogger) {
$db->getConfiguration()->setSQLLogger($this->sqlLogger);
}
$object->setDb($db);
$result = $invocation->proceed();
if ($this->sqlLogger instanceof DebugStack) {
$this->sqlLogger->stopQuery();
$object->headers['x-sql'] = [$this->sqlLogger->queries];
} elseif ($this->sqlLogger instanceof SQLLogger) {
$this->sqlLogger->stopQuery();
}
if (!$pagerAnnotation) {
return $result;
}
$pagerData = $db->getPager();
if ($pagerData) {
$object->headers['pager'] = $pagerData;
}
return $result;
}
/**
* {@inheritdoc}
*/
public function startQuery($sql, array $params = null, array $types = null)
{
parent::startQuery($sql, $params, $types);
if (null !== $this->logger) {
$this->log($sql . ' (' . str_replace("\n", '', var_export($params, true)) . ')');
}
}
public function testGetQueryTime()
{
$start = microtime(true);
$this->assertEquals(0, $this->collector->getQueryTime());
$this->logger->startQuery('some sql');
$this->logger->stopQuery();
$time = microtime(true) - $start;
$time1 = $this->collector->getQueryTime();
$this->assertGreaterThan(0, $time1);
$this->assertLessThan($time, $time1);
$this->logger->startQuery('some more sql');
$this->logger->stopQuery();
$time = microtime(true) - $start;
$time2 = $this->collector->getQueryTime();
$this->assertGreaterThan($time1, $time2);
$this->assertLessThan($time, $time1);
}
public function stopQuery()
{
parent::stopQuery();
$q = $this->queries[$this->currentQuery];
$message = "Executed Query: " . print_r($q, true);
$this->logger->info($message);
}
/**
* {@inheritdoc}
*/
public function stopQuery()
{
parent::stopQuery();
if (null !== $this->stopwatch) {
$this->stopwatch->stop('doctrine');
}
if ($this->enabled) {
$this->queries[$this->currentQuery]['callstack'] = $this->callstack;
}
}
/**
* stopQuery
*
* Perform usual Doctrine DebugStack stopQuery() and trigger event for loggers
*
* Event argument is array:
* - 'sql' => string SQL statement
* - 'params' => array of bound parameters
* - 'types' => array of parameter types
* - 'executionMS' => float of execution time in microseconds
*
* @return void
*/
public function stopQuery()
{
parent::stopQuery();
\Xoops::getInstance()->events()->triggerEvent('core.database.query.complete', $this->queries[$this->currentQuery]);
}
public function stopQuery()
{
parent::stopQuery();
if ((bool) $this->config['log_executiontime']) {
$this->log($this->queries[$this->currentQuery]['executionMS']);
}
}
