ilIndividualAssessmentMembersStorageDBTest Class Reference

Inheritance diagram for ilIndividualAssessmentMembersStorageDBTest:

Collaboration diagram for ilIndividualAssessmentMembersStorageDBTest:

Public Member Functions
	getWrapperObj (ilDBInterface $db)
	testCreateObject ()
	test_loadMembers ()
	test_loadMembersAsSingleObjects ()
	test_loadMember_exception ()
	test_loadMember ()
	test_createAssessmentMember ()
	test_updateMember ()
	test_deleteMembers ()
	test_insertMembersRecord ()
	test_removeMembersRecord ()
	test_getWhereFromFilter ($filter, $result)
	dataFor_getWhereFromFilter More...
	test_getOrderByFromSort ()

Static Public Member Functions
static	dataFor_getWhereFromFilter ()

Detailed Description

Definition at line 55 of file ilIndividualAssessmentMembersStorageDBTest.php.

Member Function Documentation

dataFor_getWhereFromFilter()

static ilIndividualAssessmentMembersStorageDBTest::dataFor_getWhereFromFilter ( )

static

Definition at line 660 of file ilIndividualAssessmentMembersStorageDBTest.php.

References ilIndividualAssessmentMembers\LP_ASSESSMENT_NOT_COMPLETED, ilIndividualAssessmentMembers\LP_COMPLETED, ilIndividualAssessmentMembers\LP_FAILED, and ilIndividualAssessmentMembers\LP_IN_PROGRESS.

                                                       : array
    {
        return [
            [
                ilIndividualAssessmentMembers::LP_ASSESSMENT_NOT_COMPLETED,
                "      AND finalized = 0 AND examiner_id IS NULL\n"
            ],
            [
                ilIndividualAssessmentMembers::LP_IN_PROGRESS,
                "      AND finalized = 0 AND examiner_id IS NOT NULL\n"
            ],
            [
                ilIndividualAssessmentMembers::LP_COMPLETED,
                "      AND finalized = 1 AND learning_progress = 2\n"
            ],
            [
                ilIndividualAssessmentMembers::LP_FAILED,
                "      AND finalized = 1 AND learning_progress = 3\n"
            ],
            [
                "test",
                ""
            ]
        ];
    }

getWrapperObj()

ilIndividualAssessmentMembersStorageDBTest::getWrapperObj

(

ilDBInterface

$db

)

Definition at line 57 of file ilIndividualAssessmentMembersStorageDBTest.php.

                                                    : ilIndividualAssessmentMembersStorageDBWrapper
    {
        $irss = $this->createMock(IRSS::class);
        $stakeholder = new ilIndividualAssessmentGradingStakeholder();
        return new ilIndividualAssessmentMembersStorageDBWrapper(
            $db,
            $irss,
            $stakeholder
        );
    }

test_createAssessmentMember()

ilIndividualAssessmentMembersStorageDBTest::test_createAssessmentMember

(

)

Definition at line 367 of file ilIndividualAssessmentMembersStorageDBTest.php.

