Inheritance diagram for ILIAS\Test\Logging\TestLoggingDatabaseRepository:

Collaboration diagram for ILIAS\Test\Logging\TestLoggingDatabaseRepository:

Public Member Functions
	__construct (private readonly Factory $factory, private readonly \ilDBInterface $db)

	storeTestAdministrationInteraction (TestAdministrationInteraction $interaction)

	storeQuestionAdministrationInteraction (TestQuestionAdministrationInteraction $interaction)

	storeParticipantInteraction (TestParticipantInteraction $interaction)

	storeScoringInteraction (TestScoringInteraction $interaction)

	storeError (TestError $interaction)

	getLogs (array $valid_types, ?array $test_filter, ?\ILIAS\Data\Range $range=null, ?\ILIAS\Data\Order $order=null, ?int $from_filter=null, ?int $to_filter=null, ?array $admin_filter=null, ?array $pax_filter=null, ?array $question_filter=null, ?string $ip_filter=null, ?array $log_entry_type_filter=null, ?array $interaction_type_filter=null)

	getLogsCount (array $valid_types, ?array $test_filter=null, ?int $from_filter=null, ?int $to_filter=null, ?array $admin_filter=null, ?array $pax_filter=null, ?array $question_filter=null, ?string $ip_filter=null, ?array $log_entry_type_filter=null, ?array $interaction_type_filter=null)

	getLogsByUniqueIdentifiers (array $unique_ids)

	getLog (string $unique_id)

	deleteLogs (array $unique_ids)

	testHasParticipantInteractions (int $ref_id)

	deleteParticipantInteractionsForTest (int $ref_id)

	getLegacyLogsForObjId (?int $obj_id)

Public Member Functions inherited from ILIAS\Test\Logging\TestLoggingRepository
	getLogs (array $valid_types, ?array $test_filter, ?Range $range=null, ?Order $order=null, ?int $from_filter=null, ?int $to_filter=null, ?array $admin_filter=null, ?array $pax_filter=null, ?array $question_filter=null, ?string $ip_filter=null, ?array $log_entry_type_filter=null, ?array $interaction_type_filter=null)

Data Fields
const	TEST_ADMINISTRATION_LOG_TABLE = 'tst_tst_admin_log'

const	QUESTION_ADMINISTRATION_LOG_TABLE = 'tst_qst_admin_log'

const	PARTICIPANT_LOG_TABLE = 'tst_pax_log'

const	SCORING_LOG_TABLE = 'tst_mark_log'

const	ERROR_LOG_TABLE = 'tst_error_log'

Private Member Functions
	buildUserInteractionForUniqueIdentifier (string $unique_id)

	buildTestAdministrationInteractionFromId (int $id)

	buildQuestionAdministrationInteractionFromId (int $id)

	buildParticipantInteractionFromId (int $id)

	buildScoringInteractionFromId (int $id)

	buildErrorFromId (int $id)

	retrieveInteractions (array $valid_types, ?Range $range, ?Order $order, ?int $from_filter, ?int $to_filter, ?array $test_filter, ?array $admin_filter, ?array $pax_filter, ?array $question_filter, ?string $ip_filter, ?array $log_entry_type_filter, ?array $interaction_type_filter)

	fetchInteractionForResult (\ilDBStatement $result)

	buildSelectStatementForId (int $id, string $table_name)

	buildDeleteQueryForUniqueIds (array $unique_ids)

	buildInteractionsStatementWithLimitAndOrder (array $valid_types, ?Range $range, ?Order $order, ?int $from_filter, ?int $to_filter, ?array $test_filter, ?array $admin_filter, ?array $pax_filter, ?array $question_filter, ?string $ip_filter, ?array $log_entry_type_filter, ?array $interaction_type_filter)

	buildCountQuery (array $valid_types, ?int $from_filter, ?int $to_filter, ?array $test_filter, ?array $admin_filter, ?array $pax_filter, ?array $question_filter, ?string $ip_filter, ?array $log_entry_type_filter, ?array $interaction_type_filter)

	buildInteractionsQuery (array $valid_types, ?int $from_filter, ?int $to_filter, ?array $test_filter, ?array $admin_filter, ?array $pax_filter, ?array $question_filter, ?string $ip_filter, ?array $log_entry_type_filter, ?array $interaction_type_filter)

	buildTableQueryFromFilterValues (string $type, ?int $from_filter, ?int $to_filter, ?array $test_filter, ?array $admin_filter, ?array $pax_filter, ?array $question_filter, ?string $ip_filter, ?array $interaction_type_filter)

	buildSelectForTable (string $table_name, string $type)

	buildWhereFromFilterValues (?int $from_filter, ?int $to_filter, ?array $test_filter, ?array $admin_filter, ?array $pax_filter, ?array $question_filter, ?string $ip_filter, ?array $interaction_type_filter)

	isFilterValid (array $valid_types, ?array $log_entry_types, ?array $interaction_types)

	areLogEntryTypesValid (array $valid_types, array $filter_log_types)

	areInteractionTypesValid (array $valid_types, ?array $filter_log_types, array $filter_interaction_types)

	parseUniqueIdsToTypeArray (array $unique_ids)

	getTableNameForTypeIdentifier (string $identifier)

Private Attributes
const	LEGACY_LOG_TABLE = 'ass_log'

const	VIEW_TABLE_TO_DB_TABLES

