ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8 Class Reference

Inheritance diagram for ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8:

Collaboration diagram for ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8:

Public Member Functions
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...
	step_1 ()
	step_2 ()
	step_3 ()
	step_4 ()

Private Member Functions
	migrate (int $id, int $field_id, $data)
	migrateData (int $field_id, $data)

Private Attributes
ilDBInterface	$db

Detailed Description

Definition at line 23 of file class.DBUpdateSteps8.php.

Member Function Documentation

migrate()

ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8::migrate ( int  $id, int  $field_id,   $data  )

private

Definition at line 56 of file class.DBUpdateSteps8.php.

References $data, $query, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

Referenced by ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8\step_3().

                                                           : void
    {
        $query = 'UPDATE pg_amd_page_list ' .
            'SET sdata = ' . $this->db->quote(serialize(serialize($data)), \ilDBConstants::T_TEXT) . ' ' .
            'WHERE id = ' . $this->db->quote($id, \ilDBConstants::T_INTEGER) . ' ' .
            'AND field_id = ' . $this->db->quote($field_id, \ilDBConstants::T_INTEGER);
        $this->db->manipulate($query);
    }

Here is the caller graph for this function:

migrateData()

ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8::migrateData ( int  $field_id,   $data  )

private

Definition at line 65 of file class.DBUpdateSteps8.php.

References $data, $query, $res, ilDBConstants\FETCHMODE_OBJECT, ILIAS\Repository\int(), ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

                                                      : array
    {
        if (!is_array($data)) {
            return [];
        }
        $indexes = [];
        foreach ($data as $idx => $value) {
            $query = 'SELECT idx from adv_mdf_enum ' .
                'WHERE value = ' . $this->db->quote($value, \ilDBConstants::T_TEXT) . ' ' .
                'AND field_id = ' . $this->db->quote($field_id, \ilDBConstants::T_INTEGER);
            $res = $this->db->query($query);

            $found_index = false;
            while ($row = $res->fetchRow(\ilDBConstants::FETCHMODE_OBJECT)) {
                $indexes[] = (int) $row->idx;
                $found_index = true;
            }
            if ($found_index) {
                continue;
            }
            $query = 'SELECT idx from adv_mdf_enum ' .
                'WHERE idx = ' . $this->db->quote($value, \ilDBConstants::T_TEXT) . ' ' .
                'AND field_id = ' . $this->db->quote($field_id, \ilDBConstants::T_INTEGER);
            $res = $this->db->query($query);
            while ($row = $res->fetchRow(\ilDBConstants::FETCHMODE_OBJECT)) {
                $indexes[] = (int) $row->idx;
            }
        }
        return $indexes;
    }

Here is the call graph for this function:

prepare()

ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8::prepare

(

\ilDBInterface

$db

)

Prepare the execution of the steps.

Do not use anything from the globals or the DIC inside your steps, only use the instance of the database provided here.

Implements ilDatabaseUpdateSteps.

Definition at line 27 of file class.DBUpdateSteps8.php.

References ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8\$db.

                                               : void
    {
        $this->db = $db;
    }

step_1()

ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8::step_1

(

)

Definition at line 32 of file class.DBUpdateSteps8.php.

                            : void
    {
        if ($this->db->tableColumnExists('adv_mdf_definition', 'field_values')) {
            $field_infos = [
                'type' => 'clob',
                'notnull' => false,
                'default' => null
            ];
            $this->db->modifyTableColumn('adv_mdf_definition', 'field_values', $field_infos);
        }
    }

step_2()

ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8::step_2

(

)

Definition at line 44 of file class.DBUpdateSteps8.php.

                            : void
    {
        if (!$this->db->tableColumnExists('pg_amd_page_list', 'sdata')) {
            $field_infos = [
                'type' => 'clob',
                'notnull' => false,
                'default' => null
            ];
            $this->db->addTableColumn('pg_amd_page_list', 'sdata', $field_infos);
        }
    }

step_3()

ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8::step_3

(

)

Definition at line 98 of file class.DBUpdateSteps8.php.

References $query, $res, ilDBConstants\FETCHMODE_OBJECT, and ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8\migrate().

                            : void
    {
        $query = 'SELECT id, pg.field_id, data, field_type FROM pg_amd_page_list pg ' .
            'JOIN adv_mdf_definition adv ' .
            'ON pg.field_id = adv.field_id ' .
            'WHERE sdata IS null ';
        $res = $this->db->query($query);
        while ($row = $res->fetchRow(\ilDBConstants::FETCHMODE_OBJECT)) {
            if ($row->field_type == 1 || $row->field_type == 8) {
                $this->migrate(
                    (int) $row->id,
                    (int) $row->field_id,
                    $this->migrateData(
                        (int) $row->field_id,
                        unserialize(unserialize($row->data))
                    )
                );
            } else {
                $this->migrate(
                    (int) $row->id,
                    (int) $row->field_id,
                    unserialize(unserialize($row->data))
                );
            }
        }
    }

Here is the call graph for this function:

step_4()

ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8::step_4

(

)

Definition at line 125 of file class.DBUpdateSteps8.php.

                            : void
    {
        $this->db->modifyTableColumn(
            'adv_md_values_extlink',
            'value',
            [
                'type' => 'text',
                'length' => 2000,
                'notnull' => false
            ]
        );
    }

Field Documentation

$db

ilDBInterface ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8::$db

private

Definition at line 25 of file class.DBUpdateSteps8.php.

Referenced by ILIAS\AdvancedMetaData\Setup\DBUpdateSteps8\prepare().

---

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

• Services/AdvancedMetaData/classes/Setup/class.DBUpdateSteps8.php