References $timestamp, ilIndividualAssessmentMembers\FIELD_CHANGE_TIME, ilIndividualAssessmentMembers\FIELD_CHANGER_ID, ilIndividualAssessmentMembers\FIELD_EVENTTIME, ilIndividualAssessmentMembers\FIELD_EXAMINER_ID, ilIndividualAssessmentMembers\FIELD_FILE_NAME, ilIndividualAssessmentMembers\FIELD_FINALIZED, ilIndividualAssessmentMembers\FIELD_INTERNAL_NOTE, ilIndividualAssessmentMembers\FIELD_LEARNING_PROGRESS, ilIndividualAssessmentMembers\FIELD_NOTIFICATION_TS, ilIndividualAssessmentMembers\FIELD_NOTIFY, ilIndividualAssessmentMembers\FIELD_PLACE, ilIndividualAssessmentMembers\FIELD_RECORD, and ilIndividualAssessmentMembers\FIELD_USER_VIEW_FILE.

                                                 : void
    {
        $iass = $this->createMock(ilObjIndividualAssessment::class);
        $usr = $this->createMock(ilObjUser::class);
        $usr
            ->expects($this->once())
            ->method("getFullname")
            ->willReturn("Full Name")
        ;

        $timestamp = 1638431626;

        $record = [
            ilIndividualAssessmentMembers::FIELD_CHANGER_ID => 11,
            ilIndividualAssessmentMembers::FIELD_CHANGE_TIME => "2021-12-02",
            ilIndividualAssessmentMembers::FIELD_EXAMINER_ID => 22,
            ilIndividualAssessmentMembers::FIELD_NOTIFICATION_TS => $timestamp,
            ilIndividualAssessmentMembers::FIELD_EVENTTIME => $timestamp,
            ilIndividualAssessmentMembers::FIELD_RECORD => "record",
            ilIndividualAssessmentMembers::FIELD_INTERNAL_NOTE => "internal_note",
            ilIndividualAssessmentMembers::FIELD_FILE_NAME => "file_name",
            ilIndividualAssessmentMembers::FIELD_USER_VIEW_FILE => true,
            ilIndividualAssessmentMembers::FIELD_LEARNING_PROGRESS => 33,
            ilIndividualAssessmentMembers::FIELD_PLACE => "place",
            ilIndividualAssessmentMembers::FIELD_NOTIFY => true,
            ilIndividualAssessmentMembers::FIELD_FINALIZED => true
        ];

        $db = $this->createMock(ilDBInterface::class);
        $obj = $this->getWrapperObj($db);

        $member = $obj->createAssessmentMemberWrapper($iass, $usr, $record);

        $this->assertEquals("Full Name", $member->getGrading()->getName());
        $this->assertEquals(11, $member->changerId());
        $this->assertEquals("2021-12-02", $member->changeTime()->format("Y-m-d"));
        $this->assertEquals(22, $member->examinerId());
        $this->assertEquals($timestamp, $member->notificationTS());
        $this->assertEquals($timestamp, $member->eventTime()->getTimestamp());
        $this->assertEquals("record", $member->record());
        $this->assertEquals("internal_note", $member->internalNote());
        $this->assertEquals("file_name", $member->fileName());
        $this->assertTrue($member->viewFile());
        $this->assertEquals(33, $member->LPStatus());
        $this->assertTrue($member->notify());
        $this->assertTrue($member->finalized());
    }

test_deleteMembers()

ilIndividualAssessmentMembersStorageDBTest::test_deleteMembers

(

)

Definition at line 526 of file ilIndividualAssessmentMembersStorageDBTest.php.

                                        : void
    {
        $iass = $this->createMock(ilObjIndividualAssessment::class);
        $iass
            ->expects($this->exactly(2))
            ->method("getId")
            ->willReturn(22)
        ;

        $sql = "DELETE FROM iass_members WHERE obj_id = 22";

        $db = $this->createMock(ilDBInterface::class);
        $db
            ->expects($this->any())
            ->method("quote")
            ->with(22, "integer")
            ->willReturn("22")
        ;
        $db
            ->expects($this->once())
            ->method("manipulate")
            ->with($sql)
        ;

        $irss = $this->createMock(IRSS::class);
        $stakeholder = new ilIndividualAssessmentGradingStakeholder();
        $obj = new ilIndividualAssessmentMembersStorageDB($db, $irss, $stakeholder);
        $obj->deleteMembers($iass);
    }

test_getOrderByFromSort()

ilIndividualAssessmentMembersStorageDBTest::test_getOrderByFromSort

(

)

Definition at line 698 of file ilIndividualAssessmentMembersStorageDBTest.php.

References $res.

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

        $sort = "test:foo";

        $res = $obj->getOrderByFromSortWrapper($sort);

        $this->assertEquals(" ORDER BY test foo", $res);
    }

