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.

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

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

Member Function Documentation

◆ exists()

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

Definition at line 53 of file TestManScoringDoneHelper.php.

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

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

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.

References ILIAS\Test\TestManScoringDoneHelper\exists().

                                                       : 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]
         );
     }