ilExternalFeedRemoveMigration Class Reference

Inheritance diagram for ilExternalFeedRemoveMigration:

Collaboration diagram for ilExternalFeedRemoveMigration:

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

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

Protected Attributes
ilDBInterface	$db

Detailed Description

Author

Alexander Killing killi.nosp@m.ng@l.nosp@m.eifos.nosp@m..de

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

Member Function Documentation

getDefaultAmountOfStepsPerRun()

ilExternalFeedRemoveMigration::getDefaultAmountOfStepsPerRun

(

)

Definition at line 34 of file class.ilExternalFeedRemoveMigration.php.

                                                   : int
    {
        return 10;
    }

getLabel()

ilExternalFeedRemoveMigration::getLabel

(

)

Definition at line 29 of file class.ilExternalFeedRemoveMigration.php.

                              : string
    {
        return "Remove external feeds from repository.";
    }

getPreconditions()

ilExternalFeedRemoveMigration::getPreconditions

(

Environment

$environment

)

Definition at line 39 of file class.ilExternalFeedRemoveMigration.php.

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

getRemainingAmountOfSteps()

ilExternalFeedRemoveMigration::getRemainingAmountOfSteps

(

)

Definition at line 223 of file class.ilExternalFeedRemoveMigration.php.

                                               : int
    {
        $db = $this->db;
 
        $set = $db->queryF(
            "SELECT * FROM object_data d JOIN object_reference r ON (d.obj_id = r.obj_id) " .
            " WHERE d.type = %s ",
            ["text"],
            ["feed"]
        );
        $obj_ids = [];
        while ($rec = $db->fetchAssoc($set)) {
            $obj_ids[$rec["obj_id"]] = $rec["obj_id"];
        }
 
        if (count($obj_ids) > 0) {
            return 1;
        }
        return 0;
    }

References $db, ilDBInterface\fetchAssoc(), and ilDBInterface\queryF().

Here is the call graph for this function:

log()

ilExternalFeedRemoveMigration::log ( string  $str )

protected

Definition at line 55 of file class.ilExternalFeedRemoveMigration.php.

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

Referenced by manipulate(), and step().

Here is the caller graph for this function:

manipulate()

ilExternalFeedRemoveMigration::manipulate ( string  $query )

protected

Definition at line 216 of file class.ilExternalFeedRemoveMigration.php.

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

References $db, $query, log(), and ilDBInterface\manipulate().

Referenced by step().

Here is the call graph for this function:

Here is the caller graph for this function:

step()

ilExternalFeedRemoveMigration::step

(

Environment

$environment

)

