PassPresentedVariablesRepo Class Reference

Stores random-generated parts of questions in order to present the user with a fixed question during a test attempt. More...

Collaboration diagram for PassPresentedVariablesRepo:

Public Member Functions
	__construct (protected ilDBInterface $db)
	getFor (int $question_id, int $active_id, int $pass)
	store (int $question_id, int $active_id, int $pass, array $values)

Data Fields
const	TABLE_NAME = 'tst_qst_var_presented'

Detailed Description

Stores random-generated parts of questions in order to present the user with a fixed question during a test attempt.

Definition at line 25 of file PassPresentedVariablesRepo.php.

Constructor & Destructor Documentation

__construct()

PassPresentedVariablesRepo::__construct

(

protected ilDBInterface

$db

)

Definition at line 29 of file PassPresentedVariablesRepo.php.

      {
    }

Member Function Documentation

getFor()

PassPresentedVariablesRepo::getFor	(	int	$question_id,
		int	$active_id,
		int	$pass
	)

Definition at line 34 of file PassPresentedVariablesRepo.php.

     : ?array {
        $query = 'SELECT variable, value FROM ' . self::TABLE_NAME . ' WHERE '
            . 'question_id = %s AND '
            . 'active_id = %s AND '
            . 'pass = %s';

        $result = $this->db->queryF(
            $query,
            ['integer','integer','integer'],
            [$question_id, $active_id, $pass]
        );

        if($result->numRows() === 0) {
            return null;
        }

        $values = [];
        while ($row = $this->db->fetchAssoc($result)) {
            $values[$row['variable']] = $row['value'];
        }
        return $values;
    }

store()

PassPresentedVariablesRepo::store	(	int	$question_id,
		int	$active_id,
		int	$pass,
		array	$values
	)

Definition at line 61 of file PassPresentedVariablesRepo.php.

     : void {
        $query = 'INSERT INTO ' . self::TABLE_NAME
            . ' (question_id, active_id, pass, variable, value) '
            . ' VALUES (%s,%s,%s,%s,%s)';

        foreach ($values as $k => $v) {
            $this->db->manipulateF(
                $query,
                ['integer','integer','integer', 'text', 'text'],
                [$question_id, $active_id, $pass, $k, $v]
            );
        }
    }

Field Documentation

TABLE_NAME

const PassPresentedVariablesRepo::TABLE_NAME = 'tst_qst_var_presented'

Definition at line 27 of file PassPresentedVariablesRepo.php.

Referenced by ilAssQuestionProcessLockerDb\getTablesUsedDuringSolutionUpdate(), and ilObjTest\removeTestResultsByActiveIds().

---

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

• Modules/Test/classes/PassPresentedVariablesRepo.php