Stu\Orm\Repository\SpacecraftSystemRepository

Complexity

Total Complexity

9

Size/Duplication

Total Lines	121
Duplicated Lines	0 %

Test Coverage

Coverage

39.34%

Importance

Changes

0

9 Methods

Rating	Name	Duplication	Size	Complexity
A	getByShip()	0	6	1
A	getWebOwningShipSystem()	0	17	1
A	isSystemHealthy()	0	17	1
A	delete()	0	6	1
A	prototype()	0	4	1
A	getTrackingShipSystems()	0	17	1
A	truncateByShip()	0	12	1
A	save()	0	6	1
A	getWebConstructingShipSystems()	0	17	1

<?php

declare(strict_types=1);

namespace Stu\Orm\Repository;

use Doctrine\ORM\EntityRepository;
use Override;

The type Override was not found. Maybe you did not declare it correctly or list all dependencies?

use Stu\Component\Spacecraft\System\SpacecraftSystemTypeEnum;
use Stu\Orm\Entity\Spacecraft;
use Stu\Orm\Entity\SpacecraftSystem;

/**
 * @extends EntityRepository<SpacecraftSystem>
 */
final class SpacecraftSystemRepository extends EntityRepository implements SpacecraftSystemRepositoryInterface
{
    #[Override]
    public function prototype(): SpacecraftSystem
    {
        return new SpacecraftSystem();
    }

    #[Override]
    public function save(SpacecraftSystem $post): void
    {
        $em = $this->getEntityManager();

        $em->persist($post);
    }

    #[Override]
    public function delete(SpacecraftSystem $post): void
    {
        $em = $this->getEntityManager();

        $em->remove($post);
    }

    #[Override]
    public function getByShip(int $shipId): array
    {
        return $this->findBy(
            ['spacecraft_id' => $shipId],
            ['system_type' => 'asc']
        );
    }

    #[Override]
    public function getTrackingShipSystems(int $targetId): array
    {
        return $this->getEntityManager()
            ->createQuery(
                sprintf(
                    'SELECT ss FROM %s ss
                    WHERE ss.system_type = :systemType
                    AND ss.data LIKE :target',
                    SpacecraftSystem::class
                )
            )
            ->setParameters([
                'systemType' => SpacecraftSystemTypeEnum::TRACKER,
                'target' => sprintf('%%"targetId":%d%%', $targetId)
            ])
            ->getResult();
    }

    #[Override]
    public function getWebConstructingShipSystems(int $webId): array
    {
        return $this->getEntityManager()
            ->createQuery(
                sprintf(
                    'SELECT ss FROM %s ss
                    WHERE ss.system_type = :systemType
                    AND ss.data LIKE :target',
                    SpacecraftSystem::class
                )
            )
            ->setParameters([
                'systemType' => SpacecraftSystemTypeEnum::THOLIAN_WEB,
                'target' => sprintf('%%"webUnderConstructionId":%d%%', $webId)
            ])
            ->getResult();
    }

    #[Override]
    public function getWebOwningShipSystem(int $webId): ?SpacecraftSystem
    {
        return $this->getEntityManager()
            ->createQuery(
                sprintf(
                    'SELECT ss FROM %s ss
                    WHERE ss.system_type = :systemType
                    AND ss.data LIKE :target',
                    SpacecraftSystem::class
                )
            )
            ->setParameters([
                'systemType' => SpacecraftSystemTypeEnum::THOLIAN_WEB,
                'target' => sprintf('%%"ownedWebId":%d%%', $webId)
            ])
            ->getOneOrNullResult();
    }

    #[Override]
    public function isSystemHealthy(Spacecraft $spacecraft, SpacecraftSystemTypeEnum $type): bool
    {
        return (int)$this->getEntityManager()
            ->createQuery(
                sprintf(
                    'SELECT ss.status FROM %s ss
                    WHERE ss.system_type = :systemType
                    AND ss.spacecraft = :spacecraft',
                    SpacecraftSystem::class
                )
            )
            ->setParameters([
                'systemType' => $type->value,
                'spacecraft' => $spacecraft
            ])
            ->getSingleScalarResult() > 0;
    }

    #[Override]
    public function truncateByShip(int $shipId): void
    {
        $this->getEntityManager()
            ->createQuery(
                sprintf(
                    'DELETE FROM %s s WHERE s.spacecraft_id = :shipId',
                    SpacecraftSystem::class
                )
            )
            ->setParameter('shipId', $shipId)
            ->execute();
    }
}