DatabaseDeleteCleanup::configure() - Code Metrics - tequilarapido/appcli - Measure and Improve Code Quality continuously with Scrutinizer

DatabaseDeleteCleanup::configure() A
last analyzed 2016-10-06 13:29 UTC

↳ Parent: DatabaseDeleteCleanup

Complexity

Conditions	1
Paths	1

Size

Total Lines	14
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	14
rs	9.4285
c	0
b	0
f	0
cc	1
eloc	8
nc	1
nop	0

<?php namespace Tequilarapido\Cli\Commands;

use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;
use Tequilarapido\Cli\Commands\Base\AbstractDatabaseCommand;
use Tequilarapido\Database\Database;
use Tequilarapido\Database\Table;

class DatabaseDeleteCleanup extends AbstractDatabaseCommand
{

    protected function configure()
    {
        parent::configure();

        $description = '';
        $description .= 'Clean up database by deleting records from tables specified in configuration file. ' . PHP_EOL;
        $description .= '  ';

        $this
            ->setName('db:delete')
            ->setDescription($description);


    }

    protected function execute(InputInterface $input, OutputInterface $output)

    {
        parent::execute($input, $output);

        // Operations config
        $cleanupConf = $this->config->getDeleteCleanup();
        if (is_null($cleanupConf)) {
            $this->output->warn('There is nothing to delete according to configuration.');
interface User
{
    /** @return string */
    public function getPassword();
}

class MyUser implements User
{
    public function getPassword()
    {
        // return something
    }

    public function getDisplayName()
    {
        // return some name.
    }
}

class AuthSystem
{
    public function authenticate(User $user)
    {
        $this->logger->info(sprintf('Authenticating %s.', $user->getDisplayName()));
        // do something.
    }
}
            return;
        }

        // Setup connection
        $this->setup();

        // Perform
        $this->databaseSize['before'] = $this->db->size($this->config->getDatabaseName());
        $this->performDeleteOperations($cleanupConf);
        $this->databaseSize['after'] = $this->db->size($this->config->getDatabaseName());

        // Output gain
        $this->outputGain();
    }

    protected function performDeleteOperations($cleanupConf)
    {
        // Get all tables
        $this->table = new Table();

        $all = $this->table->all($this->databaseName);

        foreach ($cleanupConf as $tableOperations) {
            $this->performTableDeleteOperations($tableOperations, $all);
        }
    }

    protected function performTableDeleteOperations($tableOperations, $all)
    {
        // First : Let's get tables
        $tables = array();
        $table = $tableOperations->table;
        if (!$tableOperations->multi) {
            $tables[] = $table;
        } else {
            $matchedTables = $this->table->getTablesForMulti($table, $this->databasePrefix, $all);
            if (!empty($matchedTables)) {
                $tables = array_merge($tables, $matchedTables);
            }
        }

        // Perform delete operations
        foreach ($tables as $table) {
            $this->output->info("Deleting items from table $table ...");
interface User
{
    /** @return string */
    public function getPassword();
}

class MyUser implements User
{
    public function getPassword()
    {
        // return something
    }

    public function getDisplayName()
    {
        // return some name.
    }
}

class AuthSystem
{
    public function authenticate(User $user)
    {
        $this->logger->info(sprintf('Authenticating %s.', $user->getDisplayName()));
        // do something.
    }
}
            $this->output->info("     -> " . json_encode($tableOperations->conditions));
interface User
{
    /** @return string */
    public function getPassword();
}

class MyUser implements User
{
    public function getPassword()
    {
        // return something
    }

    public function getDisplayName()
    {
        // return some name.
    }
}

class AuthSystem
{
    public function authenticate(User $user)
    {
        $this->logger->info(sprintf('Authenticating %s.', $user->getDisplayName()));
        // do something.
    }
}
            $dbTable = Database::table($table);
            foreach ($tableOperations->conditions as $cond) {
                $dbTable->where($cond->field, $cond->operator, $cond->value);
            }
            $dbTable->delete();
        }
    }
}

