ilScorm2004DatabaseUpdateSteps Class Reference

Inheritance diagram for ilScorm2004DatabaseUpdateSteps:

Collaboration diagram for ilScorm2004DatabaseUpdateSteps:

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

Protected Attributes
ilDBInterface	$db

Private Member Functions
	dropCmiInteractionIdIndex ()
	createCmiInteractionIdPrefixIndex ()

Detailed Description

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

Member Function Documentation

createCmiInteractionIdPrefixIndex()

ilScorm2004DatabaseUpdateSteps::createCmiInteractionIdPrefixIndex ( )

private

Definition at line 72 of file class.ilScorm2004DatabaseUpdateSteps.php.

                                                        : void
    {
        $this->db->loadModule(ilDBConstants::MODULE_MANAGER)->createIndex(
            'cmi_interaction',
            'i2',
            array(
                'fields' => array(
                    'id' => array(
                        'length' => 255
                    )
                )
            )
        );
    }

References ilDBConstants\MODULE_MANAGER.

Referenced by step_5(), and step_6().

Here is the caller graph for this function:

dropCmiInteractionIdIndex()

ilScorm2004DatabaseUpdateSteps::dropCmiInteractionIdIndex ( )

private

Definition at line 65 of file class.ilScorm2004DatabaseUpdateSteps.php.

                                                : void
    {
        if ($this->db->indexExistsByFields('cmi_interaction', ['id'])) {
            $this->db->dropIndexByFields('cmi_interaction', ['id']);
        }
    }

Referenced by step_5(), and step_6().

Here is the caller graph for this function:

prepare()

ilScorm2004DatabaseUpdateSteps::prepare

(

ilDBInterface

$db

)

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

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

References $db.

step_1()

ilScorm2004DatabaseUpdateSteps::step_1

(

)

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

                            : void
    {
        $this->db->modifyTableColumn("cmi_interaction", "c_timestamp", array("type" => "text", "length" => 40, "notnull" => false, 'default' => null));
    }

step_2()

ilScorm2004DatabaseUpdateSteps::step_2

(

)

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

                            : void
    {
        $this->db->modifyTableColumn("cp_dependency", "resourceid", array("type" => "text", "length" => 200, "notnull" => false, 'default' => null));
    }

step_3()

ilScorm2004DatabaseUpdateSteps::step_3

(

)

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

                            : void
    {
        if (!$this->db->indexExistsByFields('sahs_user', ['user_id'])) {
            $this->db->addIndex('sahs_user', ['user_id'], 'i1');
        }
    }

step_4()

ilScorm2004DatabaseUpdateSteps::step_4

(

)

Definition at line 47 of file class.ilScorm2004DatabaseUpdateSteps.php.

                            : void
    {
        $this->db->modifyTableColumn("cmi_correct_response", "pattern", array("type" => "text", "length" => 4000, "notnull" => false, 'default' => null));
    }

step_5()

ilScorm2004DatabaseUpdateSteps::step_5

(

)

Definition at line 52 of file class.ilScorm2004DatabaseUpdateSteps.php.

                            : void
    {
        $this->dropCmiInteractionIdIndex();
        $this->db->modifyTableColumn("cmi_interaction", "id", array("type" => "text", "length" => 4000, "notnull" => false, 'default' => null));
        $this->createCmiInteractionIdPrefixIndex();
    }

References createCmiInteractionIdPrefixIndex(), and dropCmiInteractionIdIndex().

Here is the call graph for this function:

step_6()

ilScorm2004DatabaseUpdateSteps::step_6

(

)

Definition at line 59 of file class.ilScorm2004DatabaseUpdateSteps.php.

                            : void
    {
        $this->dropCmiInteractionIdIndex();
        $this->createCmiInteractionIdPrefixIndex();
    }

References createCmiInteractionIdPrefixIndex(), and dropCmiInteractionIdIndex().

Here is the call graph for this function:

Field Documentation

$db

ilDBInterface ilScorm2004DatabaseUpdateSteps::$db

protected

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

Referenced by prepare().

---

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

• components/ILIAS/Scorm2004/classes/Setup/class.ilScorm2004DatabaseUpdateSteps.php