Rottenwood\KingdomBundle\Command\Console\Integration\Truncate::truncateEntity()

Complexity

Conditions	4
Paths	20

Size

Total Lines	32
Code Lines	22

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    protected function truncateEntity(
        string $entityName,
        OutputInterface $output = null,
        string $startEcho = '',
        string $endEcho = ''
    ) {
        if ($output) {
            $output->write($startEcho);
        }

        $em = $this->getContainer()->get('doctrine.orm.entity_manager');

        $entityMetadata = $em->getClassMetadata($entityName);
        $tableName = $entityMetadata->getTableName();
        $connection = $em->getConnection();
        $connection->beginTransaction();

        try {
            $connection->query('SET FOREIGN_KEY_CHECKS=0');
            $connection->query('DELETE FROM ' . $tableName);
            $connection->query('SET FOREIGN_KEY_CHECKS=1');
            $connection->commit();
        } catch (\Exception $e) {
            $connection->rollback();
        }

        $connection->exec('ALTER TABLE ' . $tableName . ' AUTO_INCREMENT = 1;');

        if ($output) {
            $output->writeln($endEcho);
        }
    }
}