TruncateTableTrait   A
last analyzed

Complexity

Total Complexity 2

Size/Duplication

Total Lines 22
Duplicated Lines 0 %

Importance

Changes 0
Metric Value
eloc 13
dl 0
loc 22
rs 10
c 0
b 0
f 0
wmc 2

1 Method

Rating   Name   Duplication   Size   Complexity  
A truncateTable() 0 14 2
1
<?php
2
/**
3
 * Created by PhpStorm.
4
 * User: siim
5
 * Date: 18.02.19
6
 * Time: 8:42
7
 */
8
9
namespace Sf4\Api\Utils\Traits;
10
11
use Doctrine\ORM\EntityManagerInterface;
12
13
trait TruncateTableTrait
14
{
15
    /**
16
     * @param EntityManagerInterface $em
17
     * @param string $className
18
     * @throws \Doctrine\DBAL\ConnectionException
19
     * @throws \Doctrine\DBAL\DBALException
20
     */
21
    public function truncateTable(EntityManagerInterface $em, string $className): void
22
    {
23
        $classMetaData = $em->getClassMetadata($className);
24
        $connection = $em->getConnection();
25
        $dbPlatform = $connection->getDatabasePlatform();
26
        $connection->beginTransaction();
27
        try {
28
            $connection->query('SET FOREIGN_KEY_CHECKS=0');
29
            $q = $dbPlatform->getTruncateTableSql($classMetaData->getTableName());
30
            $connection->executeUpdate($q);
31
            $connection->query('SET FOREIGN_KEY_CHECKS=1');
32
            $connection->commit();
33
        } catch (\Exception $e) {
34
            $connection->rollback();
35
        }
36
    }
37
}
38