ilDataCollectionDBUpdateSteps10 Class Reference

Inheritance diagram for ilDataCollectionDBUpdateSteps10:

Collaboration diagram for ilDataCollectionDBUpdateSteps10:

Public Member Functions
	prepare (ilDBInterface $db)
	step_1 ()
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.ilDataCollectionDBUpdateSteps10.php.

Member Function Documentation

prepare()

ilDataCollectionDBUpdateSteps10::prepare

(

ilDBInterface

$db

)

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

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

References $db.

step_1()

ilDataCollectionDBUpdateSteps10::step_1

(

)

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

                            : void
    {
        $stmt = $this->db->queryF(
            'SELECT il_dcl_field.*, area.value As text_area FROM il_dcl_field ' .
            'LEFT JOIN il_dcl_field_prop AS lenght ON il_dcl_field.id = lenght.field_id AND lenght.name = %s' .
            'LEFT JOIN il_dcl_field_prop AS area ON il_dcl_field.id = area.field_id AND area.name = %s' .
            'WHERE il_dcl_field.datatype_id = %s AND lenght.value IS NULL',
            [ilDBConstants::T_TEXT, ilDbConstants::T_TEXT, ilDbConstants::T_INTEGER],
            [ilDclBaseFieldModel::PROP_LENGTH, 'text_area', ilDclDatatype::INPUTFORMAT_TEXT]
        );
 
        while ($row = $this->db->fetchAssoc($stmt)) {
            $this->db->insert(
                'il_dcl_field_prop',
                [
                    'id' => [ilDBConstants::T_INTEGER, $this->db->nextId('il_dcl_field_prop')],
                    'field_id' => [ilDBConstants::T_INTEGER, $row['id']],
                    'name' => [ilDBConstants::T_TEXT, ilDclBaseFieldModel::PROP_LENGTH],
                    'value' => [ilDBConstants::T_TEXT, ($row['text_area'] === '1') ? '4000' : '200'],
                ]
            );
        }
 
        $this->db->manipulateF(
            "DELETE FROM il_dcl_field_prop WHERE name = %s",
            [ilDBConstants::T_TEXT],
            ['text_area']
        );
    }

References ilDclDatatype\INPUTFORMAT_TEXT, ilDclBaseFieldModel\PROP_LENGTH, ilDBConstants\T_INTEGER, and ilDBConstants\T_TEXT.

Field Documentation

$db

ilDBInterface ilDataCollectionDBUpdateSteps10::$db

protected

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

Referenced by prepare().

---

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

• components/ILIAS/DataCollection/classes/Setup/class.ilDataCollectionDBUpdateSteps10.php