ilUserCertificateRepositoryTest.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
use ILIAS\Certificate\ValueObject\CertificateId;
 
class ilUserCertificateRepositoryTest extends ilCertificateBaseTestCase
{
    public function testSaveOfUserCertificateToDatabase(): void
    {
        $database = $this->createMock(ilDBInterface::class);
 
        $database->method('nextId')
            ->willReturn(141);
 
        $database->method('insert')->with(
            'il_cert_user_cert',
            [
                'id' => ['integer', 141],
                'pattern_certificate_id' => ['integer', 1],
                'obj_id' => ['integer', 20],
                'obj_type' => ['text',  'crs'],
                'usr_id' => ['integer', 400],
                'user_name' => ['text', 'Niels Theen'],
                'acquired_timestamp' => ['integer', 123_456_789],
                'certificate_content' => ['clob', '<xml>Some Content</xml>'],
                'template_values' => ['clob', '[]'],
                'valid_until' => ['integer', null],
                'version' => ['integer', 1],
                'ilias_version' => ['text', 'v5.4.0'],
                'currently_active' => ['integer', true],
                'background_image_ident' => ['text', '-'],
                'tile_image_ident' => ['text', '-'],
                'certificate_id' => ['text', '11111111-2222-3333-4444-555555555555'],
            ]
        );
 
        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $logger->expects($this->atLeastOnce())
            ->method('debug');
 
        $repository = new ilUserCertificateRepository(
            $database,
            $logger,
            'someDefaultTitle'
        );
 
        $userCertificate = new ilUserCertificate(
            1,
            20,
            'crs',
            400,
            'Niels Theen',
            123_456_789,
            '<xml>Some Content</xml>',
            '[]',
            null,
            1,
            'v5.4.0',
            true,
            new CertificateId('11111111-2222-3333-4444-555555555555'),
            '-',
            '-',
            null
        );
 
        $repository->save($userCertificate);
    }
 
    public function testFetchAllActiveCertificateForUser(): void
    {
        $database = $this->createMock(ilDBInterface::class);
 
        $database->method('nextId')
            ->willReturn(141);
 
        $database->method('fetchAssoc')->willReturnOnConsecutiveCalls(
            [
                'id' => 141,
                'pattern_certificate_id' => 1,
                'obj_id' => 20,
                'obj_type' => 'crs',
                'usr_id' => 400,
                'user_name' => 'Niels Theen',
                'acquired_timestamp' => 123_456_789,
                'certificate_content' => '<xml>Some Content</xml>',
                'template_values' => '[]',
                'valid_until' => null,
                'version' => 1,
                'ilias_version' => 'v5.4.0',
                'currently_active' => true,
                'background_image_ident' => '-',
                'tile_image_ident' => '-',
                'title' => 'Some Title',
                'certificate_id' => '11111111-2222-3333-4444-555555555555'
            ],
            [
                'id' => 142,
                'pattern_certificate_id' => 5,
                'obj_id' => 3123,
                'obj_type' => 'tst',
                'usr_id' => 400,
                'user_name' => 'Niels Theen',
                'acquired_timestamp' => 987_654_321,
                'certificate_content' => '<xml>Some Other Content</xml>',
                'template_values' => '[]',
                'valid_until' => null,
                'version' => 1,
                'ilias_version' => 'v5.3.0',
                'currently_active' => true,
                'background_image_ident' => '-',
                'tile_image_ident' => '-',
                'title' => 'Someother Title',
                'certificate_id' => '11111111-2222-3333-4444-555555555555'
            ],
            null
        );
 
        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $logger->expects($this->atLeastOnce())
            ->method('debug');
 
        $repository = new ilUserCertificateRepository(
            $database,
            $logger,
            'someDefaultTitle'
        );
 
        $results = $repository->fetchActiveCertificates(400);
 
        $this->assertSame(141, $results[0]->getUserCertificate()->getId());
        $this->assertSame(142, $results[1]->getUserCertificate()->getId());
    }
 
