View source
<?php
namespace Drupal\KernelTests\Core\Database;
use Drupal\Core\Database\DatabaseExceptionWrapper;
use Drupal\Core\Database\IntegrityConstraintViolationException;
class UpdateTest extends DatabaseTestBase {
public function testSimpleUpdate() {
$num_updated = $this->connection
->update('test')
->fields([
'name' => 'Tiffany',
])
->condition('id', 1)
->execute();
$this
->assertSame(1, $num_updated, 'Updated 1 record.');
$saved_name = $this->connection
->query('SELECT [name] FROM {test} WHERE [id] = :id', [
':id' => 1,
])
->fetchField();
$this
->assertSame('Tiffany', $saved_name, 'Updated name successfully.');
}
public function testSimpleNullUpdate() {
$this
->ensureSampleDataNull();
$num_updated = $this->connection
->update('test_null')
->fields([
'age' => NULL,
])
->condition('name', 'Kermit')
->execute();
$this
->assertSame(1, $num_updated, 'Updated 1 record.');
$saved_age = $this->connection
->query('SELECT [age] FROM {test_null} WHERE [name] = :name', [
':name' => 'Kermit',
])
->fetchField();
$this
->assertNull($saved_age, 'Updated name successfully.');
}
public function testMultiUpdate() {
$num_updated = $this->connection
->update('test')
->fields([
'job' => 'Musician',
])
->condition('job', 'Singer')
->execute();
$this
->assertSame(2, $num_updated, 'Updated 2 records.');
$num_matches = $this->connection
->query('SELECT COUNT(*) FROM {test} WHERE [job] = :job', [
':job' => 'Musician',
])
->fetchField();
$this
->assertSame('2', $num_matches, 'Updated fields successfully.');
}
public function testMultiGTUpdate() {
$num_updated = $this->connection
->update('test')
->fields([
'job' => 'Musician',
])
->condition('age', 26, '>')
->execute();
$this
->assertSame(2, $num_updated, 'Updated 2 records.');
$num_matches = $this->connection
->query('SELECT COUNT(*) FROM {test} WHERE [job] = :job', [
':job' => 'Musician',
])
->fetchField();
$this
->assertSame('2', $num_matches, 'Updated fields successfully.');
}
public function testWhereUpdate() {
$num_updated = $this->connection
->update('test')
->fields([
'job' => 'Musician',
])
->where('[age] > :age', [
':age' => 26,
])
->execute();
$this
->assertSame(2, $num_updated, 'Updated 2 records.');
$num_matches = $this->connection
->query('SELECT COUNT(*) FROM {test} WHERE [job] = :job', [
':job' => 'Musician',
])
->fetchField();
$this
->assertSame('2', $num_matches, 'Updated fields successfully.');
}
public function testWhereAndConditionUpdate() {
$update = $this->connection
->update('test')
->fields([
'job' => 'Musician',
])
->where('[age] > :age', [
':age' => 26,
])
->condition('name', 'Ringo');
$num_updated = $update
->execute();
$this
->assertSame(1, $num_updated, 'Updated 1 record.');
$num_matches = $this->connection
->query('SELECT COUNT(*) FROM {test} WHERE [job] = :job', [
':job' => 'Musician',
])
->fetchField();
$this
->assertSame('1', $num_matches, 'Updated fields successfully.');
}
public function testExpressionUpdate() {
$num_rows = $this->connection
->update('test')
->expression('age', '[age] * [age]')
->execute();
$this
->assertSame(4, $num_rows, 'Updated 4 records.');
$saved_name = $this->connection
->query('SELECT [name] FROM {test} WHERE [age] = :age', [
':age' => pow(26, 2),
])
->fetchField();
$this
->assertSame('Paul', $saved_name, 'Successfully updated values using an algebraic expression.');
}
public function testUpdateAffectedRows() {
$num_rows = $this->connection
->update('test_task')
->condition('priority', 1, '<>')
->fields([
'task' => 'sleep',
])
->execute();
$this
->assertSame(5, $num_rows, 'Correctly returned 5 affected rows.');
}
public function testSpecialColumnUpdate() {
$num_updated = $this->connection
->update('select')
->fields([
'update' => 'New update value',
])
->condition('id', 1)
->execute();
$this
->assertSame(1, $num_updated, 'Updated 1 special column record.');
$saved_value = $this->connection
->query('SELECT [update] FROM {select} WHERE [id] = :id', [
':id' => 1,
])
->fetchField();
$this
->assertEquals('New update value', $saved_value);
}
public function testUpdateNonExistingTable() : void {
$this
->expectException(DatabaseExceptionWrapper::class);
$this->connection
->update('a-table-that-does-not-exist')
->fields([
'update' => 'New update value',
])
->condition('id', 1)
->execute();
}
public function testUpdateValueInSerial() : void {
$this
->expectException(IntegrityConstraintViolationException::class);
$this->connection
->update('test')
->fields([
'id' => 2,
])
->condition('id', 1)
->execute();
}
}