test_getWhereFromFilter()

ilIndividualAssessmentMembersStorageDBTest::test_getWhereFromFilter	(		$filter,
			$result
	)

dataFor_getWhereFromFilter

Definition at line 689 of file ilIndividualAssessmentMembersStorageDBTest.php.

References $res.

                                                             : void
    {
        $db = $this->createMock(ilDBInterface::class);
        $obj = $this->getWrapperObj($db);
        $res = $obj->getWhereFromFilterWrapper($filter);

        $this->assertEquals($result, $res);
    }

test_insertMembersRecord()

ilIndividualAssessmentMembersStorageDBTest::test_insertMembersRecord

(

)

Definition at line 556 of file ilIndividualAssessmentMembersStorageDBTest.php.

References $timestamp, ilIndividualAssessmentMembers\FIELD_CHANGE_TIME, ilIndividualAssessmentMembers\FIELD_CHANGER_ID, ilIndividualAssessmentMembers\FIELD_EVENTTIME, ilIndividualAssessmentMembers\FIELD_EXAMINER_ID, ilIndividualAssessmentMembers\FIELD_FILE_NAME, ilIndividualAssessmentMembers\FIELD_FINALIZED, ilIndividualAssessmentMembers\FIELD_INTERNAL_NOTE, ilIndividualAssessmentMembers\FIELD_LEARNING_PROGRESS, ilIndividualAssessmentMembers\FIELD_NOTIFICATION_TS, ilIndividualAssessmentMembers\FIELD_NOTIFY, ilIndividualAssessmentMembers\FIELD_PLACE, ilIndividualAssessmentMembers\FIELD_RECORD, ilIndividualAssessmentMembers\FIELD_USER_VIEW_FILE, and ilIndividualAssessmentMembers\FIELD_USR_ID.

                                              : void
    {
        $timestamp = 1638431626;

        $iass = $this->createMock(ilObjIndividualAssessment::class);
        $iass
            ->expects($this->once())
            ->method("getId")
            ->willReturn(11)
        ;

        $db = $this->createMock(ilDBInterface::class);
        $obj = $this->getWrapperObj($db);

        $record = [
            ilIndividualAssessmentMembers::FIELD_USR_ID => 22,
            ilIndividualAssessmentMembers::FIELD_LEARNING_PROGRESS => 33,
            ilIndividualAssessmentMembers::FIELD_EXAMINER_ID => 44,
            ilIndividualAssessmentMembers::FIELD_RECORD => "record",
            ilIndividualAssessmentMembers::FIELD_INTERNAL_NOTE => "internalNote",
            ilIndividualAssessmentMembers::FIELD_PLACE => "place",
            ilIndividualAssessmentMembers::FIELD_EVENTTIME => $timestamp,
            ilIndividualAssessmentMembers::FIELD_NOTIFY => true,
            ilIndividualAssessmentMembers::FIELD_FINALIZED => 0,
            ilIndividualAssessmentMembers::FIELD_NOTIFICATION_TS => -1,
            ilIndividualAssessmentMembers::FIELD_FILE_NAME => "fileName",
            ilIndividualAssessmentMembers::FIELD_USER_VIEW_FILE => true,
            ilIndividualAssessmentMembers::FIELD_CHANGER_ID => 55,
            ilIndividualAssessmentMembers::FIELD_CHANGE_TIME => $obj->getActualDateTime()
        ];

        $values = [
            "obj_id" => ["integer", 11],
            ilIndividualAssessmentMembers::FIELD_USR_ID => ["integer", 22],
            ilIndividualAssessmentMembers::FIELD_LEARNING_PROGRESS => ["text", 33],
            ilIndividualAssessmentMembers::FIELD_NOTIFY => ["integer", true],
            ilIndividualAssessmentMembers::FIELD_FINALIZED => ["integer", 0],
            ilIndividualAssessmentMembers::FIELD_NOTIFICATION_TS => ["integer", -1],
            ilIndividualAssessmentMembers::FIELD_EXAMINER_ID => ["integer", 44],
            ilIndividualAssessmentMembers::FIELD_RECORD => ["text", "record"],
            ilIndividualAssessmentMembers::FIELD_INTERNAL_NOTE => ["text", "internalNote"],
            ilIndividualAssessmentMembers::FIELD_PLACE => ["text", "place"],
            ilIndividualAssessmentMembers::FIELD_EVENTTIME => ["integer", $timestamp],
            ilIndividualAssessmentMembers::FIELD_FILE_NAME => ["text", "fileName"],
            ilIndividualAssessmentMembers::FIELD_USER_VIEW_FILE => ["integer", true],
            ilIndividualAssessmentMembers::FIELD_CHANGER_ID => ["integer", 55],
            ilIndividualAssessmentMembers::FIELD_CHANGE_TIME => ["text", $obj->getActualDateTime()]
        ];

        $db
            ->expects($this->once())
            ->method("insert")
            ->with("iass_members", $values)
        ;

        $obj->insertMembersRecord($iass, $record);
    }