Detailed Description

Definition at line 27 of file TestLoggingDatabaseRepository.php.

Constructor & Destructor Documentation

◆ __construct()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::__construct	(	private readonly Factory	$factory,
		private readonly \ilDBInterface	$db
	)

Definition at line 47 of file TestLoggingDatabaseRepository.php.

50 {

51 }

Member Function Documentation

◆ areInteractionTypesValid()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::areInteractionTypesValid	(	array	$valid_types,
		?array	$filter_log_types,
		array	$filter_interaction_types
	)

private

Definition at line 660 of file TestLoggingDatabaseRepository.php.

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\isFilterValid().

      : bool {
         if ($filter_log_types !== null
             && $filter_log_types !== []) {
             $valid_types = array_filter(
                 $valid_types,
                 fn(string $key): bool => in_array($key, $filter_log_types),
                 ARRAY_FILTER_USE_KEY
             );
         }
         $valid_interaction_types = array_reduce(
             $valid_types,
             fn(array $et, array $it): array => [...$et, ...$it],
             []
         );
 
         if (
             array_intersect($filter_interaction_types, $valid_interaction_types)
                 === $filter_interaction_types
         ) {
             return true;
         }
 
         return false;
     }

Here is the caller graph for this function:

◆ areLogEntryTypesValid()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::areLogEntryTypesValid	(	array	$valid_types,
		array	$filter_log_types
	)

private

Definition at line 650 of file TestLoggingDatabaseRepository.php.

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\isFilterValid().

      : bool {
         return array_intersect(
             $filter_log_types,
             array_keys($valid_types)
         ) === $filter_log_types;
     }

Here is the caller graph for this function:

◆ buildCountQuery()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::buildCountQuery	(	array	$valid_types,
		?int	$from_filter,
		?int	$to_filter,
		?array	$test_filter,
		?array	$admin_filter,
		?array	$pax_filter,
		?array	$question_filter,
		?string	$ip_filter,
		?array	$log_entry_type_filter,
		?array	$interaction_type_filter
	)

private

