TemporaryQueryTest.php

Same filename in this branch
  1. 10 core/modules/mysql/tests/src/Kernel/mysql/TemporaryQueryTest.php
  2. 10 core/modules/pgsql/tests/src/Kernel/pgsql/TemporaryQueryTest.php
Same filename in other branches
  1. 9 core/modules/system/tests/src/Functional/Database/TemporaryQueryTest.php
  2. 8.9.x core/modules/system/tests/src/Functional/Database/TemporaryQueryTest.php
  3. 11.x core/modules/sqlite/tests/src/Kernel/sqlite/TemporaryQueryTest.php
  4. 11.x core/modules/mysql/tests/src/Kernel/mysql/TemporaryQueryTest.php
  5. 11.x core/modules/pgsql/tests/src/Kernel/pgsql/TemporaryQueryTest.php

Namespace

Drupal\Tests\sqlite\Kernel\sqlite

File

core/modules/sqlite/tests/src/Kernel/sqlite/TemporaryQueryTest.php

View source
<?php

declare (strict_types=1);
namespace Drupal\Tests\sqlite\Kernel\sqlite;

use Drupal\KernelTests\Core\Database\TemporaryQueryTestBase;

/**
 * Tests the temporary query functionality.
 *
 * @group Database
 */
class TemporaryQueryTest extends TemporaryQueryTestBase {
    
    /**
     * Confirms that temporary tables work.
     */
    public function testTemporaryQuery() : void {
        parent::testTemporaryQuery();
        $connection = $this->getConnection();
        $table_name_test = $connection->queryTemporary('SELECT [name] FROM {test}', []);
        // Assert that the table is indeed a temporary one.
        $this->assertStringContainsString("temp.", $table_name_test);
        // Assert that both have the same field names.
        $normal_table_fields = $connection->query("SELECT * FROM {test}")
            ->fetch();
        $temp_table_name = $connection->queryTemporary('SELECT * FROM {test}');
        $temp_table_fields = $connection->query("SELECT * FROM {$temp_table_name}")
            ->fetch();
        $normal_table_fields = array_keys(get_object_vars($normal_table_fields));
        $temp_table_fields = array_keys(get_object_vars($temp_table_fields));
        $this->assertEmpty(array_diff($normal_table_fields, $temp_table_fields));
    }

}

Classes

Title Deprecated Summary
TemporaryQueryTest Tests the temporary query functionality.

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