ilUserCertificateRepositoryTest Class Reference

Inheritance diagram for ilUserCertificateRepositoryTest:

Collaboration diagram for ilUserCertificateRepositoryTest:

Public Member Functions
	testSaveOfUserCertificateToDatabase ()
	testFetchAllActiveCertificateForUser ()
	testFetchActiveCertificateForUserObjectCombination ()
	testFetchNoActiveCertificateLeadsToException ()
	testFetchActiveCertificatesByType ()
	testFetchCertificate ()
	testNoCertificateInFetchtCertificateLeadsToException ()
	testFetchObjectWithCertificateForUser ()
	testFetchUserIdsWithCertificateForObject ()

Additional Inherited Members
Protected Member Functions inherited from ilCertificateBaseTestCase
	setUp ()
	tearDown ()
	assertDoesNotThrow (callable $cb, string $message='')
	assertThrows (callable $cb, ?string $expected_class=null, ?string $expected_message=null)
	@template T of Throwable More...
	setGlobalVariable (string $name, mixed $value)
Protected Attributes inherited from ilCertificateBaseTestCase
Container	$dic

Detailed Description

Definition at line 23 of file ilUserCertificateRepositoryTest.php.

Member Function Documentation

testFetchActiveCertificateForUserObjectCombination()

ilUserCertificateRepositoryTest::testFetchActiveCertificateForUserObjectCombination

(

)

Definition at line 172 of file ilUserCertificateRepositoryTest.php.

                                                                        : 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_path' => '/some/where/background.jpg',
                'tile_image_path' => '/some/where/tile_image.svg',
                '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_path' => '/some/where/else/background.jpg',
                'tile_image_path' => '/some/where/tile_image.svg',
                '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());
    }

testFetchActiveCertificatesByType()

ilUserCertificateRepositoryTest::testFetchActiveCertificatesByType

(

)

Definition at line 265 of file ilUserCertificateRepositoryTest.php.

                                                       : 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_path' => '/some/where/background.jpg',
                'tile_image_path' => '/some/where/else/tile_image.svg',
                '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_path' => '/some/where/else/background.jpg',
                'tile_image_path' => '/some/where/else/tile_image.svg',
                '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());
    }

References $results, and ILIAS\Survey\Mode\getId().

Here is the call graph for this function:

testFetchAllActiveCertificateForUser()

ilUserCertificateRepositoryTest::testFetchAllActiveCertificateForUser

(

)

Definition at line 100 of file ilUserCertificateRepositoryTest.php.

                                                          : 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_path' => '/some/where/background.jpg',
                'tile_image_path' => '/some/where/tile_image.svg',
                '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_path' => '/some/where/else/background.jpg',
                'tile_image_path' => '/some/where/tile_image.svg',
                '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());
    }

References $results, and ILIAS\Survey\Mode\getId().

Here is the call graph for this function:

testFetchCertificate()

ilUserCertificateRepositoryTest::testFetchCertificate

(

)

Definition at line 335 of file ilUserCertificateRepositoryTest.php.

                                          : 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_path' => '/some/where/background.jpg',
                'tile_image_path' => '/some/where/else/tile_image.svg',
                '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());
    }

testFetchNoActiveCertificateLeadsToException()

ilUserCertificateRepositoryTest::testFetchNoActiveCertificateLeadsToException

(

)

Definition at line 240 of file ilUserCertificateRepositoryTest.php.

                                                                  : 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?');
    }

testFetchObjectWithCertificateForUser()

ilUserCertificateRepositoryTest::testFetchObjectWithCertificateForUser

(

)

Definition at line 407 of file ilUserCertificateRepositoryTest.php.

                                                           : 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);
    }

References $results.

testFetchUserIdsWithCertificateForObject()

ilUserCertificateRepositoryTest::testFetchUserIdsWithCertificateForObject

(

)

Definition at line 448 of file ilUserCertificateRepositoryTest.php.

                                                              : 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);
    }

References $results.

testNoCertificateInFetchtCertificateLeadsToException()

ilUserCertificateRepositoryTest::testNoCertificateInFetchtCertificateLeadsToException

(

)

Definition at line 381 of file ilUserCertificateRepositoryTest.php.

                                                                          : 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?');
    }

testSaveOfUserCertificateToDatabase()

ilUserCertificateRepositoryTest::testSaveOfUserCertificateToDatabase

(

)

Definition at line 25 of file ilUserCertificateRepositoryTest.php.

                                                         : 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_path' => ['text', '/some/where/background.jpg'],
                'tile_image_path' => ['text', '/some/where/tile_image.svg'],
                'background_image_ident' => ['text', '-'],
                'tile_image_ident' => ['text', '-'],
                'certificate_id' => ['text', '11111111-2222-3333-4444-555555555555'],
            ]
        );
 
        $database->method('tableColumnExists')->willReturnMap(
            [
                ['il_cert_user_cert', 'background_image_path', true],
                ['il_cert_user_cert', 'tile_image_path', true],
            ]
        );
 
        $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'),
            '/some/where/background.jpg',
            '/some/where/tile_image.svg',
            '-',
            '-',
            null
        );
 
        $repository->save($userCertificate);
    }

---

The documentation for this class was generated from the following file:

• components/ILIAS/Certificate/tests/ilUserCertificateRepositoryTest.php