public function DbtngExampleRepositoryTest::testDbtngExampleStorage in Examples for Developers 8

Same name and namespace in other branches

1. 3.x modules/dbtng_example/tests/src/Kernel/DbtngExampleRepositoryTest.php \Drupal\Tests\dbtng_example\Kernel\DbtngExampleRepositoryTest::testDbtngExampleStorage()

Tests several combinations, adding entries, updating and deleting.

File

dbtng_example/tests/src/Kernel/DbtngExampleRepositoryTest.php, line 48

Class

DbtngExampleRepositoryTest

Kernel testing of the DbtngExampleRepository service.

Namespace

Drupal\Tests\dbtng_example\Kernel

Code

public function testDbtngExampleStorage() {

  /* @var $repository \Drupal\dbtng_example\DbtngExampleRepository */
  $repository = $this->container
    ->get('dbtng_example.repository');

  // Create a new entry.
  $entry = [
    'name' => 'James',
    'surname' => 'Doe',
    'age' => 23,
  ];
  $repository
    ->insert($entry);

  // Save another entry.
  $entry = [
    'name' => 'Jane',
    'surname' => 'NotDoe',
    'age' => 19,
  ];
  $repository
    ->insert($entry);

  // Verify that 4 records are found in the database.
  $result = $repository
    ->load();
  $this
    ->assertCount(4, $result);

  // Verify 2 of these records have 'Doe' as surname.
  $result = $repository
    ->load([
    'surname' => 'Doe',
  ]);
  $this
    ->assertCount(2, $result, 'Did not find two entries in the table with surname = "Doe".');

  // Now find our not-Doe entry.
  $result = $repository
    ->load([
    'surname' => 'NotDoe',
  ]);

  // Found one entry in the table with surname "NotDoe'.
  $this
    ->assertCount(1, $result, 'Did not find one entry in the table with surname "NotDoe');

  // Our NotDoe will be changed to "NowDoe".
  $entry = $result[0];
  $entry->surname = "NowDoe";

  // update() returns the number of entries updated.
  $this
    ->assertNotEquals(0, $repository
    ->update((array) $entry));
  $result = $repository
    ->load([
    'surname' => 'NowDoe',
  ]);
  $this
    ->assertCount(1, $result, "Did not find renamed 'NowDoe' surname.");

  // Read only John Doe entry.
  $result = $repository
    ->load([
    'name' => 'John',
    'surname' => 'Doe',
  ]);
  $this
    ->assertCount(1, $result, 'Did not find one entry for John Doe.');

  // Get the entry.
  $entry = (array) end($result);

  // Change age to 45.
  $entry['age'] = 45;

  // Update entry in database.
  $repository
    ->update((array) $entry);

  // Find entries with age = 45.
  // Read only John Doe entry.
  $result = $repository
    ->load([
    'surname' => 'NowDoe',
  ]);

  // Found one entry with surname = Nowdoe.
  $this
    ->assertCount(1, $result, 'Did not find one entry with surname = Nowdoe.');

  // Verify it is Jane NowDoe.
  $entry = (array) end($result);

  // The name Jane is found in the entry.
  $this
    ->assertEquals('Jane', $entry['name'], 'The name Jane is not found in the entry.');

  // The surname NowDoe is found in the entry.
  $this
    ->assertEquals('NowDoe', $entry['surname'], 'The surname NowDoe is not found in the entry.');

  // Delete the entry.
  $repository
    ->delete($entry);

  // Verify that now there are only 3 records.
  $result = $repository
    ->load();

  // Found only three records, a record was deleted.
  $this
    ->assertCount(3, $result, 'Did not find only three records, a record might not have been deleted.');
}