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

File

modules/simpletest/tests/database_test.test, line 3188

Class

DatabaseLoggingTestCase

Query logging tests.

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.');
}

---