test_loadMember()

ilIndividualAssessmentMembersStorageDBTest::test_loadMember

(

)

Definition at line 285 of file ilIndividualAssessmentMembersStorageDBTest.php.

References ilIndividualAssessmentMembersStorageDB\MEMBERS_TABLE, and null.

                                     : void
    {
        $sql = "SELECT "
            . "iassme.obj_id,"
            . "iassme.usr_id,"
            . "iassme.examiner_id,"
            . "iassme.record,"
            . "iassme.internal_note,"
            . "iassme.notify,"
            . "iassme.notification_ts,"
            . "iassme.learning_progress,"
            . "iassme.finalized,"
            . "iassme.place,"
            . "iassme.event_time,"
            . "iassme.user_view_file,"
            . "iassme.file_name,"
            . "iassme.changer_id,"
            . "iassme.change_time,"
            . "usr.login AS user_login,"
            . "ex.login AS examiner_login"
            . " FROM " . ilIndividualAssessmentMembersStorageDB::MEMBERS_TABLE . " iassme\n"
            . " JOIN usr_data usr ON iassme.usr_id = usr.usr_id\n"
            . " LEFT JOIN usr_data ex ON iassme.examiner_id = ex.usr_id\n"
            . " WHERE obj_id = 22\n"
            . "         AND iassme.usr_id = 33"
        ;

        $iass = $this->createMock(ilObjIndividualAssessment::class);
        $iass
            ->expects($this->once())
            ->method("getId")
            ->willReturn(22)
        ;

        $usr = $this->createMock(ilObjUser::class);
        $usr
            ->expects($this->once())
            ->method("getId")
            ->willReturn(33)
        ;

        $db_statement = $this->createMock(ilDBStatement::class);

        $consecutive = [
            [22, "integer"],
            [33, "integer"]
        ];
        $db = $this->createMock(ilDBInterface::class);
        $db
            ->expects($this->exactly(2))
            ->method("quote")
            ->willReturnCallback(
                function (int $v, string $type) use (&$consecutive) {
                    list($ev, $etype) = array_shift($consecutive);
                    $this->assertEquals($ev, $v);
                    $this->assertEquals($etype, $type);
                    return (string)$v;
                }
            );

        $db
            ->expects($this->once())
            ->method("query")
            ->with($sql)
            ->willReturn($db_statement)
        ;
        $db
            ->expects($this->once())
            ->method("fetchAssoc")
            ->with($db_statement)
            ->willReturn(null)
        ;

        $irss = $this->createMock(IRSS::class);
        $stakeholder = new ilIndividualAssessmentGradingStakeholder();
        $obj = new ilIndividualAssessmentMembersStorageDB($db, $irss, $stakeholder);

        $this->expectException(ilIndividualAssessmentException::class);
        $this->expectExceptionMessage("invalid usr-obj combination");
        $obj->loadMember($iass, $usr);
    }

