namespace Drupal\KernelTests\Core\Database;
+use Drupal\Core\Database\Database;
use Drupal\KernelTests\KernelTestBase;
/**
public static $modules = ['database_test'];
+ /**
+ * The database connection for testing.
+ *
+ * @var \Drupal\Core\Database\Connection
+ */
+ protected $connection;
+
protected function setUp() {
parent::setUp();
+ $this->connection = Database::getConnection();
$this->installSchema('database_test', [
'test',
'test_people',
* Sets up tables for NULL handling.
*/
public function ensureSampleDataNull() {
- db_insert('test_null')
+ $this->connection->insert('test_null')
->fields(['name', 'age'])
->values([
'name' => 'Kermit',
* Sets up our sample data.
*/
public static function addSampleData() {
+ $connection = Database::getConnection();
+
// We need the IDs, so we can't use a multi-insert here.
- $john = db_insert('test')
+ $john = $connection->insert('test')
->fields([
'name' => 'John',
'age' => 25,
])
->execute();
- $george = db_insert('test')
+ $george = $connection->insert('test')
->fields([
'name' => 'George',
'age' => 27,
])
->execute();
- db_insert('test')
+ $connection->insert('test')
->fields([
'name' => 'Ringo',
'age' => 28,
])
->execute();
- $paul = db_insert('test')
+ $paul = $connection->insert('test')
->fields([
'name' => 'Paul',
'age' => 26,
])
->execute();
- db_insert('test_people')
+ $connection->insert('test_people')
->fields([
'name' => 'Meredith',
'age' => 30,
])
->execute();
- db_insert('test_task')
+ $connection->insert('test_task')
->fields(['pid', 'task', 'priority'])
->values([
'pid' => $john,
])
->execute();
- db_insert('test_special_columns')
+ $connection->insert('test_special_columns')
->fields([
'id' => 1,
'offset' => 'Offset value 1',
+ 'function' => 'Function value 1',
])
->execute();
}