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
	storeTestAdministrationInteraction (TestAdministrationInteraction $interaction)

	storeQuestionAdministrationInteraction (TestQuestionAdministrationInteraction $interaction)

	storeParticipantInteraction (TestParticipantInteraction $interaction)

	storeScoringInteraction (TestScoringInteraction $interaction)

	storeError (TestError $interaction)

	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)

	getLogsCount (array $valid_types, ?array $test_filter, ?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_identifiers)

	getLog (string $unique_identifier)

	deleteLogs (array $unique_identifiers)

	testHasParticipantInteractions (int $ref_id)

	deleteParticipantInteractionsForTest (int $ref_id)

	getLegacyLogsForObjId (?int $obj_id)

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.

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

◆ areLogEntryTypesValid()

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

private

Definition at line 650 of file TestLoggingDatabaseRepository.php.

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

◆ 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.

     : ?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';
    }

◆ buildDeleteQueryForUniqueIds()

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

private

Definition at line 376 of file TestLoggingDatabaseRepository.php.

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

References ilDBConstants\T_INTEGER.

◆ buildErrorFromId()

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

private

Definition at line 303 of file TestLoggingDatabaseRepository.php.

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

References $id, and factory().

Here is the call 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.

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

◆ 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.

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

◆ buildParticipantInteractionFromId()

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

private

Definition at line 283 of file TestLoggingDatabaseRepository.php.

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

References $id, and factory().

Here is the call graph for this function:

◆ buildQuestionAdministrationInteractionFromId()

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

private

Definition at line 273 of file TestLoggingDatabaseRepository.php.

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

References $id, and factory().

Here is the call graph for this function:

◆ buildScoringInteractionFromId()

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

private

Definition at line 293 of file TestLoggingDatabaseRepository.php.

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

References $id, and factory().

Here is the call graph for this function:

◆ buildSelectForTable()

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

private

Definition at line 557 of file TestLoggingDatabaseRepository.php.

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

◆ buildSelectStatementForId()

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

private

Definition at line 367 of file TestLoggingDatabaseRepository.php.

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

References $id, and ilDBConstants\T_INTEGER.

◆ 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.

     : ?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;
    }

◆ buildTestAdministrationInteractionFromId()

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

private

Definition at line 263 of file TestLoggingDatabaseRepository.php.

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

References $id, and factory().

Here is the call graph for this function:

◆ buildUserInteractionForUniqueIdentifier()

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

private

Definition at line 235 of file TestLoggingDatabaseRepository.php.

                                                                               : ?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;
    }

◆ 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.

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

◆ 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.

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

◆ deleteParticipantInteractionsForTest()

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

Implements ILIAS\Test\Logging\TestLoggingRepository.

Definition at line 196 of file TestLoggingDatabaseRepository.php.

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

References $ref_id, and ilDBConstants\T_INTEGER.

◆ fetchInteractionForResult()

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

private

Definition at line 344 of file TestLoggingDatabaseRepository.php.

                                                                      : \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;
            }
        }
    }

References factory().

Here is the call 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.

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

References $log.

◆ getLog()

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

Implements ILIAS\Test\Logging\TestLoggingRepository.

Definition at line 169 of file TestLoggingDatabaseRepository.php.

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

◆ 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.

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

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

Here is the call graph for this function:

◆ getLogsByUniqueIdentifiers()

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

Parameters

array<string> $unique_identifiers

Returns: array<\ILIAS\Test\Logging\TestUserInteraction>

Implements ILIAS\Test\Logging\TestLoggingRepository.

Definition at line 158 of file TestLoggingDatabaseRepository.php.

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

References ILIAS\ResourceStorage\Flavour\Machine\DefaultMachines\from(), and ilDBConstants\T_INTEGER.

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.

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

◆ getTableNameForTypeIdentifier()

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

private

Definition at line 715 of file TestLoggingDatabaseRepository.php.

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

◆ 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.

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

◆ 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.

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

◆ 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.

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

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

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.

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

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

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.

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

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

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.

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

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

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.

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

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

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.

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

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

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.

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

References $ref_id, and ilDBConstants\T_INTEGER.

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',
        LogTable::COLUMN_CORRESPONDING_TEST => 'ref_id',
        LogTable::COLUMN_ADMIN => 'admin_id',
        LogTable::COLUMN_PARTICIPANT => 'pax_id',
        LogTable::COLUMN_SOURCE_IP => 'source_ip',
        LogTable::COLUMN_QUESTION => 'qst_id',
        LogTable::COLUMN_LOG_ENTRY_TYPE => 'type',
        LogTable::COLUMN_INTERACTION_TYPE => 'interaction_type'
    ]

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