    public function testFetchActiveCertificateForUserObjectCombination(): void
    {
        $database = $this->createMock(ilDBInterface::class);
 
        $database->method('nextId')
            ->willReturn(141);
 
        $database->method('fetchAssoc')->willReturnOnConsecutiveCalls(
            [
                'id' => 141,
                'pattern_certificate_id' => 1,
                'obj_id' => 20,
                'obj_type' => 'crs',
                'usr_id' => 400,
                'user_name' => 'Niels Theen',
                'acquired_timestamp' => 123_456_789,
                'certificate_content' => '<xml>Some Content</xml>',
                'template_values' => '[]',
                'valid_until' => null,
                'version' => 1,
                'ilias_version' => 'v5.4.0',
                'currently_active' => true,
                'background_image_ident' => '-',
                'tile_image_ident' => '-',
                'certificate_id' => '11111111-2222-3333-4444-555555555555'
            ],
            [
                'id' => 142,
                'pattern_certificate_id' => 5,
                'obj_id' => 20,
                'obj_type' => 'tst',
                'usr_id' => 400,
                'user_name' => 'Niels Theen',
                'acquired_timestamp' => 987_654_321,
                'certificate_content' => '<xml>Some Other Content</xml>',
                'template_values' => '[]',
                'valid_until' => null,
                'version' => 1,
                'ilias_version' => 'v5.3.0',
                'currently_active' => true,
                'background_image_ident' => '-',
                'tile_image_ident' => '-',
                'certificate_id' => '11111111-2222-3333-4444-555555555555'
            ]
        );
 
        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $logger->expects($this->atLeastOnce())
            ->method('debug');
 
        $repository = new ilUserCertificateRepository(
            $database,
            $logger,
            'someDefaultTitle'
        );
 
        $result = $repository->fetchActiveCertificate(400, 20);
 
        $this->assertSame(141, $result->getId());
    }
 
    public function testFetchNoActiveCertificateLeadsToException(): never
    {
        $this->expectException(ilException::class);
 
        $database = $this->createMock(ilDBInterface::class);
 
        $database->method('nextId')
            ->willReturn(141);
 
        $database->method('fetchAssoc')->willReturn([]);
 
        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $logger->expects($this->atLeastOnce())
            ->method('debug');
 
        $repository = new ilUserCertificateRepository($database, $logger, 'someDefaultTitle');
 
        $repository->fetchActiveCertificate(400, 20);
 
        $this->fail('Should never happen. Certificate Found?');
    }
 
    public function testFetchActiveCertificatesByType(): void
    {
        $database = $this->createMock(ilDBInterface::class);
 
        $database->method('nextId')
            ->willReturn(141);
 
        $database->method('fetchAssoc')->willReturnOnConsecutiveCalls(
            [
                'id' => 141,
                'pattern_certificate_id' => 1,
                'obj_id' => 20,
                'obj_type' => 'crs',
                'usr_id' => 400,
                'user_name' => 'Niels Theen',
                'acquired_timestamp' => 123_456_789,
                'certificate_content' => '<xml>Some Content</xml>',
                'template_values' => '[]',
                'valid_until' => null,
                'version' => 1,
                'ilias_version' => 'v5.4.0',
                'currently_active' => true,
                'background_image_ident' => '-',
                'tile_image_ident' => '-',
                'title' => 'SomeTitle',
                'someDescription' => 'SomeDescription',
                'certificate_id' => '11111111-2222-3333-4444-555555555555'
            ],
            [
                'id' => 142,
                'pattern_certificate_id' => 5,
                'obj_id' => 20,
                'obj_type' => 'crs',
                'usr_id' => 400,
                'user_name' => 'Niels Theen',
                'acquired_timestamp' => 987_654_321,
                'certificate_content' => '<xml>Some Other Content</xml>',
                'template_values' => '[]',
                'valid_until' => null,
                'version' => 1,
                'ilias_version' => 'v5.3.0',
                'currently_active' => true,
                'background_image_ident' => '-',
                'tile_image_ident' => '-',
                'title' => 'SomeTitle',
                'someDescription' => 'SomeDescription',
                'certificate_id' => '11111111-2222-3333-4444-555555555555'
            ],
            null
        );
 
        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $logger->expects($this->atLeastOnce())
            ->method('debug');
 
        $repository = new ilUserCertificateRepository($database, $logger, 'someDefaultTitle');
 
        $results = $repository->fetchActiveCertificatesByTypeForPresentation(400, 'crs');
 
        $this->assertSame(141, $results[0]->getUserCertificate()->getId());
        $this->assertSame(142, $results[1]->getUserCertificate()->getId());
    }
 
