function LoggingTest::testEnableTargetLogging

Tests logging queries against multiple targets on the same connection.

File

drupal/core/modules/system/lib/Drupal/system/Tests/Database/LoggingTest.php, line 68

Definition of Drupal\system\Tests\Database\LoggingTest.

Class

LoggingTest

Tests query logging.

Namespace

Code

function testEnableTargetLogging() {

  // Clone the master credentials to a slave connection and to another fake
  // connection.
  $connection_info = Database::getConnectionInfo('default');
  Database::addConnectionInfo('default', 'slave', $connection_info['default']);
  Database::startLog('testing1');
  db_query('SELECT name FROM {test} WHERE age > :age', array(
    ':age' => 25,
  ))
    ->fetchCol();
  db_query('SELECT age FROM {test} WHERE name = :name', array(
    ':name' => 'Ringo',
  ), array(
    'target' => 'slave',
  ));

  //->fetchCol();
  $queries1 = Database::getLog('testing1');
  $this
    ->assertEqual(count($queries1), 2, 'Recorded queries from all targets.');
  $this
    ->assertEqual($queries1[0]['target'], 'default', 'First query used default target.');
  $this
    ->assertEqual($queries1[1]['target'], 'slave', 'Second query used slave target.');
}