1		<?php namespace Tequilarapido\Cli\Commands;
2
3		use Symfony\Component\Console\Input\InputInterface;
4		use Symfony\Component\Console\Output\OutputInterface;
5		use Tequilarapido\Cli\Commands\Base\AbstractDatabaseCommand;
6		use Tequilarapido\Database\Database;
7		use Tequilarapido\Database\Table;
8
9		class DatabaseDeleteCleanup extends AbstractDatabaseCommand
10		{
11
12		protected function configure()
13		{
14		parent::configure();
15
16		$description = '';
17		$description .= 'Clean up database by deleting records from tables specified in configuration file. ' . PHP_EOL;
18		$description .= ' ';
19
20		$this
21		->setName('db:delete')
22		->setDescription($description);
23
24
25		}
26
27	View Code Duplication	protected function execute(InputInterface $input, OutputInterface $output)
		0 ignored issues – show Duplication introduced 2016-10-06 10:37 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
28		{
29		parent::execute($input, $output);
30
31		// Operations config
32		$cleanupConf = $this->config->getDeleteCleanup();
33		if (is_null($cleanupConf)) {
34		$this->output->warn('There is nothing to delete according to configuration.');
		0 ignored issues – show Bug introduced 2016-10-06 10:37 UTC by Report Bug Copy Issue Report It seems like you code against a concrete implementation and not the interface `Symfony\Component\Console\Output\OutputInterface` as the method `warn()` does only exist in the following implementations of said interface: `Tequilarapido\Cli\EnhancedOutput`. Let’s take a look at an example: interface User { /** @return string / public function getPassword(); } class MyUser implements User { public function getPassword() { // return something } public function getDisplayName() { // return some name. } } class AuthSystem { public function authenticate(User $user) { $this->logger->info(sprintf('Authenticating %s.', $user->getDisplayName())); // do something. } } In the above example, the authenticate() method works fine as long as you just pass instances of MyUser. However, if you now also want to pass a different implementation of User which does not have a getDisplayName() method, the code will break. Available Fixes Change the type-hint for the parameter: class AuthSystem { public function authenticate(MyUser $user) { / ... / } } Add an additional type-check: class AuthSystem { public function authenticate(User $user) { if ($user instanceof MyUser) { $this->logger->info(/* ... /); } // or alternatively if ( ! $user instanceof MyUser) { throw new \LogicException( '$user must be an instance of MyUser, ' .'other instances are not supported.' ); } } } Note:* PHP Analyzer uses reverse abstract interpretation to narrow down the types inside the if block in such a case. Add the method to the interface: interface User { /** @return string / public function getPassword(); /* @return string */ public function getDisplayName(); } Loading history...
35		return;
36		}
37
38		// Setup connection
39		$this->setup();
40
41		// Perform
42		$this->databaseSize['before'] = $this->db->size($this->config->getDatabaseName());
43		$this->performDeleteOperations($cleanupConf);
44		$this->databaseSize['after'] = $this->db->size($this->config->getDatabaseName());
45
46		// Output gain
47		$this->outputGain();
48		}
49
50		protected function performDeleteOperations($cleanupConf)
51		{
52		// Get all tables
53		$this->table = new Table();
		0 ignored issues – show Documentation Bug introduced 2016-10-06 10:37 UTC by Report Bug Copy Issue Report It seems like `new \Tequilarapido\Database\Table()` of type `object<Tequilarapido\Database\Table>` is incompatible with the declared type `object<Tequilarapido\Cli\Commands\Base\Table>` of property `$table`. Our type inference engine has found an assignment to a property that is incompatible with the declared type of that property. Either this assignment is in error or the assigned type should be added to the documentation/type hint for that property.. Loading history...
54		$all = $this->table->all($this->databaseName);
55
56		foreach ($cleanupConf as $tableOperations) {
57		$this->performTableDeleteOperations($tableOperations, $all);
58		}
59		}
60
61		protected function performTableDeleteOperations($tableOperations, $all)
62		{
63		// First : Let's get tables
64		$tables = array();
65		$table = $tableOperations->table;
66		if (!$tableOperations->multi) {
67		$tables[] = $table;
68		} else {
69		$matchedTables = $this->table->getTablesForMulti($table, $this->databasePrefix, $all);
70		if (!empty($matchedTables)) {
71		$tables = array_merge($tables, $matchedTables);
72		}
73		}
74
75		// Perform delete operations
76		foreach ($tables as $table) {
77		$this->output->info("Deleting items from table $table ...");
		0 ignored issues – show Bug introduced 2016-10-06 10:37 UTC by Report Bug Copy Issue Report It seems like you code against a concrete implementation and not the interface `Symfony\Component\Console\Output\OutputInterface` as the method `info()` does only exist in the following implementations of said interface: `Tequilarapido\Cli\EnhancedOutput`. Let’s take a look at an example: interface User { /** @return string / public function getPassword(); } class MyUser implements User { public function getPassword() { // return something } public function getDisplayName() { // return some name. } } class AuthSystem { public function authenticate(User $user) { $this->logger->info(sprintf('Authenticating %s.', $user->getDisplayName())); // do something. } } In the above example, the authenticate() method works fine as long as you just pass instances of MyUser. However, if you now also want to pass a different implementation of User which does not have a getDisplayName() method, the code will break. Available Fixes Change the type-hint for the parameter: class AuthSystem { public function authenticate(MyUser $user) { / ... / } } Add an additional type-check: class AuthSystem { public function authenticate(User $user) { if ($user instanceof MyUser) { $this->logger->info(/* ... /); } // or alternatively if ( ! $user instanceof MyUser) { throw new \LogicException( '$user must be an instance of MyUser, ' .'other instances are not supported.' ); } } } Note:* PHP Analyzer uses reverse abstract interpretation to narrow down the types inside the if block in such a case. Add the method to the interface: interface User { /** @return string / public function getPassword(); /* @return string */ public function getDisplayName(); } Loading history...
78		$this->output->info(" -> " . json_encode($tableOperations->conditions));
		0 ignored issues – show Bug introduced 2016-10-06 10:37 UTC by Report Bug Copy Issue Report It seems like you code against a concrete implementation and not the interface `Symfony\Component\Console\Output\OutputInterface` as the method `info()` does only exist in the following implementations of said interface: `Tequilarapido\Cli\EnhancedOutput`. Let’s take a look at an example: interface User { /** @return string / public function getPassword(); } class MyUser implements User { public function getPassword() { // return something } public function getDisplayName() { // return some name. } } class AuthSystem { public function authenticate(User $user) { $this->logger->info(sprintf('Authenticating %s.', $user->getDisplayName())); // do something. } } In the above example, the authenticate() method works fine as long as you just pass instances of MyUser. However, if you now also want to pass a different implementation of User which does not have a getDisplayName() method, the code will break. Available Fixes Change the type-hint for the parameter: class AuthSystem { public function authenticate(MyUser $user) { / ... / } } Add an additional type-check: class AuthSystem { public function authenticate(User $user) { if ($user instanceof MyUser) { $this->logger->info(/* ... /); } // or alternatively if ( ! $user instanceof MyUser) { throw new \LogicException( '$user must be an instance of MyUser, ' .'other instances are not supported.' ); } } } Note:* PHP Analyzer uses reverse abstract interpretation to narrow down the types inside the if block in such a case. Add the method to the interface: interface User { /** @return string / public function getPassword(); /* @return string */ public function getDisplayName(); } Loading history...
79		$dbTable = Database::table($table);
80		foreach ($tableOperations->conditions as $cond) {
81		$dbTable->where($cond->field, $cond->operator, $cond->value);
82		}
83		$dbTable->delete();
84		}
85		}
86		}

tequilarapido / appcli

DatabaseDeleteCleanup::configure() A last analyzed 2016-10-06 13:29 UTC

Complexity

Size

Duplication

Importance

Available Fixes

Available Fixes

Available Fixes

Duplication Side-by-Side

Filter issues like

DatabaseDeleteCleanup::configure() A
last analyzed 2016-10-06 13:29 UTC