AnonymizeCommandTest::testExecute() - Code Metrics - Inspection of "test" - webnet-fr/database-anonymizer-bundle - Measure and Improve Code Quality continuously with Scrutinizer

Test Failed

Push — master ( 87bd16...66bd2c )

by Webnet

created 2019-06-28 14:43 UTC

AnonymizeCommandTest::testExecute() A

↳ Parent: AnonymizeCommandTest

Complexity

Conditions	4
Paths	4

Size

Total Lines	56
Code Lines	44

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	4
eloc	44
c	1
b	0
f	0
nc	4
nop	0
dl	0
loc	56
rs	9.216

How to fix Long Method

<?php

namespace WebnetFr\DatabaseAnonymizerBundle\Tests\System\Command;

use PHPUnit\Framework\TestCase;
use Symfony\Component\Console\Application;
use Symfony\Component\Console\Tester\CommandTester;
use WebnetFr\DatabaseAnonymizer\GeneratorFactory\ChainGeneratorFactory;
use WebnetFr\DatabaseAnonymizer\GeneratorFactory\ConstantGeneratorFactory;
use WebnetFr\DatabaseAnonymizer\GeneratorFactory\FakerGeneratorFactory;
use WebnetFr\DatabaseAnonymizerBundle\Command\AnonymizeCommand;
use WebnetFr\DatabaseAnonymizerBundle\Tests\System\SystemTestTrait;

/**
 * @author Vlad Riabchenko <[email protected]>
 */
class AnonymizeCommandTest extends TestCase
{
    use SystemTestTrait;

    /**
     * {@inheritdoc}
     * @throws \Doctrine\DBAL\DBALException
     */
    protected function setUp()
    {
        $this->regenerateUsersOrders();
    }

    public function testExecute()
    {
        $generator = new ChainGeneratorFactory();
        $generator->addFactory(new ConstantGeneratorFactory())
            ->addFactory(new FakerGeneratorFactory());

        $command = (new Application('Database anonymizer', '0.0.1'))
            ->add(new AnonymizeCommand($generator));

        $commandTester = new CommandTester($command);

        $commandTester->setInputs(array('y'));
        $commandTester->execute([
            'command' => $command->getName(),
            '--config' => realpath(__DIR__.'/../../config/config.yaml'),
            '--type' => $GLOBALS['db_type'],
            '--host' => $GLOBALS['db_host'],
            '--port' => $GLOBALS['db_port'],
            '--database' => $GLOBALS['db_name'],
            '--user' => $GLOBALS['db_username'],
            '--password' => $GLOBALS['db_password'],
        ]);

        $connection = $this->getConnection();

        $selectSQL = $connection->createQueryBuilder()
            ->select('email, firstname, lastname, birthdate, phone, password')
            ->from('users')
            ->getSQL();
        $selectStmt = $connection->prepare($selectSQL);
        $selectStmt->execute();

        while ($row = $selectStmt->fetch()) {
            $this->assertTrue(is_string($row['email']));
            $this->assertTrue(is_string($row['firstname']));
            $this->assertTrue(is_string($row['lastname']));
            $this->assertTrue(is_string($row['birthdate']));
            $this->assertTrue(is_string($row['phone']) || is_null($row['phone']));
            $this->assertTrue(is_string($row['password']));
        }

        $selectSQL = $connection->createQueryBuilder()
            ->select('address, street_address, zip_code, city, country, comment, comment, created_at')
            ->from('orders')
            ->getSQL();
        $selectStmt = $connection->prepare($selectSQL);
        $selectStmt->execute();

        while ($row = $selectStmt->fetch()) {
            $this->assertTrue(is_string($row['address']));
            $this->assertTrue(is_string($row['street_address']));
            $this->assertTrue(is_string($row['zip_code']));
            $this->assertTrue(is_string($row['city']));
            $this->assertTrue(is_string($row['country']));
            $this->assertTrue(is_string($row['comment']));
            $this->assertTrue(is_string($row['created_at']));
        }
    }
}


