DbDumpCommandTest.php in Zircon Profile 8

Contains \Drupal\Tests\system\Kernel\Scripts\DbDumpCommandTest.

Namespace

Drupal\Tests\system\Kernel\Scripts

File

core/modules/system/tests/src/Kernel/Scripts/DbDumpCommandTest.php

<?php

/**
 * @file
 * Contains \Drupal\Tests\system\Kernel\Scripts\DbDumpCommandTest.
 */
namespace Drupal\Tests\system\Kernel\Scripts;

use Drupal\Core\Command\DbDumpCommand;
use Drupal\Core\Database\Database;
use Drupal\KernelTests\KernelTestBase;
use Symfony\Component\Console\Tester\CommandTester;

/**
 * Test that the DbDumpCommand works correctly.
 *
 * @group console
 */
class DbDumpCommandTest extends KernelTestBase {

  /**
   * {@inheritdoc}
   */
  public static $modules = [
    'system',
  ];

  /**
   * {@inheritdoc}
   */
  public function setUp() {
    parent::setUp();

    // Determine what database backend is running, and set the skip flag.
    if (Database::getConnection()
      ->databaseType() !== 'mysql') {
      $this
        ->markTestSkipped("Skipping test since the DbDumpCommand is currently only compatible with MySQL");
    }
    $this
      ->installSchema('system', 'router');

    /** @var \Drupal\Core\Database\Connection $connection */
    $connection = $this->container
      ->get('database');
    $connection
      ->insert('router')
      ->fields([
      'name',
      'path',
      'pattern_outline',
    ])
      ->values([
      'test',
      'test',
      'test',
    ])
      ->execute();
  }

  /**
   * Test the command directly.
   */
  public function testDbDumpCommand() {
    $command = new DbDumpCommand();
    $command_tester = new CommandTester($command);
    $command_tester
      ->execute([]);

    // Assert that insert exists and that some expected fields exist.
    $output = $command_tester
      ->getDisplay();
    $this
      ->assertContains("createTable('router", $output, 'Table router found');
    $this
      ->assertContains("insert('router", $output, 'Insert found');
    $this
      ->assertContains("'name' => 'test", $output, 'Insert name field found');
    $this
      ->assertContains("'path' => 'test", $output, 'Insert path field found');
    $this
      ->assertContains("'pattern_outline' => 'test", $output, 'Insert pattern_outline field found');
  }

  /**
   * Test schema only option.
   */
  public function testSchemaOnly() {
    $command = new DbDumpCommand();
    $command_tester = new CommandTester($command);
    $command_tester
      ->execute([
      '--schema-only' => 'router',
    ]);

    // Assert that insert statement doesn't exist for schema only table.
    $output = $command_tester
      ->getDisplay();
    $this
      ->assertContains("createTable('router", $output, 'Table router found');
    $this
      ->assertNotContains("insert('router", $output, 'Insert not found');
    $this
      ->assertNotContains("'name' => 'test", $output, 'Insert name field not found');
    $this
      ->assertNotContains("'path' => 'test", $output, 'Insert path field not found');
    $this
      ->assertNotContains("'pattern_outline' => 'test", $output, 'Insert pattern_outline field not found');

    // Assert that insert statement doesn't exist for wildcard schema only match.
    $command_tester
      ->execute([
      '--schema-only' => 'route.*',
    ]);
    $output = $command_tester
      ->getDisplay();
    $this
      ->assertContains("createTable('router", $output, 'Table router found');
    $this
      ->assertNotContains("insert('router", $output, 'Insert not found');
    $this
      ->assertNotContains("'name' => 'test", $output, 'Insert name field not found');
    $this
      ->assertNotContains("'path' => 'test", $output, 'Insert path field not found');
    $this
      ->assertNotContains("'pattern_outline' => 'test", $output, 'Insert pattern_outline field not found');
  }

}

Classes

Name	Description
DbDumpCommandTest	Test that the DbDumpCommand works correctly.