test_loadMember_exception()

ilIndividualAssessmentMembersStorageDBTest::test_loadMember_exception

(

)

Definition at line 203 of file ilIndividualAssessmentMembersStorageDBTest.php.

References ilIndividualAssessmentMembersStorageDB\MEMBERS_TABLE, and null.

                                               : void
    {
        $sql = "SELECT "
            . "iassme.obj_id,"
            . "iassme.usr_id,"
            . "iassme.examiner_id,"
            . "iassme.record,"
            . "iassme.internal_note,"
            . "iassme.notify,"
            . "iassme.notification_ts,"
            . "iassme.learning_progress,"
            . "iassme.finalized,"
            . "iassme.place,"
            . "iassme.event_time,"
            . "iassme.user_view_file,"
            . "iassme.file_name,"
            . "iassme.changer_id,"
            . "iassme.change_time,"
            . "usr.login AS user_login,"
            . "ex.login AS examiner_login"
            . " FROM " . ilIndividualAssessmentMembersStorageDB::MEMBERS_TABLE . " iassme\n"
            . " JOIN usr_data usr ON iassme.usr_id = usr.usr_id\n"
            . " LEFT JOIN usr_data ex ON iassme.examiner_id = ex.usr_id\n"
            . " WHERE obj_id = 22\n"
            . "         AND iassme.usr_id = 33"
        ;

        $iass = $this->createMock(ilObjIndividualAssessment::class);
        $iass
            ->expects($this->once())
            ->method("getId")
            ->willReturn(22)
        ;

        $usr = $this->createMock(ilObjUser::class);
        $usr
            ->expects($this->once())
            ->method("getId")
            ->willReturn(33)
        ;

        $db_statement = $this->createMock(ilDBStatement::class);

        $consecutive = [
            [22, "integer"],
            [33, "integer"]
        ];
        $db = $this->createMock(ilDBInterface::class);
        $db
            ->expects($this->exactly(2))
            ->method("quote")
            ->willReturnCallback(
                function (int $v, string $type) use (&$consecutive) {
                    list($ev, $etype) = array_shift($consecutive);
                    $this->assertEquals($ev, $v);
                    $this->assertEquals($etype, $type);
                    return (string)$v;
                }
            );

        $db
            ->expects($this->once())
            ->method("query")
            ->with($sql)
            ->willReturn($db_statement)
        ;
        $db
            ->expects($this->once())
            ->method("fetchAssoc")
            ->with($db_statement)
            ->willReturn(null)
        ;

        $irss = $this->createMock(IRSS::class);
        $stakeholder = new ilIndividualAssessmentGradingStakeholder();
        $obj = new ilIndividualAssessmentMembersStorageDB($db, $irss, $stakeholder);

        $this->expectException(ilIndividualAssessmentException::class);
        $this->expectExceptionMessage("invalid usr-obj combination");
        $obj->loadMember($iass, $usr);
    }

test_loadMembers()

ilIndividualAssessmentMembersStorageDBTest::test_loadMembers

(

)

Definition at line 80 of file ilIndividualAssessmentMembersStorageDBTest.php.

