ilUserCertificateTableProviderTest.php

Go to the documentation of this file.

<?php
 
declare(strict_types=1);
 
class ilUserCertificateTableProviderTest extends ilCertificateBaseTestCase
{
    public function testFetchingDataSetForTableWithoutParamtersAndWithoutFilters(): void
    {
        $database = $this->getMockBuilder(ilDBInterface::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $database
            ->expects($this->atLeastOnce())
            ->method('quote');
 
        $database->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                [
                    'id' => 600,
                    'obj_id' => 100,
                    'title' => 'CourseTest',
                    'obj_type' => 'crs',
                    'acquired_timestamp' => 1_539_867_618,
                    'tile_image_ident' => '-',
                    'description' => 'some description',
                    'firstname' => 'ilyas',
                    'lastname' => 'homer',
                ],
                null
            );
 
        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $provider = new ilUserCertificateTableProvider(
            $database,
            $logger,
            'default_title'
        );
 
        $dataSet = $provider->fetchDataSet(100, ['language' => 'de'], []);
 
        $expected = [];
 
        $expected['items'][] = [
            'id' => 600,
            'title' => 'CourseTest',
            'obj_id' => 100,
            'obj_type' => 'crs',
            'date' => 1_539_867_618,
            'tile_image_ident' => '-',
            'description' => 'some description',
            'firstname' => 'ilyas',
            'lastname' => 'homer',
        ];
 
        $expected['cnt'] = 1;
 
        $this->assertSame($expected, $dataSet);
    }
 
    public function testFetchingDataSetForTableWithLimitParameterAndWithoutFilters(): void
    {
        $database = $this->createMock(ilDBInterface::class);
 
        $database
            ->expects($this->atLeastOnce())
            ->method('quote');
 
        $database->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                [
                    'id' => 600,
                    'obj_id' => 100,
                    'title' => 'CourseTest',
                    'obj_type' => 'crs',
                    'acquired_timestamp' => 1_539_867_618,
                    'tile_image_ident' => '-',
                    'description' => 'some description',
                    'firstname' => 'ilyas',
                    'lastname' => 'homer',
                ],
                null,
                [
                    'cnt' => 5,
                ],
                null
            );
 
        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $provider = new ilUserCertificateTableProvider(
            $database,
            $logger,
            'default_title'
        );
 
        $dataSet = $provider->fetchDataSet(100, ['language' => 'de', 'limit' => 2], []);
 
        $expected = [];
 
        $expected['items'][] = [
            'id' => 600,
            'title' => 'CourseTest',
            'obj_id' => 100,
            'obj_type' => 'crs',
            'date' => 1_539_867_618,
            'tile_image_ident' => '-',
            'description' => 'some description',
            'firstname' => 'ilyas',
            'lastname' => 'homer',
        ];
 
        $expected['cnt'] = 5;
 
