IntegrityTest.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

namespace ILIAS\Tests\Services\Database\Integrity;

use PHPUnit\Framework\TestCase;
use ILIAS\components\Database\Integrity\Integrity;
use ILIAS\components\Database\Integrity\Definition;
use ILIAS\components\Database\Integrity\Result;
use ILIAS\components\Database\Integrity\Association;
use ILIAS\components\Database\Integrity\Field;
use ilDBInterface;
use ilDBStatement;

class IntegrityTest extends TestCase
{
    public function testConstruct(): void
    {
        $db = $this->getMockBuilder(ilDBInterface::class)->getMock();
        $integrity = new Integrity($db);
        $this->assertInstanceOf(Integrity::class, $integrity);
    }

    public function testCheck(): void
    {
        $statement = $this->getMockBuilder(ilDBStatement::class)->getMock();

        $db = $this->getMockBuilder(ilDBInterface::class)->getMock();
        $db->expects(self::once())->method('query')->willReturn($statement);
        $db->expects(self::once())->method('fetchAssoc')->with($statement)->willReturn(['violations' => '17']);

        $field = $this->getMockBuilder(Field::class)->disableOriginalConstructor()->getMock();
        $field->method('fieldName')->willReturn('hej');

        $referenceField = $this->getMockBuilder(Field::class)->disableOriginalConstructor()->getMock();
        $referenceField->method('fieldName')->willReturn('ho');

        $association = $this->getMockBuilder(Association::class)->disableOriginalConstructor()->getMock();
        $association->method('field')->willReturn($field);
        $association->method('referenceField')->willReturn($referenceField);

        $definition = $this->getMockBuilder(Definition::class)->disableOriginalConstructor()->getMock();
        $definition->expects(self::once())->method('associations')->willReturn([$association]);
        $definition->expects(self::once())->method('tableName')->willReturn('table_a');
        $definition->expects(self::once())->method('referenceTableName')->willReturn('table_b');
        $definition->method('ignoreValues')->willReturn(['Some SQL.']);

        $integrity = new Integrity($db);

        $result = $integrity->check($definition);
        $this->assertInstanceOf(Result::class, $result);
        $this->assertEquals(17, $result->violations());
    }
}