class.ilAccessRBACDeleteDbkSteps.php

Go to the documentation of this file.

<?php 
declare(strict_types=1);
 
class ilAccessRBACDeleteDbkSteps implements ilDatabaseUpdateSteps
{
    protected \ilDBInterface $db;
 
    public function prepare(\ilDBInterface $db) : void
    {
        $this->db = $db;
    }
 
    public function step_1() : void
    {
        //Delete all entries with type digibook from rbac_ta
        $sql =
            "DELETE FROM rbac_ta " .
            "WHERE typ_id IN (" .
                "SELECT obj_id FROM object_data " .
                "WHERE type = 'typ' " .
                "AND title = 'dbk'" .
            ")";
 
        $this->db->manipulate($sql);
 
        //Delete the entry of the digibook type from object_data
        $sql =
            "DELETE FROM object_data " .
            "WHERE type = 'typ' " .
            "AND title = 'dbk'";
 
        $this->db->manipulate($sql);
    }
 
    public function step_2() : void
    {
        //Delete every row with the ops_id of the digibook create operation from the rbac tables
        $sql =
            "DELETE FROM rbac_ta " .
            "WHERE ops_id IN (" .
                "SELECT ops_id FROM rbac_operations " .
                "WHERE operation = 'create_dbk'" .
            ")";
 
        $this->db->manipulate($sql);
 
        $sql =
            "DELETE FROM rbac_templates " .
            "WHERE ops_id IN (" .
                "SELECT ops_id FROM rbac_operations " .
                "WHERE operation = 'create_dbk'" .
            ")";
 
        $this->db->manipulate($sql);
 
        //Delete the operation from rbac_operations
        $sql =
            "DELETE FROM rbac_operations " .
            "WHERE operation = 'create_dbk'";
 
        $this->db->manipulate($sql);
    }
 
    public function step_3() : void
    {
        //Delete all other rows in the rbac tables which refer to the type dbk
        $sql =
            "DELETE FROM rbac_templates " .
            "WHERE type = 'dbk' "
        ;
 
        $this->db->manipulate($sql);
    }
}