flipbox\craft\integration\migrations\IntegrationConnectionNameColumn::safeUp()

Complexity

Conditions	2
Paths	2

Size

Total Lines

23

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	6

Importance

Changes

0

<?php
    public function safeUp()
    {
        $this->addColumn(
            static::tableName(),
            'name',
            $this->string()->after('id')->notNull()
        );

        $records = (new Query())
            ->from(static::tableName())
            ->select(['id', 'handle'])
            ->all();

        foreach ($records as $record) {
            Craft::$app->getDb()->createCommand()
                ->update(
                    static::tableName(),
                    ['name' => StringHelper::titleize($record['handle'])],
                    ['id' => $record['id']]
                )
                ->execute();
        }
    }
}