Repository for suggested solutions. More...

Inheritance diagram for ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository:

Collaboration diagram for ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository:

Public Member Functions
	__construct (\ilDBInterface $db)

	create (int $question_id, string $type)

	selectFor (int $question_id)
	return assQuestionSuggestedSolution[] More...

	update (array $suggested_solutions)

	delete (int $suggested_solution_id)

	deleteForQuestion (int $question_id)

	syncForQuestion (int $source_question_id, int $target_question_id)

Data Fields
const	TABLE_SUGGESTED_SOLUTIONS = 'qpl_sol_sug'

Protected Member Functions
	buildSuggestedSolution (int $id, int $question_id, string $internal_link, string $import_id, int $subquestion_index, string $type, string $value, \DateTimeImmutable $last_update)

	getNow ()

	additionalOnDelete (int $question_id)

	additionalOnStore (assQuestionSuggestedSolution $solution)

Protected Attributes
ilDBInterface	$db

Detailed Description

Repository for suggested solutions.

Author: Nils Haagen nils..nosp@m.haag.nosp@m.en@co.nosp@m.ncep.nosp@m.ts-an.nosp@m.d-tr.nosp@m.ainin.nosp@m.g.de

Definition at line 28 of file assQuestionSuggestedSolutionsDatabaseRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository::__construct ( \ilDBInterface $db )

Definition at line 34 of file assQuestionSuggestedSolutionsDatabaseRepository.php.

References ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\$db.

     {
         $this->db = $db;
     }

Member Function Documentation

◆ additionalOnDelete()

ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository::additionalOnDelete ( int $question_id )

protected

Definition at line 197 of file assQuestionSuggestedSolutionsDatabaseRepository.php.

References ilInternalLink\_deleteAllLinksOfSource().

