m180328_085629_add_indexes

Complexity

Total Complexity

9

Size/Duplication

Total Lines	57
Duplicated Lines	0 %

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	setUp()	0	12	3
A	createIndexes()	0	3	2
A	safeUp()	0	6	1
A	safeDown()	0	6	1
A	dropIndexes()	0	3	2

<?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);
        }
    }

}