Definition at line 60 of file class.ilExternalFeedRemoveMigration.php.

                                                  : void
    {
        $db = $this->db;
 
        $ref_ids = [];
        $obj_ids = [];
 
        $set = $db->queryF(
            "SELECT * FROM object_data d JOIN object_reference r ON (d.obj_id = r.obj_id) " .
            " WHERE d.type = %s ",
            ["text"],
            ["feed"]
        );
        while ($rec = $db->fetchAssoc($set)) {
            $this->log("Found title: " . $rec["title"] . ", ref id: " . $rec["ref_id"]);
            $ref_ids[$rec["ref_id"]] = $rec["ref_id"];
            $obj_ids[$rec["obj_id"]] = $rec["obj_id"];
        }
 
        // local roles of feed objects
        $set = $db->queryF(
            "SELECT * FROM rbac_fa " .
            " WHERE " . $db->in("parent", $ref_ids, false, "integer"),
            [],
            []
        );
        $local_roles = [];
        while ($rec = $db->fetchAssoc($set)) {
            $local_roles[$rec["rol_id"]] = $rec["rol_id"];
        }
 
        // typ
        $set = $db->queryF(
            "SELECT * FROM object_data " .
            " WHERE type = %s AND title = %s",
            ["text", "text"],
            ["typ", "feed"]
        );
        $typ_id = 0;
        if ($rec = $db->fetchAssoc($set)) {
            $typ_id = $rec["obj_id"];
        }
 
        // create ops id
        $set = $db->queryF(
            "SELECT * FROM rbac_operations " .
            " WHERE operation = %s",
            ["text"],
            ["create_feed"]
        );
        $create_ops_id = 0;
        if ($rec = $db->fetchAssoc($set)) {
            $create_ops_id = $rec["ops_id"];
        }
 
 
        // ...tree
        $this->log("Delete tree nodes of feed objects.");
        $this->manipulate(
            "DELETE FROM tree WHERE " .
            " " . $db->in("child", $ref_ids, false, "integer")
        );
 
        // ...object_data (feed objects)
        $this->log("Delete object_data entries of feed objects.");
        $this->manipulate(
            "DELETE FROM object_data WHERE " .
            " " . $db->in("obj_id", $obj_ids, false, "integer")
        );
        // ...object_data (roles)
        $this->log("Delete object_data entries of local roles of feed objects.");
        $this->manipulate(
            "DELETE FROM object_data WHERE " .
            " " . $db->in("obj_id", $local_roles, false, "integer")
        );
        // ...object_data (type)
        $this->log("Delete object_data entry of feed type.");
        $this->manipulate(
            "DELETE FROM object_data WHERE " .
            " obj_id = " . $db->quote($typ_id, "integer")
        );
 
        // ...object_description (feed objects)
        $this->log("Delete object_description entries of feed objects.");
        $this->manipulate(
            "DELETE FROM object_description WHERE " .
            " " . $db->in("obj_id", $obj_ids, false, "integer")
        );
 
        //... role data of local roles
        $this->log("Delete role_data entries of local roles of feed objects.");
        $this->manipulate(
            "DELETE FROM role_data WHERE " .
            " " . $db->in("role_id", $local_roles, false, "integer")
        );
 
        // ...object_reference
        $this->log("Delete object_reference entries of feed objects.");
        $this->manipulate(
            "DELETE FROM object_reference WHERE " .
            " " . $db->in("ref_id", $ref_ids, false, "integer")
        );
 
        // ...rbac_pa (permissions on feeds)
        $this->log("Delete permissions of feed objects.");
        $this->manipulate(
            "DELETE FROM rbac_pa WHERE " .
            " " . $db->in("ref_id", $ref_ids, false, "integer")
        );
 
        // ...rbac_fa (local roles of feeds)
        $this->log("Delete local roles of feed objects.");
        $this->manipulate(
            "DELETE FROM rbac_fa WHERE " .
            " " . $db->in("rol_id", $local_roles, false, "integer")
        );
 
        // ...rbac_ta (operations per type)
        $this->log("Delete operations of feed type.");
        $this->manipulate(
            "DELETE FROM rbac_ta WHERE " .
            " typ_id = " . $db->quote($typ_id, "integer")
        );
 
        // ...rbac_templates (template for feed type)
        $this->log("Delete permission templates of feed type.");
        $this->manipulate(
            "DELETE FROM rbac_templates WHERE " .
            " type = " . $db->quote("feed", "text")
        );
 
        // ...rbac_templates (create_feed operation)
        $this->log("Delete create_feed operation from permission templates.");
        $this->manipulate(
            "DELETE FROM rbac_templates WHERE " .
            " ops_id = " . $db->quote($create_ops_id, "integer")
        );
 
 
        // ...conditions
        $this->log("Delete conditions of feed objects.");
        $this->manipulate(
            "DELETE FROM conditions WHERE " .
            " " . $db->in("target_ref_id", $ref_ids, false, "integer") .
            " OR " . $db->in("trigger_ref_id", $ref_ids, false, "integer")
        );
 
        // ...il_external_feed_block
        $this->log("Empty il_external_feed_block.");
        $this->manipulate("DELETE FROM il_external_feed_block");
 
        // ...il_custom_block
        $this->log("Delete il_custom_block entries of type 'feed'.");
        $this->manipulate("DELETE FROM il_custom_block WHERE type = " . $db->quote("feed", "text"));
    }

References $db, ilDBInterface\fetchAssoc(), ilDBInterface\in(), log(), manipulate(), ilDBInterface\queryF(), and ilDBInterface\quote().

Here is the call graph for this function:

Field Documentation

$db

ilDBInterface ilExternalFeedRemoveMigration::$db

protected

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

Referenced by getRemainingAmountOfSteps(), manipulate(), and step().

---

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

• Modules/ExternalFeed/classes/Setup/class.ilExternalFeedRemoveMigration.php