Uxmp\Core\Orm\Repository\DiscRepository

Complexity

Total Complexity

5

Size/Duplication

Total Lines	56
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	prototype()	0	3	1
A	save()	0	4	1
A	delete()	0	4	1
A	findUniqueDisc()	0	7	1
A	findEmptyDiscs()	0	24	1

<?php

declare(strict_types=1);

namespace Uxmp\Core\Orm\Repository;

use Doctrine\ORM\EntityRepository;
use Uxmp\Core\Orm\Model\Album;
use Uxmp\Core\Orm\Model\CatalogInterface;
use Uxmp\Core\Orm\Model\Disc;
use Uxmp\Core\Orm\Model\DiscInterface;
use Uxmp\Core\Orm\Model\Song;

/**
 * @extends EntityRepository<Disc>
 */
final class DiscRepository extends EntityRepository implements DiscRepositoryInterface
{
    public function prototype(): DiscInterface
    {
        return new Disc();
    }

    public function save(DiscInterface $disc): void
    {
        $this->getEntityManager()->persist($disc);
        $this->getEntityManager()->flush();
    }

    public function delete(DiscInterface $disc): void
    {
        $this->getEntityManager()->remove($disc);
        $this->getEntityManager()->flush();
    }

    /**
     * Find a unique disc by its mbid and the disc number within a release group
     */
    public function findUniqueDisc(
        string $musicBrainzDiscId,
        int $discNumber
    ): ?DiscInterface {
        return $this->findOneBy([
            'mbid' => $musicBrainzDiscId,
            'number' => $discNumber,
        ]);
    }

    public function findEmptyDiscs(CatalogInterface $catalog): array
    {
        $query = <<<SQL
            SELECT disc
            FROM %s disc
            LEFT JOIN %s song 
            WITH song.disc_id = disc.id
            LEFT JOIN %s album
            WITH album.id = disc.album_id
            WHERE album.catalog = :catalog
            GROUP BY disc HAVING COUNT(song.id) = 0
            SQL;

        return $this->getEntityManager()
            ->createQuery(
                sprintf(
                    $query,
                    Disc::class,
                    Song::class,
                    Album::class,
                )
            )
            ->setParameters(['catalog' => $catalog])
            ->getResult();
    }
}