Same filename and directory in other branches
- 8.9.x core/tests/Drupal/KernelTests/Core/Database/InsertLobTest.php
- 9 core/tests/Drupal/KernelTests/Core/Database/InsertLobTest.php
Namespace
Drupal\KernelTests\Core\Database
File
core/tests/Drupal/KernelTests/Core/Database/InsertLobTest.php
View source
<?php
declare (strict_types=1);
namespace Drupal\KernelTests\Core\Database;
class InsertLobTest extends DatabaseTestBase {
public function testInsertOneBlob() {
$data = "This is\0a test.";
$this
->assertSame(15, strlen($data), 'Test data contains a NULL.');
$id = $this->connection
->insert('test_one_blob')
->fields([
'blob1' => $data,
])
->execute();
$r = $this->connection
->query('SELECT * FROM {test_one_blob} WHERE [id] = :id', [
':id' => $id,
])
->fetchAssoc();
$this
->assertSame($data, $r['blob1'], "Can insert a blob: id {$id}, " . serialize($r));
}
public function testInsertNullBlob() {
$id = $this->connection
->insert('test_one_blob')
->fields([
'blob1' => NULL,
])
->execute();
$r = $this->connection
->query('SELECT * FROM {test_one_blob} WHERE [id] = :id', [
':id' => $id,
])
->fetchAssoc();
$this
->assertNull($r['blob1']);
}
public function testInsertMultipleBlob() {
$id = $this->connection
->insert('test_two_blobs')
->fields([
'blob1' => 'This is',
'blob2' => 'a test',
])
->execute();
$r = $this->connection
->query('SELECT * FROM {test_two_blobs} WHERE [id] = :id', [
':id' => $id,
])
->fetchAssoc();
$this
->assertSame('This is', $r['blob1']);
$this
->assertSame('a test', $r['blob2']);
}
}
Classes