        $this->assertSame($expected, $dataSet);
    }
 
    public function testFetchingDataSetForTableWithOrderFieldDate(): void
    {
        $database = $this->createMock(ilDBInterface::class);
 
        $database
            ->expects($this->atLeastOnce())
            ->method('quote');
 
        $database->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                [
                    'id' => 600,
                    'obj_id' => 100,
                    'title' => 'CourseTest',
                    'obj_type' => 'crs',
                    'acquired_timestamp' => 1_539_867_618,
                    'tile_image_ident' => '-',
                    'description' => 'some description',
                    'firstname' => 'ilyas',
                    'lastname' => 'homer',
                ],
                null,
                [
                    'cnt' => 5,
                ],
                null
            );
 
        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $provider = new ilUserCertificateTableProvider(
            $database,
            $logger,
            'default_title'
        );
 
        $dataSet = $provider->fetchDataSet(
            100,
            ['language' => 'de', 'limit' => 2, 'order_field' => 'date'],
            []
        );
 
        $expected = [];
 
        $expected['items'][] = [
            'id' => 600,
            'title' => 'CourseTest',
            'obj_id' => 100,
            'obj_type' => 'crs',
            'date' => 1_539_867_618,
            'tile_image_ident' => '-',
            'description' => 'some description',
            'firstname' => 'ilyas',
            'lastname' => 'homer',
        ];
 
        $expected['cnt'] = 5;
 
        $this->assertSame($expected, $dataSet);
    }
 
    public function testFetchingDataWithInvalidOrderFieldWillResultInException(): never
    {
        $this->expectException(InvalidArgumentException::class);
 
        $database = $this->createMock(ilDBInterface::class);
 
        $database
            ->expects($this->atLeastOnce())
            ->method('quote');
 
        $database->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                [
                    'id' => 600,
                    'obj_id' => 100,
                    'title' => 'CourseTest',
                    'obj_type' => 'crs',
                    'acquired_timestamp' => 1_539_867_618
                ],
                null,
                [
                    'cnt' => 5,
                ],
                null
            );
 
        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $provider = new ilUserCertificateTableProvider(
            $database,
            $logger,
            'default_title'
        );
 
        $provider->fetchDataSet(
            100,
            ['language' => 'de', 'limit' => 2, 'order_field' => 'something'],
            []
        );
 
        $this->fail('Should never happen');
    }
 
    public function testFetchingDataWithEmptyOrderFieldWillResultInException(): never
    {
        $this->expectException(InvalidArgumentException::class);
 
        $database = $this->createMock(ilDBInterface::class);
 
        $database
            ->expects($this->atLeastOnce())
            ->method('quote');
 
        $database->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                [
                    'id' => 600,
                    'obj_id' => 100,
                    'title' => 'CourseTest',
                    'obj_type' => 'crs',
                    'acquired_timestamp' => 1_539_867_618
                ],
                null,
                [
                    'cnt' => 5,
                ],
                null
            );
 
        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $provider = new ilUserCertificateTableProvider(
            $database,
            $logger,
            'default_title'
        );
 
        $provider->fetchDataSet(
            100,
            ['language' => 'de', 'limit' => 2, 'order_field' => false],
            []
        );
 
        $this->fail('Should never happen');
    }
 
    public function testFetchingDataWithWrongOrderDirectionWillResultInException(): never
    {
        $this->expectException(InvalidArgumentException::class);
 
        $database = $this->createMock(ilDBInterface::class);
 
        $database
            ->expects($this->atLeastOnce())
            ->method('quote');
 
        $database->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                [
                    'id' => 600,
                    'obj_id' => 100,
                    'title' => 'CourseTest',
                    'obj_type' => 'crs',
                    'acquired_timestamp' => 1_539_867_618
                ],
                null,
                [
                    'cnt' => 5,
                ],
                null
            );
 
        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $provider = new ilUserCertificateTableProvider(
            $database,
            $logger,
            'default_title'
        );
 
        $provider->fetchDataSet(
            600,
            [
                'language' => 'de',
                'limit' => 2,
                'order_field' => 'date',
                'order_direction' => 'mac'
            ],
            []
        );
 
        $this->fail('Should never happen');
    }
 
    public function testFetchingDataWithInvalidLimitParameterWillResultInException(): never
    {
        $this->expectException(InvalidArgumentException::class);
 
        $database = $this->createMock(ilDBInterface::class);
 
        $database
            ->expects($this->atLeastOnce())
            ->method('quote');
 
        $database->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                [
                    'id' => 600,
                    'obj_id' => 100,
                    'title' => 'CourseTest',
                    'obj_type' => 'crs',
                    'acquired_timestamp' => 1_539_867_618
                ],
                null,
                [
                    'cnt' => 5,
                ],
                null
            );
 
        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $provider = new ilUserCertificateTableProvider(
            $database,
            $logger,
            'default_title'
        );
 
        $provider->fetchDataSet(
            600,
            [
                'language' => 'de',
                'limit' => 'something',
                'order_field' => 'date',
                'order_direction' => 'mac'
            ],
            []
        );
 
        $this->fail('Should never happen');
    }
 
    public function testFetchingDataWithInvalidOffsetParameterWillResultInException(): never
    {
        $this->expectException(InvalidArgumentException::class);
 
        $database = $this->createMock(ilDBInterface::class);
 
        $database
            ->expects($this->atLeastOnce())
            ->method('quote');
 
        $database->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                [
                    'id' => 600,
                    'obj_id' => 100,
                    'title' => 'CourseTest',
                    'obj_type' => 'crs',
                    'acquired_timestamp' => 1_539_867_618
                ],
                null,
                [
                    'cnt' => 5,
                ],
                null
            );
 
        $logger = $this->getMockBuilder(ilLogger::class)
            ->disableOriginalConstructor()
            ->getMock();
 
        $provider = new ilUserCertificateTableProvider(
            $database,
            $logger,
            'default_title'
        );
 
        $provider->fetchDataSet(
            600,
            [
                'limit' => 3,
                'language' => 'de',
                'order_field' => 'date',
                'order_direction' => 'mac',
                'offset' => 'something'
            ],
            []
        );
 
        $this->fail('Should never happen');
    }
}