References ilIndividualAssessmentMembers\FIELD_CHANGER_FIRSTNAME, ilIndividualAssessmentMembers\FIELD_CHANGER_LASTNAME, ilIndividualAssessmentMembers\FIELD_EXAMINER_FIRSTNAME, ilIndividualAssessmentMembers\FIELD_EXAMINER_LASTNAME, ilIndividualAssessmentMembers\FIELD_FILE_NAME, ilIndividualAssessmentMembers\FIELD_FIRSTNAME, ilIndividualAssessmentMembers\FIELD_LASTNAME, ilIndividualAssessmentMembers\FIELD_LOGIN, and null.

                                      : void
    {
        $sql = "SELECT ex.firstname as " . ilIndividualAssessmentMembers::FIELD_EXAMINER_FIRSTNAME
            . "     , ex.lastname as " . ilIndividualAssessmentMembers::FIELD_EXAMINER_LASTNAME
            . "     , ud.firstname as " . ilIndividualAssessmentMembers::FIELD_CHANGER_FIRSTNAME
            . "     , ud.lastname as " . ilIndividualAssessmentMembers::FIELD_CHANGER_LASTNAME
            . "     ,usr.firstname as " . ilIndividualAssessmentMembers::FIELD_FIRSTNAME
            . "     ,usr.lastname as " . ilIndividualAssessmentMembers::FIELD_LASTNAME
            . "     ,usr.login as " . ilIndividualAssessmentMembers::FIELD_LOGIN
            . "    ,iassme." . ilIndividualAssessmentMembers::FIELD_FILE_NAME
            . "     ,iassme.obj_id, iassme.usr_id, iassme.examiner_id, iassme.record, iassme.internal_note, iassme.notify"
            . "     ,iassme.notification_ts, iassme.learning_progress, iassme.finalized,iassme.place"
            . "     ,iassme.event_time, iassme.changer_id, iassme.change_time\n"
            . " FROM iass_members iassme"
            . " JOIN usr_data usr ON iassme.usr_id = usr.usr_id"
            . " LEFT JOIN usr_data ex ON iassme.examiner_id = ex.usr_id"
            . " LEFT JOIN usr_data ud ON iassme.changer_id = ud.usr_id"
            . " WHERE obj_id = 22";


        $iass = $this->createMock(ilObjIndividualAssessment::class);
        $iass
            ->expects($this->once())
            ->method("getId")
            ->willReturn(22)
        ;

        $db_statement = $this->createMock(ilDBStatement::class);

        $db = $this->createMock(ilDBInterface::class);
        $db
            ->expects($this->once())
            ->method("quote")
            ->with(22, "integer")
            ->willReturn("22")
        ;
        $db
            ->expects($this->once())
            ->method("query")
            ->with($sql)
            ->willReturn($db_statement)
        ;
        $db
            ->expects($this->any())
            ->method("fetchAssoc")
            ->with($db_statement)
            ->willReturn(null)
        ;

        $obj = new ilIndividualAssessmentMembersStorageDB(
            $db,
            $this->createMock(IRSS::class),
            new ilIndividualAssessmentGradingStakeholder()
        );

        $result = $obj->loadMembers($iass);
        $this->assertInstanceOf(ilIndividualAssessmentMembers::class, $result);
    }

test_loadMembersAsSingleObjects()

ilIndividualAssessmentMembersStorageDBTest::test_loadMembersAsSingleObjects

(

)

Definition at line 139 of file ilIndividualAssessmentMembersStorageDBTest.php.

