function database_test_db_query_temporary in Drupal 7

Run a db_query_temporary and output the table name and its number of rows.

We need to test that the table created is temporary, so we run it here, in a separate menu callback request; After this request is done, the temporary table should automatically dropped.

1 string reference to 'database_test_db_query_temporary'

database_test_menu in modules/simpletest/tests/database_test.module

Implements hook_menu().

File

modules/simpletest/tests/database_test.module, line 83

Code

function database_test_db_query_temporary() {
  $table_name = db_query_temporary('SELECT status FROM {system}', array());
  drupal_json_output(array(
    'table_name' => $table_name,
    'row_count' => db_select($table_name)
      ->countQuery()
      ->execute()
      ->fetchField(),
  ));
  exit;
}