<?php

declare(strict_types=1);

/**
 * vim:set softtabstop=4 shiftwidth=4 expandtab:
 *
 * LICENSE: GNU Affero General Public License, version 3 (AGPL-3.0-or-later)
 * Copyright Ampache.org, 2001-2026
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <https://www.gnu.org/licenses/>.
 *
 */

namespace Ampache\Repository;

use Ampache\Module\Database\DatabaseConnectionInterface;
use Ampache\Repository\Model\MetadataField;
use PDO;
use PDOStatement;
use PHPUnit\Framework\MockObject\MockObject;
use PHPUnit\Framework\TestCase;
use Psr\Log\LoggerInterface;

class MetadataFieldRepositoryTest extends TestCase
{
    private DatabaseConnectionInterface&MockObject $connection;
    private LoggerInterface&MockObject $logger;
    private MetadataFieldRepository $subject;

    public function testCollectGarbageExecutesQuery(): void
    {
        $this->connection->expects(static::once())
            ->method('query')
            ->with('DELETE FROM `metadata_field` USING `metadata_field` LEFT JOIN `metadata` ON `metadata`.`field` = `metadata_field`.`id` WHERE `metadata`.`id` IS NULL;');

        $this->subject->collectGarbage();
    }

    public function testFindByIdReturnsFoundItem(): void
    {
        $id = 666;

        $result = $this->createMock(PDOStatement::class);
        $item   = $this->createMock(MetadataField::class);

        $this->connection->expects(static::once())
            ->method('query')
            ->with(
                "SELECT `id`, IFNULL(`name`, '') AS `name`, `public` FROM `metadata_field` WHERE `id` = ?",
                [
                    $id
                ],
            )
            ->willReturn($result);

        $result->expects(static::once())
            ->method('setFetchMode')
            ->with(PDO::FETCH_CLASS, MetadataField::class, [$this->subject]);
        $result->expects(static::once())
            ->method('fetch')
            ->willReturn($item);

        self::assertSame(
            $item,
            $this->subject->findById($id)
        );
    }

    public function testFindByIdReturnsNullIfNoItemWasFound(): void
    {
        $id = 666;

        $result = $this->createMock(PDOStatement::class);

        $this->connection->expects(static::once())
            ->method('query')
            ->with(
                "SELECT `id`, IFNULL(`name`, '') AS `name`, `public` FROM `metadata_field` WHERE `id` = ?",
                [
                    $id
                ],
            )
            ->willReturn($result);

        $result->expects(static::once())
            ->method('setFetchMode')
            ->with(PDO::FETCH_CLASS, MetadataField::class, [$this->subject]);
        $result->expects(static::once())
            ->method('fetch')
            ->willReturn(false);

        self::assertNull(
            $this->subject->findById($id)
        );
    }

    public function testFindByNameReturnsFoundItem(): void
    {
        $name = 'some-name';

        $result = $this->createMock(PDOStatement::class);
        $item   = $this->createMock(MetadataField::class);

        $this->connection->expects(static::once())
            ->method('query')
            ->with(
                "SELECT `id`, IFNULL(`name`, '') AS `name`, `public` FROM `metadata_field` WHERE `name` = ? LIMIT 1",
                [
                    $name
                ],
            )
            ->willReturn($result);

        $result->expects(static::once())
            ->method('setFetchMode')
            ->with(PDO::FETCH_CLASS, MetadataField::class, [$this->subject]);
        $result->expects(static::once())
            ->method('fetch')
            ->willReturn($item);

        self::assertSame(
            $item,
            $this->subject->findByName($name)
        );
    }

    public function testFindByNameReturnsNullIfNoItemWasFound(): void
    {
        $name = 'some-name';

        $result = $this->createMock(PDOStatement::class);

        $this->connection->expects(static::once())
            ->method('query')
            ->with(
                "SELECT `id`, IFNULL(`name`, '') AS `name`, `public` FROM `metadata_field` WHERE `name` = ? LIMIT 1",
                [
                    $name
                ],
            )
            ->willReturn($result);

        $result->expects(static::once())
            ->method('setFetchMode')
            ->with(PDO::FETCH_CLASS, MetadataField::class, [$this->subject]);
        $result->expects(static::once())
            ->method('fetch')
            ->willReturn(false);

        self::assertNull(
            $this->subject->findByName($name)
        );
    }

    public function testGetPropertyListReturnsData(): void
    {
        $id   = 666;
        $name = 'some-name';

        $result = $this->createMock(PDOStatement::class);

        $this->connection->expects(static::once())
            ->method('query')
            ->with('SELECT `id`, `name` FROM `metadata_field`')
            ->willReturn($result);

        $result->expects(static::exactly(2))
            ->method('fetch')
            ->with(PDO::FETCH_ASSOC)
            ->willReturn(['id' => (string) $id, 'name' => $name], false);

        self::assertSame(
            [$id => $name],
            iterator_to_array($this->subject->getPropertyList())
        );
    }

    public function testPersistInsertsNewItemIfNew(): void
    {
        $field = $this->createMock(MetadataField::class);

        $name   = 'some-name';
        $public = true;
        $result = 666;

        $field->expects(static::once())
            ->method('isNew')
            ->willReturn(true);
        $field->expects(static::once())
            ->method('getName')
            ->willReturn($name);
        $field->expects(static::once())
            ->method('isPublic')
            ->willReturn($public);

        $this->connection->expects(static::once())
            ->method('query')
            ->with(
                'INSERT INTO `metadata_field` (`name`, `public`) VALUES (?, ?)',
                [
                    $name,
                    $public
                ]
            );
        $this->connection->expects(static::once())
            ->method('getLastInsertedId')
            ->willReturn($result);

        self::assertSame(
            $result,
            $this->subject->persist($field)
        );
    }

    public function testPersistUpdatesExistingItem(): void
    {
        $field = $this->createMock(MetadataField::class);

        $fieldId = 42;
        $name    = 'some-name';
        $public  = true;

        $field->expects(static::once())
            ->method('isNew')
            ->willReturn(false);
        $field->expects(static::once())
            ->method('getName')
            ->willReturn($name);
        $field->expects(static::once())
            ->method('isPublic')
            ->willReturn($public);
        $field->expects(static::once())
            ->method('getId')
            ->willReturn($fieldId);

        $this->connection->expects(static::once())
            ->method('query')
            ->with(
                'UPDATE `metadata_field` SET `name` = ?, `public` = ? WHERE `id` = ?',
                [
                    $name,
                    $public,
                    $fieldId
                ]
            );

        self::assertNull(
            $this->subject->persist($field)
        );
    }

    public function testPrototypeReturnsNewItem(): void
    {
        self::assertInstanceOf(
            MetadataField::class,
            $this->subject->prototype()
        );
    }

    protected function setUp(): void
    {
        $this->connection = $this->createMock(DatabaseConnectionInterface::class);
        $this->logger     = $this->createMock(LoggerInterface::class);

        $this->subject = new MetadataFieldRepository(
            $this->connection,
            $this->logger,
        );
    }
}