function DatabaseLoggingTestCase::testEnableTargetLogging

Test that we can log queries against multiple targets on the same connection.

File

core/modules/simpletest/tests/database_test.test, line 2883

Database tests.

Class

DatabaseLoggingTestCase

Query logging tests.

Code

function testEnableTargetLogging() {
  // Clone the primary credentials to a replica connection and to another fake
  // connection.
  $connection_info = Database::getConnectionInfo('default');
  Database::addConnectionInfo('default', 'replica', $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' => 'replica')); //->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'], 'replica', 'Second query used replica target.');
}