ilGlossaryDefinitionMigration Class Reference

Inheritance diagram for ilGlossaryDefinitionMigration:

Collaboration diagram for ilGlossaryDefinitionMigration:

Public Member Functions
	getLabel ()
	getDefaultAmountOfStepsPerRun ()
	getPreconditions (Environment $environment)
	prepare (Environment $environment)
	step (Environment $environment)
	getRemainingAmountOfSteps ()

Protected Member Functions
	log (string $str)
	manipulate (string $query)

Protected Attributes
ilDBInterface	$db

Detailed Description

Author

Thomas Famula famul.nosp@m.a@le.nosp@m.ifos..nosp@m.de

Definition at line 28 of file class.ilGlossaryDefinitionMigration.php.

Member Function Documentation

getDefaultAmountOfStepsPerRun()

ilGlossaryDefinitionMigration::getDefaultAmountOfStepsPerRun

(

)

Definition at line 37 of file class.ilGlossaryDefinitionMigration.php.

                                                   : int
    {
        return Migration::INFINITE;
    }

getLabel()

ilGlossaryDefinitionMigration::getLabel

(

)

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

                              : string
    {
        return "Migration of glossary definitions after abolition of multiple definitions";
    }

getPreconditions()

ilGlossaryDefinitionMigration::getPreconditions

(

Environment

$environment

)

Definition at line 42 of file class.ilGlossaryDefinitionMigration.php.

                                                              : array
    {
        return [
            new ilIniFilesLoadedObjective(),
            new ilDatabaseInitializedObjective(),
            new ilDatabaseUpdatedObjective(),
        ];
    }

getRemainingAmountOfSteps()

ilGlossaryDefinitionMigration::getRemainingAmountOfSteps

(

)

Definition at line 145 of file class.ilGlossaryDefinitionMigration.php.

                                               : int
    {
        $set = $this->db->query(
            "SELECT glossary_definition.id AS glo_def_id, glossary_definition.term_id AS glo_def_term_id, " .
            " glossary_definition.short_text, glossary_definition.short_text_dirty, " .
            " glossary_term.id AS glo_term_id, glossary_term.glo_id, glossary_term.term, glossary_term.language, " .
            " glossary_term.create_date, glossary_term.last_update " .
            " FROM glossary_definition JOIN glossary_term " .
            " WHERE glossary_definition.term_id = glossary_term.id " .
            " ORDER BY glossary_term.glo_id, glossary_term.id, glossary_definition.id"
        );
        $tmp = [];
        while ($rec = $this->db->fetchAssoc($set)) {
            // check if there are multiple definitions for a term
            if (!empty($tmp)
                && $tmp["glo_id"] == $rec["glo_id"]
                && $tmp["glo_term_id"] == $rec["glo_term_id"]
            ) {
                return 1;
            }
            $tmp["glo_id"] = $rec["glo_id"];
            $tmp["glo_term_id"] = $rec["glo_term_id"];
        }
 
        $set = $this->db->query("SELECT * FROM glossary_definition WHERE migration = " . $this->db->quote("0", "integer"));
        if ($rec = $this->db->fetchAssoc($set)) {
            return 1;
        }
 
        $set = $this->db->query("SELECT parent_type FROM copg_pobj_def WHERE parent_type = " . $this->db->quote("gdf", "text"));
        if ($rec = $this->db->fetchAssoc($set)) {
            return 1;
        }
 
        return 0;
    }

log()

ilGlossaryDefinitionMigration::log ( string  $str )

protected

Definition at line 134 of file class.ilGlossaryDefinitionMigration.php.

                                       : void
    {
        echo "\n" . $str;
    }

Referenced by manipulate(), and step().

Here is the caller graph for this function:

manipulate()

ilGlossaryDefinitionMigration::manipulate ( string  $query )

protected

Definition at line 139 of file class.ilGlossaryDefinitionMigration.php.

                                                : void
    {
        $this->db->manipulate($query);
        $this->log($query);
    }

References log().

Here is the call graph for this function:

prepare()

ilGlossaryDefinitionMigration::prepare

(

Environment

$environment

)

Definition at line 51 of file class.ilGlossaryDefinitionMigration.php.

                                                     : void
    {
        $this->db = $environment->getResource(Environment::RESOURCE_DATABASE);
    }

References ILIAS\Setup\Environment\getResource().

