m180509_092225_create_articles_table::safeDown() - Code Metrics - Inspection of "Bump guzzlehttp/guzzle from 6.5.5 to 6.5.6" - itstructure/yii2-template-multilanguage - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#3)

unknown

created 2022-05-25 18:35 UTC

m180509_092225_create_articles_table::safeDown() A

↳ Parent: m180509_092225_create_articles_table

Complexity

Conditions	1
Paths	1

Size

Total Lines	23
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	13
c	1
b	0
f	0
nc	1
nop	0
dl	0
loc	23
rs	9.8333

<?php

use Itstructure\AdminModule\components\MultilanguageMigration;

/**
 * Handles the creation of table `articles`.
 */
class m180509_092225_create_articles_table extends MultilanguageMigration
{
    /**
     * {@inheritdoc}
     */
    public function safeUp()
    {
        $this->createMultiLanguageTable('articles',
            [
                'title' => $this->string(128)->notNull(),
                'description' => $this->text(),
                'content' => $this->text(),
                'metaKeys' => $this->string(128),
                'metaDescription' => $this->string(),
            ],
            [
                'pageId' => $this->integer(),
                'active' => $this->tinyInteger()->notNull()->defaultValue(0),
                'icon' => $this->string(128),
                'alias' => $this->string(128),
            ]
        );

        $this->createIndex(
            'idx-articles-pageId',
            'articles',
            'pageId'
        );

        $this->addForeignKey(
            'fk-articles-pageId',
            'articles',
            'pageId',
            'pages',
            'id',
            'SET NULL'
        );

        $this->createIndex(
            'idx-articles-active',
            'articles',
            'active'
        );

        $this->createIndex(
            'idx-articles-alias',
            'articles',
            'alias'
        );
    }

    /**
     * {@inheritdoc}
     */
    public function safeDown()
    {
        $this->dropIndex(
            'idx-articles-alias',
            'articles'
        );

        $this->dropIndex(
            'idx-articles-active',
            'articles'
        );

        $this->dropForeignKey(
            'fk-articles-pageId',
            'articles'
        );

        $this->dropIndex(
            'idx-articles-pageId',
            'articles'
        );

        $this->dropMultiLanguageTable('articles');
    }
}


1			<?php
2
3			use Itstructure\AdminModule\components\MultilanguageMigration;
4
5			/**
6			* Handles the creation of table `articles`.
7			*/
8			class m180509_092225_create_articles_table extends MultilanguageMigration
9			{
10			/**
11			* {@inheritdoc}
12			*/
13			public function safeUp()
14			{
15			$this->createMultiLanguageTable('articles',
16			[
17			'title' => $this->string(128)->notNull(),
18			'description' => $this->text(),
19			'content' => $this->text(),
20			'metaKeys' => $this->string(128),
21			'metaDescription' => $this->string(),
22			],
23			[
24			'pageId' => $this->integer(),
25			'active' => $this->tinyInteger()->notNull()->defaultValue(0),
26			'icon' => $this->string(128),
27			'alias' => $this->string(128),
28			]
29			);
30
31			$this->createIndex(
32			'idx-articles-pageId',
33			'articles',
34			'pageId'
35			);
36
37			$this->addForeignKey(
38			'fk-articles-pageId',
39			'articles',
40			'pageId',
41			'pages',
42			'id',
43			'SET NULL'
44			);
45
46			$this->createIndex(
47			'idx-articles-active',
48			'articles',
49			'active'
50			);
51
52			$this->createIndex(
53			'idx-articles-alias',
54			'articles',
55			'alias'
56			);
57			}
58
59			/**
60			* {@inheritdoc}
61			*/
62			public function safeDown()
63			{
64			$this->dropIndex(
65			'idx-articles-alias',
66			'articles'
67			);
68
69			$this->dropIndex(
70			'idx-articles-active',
71			'articles'
72			);
73
74			$this->dropForeignKey(
75			'fk-articles-pageId',
76			'articles'
77			);
78
79			$this->dropIndex(
80			'idx-articles-pageId',
81			'articles'
82			);
83
84			$this->dropMultiLanguageTable('articles');
85			}
86			}
87

itstructure / yii2-template-multilanguage

Pull Request — master (#3)

m180509_092225_create_articles_table::safeDown() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like