ilWorkflowEngine9DBUpdateSteps Class Reference

Inheritance diagram for ilWorkflowEngine9DBUpdateSteps:

Collaboration diagram for ilWorkflowEngine9DBUpdateSteps:

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

Protected Attributes
ilDBInterface	$db

Private Member Functions
	delete_directory ($dir)

Detailed Description

Definition at line 21 of file class.ilWorkflowEngine9DBUpdateSteps.php.

Member Function Documentation

delete_directory()

ilWorkflowEngine9DBUpdateSteps::delete_directory (   $dir )

private

Definition at line 138 of file class.ilWorkflowEngine9DBUpdateSteps.php.

Referenced by step_3().

    {
        if (!file_exists($dir)) {
            return true;
        }

        if (!is_dir($dir)) {
            return unlink($dir);
        }

        foreach (scandir($dir) as $item) {
            if ($item == '.' || $item == '..') {
                continue;
            }

            if (!delete_directory($dir . DIRECTORY_SEPARATOR . $item)) {
                return false;
            }
        }

        return rmdir($dir);
    }

Here is the caller graph for this function:

prepare()

ilWorkflowEngine9DBUpdateSteps::prepare

(

ilDBInterface

$db

)

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

References $db.

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

step_1()

ilWorkflowEngine9DBUpdateSteps::step_1

(

)

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

                            : void
    {
        $this->db->manipulate("DELETE FROM settings WHERE keyword = " .
            $this->db->quote('wfe_activation', "text") . " AND module = " .
            $this->db->quote('common', "text"));

        $this->db->manipulate("DELETE FROM settings WHERE module = " .
            $this->db->quote('wfe', "text"));
    }

step_2()

ilWorkflowEngine9DBUpdateSteps::step_2

(

)

Definition at line 40 of file class.ilWorkflowEngine9DBUpdateSteps.php.

                            : void
    {
        $this->db->dropTable('wfe_det_listening');
        $this->db->dropTable('wfe_startup_events');
        $this->db->dropTable('wfe_static_inputs');
        $this->db->dropTable('wfe_workflows');
    }

step_3()

ilWorkflowEngine9DBUpdateSteps::step_3

(

)

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

References delete_directory().

                            : void
    {
        $this->delete_directory( '../default/wfe');
    }

Here is the call graph for this function:

step_4()

ilWorkflowEngine9DBUpdateSteps::step_4

(

)

Definition at line 53 of file class.ilWorkflowEngine9DBUpdateSteps.php.

References $ref_id, and $res.

                            : void
    {
        $res = $this->db->queryF(
            'SELECT obj_id FROM object_data WHERE type = %s',
            array('text'),
            array('wfe')
        );
        $row = $this->db->fetchAssoc($res);
        if (is_array($row) && isset($row['obj_id'])) {
            $obj_id = $row['obj_id'];

            $ref_res = $this->db->queryF(
                'SELECT ref_id FROM object_reference WHERE obj_id = %s',
                array('integer'),
                array($obj_id)
            );

            while ($ref_row = $this->db->fetchAssoc($ref_res)) {
                if (is_array($ref_row) && isset($ref_row['ref_id'])) {
                    $ref_id = $ref_row['ref_id'];

                    $this->db->manipulateF(
                        'DELETE FROM tree WHERE child = %s',
                        array('integer'),
                        array($ref_id)
                    );

                    $this->db->manipulateF(
                        'DELETE FROM rbac_pa WHERE ref_id = %s',
                        array('integer'),
                        array($ref_id)
                    );

                    $this->db->manipulateF(
                        'DELETE FROM rbac_templates WHERE parent = %s',
                        array('integer'),
                        array($ref_id)
                    );

                    $this->db->manipulateF(
                        'DELETE FROM rbac_fa WHERE parent = %s',
                        array('integer'),
                        array($ref_id)
                    );

                }
            }

            $this->db->manipulateF(
                'DELETE FROM object_reference WHERE obj_id = %s',
                array('integer'),
                array($obj_id)
            );

            $this->db->manipulateF(
                'DELETE FROM object_data WHERE obj_id = %s',
                array('integer'),
                array($obj_id)
            );
        }

        $res = $this->db->queryF(
            'SELECT obj_id FROM object_data WHERE type = %s AND title = %s',
            array('text', 'text'),
            array('typ', 'wfe')
        );
        $row = $this->db->fetchAssoc($res);

        if (is_array($row) && isset($row['obj_id'])) {
            $obj_id = $row['obj_id'];

            $this->db->manipulateF(
                'DELETE FROM rbac_ta WHERE typ_id = %s',
                array('integer'),
                array($obj_id)
            );

            $this->db->manipulateF(
                'DELETE FROM object_data WHERE obj_id = %s',
                array('integer'),
                array($obj_id)
            );
        }
    }

Field Documentation

$db

ilDBInterface ilWorkflowEngine9DBUpdateSteps::$db

protected

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

Referenced by prepare().

---

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

• Services/WorkflowEngine/Setup/class.ilWorkflowEngine9DBUpdateSteps.php