function DatabaseTestController::dbQueryTemporary

Creates temporary table and outputs 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.

Return value

\Symfony\Component\HttpFoundation\JsonResponse

File

core/modules/system/tests/modules/database_test/src/Controller/DatabaseTestController.php, line 52

Class

DatabaseTestController

Controller routines for database_test routes.

Namespace

Code

public function dbQueryTemporary() {
    $table_name = $this->connection
        ->queryTemporary('SELECT [age] FROM {test}', []);
    return new JsonResponse([
        'table_name' => $table_name,
        'row_count' => $this->connection
            ->select($table_name)
            ->countQuery()
            ->execute()
            ->fetchField(),
    ]);
}