function TemporaryQueryTest::testTemporaryQuery in Zircon Profile 8
Same name and namespace in other branches
- 8.0 core/modules/system/src/Tests/Database/TemporaryQueryTest.php \Drupal\system\Tests\Database\TemporaryQueryTest::testTemporaryQuery()
Confirms that temporary tables work and are limited to one request.
File
- core/
modules/ system/ src/ Tests/ Database/ TemporaryQueryTest.php, line 34 - Contains \Drupal\system\Tests\Database\TemporaryQueryTest.
Class
- TemporaryQueryTest
- Tests the temporary query functionality.
Namespace
Drupal\system\Tests\DatabaseCode
function testTemporaryQuery() {
$this
->drupalGet('database_test/db_query_temporary');
$data = json_decode($this
->getRawContent());
if ($data) {
$this
->assertEqual($this
->countTableRows('test'), $data->row_count, 'The temporary table contains the correct amount of rows.');
$this
->assertFalse(db_table_exists($data->table_name), 'The temporary table is, indeed, temporary.');
}
else {
$this
->fail('The creation of the temporary table failed.');
}
// Now try to run two db_query_temporary() in the same request.
$table_name_test = db_query_temporary('SELECT name FROM {test}', array());
$table_name_task = db_query_temporary('SELECT pid FROM {test_task}', array());
$this
->assertEqual($this
->countTableRows($table_name_test), $this
->countTableRows('test'), 'A temporary table was created successfully in this request.');
$this
->assertEqual($this
->countTableRows($table_name_task), $this
->countTableRows('test_task'), 'A second temporary table was created successfully in this request.');
// Check that leading whitespace and comments do not cause problems
// in the modified query.
$sql = "\n -- Let's select some rows into a temporary table\n SELECT name FROM {test}\n ";
$table_name_test = db_query_temporary($sql, array());
$this
->assertEqual($this
->countTableRows($table_name_test), $this
->countTableRows('test'), 'Leading white space and comments do not interfere with temporary table creation.');
}