    public function testFetchCertificate(): void
    {
        $database = $this->createMock(ilDBInterface::class);
 
        $database->method('nextId')
            ->willReturn(141);
 
        $database->method('fetchAssoc')->willReturn(
            [
                'id' => 141,
                'pattern_certificate_id' => 1,
                'obj_id' => 20,
                'obj_type' => 'crs',
                'usr_id' => 400,
                'user_name' => 'Niels Theen',
                'acquired_timestamp' => 123_456_789,
                'certificate_content' => '<xml>Some Content</xml>',
                'template_values' => '[]',
                'valid_until' => null,
                'version' => 1,
                'ilias_version' => 'v5.4.0',
                'currently_active' => true,
                'background_image_ident' => '-',
                'tile_image_ident' => '-',
                'title' => 'SomeTitle',
                'someDescription' => 'SomeDescription',
                'certificate_id' => '11111111-2222-3333-4444-555555555555'
            ]
        );
 
        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $logger->expects($this->atLeastOnce())
            ->method('debug');
 
        $repository = new ilUserCertificateRepository($database, $logger, 'someTitle');
 
        $result = $repository->fetchCertificate(141);
 
        $this->assertSame(141, $result->getId());
    }
 
    public function testNoCertificateInFetchtCertificateLeadsToException(): never
    {
        $this->expectException(ilException::class);
 
        $database = $this->createMock(ilDBInterface::class);
 
        $database->method('nextId')
            ->willReturn(141);
 
        $database->method('fetchAssoc')
            ->willReturn([]);
 
        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $logger->expects($this->atLeastOnce())
            ->method('debug');
 
        $repository = new ilUserCertificateRepository($database, $logger, 'someTitle');
 
        $repository->fetchCertificate(141);
 
        $this->fail('Should never happen. Certificate Found?');
    }
 
    public function testFetchObjectWithCertificateForUser(): void
    {
        $database = $this->createMock(ilDBInterface::class);
 
        $database
            ->expects($this->once())
            ->method('query');
 
        $database
            ->expects($this->once())
            ->method('in');
 
        $database
            ->expects($this->exactly(3))
            ->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                ['obj_id' => 100],
                ['obj_id' => 300],
                []
            );
 
        $database->method('fetchAssoc')
            ->willReturn([]);
 
        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $logger->expects($this->atLeastOnce())
            ->method('debug');
 
        $repository = new ilUserCertificateRepository($database, $logger, 'someTitle');
 
        $userId = 10;
        $objectIds = [200, 300, 400];
 
        $results = $repository->fetchObjectIdsWithCertificateForUser($userId, $objectIds);
 
        $this->assertSame([100, 300], $results);
    }
 
    public function testFetchUserIdsWithCertificateForObject(): void
    {
        $database = $this->createMock(ilDBInterface::class);
 
        $database
            ->expects($this->once())
            ->method('query');
 
        $database
            ->expects($this->exactly(3))
            ->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                ['usr_id' => 100],
                ['usr_id' => 300],
                []
            );
 
        $database->method('fetchAssoc')
            ->willReturn([]);
 
        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $logger->expects($this->atLeastOnce())
            ->method('debug');
 
        $repository = new ilUserCertificateRepository($database, $logger, 'someTitle');
 
        $objectId = 10;
 
        $results = $repository->fetchUserIdsWithCertificateForObject($objectId);
 
        $this->assertSame([100, 300], $results);
    }
}