flipbox\craft\element\lists\migrations\m190413_125316_relations::safeUp()

Complexity

Conditions	2
Paths	2

Size

Total Lines

37

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	6

Importance

Changes

0

<?php
    public function safeUp()
    {
        $query = (new Query())
            ->from(['{{%elementlist}}'])
            ->select([
                'fieldId',
                'sourceId',
                'targetId',
                'sortOrder',
                'dateCreated',
                'dateUpdated',
                'uid',
                'siteId as sourceSiteId',
            ]);

        foreach ($query->batch(1000) as $batch) {
            Craft::$app->getDb()->createCommand()->batchInsert(
                Association::tableName(),
                [
                    'fieldId',
                    'sourceId',
                    'targetId',
                    'sortOrder',
                    'dateCreated',
                    'dateUpdated',
                    'uid',
                    'siteId'
                ],
                $batch,
                false
            )->execute();
        }

        $this->dropTableIfExists('elementlist');

        return true;
    }