ilLTIConsumerDatabaseUpdateSteps Class Reference

Inheritance diagram for ilLTIConsumerDatabaseUpdateSteps:

Collaboration diagram for ilLTIConsumerDatabaseUpdateSteps:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
	step_2 ()
	step_3 ()
	step_4 ()
	step_5 ()
	step_6 ()
	step_7 ()
	step_8 ()
	step_9 ()
	step_10 ()
	step_11 ()
	step_12 ()
	step_13 ()
	step_14 ()
	step_15 ()
Public Member Functions inherited from ilDatabaseUpdateSteps
	prepare (\ilDBInterface $db)
	Prepare the execution of the steps. More...

Protected Attributes
ilDBInterface	$db

Detailed Description

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

Member Function Documentation

prepare()

ilLTIConsumerDatabaseUpdateSteps::prepare

(

ilDBInterface

$db

)

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

References $db.

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

step_1()

ilLTIConsumerDatabaseUpdateSteps::step_1

(

)

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

                            : void
    {
        if (!$this->db->tableColumnExists('lti_ext_provider', 'instructor_send_name')) {
            $this->db->addTableColumn('lti_ext_provider', 'instructor_send_name', [
                'type' => 'integer',
                'length' => 1,
                'notnull' => true,
                'default' => '0'
            ]);
        }
    }

step_10()

ilLTIConsumerDatabaseUpdateSteps::step_10

(

)

Definition at line 127 of file class.ilLTIConsumerDatabaseUpdateSteps.php.

                             : void
    {
        if (!$this->db->tableColumnExists('lti_ext_provider', 'content_item')) {
            $this->db->addTableColumn('lti_ext_provider', 'content_item', [
                'type' => 'integer',
                'length' => 1,
                'notnull' => true,
                'default' => '0'
            ]);
        }
    }

step_11()

ilLTIConsumerDatabaseUpdateSteps::step_11

(

)

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

                             : void
    {
        if (!$this->db->tableColumnExists('lti_ext_provider', 'content_item_url')) {
            $this->db->addTableColumn('lti_ext_provider', 'content_item_url', [
                'type' => 'text',
                'length' => 510,
                'notnull' => false
            ]);
        }
    }

step_12()

ilLTIConsumerDatabaseUpdateSteps::step_12

(

)

Definition at line 150 of file class.ilLTIConsumerDatabaseUpdateSteps.php.

                             : void
    {
        if (!$this->db->tableColumnExists('lti_ext_provider', 'grade_synchronization')) {
            $this->db->addTableColumn('lti_ext_provider', 'grade_synchronization', [
                'type' => 'integer',
                'length' => 1,
                'notnull' => true,
                'default' => '0'
            ]);
        }
    }

step_13()

ilLTIConsumerDatabaseUpdateSteps::step_13

(

)

Definition at line 162 of file class.ilLTIConsumerDatabaseUpdateSteps.php.

                             : void
    {
        if (!$this->db->tableColumnExists('lti_ext_provider', 'lti_version')) {
            $this->db->addTableColumn('lti_ext_provider', 'lti_version', [
                'type' => 'text',
                'length' => 10,
                'notnull' => true,
                'default' => 'LTI-1p0'
            ]);
        }
    }

step_14()

ilLTIConsumerDatabaseUpdateSteps::step_14

(

)

Definition at line 174 of file class.ilLTIConsumerDatabaseUpdateSteps.php.

                             : void
    {
        if (!$this->db->tableColumnExists('lti_consumer_settings', 'custom_params')) {
            $this->db->addTableColumn('lti_consumer_settings', 'custom_params', [
                'type' => 'text',
                'length' => 255,
                'notnull' => true,
                'default' => ''
            ]);
        }
    }

step_15()

ilLTIConsumerDatabaseUpdateSteps::step_15

(

)

Definition at line 186 of file class.ilLTIConsumerDatabaseUpdateSteps.php.

