WebnetFr\DatabaseAnonymizerBundle\Tests\System\Command\AnonymizeCommandTest

Complexity

Total Complexity

5

Size/Duplication

Total Lines	69
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	setUp()	0	3	1
A	testExecute()	0	56	4

<?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 <vriabchenko@webnet.fr>
 */
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']));
        }
    }
}