Definition at line 438 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildInteractionsQuery().

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\getLogsCount().

      : ?string {
         $tables_query = $this->buildInteractionsQuery(
             $valid_types,
             $from_filter,
             $to_filter,
             $test_filter,
             $admin_filter,
             $pax_filter,
             $question_filter,
             $ip_filter,
             $log_entry_type_filter,
             $interaction_type_filter
         );
         if ($tables_query === '') {
             return '';
         }
         return 'SELECT COUNT(*) AS cnt FROM (' . PHP_EOL . $tables_query . PHP_EOL . ') x';
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ buildDeleteQueryForUniqueIds()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::buildDeleteQueryForUniqueIds ( array $unique_ids )

private

Definition at line 376 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestLoggingDatabaseRepository\parseUniqueIdsToTypeArray(), and ilDBConstants\T_INTEGER.

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\deleteLogs().

                                                                     : string
     {
         if ($unique_ids[0] === 'ALL_OBJECTS') {
             return 'TUNCATE TABLE ' . self::TEST_ADMINISTRATION_LOG_TABLE . ';'
                 . 'TUNCATE TABLE ' . self::QUESTION_ADMINISTRATION_LOG_TABLE . ';'
                 . 'TUNCATE TABLE ' . self::PARTICIPANT_LOG_TABLE . ';'
                 . 'TUNCATE TABLE ' . self::SCORING_LOG_TABLE . ';'
                 . 'TUNCATE TABLE ' . self::ERROR_LOG_TABLE . ';';
         }
         $query = '';
         foreach ($this->parseUniqueIdsToTypeArray($unique_ids) as $type => $values) {
             $query .= "DELETE FROM {$this->getTableNameForTypeIdentifier($type)} WHERE "
                 . $this->db->in('id', $values, false, \ilDBConstants::T_INTEGER) . ';' . PHP_EOL;
         }
         return $query;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ buildErrorFromId()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::buildErrorFromId ( int $id )

private

Definition at line 303 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildSelectStatementForId().

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildUserInteractionForUniqueIdentifier().

                                               : ?TestError
     {
         $query = $this->buildSelectStatementForId($id, self::ERROR_LOG_TABLE);
         if ($this->db->numRows($query) === 0) {
             return null;
         }
 
         return $this->factory->buildErrorFromDBValues($this->db->fetchObject($query));
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ buildInteractionsQuery()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::buildInteractionsQuery	(	array	$valid_types,
		?int	$from_filter,
		?int	$to_filter,
		?array	$test_filter,
		?array	$admin_filter,
		?array	$pax_filter,
		?array	$question_filter,
		?string	$ip_filter,
		?array	$log_entry_type_filter,
		?array	$interaction_type_filter
	)

private

Definition at line 468 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildTableQueryFromFilterValues().

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildCountQuery(), and ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildInteractionsStatementWithLimitAndOrder().

      : string {
         $log_entry_types_to_fetch = array_keys($valid_types);
 
         $query = [];
         foreach ($log_entry_types_to_fetch as $type) {
             if ($log_entry_type_filter !== null
                     && !in_array($type, $log_entry_type_filter)
                 || $interaction_type_filter !== null
                     && array_intersect(
                         $valid_types[$type],
                         $interaction_type_filter
                     ) === []
             ) {
                 continue;
             }
             $query[] = $this->buildTableQueryFromFilterValues(
                 $type,
                 $from_filter,
                 $to_filter,
                 $test_filter,
                 $admin_filter,
                 $pax_filter,
                 $question_filter,
                 $ip_filter,
                 $interaction_type_filter
             );
         }
 
         return implode(
             PHP_EOL . 'UNION' . PHP_EOL,
             array_filter(
                 $query,
                 static fn(?string $select): bool => $select !== null
             )
         );
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ buildInteractionsStatementWithLimitAndOrder()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::buildInteractionsStatementWithLimitAndOrder	(	array	$valid_types,
		?Range	$range,
		?Order	$order,
		?int	$from_filter,
		?int	$to_filter,
		?array	$test_filter,
		?array	$admin_filter,
		?array	$pax_filter,
		?array	$question_filter,
		?string	$ip_filter,
		?array	$log_entry_type_filter,
		?array	$interaction_type_filter
	)

private

Definition at line 393 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildInteractionsQuery(), ILIAS\Data\Range\getLength(), ILIAS\Data\Range\getStart(), and ILIAS\Data\Order\join().

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\retrieveInteractions().

      : \ilDBStatement {
         $query = $this->buildInteractionsQuery(
             $valid_types,
             $from_filter,
             $to_filter,
             $test_filter,
             $admin_filter,
             $pax_filter,
             $question_filter,
             $ip_filter,
             $log_entry_type_filter,
             $interaction_type_filter
         );
 
         $init = PHP_EOL . 'ORDER BY ';
         $order_by_string = $order?->join(
             $init,
             static fn(string $ret, string $key, string $value): string => "{$ret} "
                 . self::VIEW_TABLE_TO_DB_TABLES[$key] . " {$value}, ",
         );
         if ($order_by_string !== null
             && $order_by_string !== $init) {
             $query .= mb_substr($order_by_string, 0, -2);
         }
 
         if ($range !== null) {
             $query .= PHP_EOL . 'LIMIT ' . $range->getStart() . ', ' . $range->getLength();
         }
 
         return $this->db->query($query);
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ buildParticipantInteractionFromId()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::buildParticipantInteractionFromId ( int $id )

private

Definition at line 283 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildSelectStatementForId().

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildUserInteractionForUniqueIdentifier().

                                                                : ?TestParticipantInteraction
     {
         $query = $this->buildSelectStatementForId($id, self::PARTICIPANT_LOG_TABLE);
         if ($this->db->numRows($query) === 0) {
             return null;
         }
 
         return $this->factory->buildParticipantInteractionFromDBValues($this->db->fetchObject($query));
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ buildQuestionAdministrationInteractionFromId()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::buildQuestionAdministrationInteractionFromId ( int $id )

private

Definition at line 273 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildSelectStatementForId().

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildUserInteractionForUniqueIdentifier().

                                                                           : ?TestQuestionAdministrationInteraction
     {
         $query = $this->buildSelectStatementForId($id, self::QUESTION_ADMINISTRATION_LOG_TABLE);
         if ($this->db->numRows($query) === 0) {
             return null;
         }
 
         return $this->factory->buildQuestionAdministrationInteractionFromDBValues($this->db->fetchObject($query));
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ buildScoringInteractionFromId()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::buildScoringInteractionFromId ( int $id )

private

Definition at line 293 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildSelectStatementForId().

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildUserInteractionForUniqueIdentifier().

                                                            : ?TestScoringInteraction
     {
         $query = $this->buildSelectStatementForId($id, self::SCORING_LOG_TABLE);
         if ($this->db->numRows($query) === 0) {
             return null;
         }
 
         return $this->factory->buildScoringInteractionFromDBValues($this->db->fetchObject($query));
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ buildSelectForTable()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::buildSelectForTable	(	string	$table_name,
		string	$type
	)

private

Definition at line 557 of file TestLoggingDatabaseRepository.php.

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildTableQueryFromFilterValues().

                                                                           : string
     {
         switch ($table_name) {
             case self::TEST_ADMINISTRATION_LOG_TABLE:
                 return "SELECT '{$type}' AS type, id, ref_id, NULL AS qst_id, admin_id, "
                     . 'NULL AS pax_id, NULL AS source_ip, interaction_type, modification_ts, '
                     . "additional_data FROM {$table_name}";
             case self::QUESTION_ADMINISTRATION_LOG_TABLE:
                 return "SELECT '{$type}' AS type, id, ref_id, qst_id, admin_id, "
                     . 'NULL AS pax_id, NULL AS source_ip, interaction_type, modification_ts, '
                     . "additional_data FROM {$table_name}";
             case self::PARTICIPANT_LOG_TABLE:
                 return "SELECT '{$type}' AS type, id, ref_id, qst_id, NULL AS admin_id, "
                     . 'pax_id, source_ip, interaction_type, modification_ts, '
                     . "additional_data FROM {$table_name}";
             case self::SCORING_LOG_TABLE:
                 return "SELECT '{$type}' AS type, id, ref_id, qst_id, admin_id, "
                     . 'pax_id, NULL AS source_ip, interaction_type, modification_ts, '
                     . "additional_data FROM {$table_name}";
             case self::ERROR_LOG_TABLE:
                 return "SELECT '{$type}' AS type, id, ref_id, qst_id, admin_id, "
                     . 'pax_id, NULL AS source_ip, interaction_type, modification_ts, '
                     . "error_message AS additional_data FROM {$table_name}";
             default:
                 throw new \ErrorException('Unknown Database Table');
         }
     }

Here is the caller graph for this function:

◆ buildSelectStatementForId()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::buildSelectStatementForId	(	int	$id,
		string	$table_name
	)

private

Definition at line 367 of file TestLoggingDatabaseRepository.php.

References ilDBConstants\T_INTEGER.

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildErrorFromId(), ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildParticipantInteractionFromId(), ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildQuestionAdministrationInteractionFromId(), ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildScoringInteractionFromId(), and ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildTestAdministrationInteractionFromId().

                                                                            : \ilDBStatement
     {
         return $this->db->queryF(
             "SELECT * FROM {$table_name} WHERE id=%s",
             [\ilDBConstants::T_INTEGER],
             [$id]
         );
     }

Here is the caller graph for this function:

◆ buildTableQueryFromFilterValues()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::buildTableQueryFromFilterValues	(	string	$type,
		?int	$from_filter,
		?int	$to_filter,
		?array	$test_filter,
		?array	$admin_filter,
		?array	$pax_filter,
		?array	$question_filter,
		?string	$ip_filter,
		?array	$interaction_type_filter
	)

private

Definition at line 516 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildSelectForTable(), ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildWhereFromFilterValues(), and ILIAS\Test\Logging\TestLoggingDatabaseRepository\getTableNameForTypeIdentifier().

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildInteractionsQuery().

      : ?string {
         $table_name = $this->getTableNameForTypeIdentifier($type);
         if ($pax_filter !== null
                 && ($table_name === self::TEST_ADMINISTRATION_LOG_TABLE
                     || $table_name === self::QUESTION_ADMINISTRATION_LOG_TABLE)
             || $admin_filter !== null
                 && $table_name === self::PARTICIPANT_LOG_TABLE
             || $ip_filter !== null
                 && $table_name !== self::PARTICIPANT_LOG_TABLE
             || $question_filter !== null
                 && $table_name === self::TEST_ADMINISTRATION_LOG_TABLE
         ) {
             return null;
         }
 
         $query = $this->buildSelectForTable($table_name, $type);
 
         $where = $this->buildWhereFromFilterValues(
             $from_filter,
             $to_filter,
             $test_filter,
             $admin_filter,
             $pax_filter,
             $question_filter,
             $ip_filter,
             $interaction_type_filter
         );
 
         return $query . $where;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ buildTestAdministrationInteractionFromId()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::buildTestAdministrationInteractionFromId ( int $id )

private

Definition at line 263 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildSelectStatementForId().

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildUserInteractionForUniqueIdentifier().

                                                                       : ?TestAdministrationInteraction
     {
         $query = $this->buildSelectStatementForId($id, self::TEST_ADMINISTRATION_LOG_TABLE);
         if ($this->db->numRows($query) === 0) {
             return null;
         }
 
         return $this->factory->buildTestAdministrationInteractionFromDBValues($this->db->fetchObject($query));
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ buildUserInteractionForUniqueIdentifier()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::buildUserInteractionForUniqueIdentifier ( string $unique_id )

private

Definition at line 235 of file TestLoggingDatabaseRepository.php.

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\getLog().

                                                                                : ?TestUserInteraction
     {
         $unique_id_array = explode('_', $unique_id);
         if (count($unique_id_array) !== 2
             || !is_numeric($unique_id_array[1])) {
             return null;
         }
 
         switch ($unique_id_array[0]) {
             case TestAdministrationInteraction::IDENTIFIER:
                 return $this->buildTestAdministrationInteractionFromId((int) $unique_id_array[1]);
 
             case TestQuestionAdministrationInteraction::IDENTIFIER:
                 return $this->buildQuestionAdministrationInteractionFromId((int) $unique_id_array[1]);
 
             case TestParticipantInteraction::IDENTIFIER:
                 return $this->buildParticipantInteractionFromId((int) $unique_id_array[1]);
 
             case TestScoringInteraction::IDENTIFIER:
                 return $this->buildScoringInteractionFromId((int) $unique_id_array[1]);
 
             case TestError::IDENTIFIER:
                 return $this->buildErrorFromId((int) $unique_id_array[1]);
         }
 
         return null;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ buildWhereFromFilterValues()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::buildWhereFromFilterValues	(	?int	$from_filter,
		?int	$to_filter,
		?array	$test_filter,
		?array	$admin_filter,
		?array	$pax_filter,
		?array	$question_filter,
		?string	$ip_filter,
		?array	$interaction_type_filter
	)

private

Definition at line 585 of file TestLoggingDatabaseRepository.php.

References ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildTableQueryFromFilterValues().

      : string {
         $where = [];
         if ($from_filter !== null) {
             $where[] = 'modification_ts > ' . $from_filter;
         }
         if ($to_filter !== null) {
             $where[] = 'modification_ts < ' . $to_filter;
         }
         if ($test_filter !== null) {
             $where[] = $this->db->in('ref_id', $test_filter, false, \ilDBConstants::T_INTEGER);
         }
         if ($admin_filter !== null) {
             $where[] = $this->db->in('admin_id', $admin_filter, false, \ilDBConstants::T_INTEGER);
         }
         if ($pax_filter !== null) {
             $where[] = $this->db->in('pax_id', $pax_filter, false, \ilDBConstants::T_INTEGER);
         }
         if ($question_filter !== null) {
             $where[] = $this->db->in('qst_id', $question_filter, false, \ilDBConstants::T_INTEGER);
         }
         if ($ip_filter !== null) {
             $where[] = $this->db->like('source_ip', \ilDBConstants::T_TEXT, $ip_filter);
         }
         if ($interaction_type_filter !== null) {
             $where[] = $this->db->in('interaction_type', $interaction_type_filter, false, \ilDBConstants::T_TEXT);
         }
 
         if ($where === []) {
             return '';
         }
 
         return ' WHERE ' . implode(' AND ', $where);
     }

Here is the caller graph for this function:

◆ deleteLogs()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::deleteLogs ( array $unique_ids )

Parameters

array<string> $unique_ids

Implements ILIAS\Test\Logging\TestLoggingRepository.

Definition at line 178 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildDeleteQueryForUniqueIds().

      : void {
         $this->db->manipulate(
             $this->buildDeleteQueryForUniqueIds($unique_ids)
         );
     }

Here is the call graph for this function:

◆ deleteParticipantInteractionsForTest()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::deleteParticipantInteractionsForTest ( int $ref_id )

Implements ILIAS\Test\Logging\TestLoggingRepository.

Definition at line 196 of file TestLoggingDatabaseRepository.php.

References ilDBConstants\T_INTEGER.

                                                                      : void
     {
         $this->db->manipulateF(
             'DELETE FROM ' . self::PARTICIPANT_LOG_TABLE . ' WHERE ref_id=%s',
             [\ilDBConstants::T_INTEGER],
             [$ref_id]
         );
     }

◆ fetchInteractionForResult()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::fetchInteractionForResult ( \ilDBStatement $result )

private

Definition at line 344 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestParticipantInteraction\IDENTIFIER, ILIAS\Test\Logging\TestError\IDENTIFIER, ILIAS\Test\Logging\TestAdministrationInteraction\IDENTIFIER, ILIAS\Test\Logging\TestQuestionAdministrationInteraction\IDENTIFIER, and ILIAS\Test\Logging\TestScoringInteraction\IDENTIFIER.

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\getLogsByUniqueIdentifiers(), and ILIAS\Test\Logging\TestLoggingDatabaseRepository\retrieveInteractions().

                                                                       : \Generator
     {
         while ($interaction = $this->db->fetchObject($result)) {
             switch ($interaction->type) {
                 case TestAdministrationInteraction::IDENTIFIER:
                     yield $this->factory->buildTestAdministrationInteractionFromDBValues($interaction);
                     break;
                 case TestQuestionAdministrationInteraction::IDENTIFIER:
                     yield $this->factory->buildQuestionAdministrationInteractionFromDBValues($interaction);
                     break;
                 case TestParticipantInteraction::IDENTIFIER:
                     yield $this->factory->buildParticipantInteractionFromDBValues($interaction);
                     break;
                 case TestScoringInteraction::IDENTIFIER:
                     yield $this->factory->buildScoringInteractionFromDBValues($interaction);
                     break;
                 case TestError::IDENTIFIER:
                     yield $this->factory->buildErrorFromDBValues($interaction);
                     break;
             }
         }
     }

Here is the caller graph for this function:

◆ getLegacyLogsForObjId()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::getLegacyLogsForObjId ( ?int $obj_id )

Implements ILIAS\Test\Logging\TestLoggingRepository.

Definition at line 205 of file TestLoggingDatabaseRepository.php.

References $log.

                                                        : array
     {
         $log = [];
 
         $where = '';
         if ($obj_id !== null) {
             $where = ' WHERE obj_fi = ' . $obj_id;
         }
 
         $result = $this->db->query(
             'SELECT * FROM ' . self::LEGACY_LOG_TABLE . $where . ' ORDER BY tstamp'
         );
 
         while ($row = $this->db->fetchAssoc($result)) {
             if (!array_key_exists($row['tstamp'], $log)) {
                 $log[$row['tstamp']] = [];
             }
             $log[$row['tstamp']][] = $row;
         }
         krsort($log);
         // flatten array
         $log_array = [];
         foreach ($log as $value) {
             foreach ($value as $row) {
                 $log_array[] = $row;
             }
         }
         return $log_array;
     }

◆ getLog()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::getLog ( string $unique_id )

Implements ILIAS\Test\Logging\TestLoggingRepository.

Definition at line 169 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildUserInteractionForUniqueIdentifier().

      : ?TestUserInteraction {
         return $this->buildUserInteractionForUniqueIdentifier($unique_id);
     }

Here is the call graph for this function:

◆ getLogs()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::getLogs	(	array	$valid_types,
		?array	$test_filter,
		?\ILIAS\Data\Range	$range = `null`,
		?\ILIAS\Data\Order	$order = `null`,
		?int	$from_filter = `null`,
		?int	$to_filter = `null`,
		?array	$admin_filter = `null`,
		?array	$pax_filter = `null`,
		?array	$question_filter = `null`,
		?string	$ip_filter = `null`,
		?array	$log_entry_type_filter = `null`,
		?array	$interaction_type_filter = `null`
	)

Definition at line 88 of file TestLoggingDatabaseRepository.php.

References ILIAS\UI\Implementation\Component\Table\$range, ILIAS\ResourceStorage\Flavour\Machine\DefaultMachines\from(), ILIAS\Test\Logging\TestLoggingDatabaseRepository\isFilterValid(), and ILIAS\Test\Logging\TestLoggingDatabaseRepository\retrieveInteractions().

      : \Generator {
         if ($this->isFilterValid(
             $valid_types,
             $log_entry_type_filter,
             $interaction_type_filter
         )
         ) {
             yield from $this->retrieveInteractions(
                 $valid_types,
                 $range,
                 $order,
                 $from_filter,
                 $to_filter,
                 $test_filter,
                 $admin_filter,
                 $pax_filter,
                 $question_filter,
                 $ip_filter,
                 $log_entry_type_filter,
                 $interaction_type_filter
             );
         }
     }

Here is the call graph for this function:

◆ getLogsByUniqueIdentifiers()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::getLogsByUniqueIdentifiers ( array $unique_identifiers )

Parameters

array<string> $unique_identifiers

Returns: array<>

Implements ILIAS\Test\Logging\TestLoggingRepository.

Definition at line 158 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestLoggingDatabaseRepository\fetchInteractionForResult(), ILIAS\ResourceStorage\Flavour\Machine\DefaultMachines\from(), ILIAS\Test\Logging\TestLoggingDatabaseRepository\parseUniqueIdsToTypeArray(), and ilDBConstants\T_INTEGER.

      : \Generator {
         foreach ($this->parseUniqueIdsToTypeArray($unique_ids) as $type => $values) {
             $query = "SELECT *, '{$type}' AS type FROM {$this->getTableNameForTypeIdentifier($type)} WHERE "
                 . $this->db->in('id', $values, false, \ilDBConstants::T_INTEGER);
             $result = $this->db->query($query);
             yield from $this->fetchInteractionForResult($result);
         }
     }

Here is the call graph for this function:

◆ getLogsCount()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::getLogsCount	(	array	$valid_types,
		?array	$test_filter = `null`,
		?int	$from_filter = `null`,
		?int	$to_filter = `null`,
		?array	$admin_filter = `null`,
		?array	$pax_filter = `null`,
		?array	$question_filter = `null`,
		?string	$ip_filter = `null`,
		?array	$log_entry_type_filter = `null`,
		?array	$interaction_type_filter = `null`
	)

Implements ILIAS\Test\Logging\TestLoggingRepository.

Definition at line 125 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildCountQuery().

      : int {
         $query = $this->buildCountQuery(
             $valid_types,
             $from_filter,
             $to_filter,
             $test_filter,
             $admin_filter,
             $pax_filter,
             $question_filter,
             $ip_filter,
             $log_entry_type_filter,
             $interaction_type_filter
         );
         if ($query === '') {
             return 0;
         }
         $result = $this->db->query(
             $query
         );
         return $this->db->fetchObject($result)->cnt;
     }

Here is the call graph for this function:

◆ getTableNameForTypeIdentifier()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::getTableNameForTypeIdentifier ( string $identifier )

private

Definition at line 715 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestParticipantInteraction\IDENTIFIER, ILIAS\Test\Logging\TestError\IDENTIFIER, ILIAS\Test\Logging\TestAdministrationInteraction\IDENTIFIER, ILIAS\Test\Logging\TestQuestionAdministrationInteraction\IDENTIFIER, and ILIAS\Test\Logging\TestScoringInteraction\IDENTIFIER.

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildTableQueryFromFilterValues().

                                                                       : string
     {
         switch ($identifier) {
             case TestAdministrationInteraction::IDENTIFIER:
                 return self::TEST_ADMINISTRATION_LOG_TABLE;
 
             case TestQuestionAdministrationInteraction::IDENTIFIER:
                 return self::QUESTION_ADMINISTRATION_LOG_TABLE;
 
             case TestParticipantInteraction::IDENTIFIER:
                 return self::PARTICIPANT_LOG_TABLE;
 
             case TestScoringInteraction::IDENTIFIER:
                 return self::SCORING_LOG_TABLE;
 
             case TestError::IDENTIFIER:
                 return self::ERROR_LOG_TABLE;
             default:
                 throw new \ErrorException('Unknown Identifier Type');
         }
     }

Here is the caller graph for this function:

◆ isFilterValid()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::isFilterValid	(	array	$valid_types,
		?array	$log_entry_types,
		?array	$interaction_types
	)

private

Definition at line 628 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestLoggingDatabaseRepository\areInteractionTypesValid(), and ILIAS\Test\Logging\TestLoggingDatabaseRepository\areLogEntryTypesValid().

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\getLogs().

      : bool {
         if ($log_entry_types !== null
                 && !$this->areLogEntryTypesValid(
                     $valid_types,
                     $log_entry_types
                 )
             || $interaction_types !== null
                 && !$this->areInteractionTypesValid(
                     $valid_types,
                     $log_entry_types,
                     $interaction_types
                 )
         ) {
             return false;
         }
         return true;
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ parseUniqueIdsToTypeArray()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::parseUniqueIdsToTypeArray ( array $unique_ids )

private

Parameters

array<int> $unique_ids

Returns: array<string, array<int>>

Definition at line 693 of file TestLoggingDatabaseRepository.php.

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildDeleteQueryForUniqueIds(), and ILIAS\Test\Logging\TestLoggingDatabaseRepository\getLogsByUniqueIdentifiers().

                                                                  : array
     {
         return array_reduce(
             $unique_ids,
             function (array $type_array, string $unique_id): array {
                 $unique_id_array = explode('_', $unique_id);
                 if (count($unique_id_array) !== 2
                     || !is_numeric($unique_id_array[1])) {
                     return $type_array;
                 }
 
                 if (!array_key_exists($unique_id_array[0], $type_array)) {
                     $type_array[$unique_id_array[0]] = [];
                 }
 
                 $type_array[$unique_id_array[0]][] = $unique_id_array[1];
                 return $type_array;
             },
             []
         );
     }

Here is the caller graph for this function:

◆ retrieveInteractions()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::retrieveInteractions	(	array	$valid_types,
		?Range	$range,
		?Order	$order,
		?int	$from_filter,
		?int	$to_filter,
		?array	$test_filter,
		?array	$admin_filter,
		?array	$pax_filter,
		?array	$question_filter,
		?string	$ip_filter,
		?array	$log_entry_type_filter,
		?array	$interaction_type_filter
	)

private

Definition at line 313 of file TestLoggingDatabaseRepository.php.

References ILIAS\Test\Logging\TestLoggingDatabaseRepository\buildInteractionsStatementWithLimitAndOrder(), ILIAS\Test\Logging\TestLoggingDatabaseRepository\fetchInteractionForResult(), and ILIAS\ResourceStorage\Flavour\Machine\DefaultMachines\from().

Referenced by ILIAS\Test\Logging\TestLoggingDatabaseRepository\getLogs().

      : \Generator {
         $result = $this->buildInteractionsStatementWithLimitAndOrder(
             $valid_types,
             $range,
             $order,
             $from_filter,
             $to_filter,
             $test_filter,
             $admin_filter,
             $pax_filter,
             $question_filter,
             $ip_filter,
             $log_entry_type_filter,
             $interaction_type_filter
         );
         yield from $this->fetchInteractionForResult($result);
     }

Here is the call graph for this function:

Here is the caller graph for this function:

◆ storeError()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::storeError ( TestError $interaction )

Implements ILIAS\Test\Logging\TestLoggingRepository.

Definition at line 81 of file TestLoggingDatabaseRepository.php.

References ilDBConstants\T_INTEGER, and ILIAS\Test\Logging\TestError\toStorage().

                                                       : void
     {
         $storage_array = $interaction->toStorage();
         $storage_array['id'] = [\ilDBConstants::T_INTEGER, $this->db->nextId(self::ERROR_LOG_TABLE)];
         $this->db->insert(self::ERROR_LOG_TABLE, $storage_array);
     }

Here is the call graph for this function:

◆ storeParticipantInteraction()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::storeParticipantInteraction ( TestParticipantInteraction $interaction )

Implements ILIAS\Test\Logging\TestLoggingRepository.

Definition at line 67 of file TestLoggingDatabaseRepository.php.

References ilDBConstants\T_INTEGER, and ILIAS\Test\Logging\TestParticipantInteraction\toStorage().

                                                                                         : void
     {
         $storage_array = $interaction->toStorage();
         $storage_array['id'] = [\ilDBConstants::T_INTEGER, $this->db->nextId(self::PARTICIPANT_LOG_TABLE)];
         $this->db->insert(self::PARTICIPANT_LOG_TABLE, $storage_array);
     }

Here is the call graph for this function:

◆ storeQuestionAdministrationInteraction()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::storeQuestionAdministrationInteraction ( TestQuestionAdministrationInteraction $interaction )

Implements ILIAS\Test\Logging\TestLoggingRepository.

Definition at line 60 of file TestLoggingDatabaseRepository.php.

References ilDBConstants\T_INTEGER, and ILIAS\Test\Logging\TestQuestionAdministrationInteraction\toStorage().

                                                                                                               : void
     {
         $storage_array = $interaction->toStorage();
         $storage_array['id'] = [\ilDBConstants::T_INTEGER, $this->db->nextId(self::QUESTION_ADMINISTRATION_LOG_TABLE)];
         $this->db->insert(self::QUESTION_ADMINISTRATION_LOG_TABLE, $storage_array);
     }

Here is the call graph for this function:

◆ storeScoringInteraction()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::storeScoringInteraction ( TestScoringInteraction $interaction )

Implements ILIAS\Test\Logging\TestLoggingRepository.

Definition at line 74 of file TestLoggingDatabaseRepository.php.

References ilDBConstants\T_INTEGER, and ILIAS\Test\Logging\TestScoringInteraction\toStorage().

                                                                                 : void
     {
         $storage_array = $interaction->toStorage();
         $storage_array['id'] = [\ilDBConstants::T_INTEGER, $this->db->nextId(self::SCORING_LOG_TABLE)];
         $this->db->insert(self::SCORING_LOG_TABLE, $storage_array);
     }

Here is the call graph for this function:

◆ storeTestAdministrationInteraction()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::storeTestAdministrationInteraction ( TestAdministrationInteraction $interaction )

Implements ILIAS\Test\Logging\TestLoggingRepository.

Definition at line 53 of file TestLoggingDatabaseRepository.php.

References ilDBConstants\T_INTEGER, and ILIAS\Test\Logging\TestAdministrationInteraction\toStorage().

                                                                                                   : void
     {
         $storage_array = $interaction->toStorage();
         $storage_array['id'] = [\ilDBConstants::T_INTEGER, $this->db->nextId(self::TEST_ADMINISTRATION_LOG_TABLE)];
         $this->db->insert(self::TEST_ADMINISTRATION_LOG_TABLE, $storage_array);
     }

Here is the call graph for this function:

◆ testHasParticipantInteractions()

ILIAS\Test\Logging\TestLoggingDatabaseRepository::testHasParticipantInteractions ( int $ref_id )

Implements ILIAS\Test\Logging\TestLoggingRepository.

Definition at line 186 of file TestLoggingDatabaseRepository.php.

References ilDBConstants\T_INTEGER.

                                                                : bool
     {
         $query = $this->db->queryF(
             'SELECT COUNT(id) AS cnt FROM ' . self::PARTICIPANT_LOG_TABLE . ' WHERE ref_id=%s',
             [\ilDBConstants::T_INTEGER],
             [$ref_id]
         );
         return $this->db->fetchObject($query)->cnt > 0;
     }

Field Documentation

◆ ERROR_LOG_TABLE

const ILIAS\Test\Logging\TestLoggingDatabaseRepository::ERROR_LOG_TABLE = 'tst_error_log'

Definition at line 34 of file TestLoggingDatabaseRepository.php.

Referenced by ILIAS\Test\Setup\Test10DBUpdateSteps\step_3().

◆ LEGACY_LOG_TABLE

const ILIAS\Test\Logging\TestLoggingDatabaseRepository::LEGACY_LOG_TABLE = 'ass_log'

private

Definition at line 29 of file TestLoggingDatabaseRepository.php.

◆ PARTICIPANT_LOG_TABLE

const ILIAS\Test\Logging\TestLoggingDatabaseRepository::PARTICIPANT_LOG_TABLE = 'tst_pax_log'

Definition at line 32 of file TestLoggingDatabaseRepository.php.

Referenced by ILIAS\Test\Setup\Test10DBUpdateSteps\step_3().

◆ QUESTION_ADMINISTRATION_LOG_TABLE

const ILIAS\Test\Logging\TestLoggingDatabaseRepository::QUESTION_ADMINISTRATION_LOG_TABLE = 'tst_qst_admin_log'

Definition at line 31 of file TestLoggingDatabaseRepository.php.

Referenced by ILIAS\Test\Setup\Test10DBUpdateSteps\step_3().

◆ SCORING_LOG_TABLE

const ILIAS\Test\Logging\TestLoggingDatabaseRepository::SCORING_LOG_TABLE = 'tst_mark_log'

Definition at line 33 of file TestLoggingDatabaseRepository.php.

Referenced by ILIAS\Test\Setup\Test10DBUpdateSteps\step_3().

◆ TEST_ADMINISTRATION_LOG_TABLE

const ILIAS\Test\Logging\TestLoggingDatabaseRepository::TEST_ADMINISTRATION_LOG_TABLE = 'tst_tst_admin_log'

Definition at line 30 of file TestLoggingDatabaseRepository.php.

Referenced by ILIAS\Test\Setup\Test10DBUpdateSteps\step_3().

◆ VIEW_TABLE_TO_DB_TABLES

const ILIAS\Test\Logging\TestLoggingDatabaseRepository::VIEW_TABLE_TO_DB_TABLES

private

Initial value:

= [

LogTable::COLUMN_DATE_TIME => 'modification_ts'

Definition at line 36 of file TestLoggingDatabaseRepository.php.

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

components/ILIAS/Test/src/Logging/TestLoggingDatabaseRepository.php

Public Member Functions

Data Fields

Private Member Functions

Private Attributes

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ areInteractionTypesValid()

◆ areLogEntryTypesValid()

◆ buildCountQuery()

◆ buildDeleteQueryForUniqueIds()

◆ buildErrorFromId()

◆ buildInteractionsQuery()

◆ buildInteractionsStatementWithLimitAndOrder()

◆ buildParticipantInteractionFromId()

◆ buildQuestionAdministrationInteractionFromId()

◆ buildScoringInteractionFromId()

◆ buildSelectForTable()

◆ buildSelectStatementForId()

◆ buildTableQueryFromFilterValues()

◆ buildTestAdministrationInteractionFromId()

◆ buildUserInteractionForUniqueIdentifier()

◆ buildWhereFromFilterValues()

◆ deleteLogs()

◆ deleteParticipantInteractionsForTest()

◆ fetchInteractionForResult()

◆ getLegacyLogsForObjId()

◆ getLog()

◆ getLogs()

◆ getLogsByUniqueIdentifiers()

◆ getLogsCount()

◆ getTableNameForTypeIdentifier()

◆ isFilterValid()

◆ parseUniqueIdsToTypeArray()

◆ retrieveInteractions()

◆ storeError()

◆ storeParticipantInteraction()

◆ storeQuestionAdministrationInteraction()

◆ storeScoringInteraction()

◆ storeTestAdministrationInteraction()

◆ testHasParticipantInteractions()

Field Documentation

◆ ERROR_LOG_TABLE

◆ LEGACY_LOG_TABLE

◆ PARTICIPANT_LOG_TABLE

◆ QUESTION_ADMINISTRATION_LOG_TABLE

◆ SCORING_LOG_TABLE

◆ TEST_ADMINISTRATION_LOG_TABLE

◆ VIEW_TABLE_TO_DB_TABLES