m190413_125316_relations::safeDown() - Code Metrics - Inspection of "migrating data" - flipboxfactory/craft-element-lists - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — develop ( 664cbd...b0b15d )

by Nate

created 2019-04-13 21:26 UTC

m190413_125316_relations::safeDown() A

↳ Parent: m190413_125316_relations

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

Metric	Value
dl	0
loc	4
ccs	0
cts	4
cp	0
rs	10
c	0
b	0
f	0
cc	1
nc	1
nop	0
crap	2

<?php

/**
 * @copyright  Copyright (c) Flipbox Digital Limited
 * @license    https://github.com/flipboxfactory/craft-element-lists/LICENSE
 * @link       https://github.com/flipboxfactory/craft-element-lists/
 */

namespace flipbox\craft\element\lists\migrations;

use Craft;
use craft\db\Migration;
use flipbox\craft\element\lists\records\Association;
use yii\db\Query;

class m190413_125316_relations extends Migration
{
    /**
     * @return bool
     * @throws \yii\db\Exception
     */
    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;
    }

    /**
     * @inheritdoc
     */
    public function safeDown()
    {
        return true;
    }
}


1			<?php
2
3			/**
4			* @copyright Copyright (c) Flipbox Digital Limited
5			* @license https://github.com/flipboxfactory/craft-element-lists/LICENSE
6			* @link https://github.com/flipboxfactory/craft-element-lists/
7			*/
8
9			namespace flipbox\craft\element\lists\migrations;
10
11			use Craft;
12			use craft\db\Migration;
13			use flipbox\craft\element\lists\records\Association;
14			use yii\db\Query;
15
16			class m190413_125316_relations extends Migration
17			{
18			/**
19			* @return bool
20			* @throws \yii\db\Exception
21			*/
22			public function safeUp()
23			{
24			$query = (new Query())
25			->from(['{{%elementlist}}'])
26			->select([
27			'fieldId',
28			'sourceId',
29			'targetId',
30			'sortOrder',
31			'dateCreated',
32			'dateUpdated',
33			'uid',
34			'siteId as sourceSiteId',
35			]);
36
37			foreach ($query->batch(1000) as $batch) {
38			Craft::$app->getDb()->createCommand()->batchInsert(
39			Association::tableName(),
40			[
41			'fieldId',
42			'sourceId',
43			'targetId',
44			'sortOrder',
45			'dateCreated',
46			'dateUpdated',
47			'uid',
48			'siteId'
49			],
50			$batch,
51			false
52			)->execute();
53			}
54
55			$this->dropTableIfExists('elementlist');
56
57			return true;
58			}
59
60			/**
61			* @inheritdoc
62			*/
63			public function safeDown()
64			{
65			return true;
66			}
67			}
68

flipboxfactory / craft-element-lists

Push — develop ( 664cbd...b0b15d )

m190413_125316_relations::safeDown() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like