Collaboration diagram for ILIAS\Test\TestManScoringDoneHelper:

Public Member Functions
	__construct (?\ilDBInterface $db=null)

	isDone (int $activeId)

	exists (int $activeId)

	setDone (int $activeId, bool $done)

Private Attributes
ilDBInterface	$db

const	TABLE_NAME = "manscoring_done"

Detailed Description

Definition at line 28 of file TestManScoringDoneHelper.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\Test\TestManScoringDoneHelper::__construct ( ?\ilDBInterface $db = null )

Definition at line 33 of file TestManScoringDoneHelper.php.

    {
        if (!$db) {
            global $DIC;
            $db = $DIC->database();
        }
        $this->db = $db;
    }

References ILIAS\Test\TestManScoringDoneHelper\$db, and $DIC.

Member Function Documentation

◆ exists()

ILIAS\Test\TestManScoringDoneHelper::exists ( int $activeId )

Definition at line 53 of file TestManScoringDoneHelper.php.

                                         : bool
    {
        $result = $this->db->queryF(
            "SELECT active_id FROM " . self::TABLE_NAME . " WHERE active_id = %s",
            ["integer"],
            [$activeId]
        );
 
        return $result->numRows() === 1;
    }

Referenced by ILIAS\Test\TestManScoringDoneHelper\setDone().

Here is the caller graph for this function:

◆ isDone()

ILIAS\Test\TestManScoringDoneHelper::isDone ( int $activeId )

Definition at line 42 of file TestManScoringDoneHelper.php.

                                         : bool
    {
        $result = $this->db->queryF(
            "SELECT done FROM " . self::TABLE_NAME . " WHERE active_id = %s AND done = 1",
            ["integer"],
            [$activeId]
        );
 
        return $result->numRows() === 1;
    }

◆ setDone()

ILIAS\Test\TestManScoringDoneHelper::setDone	(	int	$activeId,
		bool	$done
	)

Definition at line 64 of file TestManScoringDoneHelper.php.

                                                      : void
    {
        if ($this->exists($activeId)) {
            $this->db->manipulateF(
                "UPDATE " . self::TABLE_NAME . " SET done = %s WHERE active_id = %s",
                ["integer", "integer"],
                [$done, $activeId]
            );
            return;
        }
 
        $this->db->manipulateF(
            "INSERT INTO " . self::TABLE_NAME . " (active_id, done) VALUES (%s, %s)",
            ["integer", "integer"],
            [$activeId, $done]
        );
    }