Referenced by ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\deleteForQuestion().

                                                            : void
     {
         \ilInternalLink::_deleteAllLinksOfSource("qst", $question_id);
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ additionalOnStore()

ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository::additionalOnStore ( assQuestionSuggestedSolution $solution )

protected

Definition at line 202 of file assQuestionSuggestedSolutionsDatabaseRepository.php.

References ilInternalLink\_saveLink(), ILIAS\TA\Questions\assQuestionSuggestedSolution\getQuestionId(), ILIAS\Repository\int(), and ILIAS\TA\Questions\assQuestionSuggestedSolution\isOfTypeLink().

Referenced by ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\update().

                                                                                 : void
     {
         if ($solution->isOfTypeLink()) {
             if (preg_match("/il_(\d*?)_(\w+)_(\d+)/", $solution->getInternalLink(), $matches)) {
                 \ilInternalLink::_saveLink("qst", $solution->getQuestionId(), $matches[2], (int) $matches[3], (int) $matches[1]);
             }
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ buildSuggestedSolution()

ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository::buildSuggestedSolution	(	int	$id,
		int	$question_id,
		string	$internal_link,
		string	$import_id,
		int	$subquestion_index,
		string	$type,
		string	$value,
		\DateTimeImmutable	$last_update
	)

protected

Definition at line 155 of file assQuestionSuggestedSolutionsDatabaseRepository.php.

References ILIAS\TA\Questions\assQuestionSuggestedSolution\TYPE_FILE, ILIAS\TA\Questions\assQuestionSuggestedSolution\TYPE_GLOSARY_TERM, ILIAS\TA\Questions\assQuestionSuggestedSolution\TYPE_LM, ILIAS\TA\Questions\assQuestionSuggestedSolution\TYPE_LM_CHAPTER, and ILIAS\TA\Questions\assQuestionSuggestedSolution\TYPE_LM_PAGE.

Referenced by ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\create(), assQuestionSuggestedSolutionRepoMock\getSolution(), and ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\selectFor().

      : assQuestionSuggestedSolution {
         switch ($type) {
             case assQuestionSuggestedSolution::TYPE_FILE:
                 $suggestion_class = assSuggestedSolutionFile::class;
                 break;
             case assQuestionSuggestedSolution::TYPE_LM:
             case assQuestionSuggestedSolution::TYPE_LM_CHAPTER:
             case assQuestionSuggestedSolution::TYPE_LM_PAGE:
             case assQuestionSuggestedSolution::TYPE_GLOSARY_TERM:
                 $suggestion_class = assSuggestedSolutionLink::class;
                 $value = $internal_link;
                 break;
             default:
                 throw new \LogicException('invalid suggestion-type in repo.');
         }
 
         return new $suggestion_class(
             $id,
             $question_id,
             $subquestion_index,
             $import_id,
             $last_update,
             $type,
             $value
         );
     }

Here is the caller graph for this function:

◆ create()

ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository::create	(	int	$question_id,
		string	$type
	)

Definition at line 39 of file assQuestionSuggestedSolutionsDatabaseRepository.php.

References ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\buildSuggestedSolution(), and ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\getNow().

                                                           : assQuestionSuggestedSolution
     {
         $solution = $this->buildSuggestedSolution(
             -1,
             $question_id,
             '',
             '',
             0,
             $type,
             '',
             $this->getNow()
         );
         return $solution;
     }

Here is the call graph for this function:

◆ delete()

ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository::delete ( int $suggested_solution_id )

Definition at line 127 of file assQuestionSuggestedSolutionsDatabaseRepository.php.

                                                       : void
     {
         $query = 'DELETE FROM ' . self::TABLE_SUGGESTED_SOLUTIONS . PHP_EOL
             . 'WHERE suggested_solution_id = ' . $this->db->quote($suggested_solution_id, 'integer');
         $this->db->manipulate($query);
     }

◆ deleteForQuestion()

ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository::deleteForQuestion ( int $question_id )

Definition at line 134 of file assQuestionSuggestedSolutionsDatabaseRepository.php.

References ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\additionalOnDelete().

Referenced by ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\syncForQuestion().

                                                        : void
     {
         $query = 'DELETE FROM ' . self::TABLE_SUGGESTED_SOLUTIONS . PHP_EOL
             . 'WHERE question_fi = ' . $this->db->quote($question_id, 'integer');
         $this->db->manipulate($query);
         $this->additionalOnDelete($question_id);
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ getNow()

ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository::getNow ( )

protected

Definition at line 191 of file assQuestionSuggestedSolutionsDatabaseRepository.php.

Referenced by ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\create(), and ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\update().

                                : \DateTimeImmutable
     {
         return new \DateTimeImmutable();
     }

Here is the caller graph for this function:

◆ selectFor()

ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository::selectFor ( int $question_id )

return assQuestionSuggestedSolution[]

Definition at line 57 of file assQuestionSuggestedSolutionsDatabaseRepository.php.

References ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\buildSuggestedSolution().

Referenced by ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\syncForQuestion().

                                                : array
     {
         $ret = [];
         $query = 'SELECT' . PHP_EOL
             . 'suggested_solution_id, question_fi, internal_link, import_id, '
             . 'subquestion_index, type, tstamp, value' . PHP_EOL
             . 'FROM ' . self::TABLE_SUGGESTED_SOLUTIONS . PHP_EOL
             . 'WHERE question_fi = ' . $this->db->quote($question_id, 'integer');
 
         $result = $this->db->query($query);
 
         while ($row = $this->db->fetchAssoc($result)) {
             $last_update = \DateTimeImmutable::createFromFormat('U', (string) $row['tstamp']);
 
             if ($row['type'] === null || $row['type'] === '' || $row['type'] === 'text') {
                 continue;
             }
 
             $ret[] = $this->buildSuggestedSolution(
                 (int) $row['suggested_solution_id'],
                 (int) $row['question_fi'],
                 (string) $row['internal_link'],
                 (string) $row['import_id'],
                 (int) $row['subquestion_index'],
                 (string) $row['type'],
                 (string) $row['value'],
                 $last_update
             );
         }
 
         return $ret;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ syncForQuestion()

ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository::syncForQuestion	(	int	$source_question_id,
		int	$target_question_id
	)

Definition at line 142 of file assQuestionSuggestedSolutionsDatabaseRepository.php.

References ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\deleteForQuestion(), ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\selectFor(), and ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\update().

                                                                                      : void
     {
         if ($source_question_id === $target_question_id) {
             throw new \LogicException('do not sync with same question');
         }
         $this->deleteForQuestion($target_question_id);
         $suggested_solutions = [];
         foreach ($this->selectFor($source_question_id) as $solution) {
             $suggested_solutions[] = $solution->withQuestionId($target_question_id);
         }
         $this->update($suggested_solutions);
     }

Here is the call graph for this function:

◆ update()

ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository::update ( array $suggested_solutions )

Definition at line 90 of file assQuestionSuggestedSolutionsDatabaseRepository.php.

References ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\additionalOnStore(), and ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\getNow().

Referenced by ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\syncForQuestion().

                                                       : void
     {
         foreach ($suggested_solutions as $solution) {
             if (!is_a($solution, assQuestionSuggestedSolution::class)) {
                 throw new \Exception('cannot update other than assQuestionSuggestedSolution');
             }
         };
 
         foreach ($suggested_solutions as $solution) {
             $query = 'DELETE FROM ' . self::TABLE_SUGGESTED_SOLUTIONS . PHP_EOL
                 . 'WHERE question_fi = ' . $this->db->quote($solution->getQuestionId(), 'integer') . PHP_EOL
                 . 'AND subquestion_index = ' . $this->db->quote($solution->getSubQuestionIndex(), 'integer');
             $this->db->manipulate($query);
 
             $next_id = $this->db->nextId(self::TABLE_SUGGESTED_SOLUTIONS);
             $internal_link = '';
             if ($solution->isOfTypeLink()) {
                 $internal_link = $solution->getInternalLink();
             }
             $this->db->insert(
                 self::TABLE_SUGGESTED_SOLUTIONS,
                 [
                    'suggested_solution_id' => ['integer', $next_id],
                    'question_fi' => ['integer', $solution->getQuestionId()],
                    'type' => ['text',$solution->getType()],
                    'value' => ['clob', $solution->getStorableValue()],
                    'internal_link' => ['text', $internal_link],
                    'import_id' => ['text', $solution->getImportId()],
                    'subquestion_index' => ['integer', $solution->getSubquestionIndex() ],
                    'tstamp' => ['integer', $this->getNow()->format('U')]
                 ]
             );
 
             $this->additionalOnStore($solution);
         }
     }

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

◆ $db

ilDBInterface ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository::$db

protected

Definition at line 32 of file assQuestionSuggestedSolutionsDatabaseRepository.php.

Referenced by ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository\__construct().

◆ TABLE_SUGGESTED_SOLUTIONS

const ILIAS\TA\Questions\assQuestionSuggestedSolutionsDatabaseRepository::TABLE_SUGGESTED_SOLUTIONS = 'qpl_sol_sug'

Definition at line 30 of file assQuestionSuggestedSolutionsDatabaseRepository.php.

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

Modules/TestQuestionPool/classes/questions/SuggestedSolutions/assQuestionSuggestedSolutionsDatabaseRepository.php

Public Member Functions

Data Fields

Protected Member Functions

Protected Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ additionalOnDelete()

◆ additionalOnStore()

◆ buildSuggestedSolution()

◆ create()

◆ delete()

◆ deleteForQuestion()

◆ getNow()

◆ selectFor()

◆ syncForQuestion()

◆ update()

Field Documentation

◆ $db

◆ TABLE_SUGGESTED_SOLUTIONS