ilLSPostConditionDBTest Class Reference

Inheritance diagram for ilLSPostConditionDBTest:

Collaboration diagram for ilLSPostConditionDBTest:

Public Member Functions
	testCreateObject ()
	testSelectWithEmptyArray ()
	testSelectWithNoDBResults ()
	testSelectWithDBResults ()
	testDelete ()

Protected Member Functions
	setUp ()

Protected Attributes
	$db

Detailed Description

Definition at line 23 of file ilLSPostConditionDBTest.php.

Member Function Documentation

setUp()

ilLSPostConditionDBTest::setUp ( )

protected

Definition at line 30 of file ilLSPostConditionDBTest.php.

                              : void
    {
        $this->db = $this->createMock(ilDBInterface::class);
    }

testCreateObject()

ilLSPostConditionDBTest::testCreateObject

(

)

Definition at line 35 of file ilLSPostConditionDBTest.php.

                                      : void
    {
        $obj = new ilLSPostConditionDB($this->db);

        $this->assertInstanceOf(ilLSPostConditionDB::class, $obj);
    }

testDelete()

ilLSPostConditionDBTest::testDelete

(

)

Definition at line 134 of file ilLSPostConditionDBTest.php.

                                : void
    {
        $sql =
              "DELETE FROM post_conditions" . PHP_EOL
            . "WHERE ref_id IN (20,22)" . PHP_EOL
        ;

        $this->db
            ->expects($this->once())
            ->method('manipulate')
            ->with($sql)
        ;

        $obj = new ilLSPostConditionDB($this->db);
        $obj->delete([20,22]);
    }

testSelectWithDBResults()

ilLSPostConditionDBTest::testSelectWithDBResults

(

)

Definition at line 86 of file ilLSPostConditionDBTest.php.

References ILIAS\UI\Implementation\Component\Input\getValue(), and null.

                                             : void
    {
        $sql =
              "SELECT ref_id, condition_operator, value" . PHP_EOL
            . "FROM post_conditions" . PHP_EOL
            . "WHERE ref_id IN (33,44)" . PHP_EOL
        ;

        $rows = [
            [
                'ref_id' => 33,
                'condition_operator' => 'failed',
                'value' => "11"
            ],
            [
                'ref_id' => 44,
                'condition_operator' => 'finished',
                'value' => "12"
            ],
            null
        ];

        $return_statement = $this->getMockBuilder(ilDBStatement::class)->getMock();
        $this->db
            ->expects($this->once())
            ->method('query')
            ->with($sql)
            ->willReturn($return_statement)
        ;
        $this->db
            ->expects($this->any())
            ->method('fetchAssoc')
            ->with($return_statement)
            ->willReturnOnConsecutiveCalls(...$rows)
        ;

        $obj = new ilLSPostConditionDB($this->db);
        $result = $obj->select([33,44]);

        $this->assertEquals(33, $result[0]->getRefId());
        $this->assertEquals('failed', $result[0]->getConditionOperator());
        $this->assertEquals("11", $result[0]->getValue());

        $this->assertEquals(44, $result[1]->getRefId());
        $this->assertEquals('finished', $result[1]->getConditionOperator());
        $this->assertEquals("12", $result[1]->getValue());
    }

Here is the call graph for this function:

testSelectWithEmptyArray()

ilLSPostConditionDBTest::testSelectWithEmptyArray

(

)

Definition at line 42 of file ilLSPostConditionDBTest.php.

                                              : void
    {
        $obj = new ilLSPostConditionDB($this->db);

        $result = $obj->select([]);

        $this->assertIsArray($result);
        $this->assertEmpty($result);
    }

testSelectWithNoDBResults()

ilLSPostConditionDBTest::testSelectWithNoDBResults

(

)

Definition at line 52 of file ilLSPostConditionDBTest.php.

References ILIAS\UI\Implementation\Component\Input\getValue(), and ilLSPostConditionDB\STD_ALWAYS_OPERATOR.

                                               : void
    {
        $sql =
              "SELECT ref_id, condition_operator, value" . PHP_EOL
            . "FROM post_conditions" . PHP_EOL
            . "WHERE ref_id IN (20,22)" . PHP_EOL
        ;

        $return = $this->getMockBuilder(ilDBStatement::class)->getMock();
        $this->db
            ->expects($this->once())
            ->method('query')
            ->with($sql)
            ->willReturn($return)
        ;
        $this->db
            ->expects($this->once())
            ->method('fetchAssoc')
            ->with($return)
            ->willReturn([])
        ;

        $obj = new ilLSPostConditionDB($this->db);
        $result = $obj->select([20,22]);

        $this->assertEquals(20, $result[0]->getRefId());
        $this->assertEquals(ilLSPostConditionDB::STD_ALWAYS_OPERATOR, $result[0]->getConditionOperator());
        $this->assertNull($result[0]->getValue());

        $this->assertEquals(22, $result[1]->getRefId());
        $this->assertEquals(ilLSPostConditionDB::STD_ALWAYS_OPERATOR, $result[1]->getConditionOperator());
        $this->assertNull($result[1]->getValue());
    }

Here is the call graph for this function:

Field Documentation

$db

ilLSPostConditionDBTest::$db

protected

Definition at line 28 of file ilLSPostConditionDBTest.php.

---

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

• components/ILIAS/LearningSequence/tests/PostConditions/ilLSPostConditionDBTest.php