TestMigration::up() - Code Metrics - Inspection of "Use external yii2-sortable. populateTree(). New na..." - paulzi/yii2-materialized-path - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( a54314...1f466c )

by Pavel

created 2015-12-11 16:25 UTC

TestMigration::up() B

↳ Parent: TestMigration

Complexity

Conditions	5
Paths	16

Size

Total Lines	55
Code Lines	40

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	45
CRAP Score	5

Metric	Value
dl	0
loc	55
ccs	45
cts	45
cp	1
rs	8.7753
cc	5
eloc	40
nc	16
nop	0
crap	5

How to fix Long Method

<?php
/**
 * @link https://github.com/paulzi/yii2-materialized-path
 * @copyright Copyright (c) 2015 PaulZi <[email protected]>
 * @license MIT (https://github.com/paulzi/yii2-materialized-path/blob/master/LICENSE)
 */

namespace paulzi\materializedPath\tests\migrations;

use yii\db\Schema;
use yii\db\Migration;

/**
 * @author PaulZi <[email protected]>
 */
class TestMigration extends Migration
{
    public function up()
    {
        ob_start();
        $tableOptions = null;
        if ($this->db->driverName === 'mysql') {
            // http://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci
            $tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB';
        }

        // tree
        if ($this->db->getTableSchema('{{%tree}}', true) !== null) {
            $this->dropTable('{{%tree}}');
        }
        $this->createTable('{{%tree}}', [
            'id'    => Schema::TYPE_PK,
            'path'  => Schema::TYPE_STRING . ' NULL',
            'depth' => Schema::TYPE_INTEGER . ' NOT NULL',
            'sort'  => Schema::TYPE_INTEGER . ' NOT NULL',
            'slug'  => Schema::TYPE_STRING . ' NOT NULL',
        ], $tableOptions);
        $this->createIndex('path', '{{%tree}}', ['path']);

        // attribute mode tree
        if ($this->db->getTableSchema('{{%attribute_mode_tree}}', true) !== null) {
            $this->dropTable('{{%attribute_mode_tree}}');
        }
        $this->createTable('{{%attribute_mode_tree}}', [
            'id'    => Schema::TYPE_PK,
            'path'  => Schema::TYPE_STRING . ' NULL',
            'depth' => Schema::TYPE_INTEGER . ' NOT NULL',
            'sort'  => Schema::TYPE_INTEGER . ' NOT NULL',
            'slug'  => Schema::TYPE_STRING . ' NOT NULL',
        ], $tableOptions);
        $this->createIndex('path2', '{{%attribute_mode_tree}}', ['path']);

        // multiple tree
        if ($this->db->getTableSchema('{{%multiple_tree}}', true) !== null) {
            $this->dropTable('{{%multiple_tree}}');
        }
        $this->createTable('{{%multiple_tree}}', [
            'id'    => Schema::TYPE_PK,
            'tree'  => Schema::TYPE_INTEGER . ' NULL',
            'path'  => Schema::TYPE_STRING . ' NULL',
            'depth' => Schema::TYPE_INTEGER . ' NOT NULL',
            'sort'  => Schema::TYPE_INTEGER . ' NOT NULL',
            'slug'  => Schema::TYPE_STRING . ' NOT NULL',
        ], $tableOptions);
        $this->createIndex('path3', '{{%multiple_tree}}', ['tree', 'path']);

        // update cache (sqlite bug)
        $this->db->getSchema()->getTableSchema('{{%tree}}', true);
        $this->db->getSchema()->getTableSchema('{{%attribute_mode_tree}}', true);
        $this->db->getSchema()->getTableSchema('{{%multiple_tree}}', true);
        ob_end_clean();
    }
}


1		<?php
2		/**
3		* @link https://github.com/paulzi/yii2-materialized-path
4		* @copyright Copyright (c) 2015 PaulZi <[email protected]>
5		* @license MIT (https://github.com/paulzi/yii2-materialized-path/blob/master/LICENSE)
6		*/
7
8		namespace paulzi\materializedPath\tests\migrations;
9
10		use yii\db\Schema;
11		use yii\db\Migration;
12
13		/**
14		* @author PaulZi <[email protected]>
15		*/
16		class TestMigration extends Migration
17		{
18	201	public function up()
19		{
20	201	ob_start();
21	201	$tableOptions = null;
22	201	if ($this->db->driverName === 'mysql') {
23		// http://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci
24	67	$tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB';
25	67	}
26
27		// tree
28	201	if ($this->db->getTableSchema('{{%tree}}', true) !== null) {
29	197	$this->dropTable('{{%tree}}');
30	197	}
31	201	$this->createTable('{{%tree}}', [
32	201	'id' => Schema::TYPE_PK,
33	201	'path' => Schema::TYPE_STRING . ' NULL',
34	201	'depth' => Schema::TYPE_INTEGER . ' NOT NULL',
35	201	'sort' => Schema::TYPE_INTEGER . ' NOT NULL',
36	201	'slug' => Schema::TYPE_STRING . ' NOT NULL',
37	201	], $tableOptions);
38	201	$this->createIndex('path', '{{%tree}}', ['path']);
39
40		// attribute mode tree
41	201	if ($this->db->getTableSchema('{{%attribute_mode_tree}}', true) !== null) {
42	197	$this->dropTable('{{%attribute_mode_tree}}');
43	197	}
44	201	$this->createTable('{{%attribute_mode_tree}}', [
45	201	'id' => Schema::TYPE_PK,
46	201	'path' => Schema::TYPE_STRING . ' NULL',
47	201	'depth' => Schema::TYPE_INTEGER . ' NOT NULL',
48	201	'sort' => Schema::TYPE_INTEGER . ' NOT NULL',
49	201	'slug' => Schema::TYPE_STRING . ' NOT NULL',
50	201	], $tableOptions);
51	201	$this->createIndex('path2', '{{%attribute_mode_tree}}', ['path']);
52
53		// multiple tree
54	201	if ($this->db->getTableSchema('{{%multiple_tree}}', true) !== null) {
55	197	$this->dropTable('{{%multiple_tree}}');
56	197	}
57	201	$this->createTable('{{%multiple_tree}}', [
58	201	'id' => Schema::TYPE_PK,
59	201	'tree' => Schema::TYPE_INTEGER . ' NULL',
60	201	'path' => Schema::TYPE_STRING . ' NULL',
61	201	'depth' => Schema::TYPE_INTEGER . ' NOT NULL',
62	201	'sort' => Schema::TYPE_INTEGER . ' NOT NULL',
63	201	'slug' => Schema::TYPE_STRING . ' NOT NULL',
64	201	], $tableOptions);
65	201	$this->createIndex('path3', '{{%multiple_tree}}', ['tree', 'path']);
66
67		// update cache (sqlite bug)
68	201	$this->db->getSchema()->getTableSchema('{{%tree}}', true);
69	201	$this->db->getSchema()->getTableSchema('{{%attribute_mode_tree}}', true);
70	201	$this->db->getSchema()->getTableSchema('{{%multiple_tree}}', true);
71	201	ob_end_clean();
72	201	}
73		}
74

paulzi / yii2-materialized-path

GitHub Access Token became invalid

Push — master ( a54314...1f466c )

TestMigration::up() B

Complexity

Size

Duplication

Code Coverage

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like