ILIAS\components\Database\Integrity\Integrity Class Reference

Collaboration diagram for ILIAS\components\Database\Integrity\Integrity:

Public Member Functions
	__construct (private ilDBInterface $database)
	check (Definition $definition)
	Example: $violations = $this->check(new Definition([ new Association(new Field('mail', 'folder_id'), new Field('mail', 'folder_id') ])))->violations(); Mail example: $mailId = new Field('mail', 'mail_id'); $mailObjDataId = new Field('mail_obj_data', 'obj_id'); $defintions = [ new Definition([new Association(new Field('mail', 'folder_id'), $mailObjDataId)]), new Definition([new Association(new Field('mail_attachment', 'mail_id'), $mailId)]), new Definition([new Association(new Field('mail_cron_orphaned', 'mail_id'), $mailId)]), new Definition([new Association(new Field('mail_cron_orphaned', 'folder_id'), $mailObjDataId)]), new Definition([new Association(new Field('mail_tree', 'child'), $mailObjDataId)]), new Definition([new Association(new Field('mail_tree', 'parent'), new Field('mail_tree', 'child', 'parent'))], new Ignore(null, '0')), ]; $results = array_map([$this, 'check'], $defintions);. More...

Detailed Description

Definition at line 25 of file Integrity.php.

Constructor & Destructor Documentation

__construct()

ILIAS\components\Database\Integrity\Integrity::__construct

(

private ilDBInterface

$database

)

Definition at line 27 of file Integrity.php.

      {
    }

Member Function Documentation

check()

ILIAS\components\Database\Integrity\Integrity::check

(

Definition

$definition

)

Example: $violations = $this->check(new Definition([ new Association(new Field('mail', 'folder_id'), new Field('mail', 'folder_id') ])))->violations(); Mail example: $mailId = new Field('mail', 'mail_id'); $mailObjDataId = new Field('mail_obj_data', 'obj_id'); $defintions = [ new Definition([new Association(new Field('mail', 'folder_id'), $mailObjDataId)]), new Definition([new Association(new Field('mail_attachment', 'mail_id'), $mailId)]), new Definition([new Association(new Field('mail_cron_orphaned', 'mail_id'), $mailId)]), new Definition([new Association(new Field('mail_cron_orphaned', 'folder_id'), $mailObjDataId)]), new Definition([new Association(new Field('mail_tree', 'child'), $mailObjDataId)]), new Definition([new Association(new Field('mail_tree', 'parent'), new Field('mail_tree', 'child', 'parent'))], new Ignore(null, '0')), ]; $results = array_map([$this, 'check'], $defintions);.

Definition at line 50 of file Integrity.php.

References ILIAS\components\Database\Integrity\Definition\associations(), ILIAS\components\Database\Integrity\Definition\ignoreValues(), ILIAS\components\Database\Integrity\Definition\referenceTableName(), and ILIAS\components\Database\Integrity\Definition\tableName().

                                                 : Result
    {
        $on = [];
        $where = [];
        // $definition->associations() always returns a non empty array
        foreach ($definition->associations() as $association) {
            $on[] = sprintf('%s = %s', $association->field()->fieldName(), $association->referenceField()->fieldName());
            $where[] = sprintf('%s IS NULL', $association->referenceField()->fieldName());
            foreach ($definition->ignoreValues() as $value_to_ignore) {
                $where[] = sprintf('%s %s', $association->field()->fieldName(), $value_to_ignore);
            }
        }

        $result = $this->database->query(sprintf(
            'SELECT COUNT(1) as violations FROM %s LEFT JOIN %s ON %s WHERE %s',
            $definition->tableName(),
            $definition->referenceTableName(),
            implode(' AND ', $on),
            implode(' AND ', $where),
        ));

        $result = $this->database->fetchAssoc($result);

        return new Result((int) $result['violations']);
    }

Here is the call graph for this function:

---

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

• components/ILIAS/Database/classes/Integrity/Integrity.php