References null.

                             : void
    {
        if (!$this->db->tableExists('lti_consumer_grades')) {
            $values = array(
                'id' => array(
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true
                ),
                'obj_id' => array(
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true
                ),
                'usr_id' => array(
                    'type' => 'integer',
                    'length' => 4,
                    'notnull' => true
                ),
                'score_given' => array(
                    'type' => 'float',
                    'notnull' => false
                ),
                'score_maximum' => array(
                    'type' => 'float',
                    'notnull' => false
                ),
                'activity_progress' => array(
                    'type' => 'text',
                    'length' => 20,
                    'notnull' => true
                ),
                'grading_progress' => array(
                    'type' => 'text',
                    'length' => 20,
                    'notnull' => true
                ),
                'lti_timestamp' => array(
                    'type' => 'timestamp',
                    'notnull' => false,
                    'default' => null
                ),
                'stored' => array(
                    'type' => 'timestamp',
                    'notnull' => true
                )
            );
            $this->db->createTable("lti_consumer_grades", $values);
            $this->db->addPrimaryKey("lti_consumer_grades", array("id"));
            $this->db->createSequence("lti_consumer_grades");
            $this->db->addIndex("lti_consumer_grades", array("obj_id","usr_id"), 'i1');
        }
    }

step_2()

ilLTIConsumerDatabaseUpdateSteps::step_2

(

)

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

                            : void
    {
        if (!$this->db->tableColumnExists('lti_ext_provider', 'instructor_send_email')) {
            $this->db->addTableColumn('lti_ext_provider', 'instructor_send_email', [
                'type' => 'integer',
                'length' => 1,
                'notnull' => true,
                'default' => '0'
            ]);
        }
    }

step_3()

ilLTIConsumerDatabaseUpdateSteps::step_3

(

)

Definition at line 54 of file class.ilLTIConsumerDatabaseUpdateSteps.php.

                            : void
    {
        if (!$this->db->tableColumnExists('lti_ext_provider', 'client_id')) {
            $this->db->addTableColumn('lti_ext_provider', 'client_id', [
                'type' => 'text',
                'length' => 255,
                'notnull' => false
            ]);
        }
    }

step_4()

ilLTIConsumerDatabaseUpdateSteps::step_4

(

)

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

                            : void
    {
        if (!$this->db->tableColumnExists('lti_ext_provider', 'enabled_capability')) {
            $this->db->addTableColumn('lti_ext_provider', 'enabled_capability', [
                'type' => 'clob'
            ]);
        }
    }

step_5()

ilLTIConsumerDatabaseUpdateSteps::step_5

(

)

Definition at line 74 of file class.ilLTIConsumerDatabaseUpdateSteps.php.

                            : void
    {
        if (!$this->db->tableColumnExists('lti_ext_provider', 'key_type')) {
            $this->db->addTableColumn('lti_ext_provider', 'key_type', [
                'type' => 'text',
                'length' => 16,
                'notnull' => false
            ]);
        }
    }

step_6()

ilLTIConsumerDatabaseUpdateSteps::step_6

(

)

Definition at line 85 of file class.ilLTIConsumerDatabaseUpdateSteps.php.

                            : void
    {
        if (!$this->db->tableColumnExists('lti_ext_provider', 'public_key')) {
            $this->db->addTableColumn('lti_ext_provider', 'public_key', [
                'type' => 'clob'
            ]);
        }
    }

step_7()

ilLTIConsumerDatabaseUpdateSteps::step_7

(

)

Definition at line 94 of file class.ilLTIConsumerDatabaseUpdateSteps.php.

                            : void
    {
        if (!$this->db->tableColumnExists('lti_ext_provider', 'public_keyset')) {
            $this->db->addTableColumn('lti_ext_provider', 'public_keyset', [
                'type' => 'text',
                'length' => 255,
                'notnull' => false
            ]);
        }
    }

step_8()

ilLTIConsumerDatabaseUpdateSteps::step_8

(

)

Definition at line 105 of file class.ilLTIConsumerDatabaseUpdateSteps.php.

                            : void
    {
        if (!$this->db->tableColumnExists('lti_ext_provider', 'initiate_login')) {
            $this->db->addTableColumn('lti_ext_provider', 'initiate_login', [
                'type' => 'text',
                'length' => 255,
                'notnull' => false
            ]);
        }
    }

step_9()

ilLTIConsumerDatabaseUpdateSteps::step_9

(

)

Definition at line 116 of file class.ilLTIConsumerDatabaseUpdateSteps.php.

                            : void
    {
        if (!$this->db->tableColumnExists('lti_ext_provider', 'redirection_uris')) {
            $this->db->addTableColumn('lti_ext_provider', 'redirection_uris', [
                'type' => 'text',
                'length' => 510,
                'notnull' => false
            ]);
        }
    }

Field Documentation

$db

ilDBInterface ilLTIConsumerDatabaseUpdateSteps::$db

protected

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

Referenced by prepare().

---

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

• components/ILIAS/LTIConsumer/classes/Setup/class.ilLTIConsumerDatabaseUpdateSteps.php