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

Complexity

Conditions	3
Paths	3

Size

Total Lines

31

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	12

Importance

Changes

0

<?php
    public function safeUp()
    {
        $table = $this->getDb()->getSchema()->getTableSchema(
            $this->getDb()->getSchema()->getRawTableName(static::tableName())
        );

        if (isset($table->columns['name'])) {
            return true;
        }

        $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();
        }
    }
}