Inheritance diagram for ILIAS\components\TodoExample\Setup\TodoDBUpdateSteps:

Collaboration diagram for ILIAS\components\TodoExample\Setup\TodoDBUpdateSteps:

Public Member Functions
	prepare (ilDBInterface $db)
	Prepare the update ilDBInterface should be the only dependency of the update steps. More...

	step_1 ()
	Step 1: Creation of the table Update steps must be consecutively numbered ILIAS setup remembers the already executed steps. More...

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 26 of file TodoDBUpdateSteps.php.

Member Function Documentation

◆ prepare()

ILIAS\components\TodoExample\Setup\TodoDBUpdateSteps::prepare ( ilDBInterface $db )

Prepare the update ilDBInterface should be the only dependency of the update steps.

Definition at line 34 of file TodoDBUpdateSteps.php.

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

References ILIAS\components\TodoExample\Setup\TodoDBUpdateSteps\$db.

◆ step_1()

ILIAS\components\TodoExample\Setup\TodoDBUpdateSteps::step_1 ( )

Step 1: Creation of the table Update steps must be consecutively numbered ILIAS setup remembers the already executed steps.

Definition at line 44 of file TodoDBUpdateSteps.php.

    {
        if (! $this->db->tableExists('todo_items')) {
            $this->db->createTable('todo_items', [
                'todo_id' => ['type' => 'integer', 'length' => '4', 'notnull' => true],
                'user_id' => ['type' => 'integer', 'length' => '4', 'notnull' => true],
                'title' => ['type' => 'text', 'length' => '250', 'notnull' => true],
                'description' => ['type' => 'clob', 'notnull' => false],
                'deadline' => ['type' => 'date', 'notnull' => false],
            ]);
 
            $this->db->createSequence('todo_items');
            $this->db->addPrimaryKey('todo_items', ['todo_id']);
            $this->db->addIndex('todo_items', ['user_id'], 'i1');
        }
    }

Field Documentation

◆ $db

ilDBInterface ILIAS\components\TodoExample\Setup\TodoDBUpdateSteps::$db

protected

Definition at line 28 of file TodoDBUpdateSteps.php.

Referenced by ILIAS\components\TodoExample\Setup\TodoDBUpdateSteps\prepare().

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

docs/development/tutorial/04-coding/TodoExample/src/Setup/TodoDBUpdateSteps.php