nystudio107\retour\migrations\m181213_233502_add_site_id

Complexity

Total Complexity

9

Size/Duplication

Total Lines	110
Duplicated Lines	0 %

Importance

Changes

0

4 Methods

Rating	Name	Duplication	Size	Complexity
B	safeUp()	0	43	6
A	addForeignKeys()	0	20	1
A	createIndexes()	0	21	1
A	safeDown()	0	4	1

<?php

Missing file doc comment

namespace nystudio107\retour\migrations;

use craft\db\Migration;
use yii\base\NotSupportedException;

/**
 * m181213_233502_add_site_id migration.

Doc comment short description must start with a capital letter

 */

Missing @category tag in class comment

Missing @package tag in class comment

Missing @author tag in class comment

Missing @license tag in class comment

Missing @link tag in class comment

class m181213_233502_add_site_id extends Migration

Class name must begin with a capital letter

Class name is not valid; consider M181213_233502_Add_Site_Id instead

{
    /**

Missing short description in doc comment

     * @inheritdoc
     * @throws NotSupportedException

Tag value for @throws tag indented incorrectly; expected 5 spaces but found 1

     */

Missing @return tag in function comment

    public function safeUp(): bool
    {
        // Drop the locale columns
        if ($this->db->columnExists('{{%retour_redirects}}', 'locale')) {
            $this->dropColumn(
                '{{%retour_redirects}}',
                'locale'
            );
        }
        if ($this->db->columnExists('{{%retour_static_redirects}}', 'locale')) {
            $this->dropColumn(
                '{{%retour_static_redirects}}',
                'locale'
            );
        }
        // Add in the siteId columns
        if (!$this->db->columnExists('{{%retour_redirects}}', 'siteId')) {
            $this->addColumn(
                '{{%retour_redirects}}',
                'siteId',
                $this->integer()->null()->after('uid')->defaultValue(null)
            );
        }
        if (!$this->db->columnExists('{{%retour_static_redirects}}', 'siteId')) {
            $this->addColumn(
                '{{%retour_static_redirects}}',
                'siteId',
                $this->integer()->null()->after('uid')->defaultValue(null)
            );
        }
        if (!$this->db->columnExists('{{%retour_stats}}', 'siteId')) {
            $this->addColumn(
                '{{%retour_stats}}',
                'siteId',
                $this->integer()->null()->after('uid')->defaultValue(null)
            );
        }
        // Add foreign keys
        $this->addForeignKeys();
        // Create indexes
        $this->createIndexes();

        return true;
    }

    /**

Missing short description in doc comment

     * @inheritdoc
     */

Missing @return tag in function comment

    public function safeDown()
    {
        echo "m181213_233502_add_site_id cannot be reverted.\n";
        return false;
    }

    /**

Missing short description in doc comment

     * @return void
     */
    protected function addForeignKeys(): void
    {
        $this->addForeignKey(
            $this->db->getForeignKeyName(),
            '{{%retour_static_redirects}}',
            'siteId',
            '{{%sites}}',
            'id',
            'CASCADE',
            'CASCADE'
        );

        $this->addForeignKey(
            $this->db->getForeignKeyName(),
            '{{%retour_stats}}',
            'siteId',
            '{{%sites}}',
            'id',
            'CASCADE',
            'CASCADE'
        );
    }

    /**

Missing short description in doc comment

     * @return void
     */
    protected function createIndexes(): void
    {
        $this->createIndex(
            $this->db->getIndexName(),
            '{{%retour_redirects}}',
            'siteId',
            false
        );

        $this->createIndex(
            $this->db->getIndexName(),
            '{{%retour_static_redirects}}',
            'siteId',
            false
        );

        $this->createIndex(
            $this->db->getIndexName(),
            '{{%retour_stats}}',
            'siteId',
            false
        );
    }
}