DatabaseHelperTrait::truncateTable() - Code Metrics - Inspection of "Add debug and verbose options to phpunit command" - kiwijos/mvc-report - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — main ( 5011e1...c36c7b )

by Alex

created 2023-07-19 13:35 UTC

DatabaseHelperTrait::truncateTable() A

↳ Parent: DatabaseHelperTrait

Complexity

Conditions	1
Paths	1

Size

Total Lines	7
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	3
c	1
b	0
f	0
nc	1
nop	2
dl	0
loc	7
rs	10

<?php

namespace App\Tests;

use Doctrine\ORM\EntityManagerInterface;

trait DatabaseHelperTrait
{
    /**
     * Truncates the specified table to remove all data.
     *
     * @param EntityManagerInterface $entityManager The entity manager instance.
     * @param string                 $tableName     The name of the table to truncate.
     */
    private function truncateTable(EntityManagerInterface $entityManager, string $tableName): void
    {
        $connection = $entityManager->getConnection();
        $platform = $connection->getDatabasePlatform();

        // Execute a truncate table SQL statement for the specified table
        $connection->executeQuery($platform->getTruncateTableSQL($tableName, true));
    }

    /**
     * Asserts that the specified table is empty.
     *
     * @param EntityManagerInterface $entityManager The entity manager instance.
     * @param string                 $tableName     The name of the table to check.
     */
    private function assertEmptyTable(EntityManagerInterface $entityManager, string $tableName): void
    {
        $entityNamespace = $this->getEntityNameSpace($entityManager, $tableName);
        $query = $entityManager->createQuery("SELECT COUNT(e) FROM {$entityNamespace} e");
        $count = $query->getSingleScalarResult();

        $this->assertSame(0, $count, "The '$tableName' table is not empty.");
               assertSame(0, $count, "The '$tableName' table is not empty.");
    }

    /**
     * Asserts that the specified table is not empty.
     *
     * @param EntityManagerInterface $entityManager The entity manager instance.
     * @param string                 $tableName     The name of the table to check.
     */
    private function assertNonEmptyTable(EntityManagerInterface $entityManager, string $tableName): void
    {
        $entityNamespace = $this->getEntityNameSpace($entityManager, $tableName);
        $query = $entityManager->createQuery("SELECT COUNT(e) FROM {$entityNamespace} e");
        $count = $query->getSingleScalarResult();

        $this->assertGreaterThan(0, $count, "The '$tableName' table is empty.");
               assertGreaterThan(0, $count, "The '$tableName' table is empty.");
    }

    private function getEntityNameSpace(EntityManagerInterface $entityManager, string $tableName): string
    {
        $configuration = $entityManager->getConfiguration();
        $entityNamespaces = $configuration->getEntityNamespaces();
        foreach ($entityNamespaces as $namespace) {
            $entityClass = $namespace . '\\' . ucfirst($tableName); // Assume that the name's first character should be uppercase

            if (class_exists($entityClass)) {
                return $entityClass;
            }
        }
interface ReturnsInt {
    public function returnsIntHinted(): int;
}

class MyClass implements ReturnsInt {
    public function returnsIntHinted(): int
    {
        if (foo()) {
            return 123;
        }
        // here: null is implicitly returned
    }
}
    }
}


kiwijos / mvc-report

Push — main ( 5011e1...c36c7b )

DatabaseHelperTrait::truncateTable() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like