function database_test_db_query_temporary

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.

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;
}