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($this->once())->method('query')->willReturn($statement);
        $db->expects($this->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($this->once())->method('associations')->willReturn([$association]);
        $definition->expects($this->once())->method('tableName')->willReturn('table_a');
        $definition->expects($this->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->assertSame(17, $result->violations());
    }
}