ilTermsOfServiceAcceptanceDatabaseGatewayTest Class Reference

Class ilTermsOfServiceAcceptanceDatabaseGatewayTest. More...

Inheritance diagram for ilTermsOfServiceAcceptanceDatabaseGatewayTest:

Collaboration diagram for ilTermsOfServiceAcceptanceDatabaseGatewayTest:

Public Member Functions
	testInstanceCanBeCreated ()
	testAcceptanceIsTrackedAndCreatesANewTermsOfServicesVersionIfNecessary ()
	testAcceptanceIsTrackedAndRefersToAnExistingTermsOfServicesVersion ()
	testLatestAcceptanceOfUserCanBeLoaded ()
	testAcceptanceHistoryOfAUserCanBeDeleted ()
	testAcceptanceHistoryRecordCanBeLoadedById ()

Additional Inherited Members
Protected Member Functions inherited from ilTermsOfServiceBaseTest
	setUp ()
	getLanguageMock ()
	setGlobalVariable (string $name, $value)
	assertException (string $exceptionClass)
	getCriterionConfig ($value=null)
Protected Attributes inherited from ilTermsOfServiceBaseTest
	$dic

Detailed Description

Class ilTermsOfServiceAcceptanceDatabaseGatewayTest.

Author

Michael Jansen mjans.nosp@m.en@d.nosp@m.ataba.nosp@m.y.de

Definition at line 8 of file ilTermsOfServiceAcceptanceDatabaseGatewayTest.php.

Member Function Documentation

testAcceptanceHistoryOfAUserCanBeDeleted()

ilTermsOfServiceAcceptanceDatabaseGatewayTest::testAcceptanceHistoryOfAUserCanBeDeleted

(

)

Definition at line 183 of file ilTermsOfServiceAcceptanceDatabaseGatewayTest.php.

    {
        $entity = new \ilTermsOfServiceAcceptanceEntity();
        $entity->withUserId(4711);
 
        $database = $this->getMockBuilder(\ilDBInterface::class)->getMock();
 
        $database
            ->expects($this->once())
            ->method('quote')
            ->with($entity->getUserId(), 'integer')
            ->will($this->returnValue($entity->getUserId()));
 
        $database
            ->expects($this->once())
            ->method('manipulate')
            ->with('DELETE FROM tos_acceptance_track WHERE usr_id = ' . $entity->getUserId());
 
        $gateway = new \ilTermsOfServiceAcceptanceDatabaseGateway($database);
        $gateway->deleteAcceptanceHistoryByUser($entity);
    }

References Sabre\Event\once().

Here is the call graph for this function:

testAcceptanceHistoryRecordCanBeLoadedById()

ilTermsOfServiceAcceptanceDatabaseGatewayTest::testAcceptanceHistoryRecordCanBeLoadedById

(

)

Definition at line 208 of file ilTermsOfServiceAcceptanceDatabaseGatewayTest.php.

    {
        $entity = new \ilTermsOfServiceAcceptanceEntity();
 
        $expected = [
            'id' => 4711,
            'title' => 'Document PHP Unit',
            'doc_id' => 4711,
            'criteria' => '',
            'text' => 'PHP Unit',
            'hash' => md5('PHP Unit'),
        ];
 
        $database = $this->getMockBuilder(\ilDBInterface::class)->getMock();
        $database
            ->expects($this->once())
            ->method('fetchAssoc')
            ->will($this->onConsecutiveCalls($expected));
 
        $gateway = new \ilTermsOfServiceAcceptanceDatabaseGateway($database);
        $entity = $gateway->loadById($entity);
 
        $this->assertEquals($expected['id'], $entity->getId());
        $this->assertEquals($expected['doc_id'], $entity->getDocumentId());
        $this->assertEquals($expected['title'], $entity->getTitle());
        $this->assertEquals($expected['criteria'], $entity->getSerializedCriteria());
        $this->assertEquals($expected['text'], $entity->getText());
        $this->assertEquals($expected['hash'], $entity->getHash());
    }

References Sabre\Event\once().

Here is the call graph for this function:

testAcceptanceIsTrackedAndCreatesANewTermsOfServicesVersionIfNecessary()

ilTermsOfServiceAcceptanceDatabaseGatewayTest::testAcceptanceIsTrackedAndCreatesANewTermsOfServicesVersionIfNecessary

(

)

Definition at line 24 of file ilTermsOfServiceAcceptanceDatabaseGatewayTest.php.

    {
        $entity = new \ilTermsOfServiceAcceptanceEntity();
        $entity->withUserId(666);
        $entity->withDocumentId(4711);
        $entity->withTitle('Document PHP Unit');
        $entity->withSerializedCriteria('');
        $entity->withText('PHP Unit');
        $entity->withTimestamp(time());
        $entity->withHash(md5($entity->getText()));
 
        $expected_id = 4711;
 
        $database = $this->getMockBuilder(\ilDBInterface::class)->getMock();
        $result = $this->getMockBuilder(\ilDBStatement::class)->getMock();
 
        $database
            ->expects($this->once())
            ->method('queryF')
            ->with(
                'SELECT id FROM tos_versions WHERE hash = %s AND doc_id = %s',
                ['text', 'integer'],
                [$entity->getHash(), $entity->getDocumentId()]
            )->will($this->returnValue($result));
    
        $database
            ->expects($this->once())
            ->method('numRows')
            ->with($result)->
            will($this->returnValue(0));
 
        $database
            ->expects($this->once())
            ->method('nextId')
            ->with('tos_versions')
            ->will($this->returnValue($expected_id));
 
        $expectedVersions = [
            'id' => ['integer', $expected_id],
            'doc_id' => ['integer', $entity->getDocumentId()],
            'title' => ['text', $entity->getTitle()],
            'text' => ['clob', $entity->getText()],
            'hash' => ['text', $entity->getHash()],
            'ts' => ['integer', $entity->getTimestamp()]
        ];
        $expectedTracking = [
            'tosv_id' => ['integer', $expected_id],
            'usr_id' => ['integer', $entity->getUserId()],
            'criteria' => ['clob', $entity->getSerializedCriteria()],
            'ts' => ['integer', $entity->getTimestamp()]
        ];
 
        $database
            ->expects($this->exactly(2))
            ->method('insert')
            ->with(
                $this->logicalOr('tos_versions', 'tos_acceptance_track'),
                $this->logicalOr($expectedVersions, $expectedTracking)
            );
 
        $gateway = new \ilTermsOfServiceAcceptanceDatabaseGateway($database);
        $gateway->trackAcceptance($entity);
    }

