ilUserCertificateTableProviderTest.php

Go to the documentation of this file.

<?php
/* Copyright (c) 1998-2018 ILIAS open source, Extended GPL, see docs/LICENSE */

class ilUserCertificateTableProviderTest extends PHPUnit_Framework_TestCase
{
    public function testFetchingDataSetForTableWithoutParamtersAndWithoutFilters()
    {
        $database = $this->getMockBuilder('ilDBInterface')
            ->disableOriginalConstructor()
            ->getMock();

        $database
            ->expects($this->atLeastOnce())
            ->method('quote');

        $database->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                array(
                    'id' => 600,
                    'obj_id' => 100,
                    'title' => 'CourseTest',
                    'obj_type' => 'crs',
                    'acquired_timestamp' => 1539867618,
                    'thumbnail_image_path' => 'some/path/test.svg',
                    'description' => 'some description',
                    'firstname' => 'ilyas',
                    'lastname' => 'homer',
                ),
                null
            );

        $logger = $this->getMockBuilder('ilLogger')
            ->disableOriginalConstructor()
            ->getMock();

        $logger
            ->expects($this->once())
            ->method('info');

        $controller = $this->getMockBuilder('ilCtrl')
            ->getMock();

        $controller->method('getLinkTargetByClass')
            ->willReturn('something');

        $objectMock = $this->getMockBuilder('ilObject')
            ->disableOriginalConstructor()
            ->getMock();

        $objectMock->method('getTitle')
            ->willReturn('CourseTest');

        $objectHelper = $this->getMockBuilder('ilCertificateObjectHelper')
            ->disableOriginalConstructor()
            ->getMock();

        $objectHelper->method('getInstanceByObjId')
            ->willReturn($objectMock);

        $provider = new ilUserCertificateTableProvider(
            $database,
            $logger,
            $controller,
            'default_title',
            $objectHelper
        );

        $dataSet = $provider->fetchDataSet(100, array(), array());

        $expected = array();

        $expected['items'][] = array(
            'id' => 600,
            'title' => 'CourseTest',
            'obj_id' => 100,
            'obj_type' => 'crs',
            'date' => 1539867618,
            'thumbnail_image_path' => 'some/path/test.svg',
            'description' => 'some description',
            'firstname' => 'ilyas',
            'lastname' => 'homer',
        );

        $expected['cnt'] = 1;