1			<?php
2
3			namespace WebnetFr\DatabaseAnonymizerBundle\Tests\System\Command;
4
5			use PHPUnit\Framework\TestCase;
6			use Symfony\Component\Console\Application;
7			use Symfony\Component\Console\Tester\CommandTester;
8			use WebnetFr\DatabaseAnonymizer\GeneratorFactory\ChainGeneratorFactory;
9			use WebnetFr\DatabaseAnonymizer\GeneratorFactory\ConstantGeneratorFactory;
10			use WebnetFr\DatabaseAnonymizer\GeneratorFactory\FakerGeneratorFactory;
11			use WebnetFr\DatabaseAnonymizerBundle\Command\AnonymizeCommand;
12			use WebnetFr\DatabaseAnonymizerBundle\Tests\System\SystemTestTrait;
13
14			/**
15			* @author Vlad Riabchenko <[email protected]>
16			*/
17			class AnonymizeCommandTest extends TestCase
18			{
19			use SystemTestTrait;
20
21			/**
22			* {@inheritdoc}
23			* @throws \Doctrine\DBAL\DBALException
24			*/
25			protected function setUp()
26			{
27			$this->regenerateUsersOrders();
28			}
29
30			public function testExecute()
31			{
32			$generator = new ChainGeneratorFactory();
33			$generator->addFactory(new ConstantGeneratorFactory())
34			->addFactory(new FakerGeneratorFactory());
35
36			$command = (new Application('Database anonymizer', '0.0.1'))
37			->add(new AnonymizeCommand($generator));
38
39			$commandTester = new CommandTester($command);
40
41			$commandTester->setInputs(array('y'));
42			$commandTester->execute([
43			'command' => $command->getName(),
44			'--config' => realpath(__DIR__.'/../../config/config.yaml'),
45			'--type' => $GLOBALS['db_type'],
46			'--host' => $GLOBALS['db_host'],
47			'--port' => $GLOBALS['db_port'],
48			'--database' => $GLOBALS['db_name'],
49			'--user' => $GLOBALS['db_username'],
50			'--password' => $GLOBALS['db_password'],
51			]);
52
53			$connection = $this->getConnection();
54
55			$selectSQL = $connection->createQueryBuilder()
56			->select('email, firstname, lastname, birthdate, phone, password')
57			->from('users')
58			->getSQL();
59			$selectStmt = $connection->prepare($selectSQL);
60			$selectStmt->execute();
61
62			while ($row = $selectStmt->fetch()) {
63			$this->assertTrue(is_string($row['email']));
64			$this->assertTrue(is_string($row['firstname']));
65			$this->assertTrue(is_string($row['lastname']));
66			$this->assertTrue(is_string($row['birthdate']));
67			$this->assertTrue(is_string($row['phone']) \|\| is_null($row['phone']));
68			$this->assertTrue(is_string($row['password']));
69			}
70
71			$selectSQL = $connection->createQueryBuilder()
72			->select('address, street_address, zip_code, city, country, comment, comment, created_at')
73			->from('orders')
74			->getSQL();
75			$selectStmt = $connection->prepare($selectSQL);
76			$selectStmt->execute();
77
78			while ($row = $selectStmt->fetch()) {
79			$this->assertTrue(is_string($row['address']));
80			$this->assertTrue(is_string($row['street_address']));
81			$this->assertTrue(is_string($row['zip_code']));
82			$this->assertTrue(is_string($row['city']));
83			$this->assertTrue(is_string($row['country']));
84			$this->assertTrue(is_string($row['comment']));
85			$this->assertTrue(is_string($row['created_at']));
86			}
87			}
88			}
89

webnet-fr / database-anonymizer-bundle

Push — master ( 87bd16...66bd2c )

AnonymizeCommandTest::testExecute() A

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like