m160313_153426_session_init::up() - Code Metrics - Inspection of "Update session migration for MSSQL" - yiisoft/yii2 - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Pull Request — master (#19612)

by Fedonyuk

created 2022-10-14 14:00 UTC

m160313_153426_session_init::up() A

↳ Parent: m160313_153426_session_init

Complexity

Conditions	6
Paths	8

Size

Total Lines	26
Code Lines	18

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	15
CRAP Score	6.1666

Importance

Changes	2
Bugs	0	Features	0

Metric	Value
cc	6
eloc	18
c	2
b	0
f	0
nc	8
nop	0
dl	0
loc	26
ccs	15
cts	18
cp	0.8333
crap	6.1666
rs	9.0444

<?php
/**
 * @link https://www.yiiframework.com/
 * @copyright Copyright (c) 2008 Yii Software LLC
 * @license https://www.yiiframework.com/license/
 */

use yii\db\Migration;

/**
 * Initializes Session tables.
 *
 * @author Misbahul D Munir <[email protected]>
 * @since 2.0.8
 */
class m160313_153426_session_init extends Migration
{
    /**
     * {@inheritdoc}
     */
    public function up()
    {
        $dataType = $this->binary();
        $tableOptions = null;

        switch ($this->db->driverName) {
            case 'mysql':
                // https://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';
                break;
            case 'sqlsrv':
            case 'mssql':
            case 'dblib':
                // "varbinary(max)" added in SQL Server 2012 (version 11.0.0)
                if (version_compare($this->getDb()->getServerVersion(), '11.0.0') < 0) {
                    $dataType = $this->text();
                }
                break;
        }

        $this->createTable('{{%session}}', [
            'id' => $this->string()->notNull(),
            'expire' => $this->integer(),
            'data' => $dataType,
            'PRIMARY KEY ([[id]])',
        ], $tableOptions);
    }

    /**
     * {@inheritdoc}
     */
    public function down()
    {
        $this->dropTable('{{%session}}');
    }
}


1		<?php
2		/**
3		* @link https://www.yiiframework.com/
4		* @copyright Copyright (c) 2008 Yii Software LLC
5		* @license https://www.yiiframework.com/license/
6		*/
7
8		use yii\db\Migration;
9
10		/**
11		* Initializes Session tables.
12		*
13		* @author Misbahul D Munir <[email protected]>
14		* @since 2.0.8
15		*/
16		class m160313_153426_session_init extends Migration
17		{
18		/**
19		* {@inheritdoc}
20		*/
21	30	public function up()
22		{
23	30	$dataType = $this->binary();
24	30	$tableOptions = null;
25
26	30	switch ($this->db->driverName) {
27	30	case 'mysql':
28		// https://stackoverflow.com/questions/766809/whats-the-difference-between-utf8-general-ci-and-utf8-unicode-ci
29	10	$tableOptions = 'CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE=InnoDB';
30	10	break;
31	20	case 'sqlsrv':
32	20	case 'mssql':
33	20	case 'dblib':
34		// "varbinary(max)" added in SQL Server 2012 (version 11.0.0)
35		if (version_compare($this->getDb()->getServerVersion(), '11.0.0') < 0) {
36		$dataType = $this->text();
37		}
38		break;
39		}
40
41	30	$this->createTable('{{%session}}', [
42	30	'id' => $this->string()->notNull(),
43	30	'expire' => $this->integer(),
44	30	'data' => $dataType,
45	30	'PRIMARY KEY ([[id]])',
46		], $tableOptions);
47	30	}
48
49		/**
50		* {@inheritdoc}
51		*/
52	30	public function down()
53		{
54	30	$this->dropTable('{{%session}}');
55	30	}
56		}
57

yiisoft / yii2

Pull Request — master (#19612)

m160313_153426_session_init::up() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like