ilBibliograficDB80 Class Reference

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V. More...

Inheritance diagram for ilBibliograficDB80:

Collaboration diagram for ilBibliograficDB80:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
	step_2 ()
	This step serves the transfer from the old object specific online status implementation to the new centralized one. More...
Public Member Functions inherited from ilDatabaseUpdateSteps
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

Protected Attributes
ilDBInterface	$database

Detailed Description

This file is part of ILIAS, a powerful learning management system published by ILIAS open source e-Learning e.V.

ILIAS is licensed with the GPL-3.0, see https://www.gnu.org/licenses/gpl-3.0.en.html You should have received a copy of said license along with the source code, too.

If this is not the case or you just want to try ILIAS, you'll find us at: https://www.ilias.de https://github.com/ILIAS-eLearning Class ilBibliograficDB80

Author

Thibeau Fuhrer thf@s.nosp@m.tude.nosp@m.r-rai.nosp@m.mann.nosp@m..ch

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

Member Function Documentation

prepare()

ilBibliograficDB80::prepare

(

ilDBInterface

$db

)

Definition at line 30 of file class.ilBibliograficDB80.php.

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

step_1()

ilBibliograficDB80::step_1

(

)

Definition at line 35 of file class.ilBibliograficDB80.php.

                            : void
    {
        if ($this->database->tableColumnExists('il_bibl_field', 'object_id')) {
            $this->database->dropTableColumn('il_bibl_field', 'object_id');
        }
    }

step_2()

ilBibliograficDB80::step_2

(

)

This step serves the transfer from the old object specific online status implementation to the new centralized one.

It will update the object_data offline column to the inverted value of the il_bibl_data is_online column for all bibl entries where the offline status is not set yet and an old is_online status exists.

Definition at line 48 of file class.ilBibliograficDB80.php.

                            : void
    {
        if ($this->database->tableColumnExists('il_bibl_data', 'is_online')
            && $this->database->tableColumnExists('object_data', 'offline')
        ) {
            $bibl_data = $this->database->fetchAll(
                $this->database->query('SELECT * FROM il_bibl_data')
            );
            foreach ($bibl_data as $bibl_data_entry) {
                if (isset($bibl_data_entry['is_online'])) {
                    $query = "UPDATE `object_data` SET `offline` = %s WHERE `obj_id` = %s AND `type` = %s AND `offline` IS NULL";
                    $this->database->manipulateF(
                        $query,
                        ['integer', 'integer', 'text'],
                        [
                            !$bibl_data_entry['is_online'],
                            $bibl_data_entry['id'],
                            'bibl'
                        ]
                    );
                }
            }
            $this->database->dropTableColumn('il_bibl_data', 'is_online');
        }
    }

Field Documentation

$database

ilDBInterface ilBibliograficDB80::$database

protected

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

---

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

• components/ILIAS/Bibliographic/classes/Setup/class.ilBibliograficDB80.php