Db3v4l\Command\DatabaseCreate

Complexity

Total Complexity

12

Size/Duplication

Total Lines	90
Duplicated Lines	0 %

Importance

Changes	3
Bugs	0	Features	1

2 Methods

Rating	Name	Duplication	Size	Complexity
A	configure()	0	9	1
B	execute()	0	68	11

<?php

Missing file doc comment

namespace Db3v4l\Command;

use Symfony\Component\Console\Input\InputInterface;

The type Symfony\Component\Console\Input\InputInterface was not found. Maybe you did not declare it correctly or list all dependencies?

use Symfony\Component\Console\Input\InputOption;

The type Symfony\Component\Console\Input\InputOption was not found. Maybe you did not declare it correctly or list all dependencies?

use Symfony\Component\Console\Output\OutputInterface;

The type Symfony\Component\Console\Output\OutputInterface was not found. Maybe you did not declare it correctly or list all dependencies?

class DatabaseCreate extends DatabaseManagingCommand

Missing doc comment for class DatabaseCreate

{
    protected static $defaultName = 'db3v4l:database:create';

    protected function configure()

Missing doc comment for function configure()

    {
        $this
            ->setDescription('Creates a database & associated user in parallel on all configured database instances')
            ->addOption('database', 'd', InputOption::VALUE_REQUIRED, 'The name of the database to create')
            ->addOption('user', 'u', InputOption::VALUE_REQUIRED, 'The name of a user to create with r/w access to the new database. If omitted, no user will be created')
            ->addOption('password', 'p', InputOption::VALUE_REQUIRED, 'The password. If omitted, a random one will be generated and echoed as part of results')
            ->addOption('charset', 'c', InputOption::VALUE_REQUIRED, 'The collation/character-set to use for the database. If omitted, the default collation for the instance will be used')
            ->addCommonOptions()

Space after closing parenthesis of function call prohibited

        ;
    }

    /**

Missing short description in doc comment

     * @param InputInterface $input

Missing parameter comment

Expected 2 spaces after parameter type; 1 found

Tag value for @param tag indented incorrectly; expected 2 spaces but found 1

     * @param OutputInterface $output

Missing parameter comment

Tag value for @param tag indented incorrectly; expected 2 spaces but found 1

     * @return int

Tag @return cannot be grouped with parameter tags in a doc comment

     * @throws \Exception

Tag @throws cannot be grouped with parameter tags in a doc comment

     */
    protected function execute(InputInterface $input, OutputInterface $output)
    {
        $start = microtime(true);

        // as per https://www.php.net/manual/en/function.ignore-user-abort.php: for cli scripts, it is probably a good idea
        // to use ignore_user_abort
        ignore_user_abort(true);

        $this->setOutput($output);
        $this->setVerbosity($output->getVerbosity());

        $instanceList = $this->parseCommonOptions($input);

        $dbName = $input->getOption('database');
        $userName = $input->getOption('user');
        $password = $input->getOption('password');
        $charset = $input->getOption('charset');

        // BC api
        if ($dbName == null && $userName != null) {
            $dbName = $userName;
        }

        if ($dbName == null) {
            throw new \Exception("Please provide a database name");
        }

        if ($userName == null) {
            if ($password != null) {
                throw new \Exception("Option 'password' is only valid together with option 'user'");
            }
        } else {
            if ($password == null) {
                // 30 chars = max length for Oracle (at least up to 11g)
                /// @todo move to a constant
                $password = bin2hex(random_bytes(15));

                // Should we warn the user always? To avoid breaking non-text-format, we can send it to stderr...
                // Otoh we give the password in the structured output that we produce
                //$this->writeErrorln("<info>Assigned password to the user: $password</info>");
            }
        }

        if ($this->outputFormat === 'text') {
            $this->writeln('<info>Creating databases...</info>');
        }

        $newDbSpecs = [];
        foreach($instanceList as $instanceName => $instanceSpecs) {

Expected "foreach (...) {\n"; found "foreach(...) {\n"

            $newDbSpecs[$instanceName] = [
                'dbname' => $dbName
            ];
            if ($userName != null) {
                $newDbSpecs[$instanceName]['user'] = $userName;
                $newDbSpecs[$instanceName]['password'] = $password;
            }
            if ($charset != '') {
                $newDbSpecs[$instanceName]['charset'] = $charset;
            }
        }

        $results = $this->createDatabases($instanceList, $newDbSpecs);

        $time = microtime(true) - $start;

        $this->writeResults($results, $time);

        return (int)$results['failed'];
    }
}