m180328_085629_add_indexes::dropIndexes() - Code Metrics - andmemasin/language - Measure and Improve Code Quality continuously with Scrutinizer

m180328_085629_add_indexes::dropIndexes() A
last analyzed 2020-12-16 13:01 UTC

↳ Parent: m180328_085629_add_indexes

Complexity

Conditions	2
Paths	2

Size

Total Lines	3
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	2
eloc	2
nc	2
nop	0
dl	0
loc	3
rs	10
c	0
b	0
f	0

<?php

use yii\db\Migration;

/**
 * Class m180328_085629_add_indexes
 */
class m180328_085629_add_indexes extends Migration
{
    private $columns = [];
    private $tableName;
    private $indexPrefix = 'ix_';


    private function setUp($model) {
        $this->tableName = $model;

        if ($model === 'language') {
            $this->columns =[
                'language', 'name'
            ];
        }

        if ($model === 'language_translation') {
            $this->columns =[
                'model_class', 'model_field_name', 'model_id'
            ];
        }
    }

    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $this->setUp('language');
        $this->createIndexes();
        $this->setUp('language_translation');
        $this->createIndexes();
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        $this->setUp('language');
        $this->dropIndexes();
        $this->setUp('language_translation');
        $this->dropIndexes();
    }




    private function createIndexes(){
        foreach ($this->columns as $column) {
            $this->createIndex($this->indexPrefix.$column,$this->tableName, $column);
        }
    }

    private function dropIndexes(){
        foreach ($this->columns as $column) {
            $this->dropIndex($this->indexPrefix.$column,$this->tableName);
        }
    }

}


1			<?php
2
3			use yii\db\Migration;
4
5			/**
6			* Class m180328_085629_add_indexes
7			*/
8			class m180328_085629_add_indexes extends Migration
9			{
10			private $columns = [];
11			private $tableName;
12			private $indexPrefix = 'ix_';
13
14
15			private function setUp($model) {
16			$this->tableName = $model;
17
18			if ($model === 'language') {
19			$this->columns =[
20			'language', 'name'
21			];
22			}
23
24			if ($model === 'language_translation') {
25			$this->columns =[
26			'model_class', 'model_field_name', 'model_id'
27			];
28			}
29			}
30
31			/**
32			* {@inheritdoc}
33			*/
34			public function safeUp()
35			{
36			$this->setUp('language');
37			$this->createIndexes();
38			$this->setUp('language_translation');
39			$this->createIndexes();
40			}
41
42			/**
43			* {@inheritdoc}
44			*/
45			public function safeDown()
46			{
47			$this->setUp('language');
48			$this->dropIndexes();
49			$this->setUp('language_translation');
50			$this->dropIndexes();
51			}
52
53
54
55
56			private function createIndexes(){
57			foreach ($this->columns as $column) {
58			$this->createIndex($this->indexPrefix.$column,$this->tableName, $column);
59			}
60			}
61
62			private function dropIndexes(){
63			foreach ($this->columns as $column) {
64			$this->dropIndex($this->indexPrefix.$column,$this->tableName);
65			}
66			}
67
68			}
69

andmemasin / language

m180328_085629_add_indexes::dropIndexes() A last analyzed 2020-12-16 13:01 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

m180328_085629_add_indexes::dropIndexes() A
last analyzed 2020-12-16 13:01 UTC