Error message

You are browsing documentation for drupal 7.x, which is not supported anymore. Read the updated version of this page for drupal 11.x (the latest version).

function DatabaseLoggingTestCase::testEnableLogging

Test that we can log the existence of a query.

File

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

Class

DatabaseLoggingTestCase
Query logging tests.

Code

function testEnableLogging() {
 $log = Database ::startLog ('testing');
 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',
 ))->fetchCol ();
 // Trigger a call that does not have file in the backtrace.
 call_user_func_array ('db_query', array(
 'SELECT age FROM {test} WHERE name = :name',
 array(
 ':name' => 'Ringo',
 ),
 ))->fetchCol ();
 $queries = Database ::getLog ('testing', 'default');
 $this->assertEqual (count ($queries), 3, 'Correct number of queries recorded.');
 foreach ($queries as $query) {
 $this->assertEqual ($query['caller']['function'], __FUNCTION__, 'Correct function in query log.');
 }
}

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.