Integrate Propel clean command

The propel:database:drop command is used to clean a database of all the tables, indexes, counters and so on. The command invokes the drop process to delete and re-create the database from scratch.

When working with a remote database, you might have insufficient permissions to invoke the drop process. To cover the case, the vendor/bin/console propel:tables:drop command was introduced. The command cleans the database without dropping it.

To integrate the command, follow the steps.

Prerequisites

Install the following features:

1) Install the required modules

Install the required modules using Composer:

composer require spryker/propel:"^3.10.0" --update-with-dependencies

2) Set up behavior

1. Clean up Codeception configuration by deleting SetupHelper from all Codeception configuration files:

- \SprykerTest\Shared\Application\Helper\SetupHelper

2. Enable the DatabaseDropTablesConsole console command in Pyz\Zed\Console\ConsoleDependencyProvider:

src/Pyz/Zed/Console/ConsoleDependencyProvider.php

    <?php
    class ConsoleDependencyProvider extends SprykerConsoleDependencyProvider
{
    /**
     * @param \Spryker\Zed\Kernel\Container $container
     *
     * @return \Symfony\Component\Console\Command\Command[]
     */
    protected function getConsoleCommands(Container $container)
    {
        $commands = [
            ...
            new DatabaseDropTablesConsole(),
            ...

3. Run vendor/bin/console and make sure the propel:tables:drop command is in the list.