Test that we can log queries separately on different connections.

File

drupal-7.x/modules/simpletest/tests/database_test.test, line 2968

Class

DatabaseLoggingTestCase

Query logging tests.

Code

function testEnableMultiConnectionLogging() {
  // Clone the master credentials to a fake connection.
  // That both connections point to the same physical database is irrelevant.
  $connection_info = Database::getConnectionInfo('default');
  Database::addConnectionInfo('test2', 'default', $connection_info['default']);

  Database::startLog('testing1');
  Database::startLog('testing1', 'test2');

  db_query('SELECT name FROM {test} WHERE age > :age', array(':age' => 25))->fetchCol();

  $old_key = db_set_active('test2');

  db_query('SELECT age FROM {test} WHERE name = :name', array(':name' => 'Ringo'), array('target' => 'slave'))->fetchCol();

  db_set_active($old_key);

  $queries1 = Database::getLog('testing1');
  $queries2 = Database::getLog('testing1', 'test2');

  $this->assertEqual(count($queries1), 1, 'Correct number of queries recorded for first connection.');
  $this->assertEqual(count($queries2), 1, 'Correct number of queries recorded for second connection.');
}