class.ilADTMultiDBBridge.php

Go to the documentation of this file.

<?php

declare(strict_types=1);

abstract class ilADTMultiDBBridge extends ilADTDBBridge
{
    protected function getSubTableName(): string
    {
        // getElementId? => adv_md_values_enum_123
        return $this->getTable() . "_" . $this->getElementId();
    }

    public function readRecord(array $a_row): void
    {
        $sql = "SELECT " . $this->getElementId() .
            " FROM " . $this->getSubTableName() .
            " WHERE " . $this->buildPrimaryWhere();
        $set = $this->db->query($sql);
        $this->readMultiRecord($set);
    }

    abstract protected function readMultiRecord(ilDBStatement $a_set): void;

    public function prepareInsert(array &$a_fields): void
    {
        // see afterUpdate()
    }

    public function afterInsert(): void
    {
        $this->afterUpdate();
    }

    public function afterUpdate(): void
    {
        // :TODO: build diff, save difference
        // is this in use? Cannot
        /*
        $ilDB->manipulate("DELETE FROM " . $this->getSubTableName() .
            " WHERE " . $this->buildPrimaryWhere());

        foreach ($this->prepareMultiInsert() as $sub_items) {
            $fields = array_merge($this->getPrimary(), $sub_items);

            $ilDB->insert($this->getSubTableName(), $fields);
        }
        */
    }

    abstract protected function prepareMultiInsert(): array;

    public function afterDelete(): void
    {
        // is this in use? Cannot
        /*
        $ilDB->manipulate("DELETE FROM " . $this->getSubTableName() .
            " WHERE " . $this->buildPrimaryWhere());
        */
    }
}