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 ()

	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.

References null.

                                                                         : 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.

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

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

Here is the call graph for this function:

◆ testFetchAllActiveCertificateForUser()

ilUserCertificateRepositoryTest::testFetchAllActiveCertificateForUser ( )

Definition at line 100 of file ilUserCertificateRepositoryTest.php.

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

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

Here is the call graph for this function:

◆ testFetchCertificate()

ilUserCertificateRepositoryTest::testFetchCertificate ( )

Definition at line 335 of file ilUserCertificateRepositoryTest.php.

References null.

                                           : 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.

References $results.

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

◆ testFetchUserIdsWithCertificateForObject()

ilUserCertificateRepositoryTest::testFetchUserIdsWithCertificateForObject ( )

Definition at line 448 of file ilUserCertificateRepositoryTest.php.

References $results.

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

◆ 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.

References null.

                                                          : 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

Public Member Functions

Additional Inherited Members

Detailed Description

Member Function Documentation

◆ testFetchActiveCertificateForUserObjectCombination()

◆ testFetchActiveCertificatesByType()

◆ testFetchAllActiveCertificateForUser()

◆ testFetchCertificate()

◆ testFetchNoActiveCertificateLeadsToException()

◆ testFetchObjectWithCertificateForUser()

◆ testFetchUserIdsWithCertificateForObject()

◆ testNoCertificateInFetchtCertificateLeadsToException()

◆ testSaveOfUserCertificateToDatabase()