Here is the call graph for this function:

step()

ilGlossaryDefinitionMigration::step

(

Environment

$environment

)

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

                                                  : void
    {
        $set = $this->db->query(
            "SELECT glossary_definition.id AS glo_def_id, glossary_definition.term_id AS glo_def_term_id, " .
            " glossary_definition.short_text, glossary_definition.short_text_dirty, " .
            " glossary_term.id AS glo_term_id, glossary_term.glo_id, glossary_term.term, glossary_term.language, " .
            " glossary_term.create_date, glossary_term.last_update " .
            " FROM glossary_definition JOIN glossary_term " .
            " WHERE glossary_definition.term_id = glossary_term.id " .
            " ORDER BY glossary_term.glo_id, glossary_term.id, glossary_definition.id"
        );
        $tmp = [];
        while ($rec = $this->db->fetchAssoc($set)) {
            // check if there are multiple definitions for a term
            if (!empty($tmp)
                && $tmp["glo_id"] == $rec["glo_id"]
                && $tmp["glo_term_id"] == $rec["glo_term_id"]
            ) {
                $new_term_id = $this->db->nextId('glossary_term');
                // create new term with same values, but new id
                $this->log("Create new glossary term with id: " . $new_term_id);
                $this->db->manipulate("INSERT INTO glossary_term (id, glo_id, term, language, import_id, create_date, last_update)" .
                    " VALUES (" .
                    $this->db->quote($new_term_id, "integer") . ", " .
                    $this->db->quote($rec["glo_id"], "integer") . ", " .
                    $this->db->quote($rec["term"], "text") . ", " .
                    $this->db->quote($rec["language"], "text") . "," .
                    $this->db->quote("", "text") . "," .
                    $this->db->quote($rec["create_date"], "text") . ", " .
                    $this->db->quote($rec["last_update"], "text") . ")");
                // change definition with new term id
                $this->db->manipulate(
                    "UPDATE glossary_definition SET " .
                    " term_id = " . $this->db->quote($new_term_id, "integer") .
                    " WHERE id = " . $this->db->quote($rec["glo_def_id"], "integer")
                );
            }
            $tmp["glo_id"] = $rec["glo_id"];
            $tmp["glo_term_id"] = $rec["glo_term_id"];
        }
 
        $set = $this->db->query("SELECT * FROM glossary_definition WHERE migration = " . $this->db->quote("0", "integer"));
        while ($rec = $this->db->fetchAssoc($set)) {
            // merge glossary_term and glossary_definition table
            $this->log("Add short text ('" . $rec["short_text"] . "') and short text dirty ('" .
                $rec["short_text_dirty"] . "') to glossary term with id: " . $rec["term_id"]);
            $this->db->manipulate(
                "UPDATE glossary_term SET " .
                " short_text = " . $this->db->quote($rec["short_text"], "text") . ", " .
                " short_text_dirty = " . $this->db->quote($rec["short_text_dirty"], "integer") .
                " WHERE id = " . $this->db->quote($rec["term_id"], "integer")
            );
            // update id and type in page objects
            $this->log("Update id and type ('gdf' to 'term') for page object with id: " . $rec["id"]);
            $this->db->manipulate(
                "UPDATE page_object SET " .
                " page_id = " . $this->db->quote($rec["term_id"], "integer") . ", " .
                " parent_type = " . $this->db->quote("term", "text") .
                " WHERE parent_type = " . $this->db->quote("gdf", "text") .
                " AND page_id = " . $this->db->quote($rec["id"], "integer")
            );
            // set migration marker to 1 when it's done
            $this->db->manipulate(
                "UPDATE glossary_definition SET " .
                " migration = " . $this->db->quote("1", "integer") .
                " WHERE id = " . $this->db->quote($rec["id"], "integer")
            );
        }
 
        // update type in page object definition
        $this->log("Update type ('gdf' to 'term') for page object definition.");
        $this->db->manipulate(
            "UPDATE copg_pobj_def SET " .
            " parent_type = " . $this->db->quote("term", "text") .
            " WHERE parent_type = " . $this->db->quote("gdf", "text")
        );
    }

References log().

Here is the call graph for this function:

Field Documentation

$db

ilDBInterface ilGlossaryDefinitionMigration::$db

protected

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

---

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

• components/ILIAS/Glossary/classes/Setup/class.ilGlossaryDefinitionMigration.php