        $this->assertEquals($expected, $dataSet);
    }

    public function testFetchingDataSetForTableWithLimitParamterAndWithoutFilters()
    {
        $database = $this->getMockBuilder('ilDBInterface')
            ->disableOriginalConstructor()
            ->getMock();

        $database
            ->expects($this->atLeastOnce())
            ->method('quote');

        $database->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                array(
                    'id' => 600,
                    'obj_id' => 100,
                    'title' => 'CourseTest',
                    'obj_type' => 'crs',
                    'acquired_timestamp' => 1539867618,
                    'thumbnail_image_path' => 'some/path/test.svg',
                    'description' => 'some description',
                    'firstname' => 'ilyas',
                    'lastname' => 'homer',
                ),
                null,
                array(
                    'cnt' => 5,
                ),
                null
            );

        $logger = $this->getMockBuilder('ilLogger')
            ->disableOriginalConstructor()
            ->getMock();

        $logger
            ->expects($this->atLeastOnce())
            ->method('info');

        $controller = $this->getMockBuilder('ilCtrl')
            ->getMock();

        $controller->method('getLinkTargetByClass')
            ->willReturn('something');

        $objectMock = $this->getMockBuilder('ilObject')
            ->disableOriginalConstructor()
            ->getMock();

        $objectMock->method('getTitle')
            ->willReturn('CourseTest');

        $objectHelper = $this->getMockBuilder('ilCertificateObjectHelper')
            ->disableOriginalConstructor()
            ->getMock();

        $objectHelper->method('getInstanceByObjId')
            ->willReturn($objectMock);

        $provider = new ilUserCertificateTableProvider(
            $database,
            $logger,
            $controller,
            'default_title',
            $objectHelper
        );

        $dataSet = $provider->fetchDataSet(100, array('limit' => 2), array());

        $expected = array();

        $expected['items'][] = array(
            'id' => 600,
            'title' => 'CourseTest',
            'obj_id' => 100,
            'obj_type' => 'crs',
            'date' => 1539867618,
            'thumbnail_image_path' => 'some/path/test.svg',
            'description' => 'some description',
            'firstname' => 'ilyas',
            'lastname' => 'homer',
        );

        $expected['cnt'] = 5;

        $this->assertEquals($expected, $dataSet);
    }

    public function testFetchingDataSetForTableWithOrderFieldDate()
    {
        $database = $this->getMockBuilder('ilDBInterface')
            ->disableOriginalConstructor()
            ->getMock();

        $database
            ->expects($this->atLeastOnce())
            ->method('quote');

        $database->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                array(
                    'id' => 600,
                    'obj_id' => 100,
                    'title' => 'CourseTest',
                    'obj_type' => 'crs',
                    'acquired_timestamp' => 1539867618,
                    'thumbnail_image_path' => 'some/path/test.svg',
                    'description' => 'some description',
                    'firstname' => 'ilyas',
                    'lastname' => 'homer',
                ),
                null,
                array(
                    'cnt' => 5,
                ),
                null
            );

        $logger = $this->getMockBuilder('ilLogger')
            ->disableOriginalConstructor()
            ->getMock();

        $logger
            ->expects($this->atLeastOnce())
            ->method('info');

        $controller = $this->getMockBuilder('ilCtrl')
            ->getMock();

        $controller->method('getLinkTargetByClass')
            ->willReturn('something');

        $objectMock = $this->getMockBuilder('ilObject')
            ->disableOriginalConstructor()
            ->getMock();

        $objectMock->method('getTitle')
            ->willReturn('CourseTest');

        $objectHelper = $this->getMockBuilder('ilCertificateObjectHelper')
            ->disableOriginalConstructor()
            ->getMock();

        $objectHelper->method('getInstanceByObjId')
            ->willReturn($objectMock);

        $provider = new ilUserCertificateTableProvider(
            $database,
            $logger,
            $controller,
            'default_title',
            $objectHelper
        );

        $dataSet = $provider->fetchDataSet(100, array('limit' => 2, 'order_field' => 'date'), array());

        $expected = array();

        $expected['items'][] = array(
            'id' => 600,
            'title' => 'CourseTest',
            'obj_id' => 100,
            'obj_type' => 'crs',
            'date' => 1539867618,
            'thumbnail_image_path' => 'some/path/test.svg',
            'description' => 'some description',
            'firstname' => 'ilyas',
            'lastname' => 'homer',
        );

        $expected['cnt'] = 5;

        $this->assertEquals($expected, $dataSet);
    }

    public function testFetchingDataWithInvalidOrderFieldWillResultInException()
    {
        $database = $this->getMockBuilder('ilDBInterface')
            ->disableOriginalConstructor()
            ->getMock();

        $database
            ->expects($this->atLeastOnce())
            ->method('quote');

        $database->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                array(
                    'id' => 600,
                    'obj_id' => 100,
                    'title' => 'CourseTest',
                    'obj_type' => 'crs',
                    'acquired_timestamp' => 1539867618
                ),
                null,
                array(
                    'cnt' => 5,
                ),
                null
            );

        $logger = $this->getMockBuilder('ilLogger')
            ->disableOriginalConstructor()
            ->getMock();

        $logger
            ->expects($this->atLeastOnce())
            ->method('info');

        $controller = $this->getMockBuilder('ilCtrl')
            ->getMock();

        $controller->method('getLinkTargetByClass')
            ->willReturn('something');

        $objectMock = $this->getMockBuilder('ilObject')
            ->disableOriginalConstructor()
            ->getMock();

        $objectMock->method('getTitle')
            ->willReturn('CourseTest');

        $objectHelper = $this->getMockBuilder('ilCertificateObjectHelper')
            ->disableOriginalConstructor()
            ->getMock();

        $objectHelper->method('getInstanceByObjId')
            ->willReturn($objectMock);

        $provider = new ilUserCertificateTableProvider(
            $database,
            $logger,
            $controller,
            'default_title',
            $objectHelper
        );

        $dataSet = $provider->fetchDataSet(100, array('limit' => 2, 'order_field' => 'something'), array());

        $this->fail('Should never happen');
    }

    public function testFetchingDataWithEmptyOrderFieldWillResultInException()
    {
        $database = $this->getMockBuilder('ilDBInterface')
            ->disableOriginalConstructor()
            ->getMock();

        $database
            ->expects($this->atLeastOnce())
            ->method('quote');

        $database->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                array(
                    'id' => 600,
                    'obj_id' => 100,
                    'title' => 'CourseTest',
                    'obj_type' => 'crs',
                    'acquired_timestamp' => 1539867618
                ),
                null,
                array(
                    'cnt' => 5,
                ),
                null
            );

        $logger = $this->getMockBuilder('ilLogger')
            ->disableOriginalConstructor()
            ->getMock();

        $logger
            ->expects($this->atLeastOnce())
            ->method('info');

        $controller = $this->getMockBuilder('ilCtrl')
            ->getMock();

        $controller->method('getLinkTargetByClass')
            ->willReturn('something');

        $objectMock = $this->getMockBuilder('ilObject')
            ->disableOriginalConstructor()
            ->getMock();

        $objectMock->method('getTitle')
            ->willReturn('CourseTest');

        $objectHelper = $this->getMockBuilder('ilCertificateObjectHelper')
            ->disableOriginalConstructor()
            ->getMock();

        $objectHelper->method('getInstanceByObjId')
            ->willReturn($objectMock);

        $provider = new ilUserCertificateTableProvider(
            $database,
            $logger,
            $controller,
            'default_title',
            $objectHelper
        );

        $dataSet = $provider->fetchDataSet(100, array('limit' => 2, 'order_field' => false), array());

        $this->fail('Should never happen');
    }

    public function testFetchingDataWithWrongOrderDirectionWillResultInException()
    {
        $database = $this->getMockBuilder('ilDBInterface')
            ->disableOriginalConstructor()
            ->getMock();

        $database
            ->expects($this->atLeastOnce())
            ->method('quote');

        $database->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                array(
                    'id' => 600,
                    'obj_id' => 100,
                    'title' => 'CourseTest',
                    'obj_type' => 'crs',
                    'acquired_timestamp' => 1539867618
                ),
                null,
                array(
                    'cnt' => 5,
                ),
                null
            );

        $logger = $this->getMockBuilder('ilLogger')
            ->disableOriginalConstructor()
            ->getMock();

        $logger
            ->expects($this->atLeastOnce())
            ->method('info');

        $controller = $this->getMockBuilder('ilCtrl')
            ->getMock();

        $controller->method('getLinkTargetByClass')
            ->willReturn('something');

        $objectMock = $this->getMockBuilder('ilObject')
            ->disableOriginalConstructor()
            ->getMock();

        $objectMock->method('getTitle')
            ->willReturn('CourseTest');

        $objectHelper = $this->getMockBuilder('ilCertificateObjectHelper')
            ->disableOriginalConstructor()
            ->getMock();

        $objectHelper->method('getInstanceByObjId')
            ->willReturn($objectMock);

        $provider = new ilUserCertificateTableProvider(
            $database,
            $logger,
            $controller,
            'default_title',
            $objectHelper
        );

        $dataSet = $provider->fetchDataSet(
            600,
            array(
                'limit' => 2,
                'order_field' => 'date',
                'order_direction' => 'mac'
            ),
            array()
        );

        $this->fail('Should never happen');
    }

    public function testFetchingDataWithInvalidLimitParameterWillResultInException()
    {
        $database = $this->getMockBuilder('ilDBInterface')
            ->disableOriginalConstructor()
            ->getMock();

        $database
            ->expects($this->atLeastOnce())
            ->method('quote');

        $database->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                array(
                    'id' => 600,
                    'obj_id' => 100,
                    'title' => 'CourseTest',
                    'obj_type' => 'crs',
                    'acquired_timestamp' => 1539867618
                ),
                null,
                array(
                    'cnt' => 5,
                ),
                null
            );

        $logger = $this->getMockBuilder('ilLogger')
            ->disableOriginalConstructor()
            ->getMock();

        $logger
            ->expects($this->atLeastOnce())
            ->method('info');

        $controller = $this->getMockBuilder('ilCtrl')
            ->getMock();

        $controller->method('getLinkTargetByClass')
            ->willReturn('something');

        $objectMock = $this->getMockBuilder('ilObject')
            ->disableOriginalConstructor()
            ->getMock();

        $objectMock->method('getTitle')
            ->willReturn('CourseTest');

        $objectHelper = $this->getMockBuilder('ilCertificateObjectHelper')
            ->disableOriginalConstructor()
            ->getMock();

        $objectHelper->method('getInstanceByObjId')
            ->willReturn($objectMock);

        $provider = new ilUserCertificateTableProvider(
            $database,
            $logger,
            $controller,
            'default_title',
            $objectHelper
        );

        $dataSet = $provider->fetchDataSet(
            600,
            array(
                'limit' => 'something',
                'order_field' => 'date',
                'order_direction' => 'mac'
            ),
            array()
        );

        $this->fail('Should never happen');
    }

    public function testFetchingDataWithInvalidOffsetParameterWillResultInException()
    {
        $database = $this->getMockBuilder('ilDBInterface')
            ->disableOriginalConstructor()
            ->getMock();

        $database
            ->expects($this->atLeastOnce())
            ->method('quote');

        $database->method('fetchAssoc')
            ->willReturnOnConsecutiveCalls(
                array(
                    'id' => 600,
                    'obj_id' => 100,
                    'title' => 'CourseTest',
                    'obj_type' => 'crs',
                    'acquired_timestamp' => 1539867618
                ),
                null,
                array(
                    'cnt' => 5,
                ),
                null
            );

        $logger = $this->getMockBuilder('ilLogger')
            ->disableOriginalConstructor()
            ->getMock();

        $logger
            ->expects($this->atLeastOnce())
            ->method('info');

        $controller = $this->getMockBuilder('ilCtrl')
            ->getMock();

        $controller->method('getLinkTargetByClass')
            ->willReturn('something');

        $objectMock = $this->getMockBuilder('ilObject')
            ->disableOriginalConstructor()
            ->getMock();

        $objectMock->method('getTitle')
            ->willReturn('CourseTest');

        $objectHelper = $this->getMockBuilder('ilCertificateObjectHelper')
            ->disableOriginalConstructor()
            ->getMock();

        $objectHelper->method('getInstanceByObjId')
            ->willReturn($objectMock);

        $provider = new ilUserCertificateTableProvider(
            $database,
            $logger,
            $controller,
            'default_title',
            $objectHelper
        );

        $dataSet = $provider->fetchDataSet(
            600,
            array(
                'limit' => 3,
                'order_field' => 'date',
                'order_direction' => 'mac',
                'offset' => 'something'
            ),
            array()
        );

        $this->fail('Should never happen');
    }
}