DbDumpCommandTest.php
Same filename in other branches
Namespace
Drupal\Tests\system\Kernel\ScriptsFile
-
core/
modules/ system/ tests/ src/ Kernel/ Scripts/ DbDumpCommandTest.php
View source
<?php
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}
*/
protected static $modules = [
'system',
];
/**
* {@inheritdoc}
*/
protected function setUp() : void {
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");
}
// Rebuild the router to ensure a routing table.
\Drupal::service('router.builder')->rebuild();
/** @var \Drupal\Core\Database\Connection $connection */
$connection = $this->container
->get('database');
$connection->insert('router')
->fields([
'name',
'path',
'pattern_outline',
])
->values([
'test',
'test',
'test',
])
->execute();
// Create a table with a field type not defined in
// \Drupal\Core\Database\Schema::getFieldTypeMap.
$table_name = $connection->tablePrefix() . 'foo';
$sql = "create table if not exists `{$table_name}` (`test` datetime NOT NULL);";
$connection->query($sql)
->execute();
}
/**
* Tests 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->assertStringContainsString("createTable('router", $output, 'Table router found');
$this->assertStringContainsString("insert('router", $output, 'Insert found');
$this->assertStringContainsString("'name' => 'test", $output, 'Insert name field found');
$this->assertStringContainsString("'path' => 'test", $output, 'Insert path field found');
$this->assertStringContainsString("'pattern_outline' => 'test", $output, 'Insert pattern_outline field found');
$this->assertStringContainsString("// phpcs:ignoreFile", $output);
$version = \Drupal::VERSION;
$this->assertStringContainsString("This file was generated by the Drupal {$version} db-tools.php script.", $output);
}
/**
* Tests 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->assertStringContainsString("createTable('router", $output, 'Table router found');
$this->assertStringNotContainsString("insert('router", $output, 'Insert not found');
$this->assertStringNotContainsString("'name' => 'test", $output, 'Insert name field not found');
$this->assertStringNotContainsString("'path' => 'test", $output, 'Insert path field not found');
$this->assertStringNotContainsString("'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->assertStringContainsString("createTable('router", $output, 'Table router found');
$this->assertStringNotContainsString("insert('router", $output, 'Insert not found');
$this->assertStringNotContainsString("'name' => 'test", $output, 'Insert name field not found');
$this->assertStringNotContainsString("'path' => 'test", $output, 'Insert path field not found');
$this->assertStringNotContainsString("'pattern_outline' => 'test", $output, 'Insert pattern_outline field not found');
}
}
Classes
Title | Deprecated | Summary |
---|---|---|
DbDumpCommandTest | Test that the DbDumpCommand works correctly. |
Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.