References ilIndividualAssessmentMembersStorageDB\MEMBERS_TABLE, and null.

                                                     : void
    {
        $sql = "SELECT "
            . "iassme.obj_id,"
            . "iassme.usr_id,"
            . "iassme.examiner_id,"
            . "iassme.record,"
            . "iassme.internal_note,"
            . "iassme.notify,"
            . "iassme.notification_ts,"
            . "iassme.learning_progress,"
            . "iassme.finalized,"
            . "iassme.place,"
            . "iassme.event_time,"
            . "iassme.user_view_file,"
            . "iassme.file_name,"
            . "iassme.changer_id,"
            . "iassme.change_time,"
            . "usr.login AS user_login,"
            . "ex.login AS examiner_login"
            . " FROM " . ilIndividualAssessmentMembersStorageDB::MEMBERS_TABLE . " iassme\n"
            . " JOIN usr_data usr ON iassme.usr_id = usr.usr_id\n"
            . " LEFT JOIN usr_data ex ON iassme.examiner_id = ex.usr_id\n"
            . " WHERE obj_id = 22"
        ;

        $iass = $this->createMock(ilObjIndividualAssessment::class);
        $iass
            ->expects($this->once())
            ->method("getId")
            ->willReturn(22)
        ;

        $db_statement = $this->createMock(ilDBStatement::class);

        $db = $this->createMock(ilDBInterface::class);
        $db
            ->expects($this->once())
            ->method("quote")
            ->with(22, "integer")
            ->willReturn("22")
        ;
        $db
            ->expects($this->once())
            ->method("query")
            ->with($sql)
            ->willReturn($db_statement)
        ;
        $db
            ->expects($this->once())
            ->method("fetchAssoc")
            ->with($db_statement)
            ->willReturn(null)
        ;

        $irss = $this->createMock(IRSS::class);
        $stakeholder = new ilIndividualAssessmentGradingStakeholder();
        $obj = new ilIndividualAssessmentMembersStorageDB($db, $irss, $stakeholder);
        $result = $obj->loadMembersAsSingleObjects($iass);

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

test_removeMembersRecord()

ilIndividualAssessmentMembersStorageDBTest::test_removeMembersRecord

(

)

Definition at line 614 of file ilIndividualAssessmentMembersStorageDBTest.php.

References ilIndividualAssessmentMembers\FIELD_USR_ID.

                                              : void
    {
        $iass = $this->createMock(ilObjIndividualAssessment::class);
        $iass
            ->expects($this->once())
            ->method("getId")
            ->willReturn(11)
        ;

        $record[ilIndividualAssessmentMembers::FIELD_USR_ID] = 22;

        $sql =
            "DELETE FROM iass_members" . PHP_EOL
            . "WHERE obj_id = 11" . PHP_EOL
            . "AND usr_id = 22" . PHP_EOL
        ;

        $consecutive = [
            [11, "integer"],
            [22, "integer"]
        ];
        $db = $this->createMock(ilDBInterface::class);
        $db
            ->expects($this->exactly(2))
            ->method("quote")
            ->willReturnCallback(
                function (int $v, string $type) use (&$consecutive) {
                    list($ev, $etype) = array_shift($consecutive);
                    $this->assertEquals($ev, $v);
                    $this->assertEquals($etype, $type);
                    return (string)$v;
                }
            );

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

        $irss = $this->createMock(IRSS::class);
        $stakeholder = new ilIndividualAssessmentGradingStakeholder();
        $obj = new ilIndividualAssessmentMembersStorageDB($db, $irss, $stakeholder);
        $obj->removeMembersRecord($iass, $record);
    }

test_updateMember()

ilIndividualAssessmentMembersStorageDBTest::test_updateMember

(

)

Definition at line 415 of file ilIndividualAssessmentMembersStorageDBTest.php.

References $timestamp, ilIndividualAssessmentMembers\FIELD_CHANGE_TIME, ilIndividualAssessmentMembers\FIELD_CHANGER_ID, ilIndividualAssessmentMembers\FIELD_EVENTTIME, ilIndividualAssessmentMembers\FIELD_EXAMINER_ID, ilIndividualAssessmentMembers\FIELD_FILE_NAME, ilIndividualAssessmentMembers\FIELD_FINALIZED, ilIndividualAssessmentMembers\FIELD_INTERNAL_NOTE, ilIndividualAssessmentMembers\FIELD_LEARNING_PROGRESS, ilIndividualAssessmentMembers\FIELD_NOTIFICATION_TS, ilIndividualAssessmentMembers\FIELD_NOTIFY, ilIndividualAssessmentMembers\FIELD_PLACE, ilIndividualAssessmentMembers\FIELD_RECORD, and ilIndividualAssessmentMembers\FIELD_USER_VIEW_FILE.

                                       : void
    {
        $timestamp = 1638431626;
        $date = (new DateTimeImmutable())->setTimestamp($timestamp);

        $member = $this->createMock(ilIndividualAssessmentMember::class);
        $member
            ->expects($this->once())
            ->method("assessmentId")
            ->willReturn(11)
        ;
        $member
            ->expects($this->once())
            ->method("id")
            ->willReturn(22)
        ;
        $member
            ->expects($this->once())
            ->method("eventTime")
            ->willReturn($date)
        ;
        $member
            ->expects($this->once())
            ->method("LPStatus")
            ->willReturn(33)
        ;
        $member
            ->expects($this->once())
            ->method("examinerId")
            ->willReturn(44)
        ;
        $member
            ->expects($this->once())
            ->method("record")
            ->willReturn("record")
        ;
        $member
            ->expects($this->once())
            ->method("internalNote")
            ->willReturn("internalNote")
        ;
        $member
            ->expects($this->once())
            ->method("place")
            ->willReturn("place")
        ;
        $member
            ->expects($this->once())
            ->method("notify")
            ->willReturn(true)
        ;
        $member
            ->expects($this->once())
            ->method("finalized")
            ->willReturn(true)
        ;
        $member
            ->expects($this->once())
            ->method("notificationTS")
            ->willReturn($timestamp)
        ;
        $member
            ->expects($this->once())
            ->method("fileName")
            ->willReturn("fileName")
        ;
        $member
            ->expects($this->once())
            ->method("viewFile")
            ->willReturn(true)
        ;
        $member
            ->expects($this->once())
            ->method("changerId")
            ->willReturn(55)
        ;

        $db = $this->createMock(ilDBInterface::class);
        $obj = $this->getWrapperObj($db);

        $where = [
            "obj_id" => ["integer", 11],
            "usr_id" => ["integer", 22]
        ];

        $values = [
            ilIndividualAssessmentMembers::FIELD_LEARNING_PROGRESS => ["text", 33],
            ilIndividualAssessmentMembers::FIELD_EXAMINER_ID => ["integer", 44],
            ilIndividualAssessmentMembers::FIELD_RECORD => ["text", "record"],
            ilIndividualAssessmentMembers::FIELD_INTERNAL_NOTE => ["text", "internalNote"],
            ilIndividualAssessmentMembers::FIELD_PLACE => ["text", "place"],
            ilIndividualAssessmentMembers::FIELD_EVENTTIME => ["integer", $timestamp],
            ilIndividualAssessmentMembers::FIELD_NOTIFY => ["integer", true],
            ilIndividualAssessmentMembers::FIELD_FINALIZED => ["integer", true],
            ilIndividualAssessmentMembers::FIELD_NOTIFICATION_TS => ["integer", $timestamp],
            ilIndividualAssessmentMembers::FIELD_FILE_NAME => ["text", "fileName"],
            ilIndividualAssessmentMembers::FIELD_USER_VIEW_FILE => ["integer", true],
            ilIndividualAssessmentMembers::FIELD_CHANGER_ID => ["integer", 55],
            ilIndividualAssessmentMembers::FIELD_CHANGE_TIME => ["string", $obj->getActualDateTime()]
        ];

        $db
            ->expects($this->once())
            ->method("update")
            ->with("iass_members", $values, $where)
        ;


        $obj->updateMember($member);
    }

testCreateObject()

ilIndividualAssessmentMembersStorageDBTest::testCreateObject

(

)

Definition at line 68 of file ilIndividualAssessmentMembersStorageDBTest.php.

                                      : void
    {
        $db = $this->createMock(ilDBInterface::class);
        $irss = $this->createMock(IRSS::class);
        $obj = new ilIndividualAssessmentMembersStorageDB(
            $db,
            $irss,
            new ilIndividualAssessmentGradingStakeholder()
        );
        $this->assertInstanceOf(ilIndividualAssessmentMembersStorageDB::class, $obj);
    }

---

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

• components/ILIAS/IndividualAssessment/tests/Members/ilIndividualAssessmentMembersStorageDBTest.php