References $result, and Sabre\Event\once().

Here is the call graph for this function:

testAcceptanceIsTrackedAndRefersToAnExistingTermsOfServicesVersion()

ilTermsOfServiceAcceptanceDatabaseGatewayTest::testAcceptanceIsTrackedAndRefersToAnExistingTermsOfServicesVersion

(

)

Definition at line 91 of file ilTermsOfServiceAcceptanceDatabaseGatewayTest.php.

    {
        $entity = new \ilTermsOfServiceAcceptanceEntity();
        $entity->withUserId(666);
        $entity->withDocumentId(4711);
        $entity->withTitle('Document PHP Unit');
        $entity->withSerializedCriteria('');
        $entity->withText('PHP Unit');
        $entity->withTimestamp(time());
        $entity->withHash(md5($entity->getText()));
 
        $expected_id = 4711;
 
        $database = $this->getMockBuilder(\ilDBInterface::class)->getMock();
        $result = $this->getMockBuilder(\ilDBStatement::class)->getMock();
 
        $database
            ->expects($this->once())
            ->method('queryF')
            ->with(
                'SELECT id FROM tos_versions WHERE hash = %s AND doc_id = %s',
                ['text', 'integer'],
                [$entity->getHash(), $entity->getDocumentId()]
            )->will($this->returnValue($result));
 
        $database
            ->expects($this->once())
            ->method('numRows')
            ->with($result)
            ->will($this->returnValue(1));
 
        $database
            ->expects($this->once())
            ->method('fetchAssoc')
            ->with($result)
            ->will($this->returnValue(['id' => $expected_id]));
 
        $expectedTracking = [
            'tosv_id' => ['integer', $expected_id],
            'usr_id' => ['integer', $entity->getUserId()],
            'criteria' => ['clob', $entity->getSerializedCriteria()],
            'ts' => ['integer', $entity->getTimestamp()]
        ];
        $database
            ->expects($this->once())
            ->method('insert')
            ->with('tos_acceptance_track', $expectedTracking);
 
        $gateway = new \ilTermsOfServiceAcceptanceDatabaseGateway($database);
        $gateway->trackAcceptance($entity);
    }

References $result, and Sabre\Event\once().

Here is the call graph for this function:

testInstanceCanBeCreated()

ilTermsOfServiceAcceptanceDatabaseGatewayTest::testInstanceCanBeCreated

(

)

Definition at line 13 of file ilTermsOfServiceAcceptanceDatabaseGatewayTest.php.

    {
        $database = $this->getMockBuilder(\ilDBInterface::class)->getMock();
        $gateway = new \ilTermsOfServiceAcceptanceDatabaseGateway($database);
 
        $this->assertInstanceOf(\ilTermsOfServiceAcceptanceDatabaseGateway::class, $gateway);
    }

testLatestAcceptanceOfUserCanBeLoaded()

ilTermsOfServiceAcceptanceDatabaseGatewayTest::testLatestAcceptanceOfUserCanBeLoaded

(

)

Definition at line 146 of file ilTermsOfServiceAcceptanceDatabaseGatewayTest.php.

    {
        $entity = new \ilTermsOfServiceAcceptanceEntity();
 
        $expected = [
            'id' => 4711,
            'usr_id' => 6,
            'title' => 'Document PHP Unit',
            'doc_id' => 4711,
            'criteria' => '',
            'text' => 'PHP Unit',
            'hash' => md5('PHP Unit'),
            'accepted_ts' => time()
        ];
 
        $database = $this->getMockBuilder(\ilDBInterface::class)->getMock();
        $database
            ->expects($this->once())
            ->method('fetchAssoc')
            ->will($this->onConsecutiveCalls($expected));
 
        $gateway = new \ilTermsOfServiceAcceptanceDatabaseGateway($database);
        $entity = $gateway->loadCurrentAcceptanceOfUser($entity);
 
        $this->assertEquals($expected['id'], $entity->getId());
        $this->assertEquals($expected['usr_id'], $entity->getUserId());
        $this->assertEquals($expected['doc_id'], $entity->getDocumentId());
        $this->assertEquals($expected['title'], $entity->getTitle());
        $this->assertEquals($expected['criteria'], $entity->getSerializedCriteria());
        $this->assertEquals($expected['text'], $entity->getText());
        $this->assertEquals($expected['accepted_ts'], $entity->getTimestamp());
        $this->assertEquals($expected['hash'], $entity->getHash());
    }

References Sabre\Event\once().

Here is the call graph for this function:

---

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

• Services/TermsOfService/test/gateways/ilTermsOfServiceAcceptanceDatabaseGatewayTest.php