M180807000000Schema::safeUp() - Code Metrics - zhuravljov/yii2-queue-monitor - Measure and Improve Code Quality continuously with Scrutinizer

M180807000000Schema::safeUp() A
last analyzed 2020-08-04 21:36 UTC

↳ Parent: M180807000000Schema

Complexity

Conditions	1
Paths	1

Size

Total Lines	51
Code Lines	44

Duplication

Lines	0
Ratio	0 %

Importance

Changes	3
Bugs	0	Features	0

Metric	Value
eloc	44
c	3
b	0
f	0
dl	0
loc	51
rs	9.216
cc	1
nc	1
nop	0

How to fix Long Method

<?php
/**
 * @link https://github.com/zhuravljov/yii2-queue-monitor
 * @copyright Copyright (c) 2017 Roman Zhuravlev
 * @license http://opensource.org/licenses/BSD-3-Clause
 */

namespace zhuravljov\yii\queue\monitor\migrations;

use zhuravljov\yii\queue\monitor\base\Migration;

/**
 * Storage Schema
 *
 * @author Roman Zhuravlev <[email protected]>
 */
class M180807000000Schema extends Migration
{
    /**
     * @inheritdoc
     */
    public function safeUp()
    {
        $this->createTable($this->env->pushTableName, [
            'id' => $this->bigPrimaryKey(),
            'parent_id' => $this->bigInteger(),
            'sender_name' => $this->string(32)->notNull(),
            'job_uid' => $this->string(32)->notNull(),
            'job_class' => $this->string()->notNull(),
            'job_data' => $this->binary()->notNull(),
            'ttr' => $this->integer()->unsigned()->notNull(),
            'delay' => $this->integer()->unsigned()->notNull(),
            'trace' => $this->text(),
            'context' => $this->text(),
            'pushed_at' => $this->integer()->unsigned()->notNull(),
            'stopped_at' => $this->integer()->unsigned(),
            'first_exec_id' => $this->bigInteger(),
            'last_exec_id' => $this->bigInteger(),
        ]);
        $this->createIndex('ind_qp_parent_id', $this->env->pushTableName, 'parent_id');
        $this->createIndex('ind_qp_job_uid', $this->env->pushTableName, ['sender_name', 'job_uid']);
        $this->createIndex('ind_qp_job_class', $this->env->pushTableName, 'job_class');
        $this->createIndex('ind_qp_first_exec_id', $this->env->pushTableName, 'first_exec_id');
        $this->createIndex('ind_qp_last_exec_id', $this->env->pushTableName, 'last_exec_id');

        $this->createTable($this->env->execTableName, [
            'id' => $this->bigPrimaryKey(),
            'push_id' => $this->bigInteger()->notNull(),
            'worker_id' => $this->bigInteger(),
            'attempt' => $this->integer()->unsigned()->notNull(),
            'started_at' => $this->integer()->unsigned()->notNull(),
            'finished_at' => $this->integer()->unsigned(),
            'memory_usage' => $this->bigInteger()->unsigned(),
            'error' => $this->text(),
            'retry' => $this->boolean(),
        ]);
        $this->createIndex('ind_qe_push_id', $this->env->execTableName, 'push_id');
        $this->createIndex('ind_qe_worker_id', $this->env->execTableName, 'worker_id');

        $this->createTable($this->env->workerTableName, [
            'id' => $this->bigPrimaryKey(),
            'sender_name' => $this->string(32)->notNull(),
            'host' => $this->string(64),
            'pid' => $this->integer()->unsigned(),
            'started_at' => $this->integer()->unsigned()->notNull(),
            'pinged_at' => $this->integer()->unsigned()->notNull(),
            'stopped_at' => $this->integer()->unsigned(),
            'finished_at' => $this->integer()->unsigned(),
            'last_exec_id' => $this->bigInteger(),
        ]);
        $this->createIndex('ind_qw_finished_at', $this->env->workerTableName, 'finished_at');
        $this->createIndex('ind_qw_last_exec_id', $this->env->workerTableName, 'last_exec_id');
    }

    /**
     * @inheritdoc
     */
    public function safeDown()
    {
        $this->dropTable($this->env->workerTableName);
        $this->dropTable($this->env->execTableName);
        $this->dropTable($this->env->pushTableName);
    }
}


1			<?php
2			/**
3			* @link https://github.com/zhuravljov/yii2-queue-monitor
4			* @copyright Copyright (c) 2017 Roman Zhuravlev
5			* @license http://opensource.org/licenses/BSD-3-Clause
6			*/
7
8			namespace zhuravljov\yii\queue\monitor\migrations;
9
10			use zhuravljov\yii\queue\monitor\base\Migration;
11
12			/**
13			* Storage Schema
14			*
15			* @author Roman Zhuravlev <[email protected]>
16			*/
17			class M180807000000Schema extends Migration
18			{
19			/**
20			* @inheritdoc
21			*/
22			public function safeUp()
23			{
24			$this->createTable($this->env->pushTableName, [
25			'id' => $this->bigPrimaryKey(),
26			'parent_id' => $this->bigInteger(),
27			'sender_name' => $this->string(32)->notNull(),
28			'job_uid' => $this->string(32)->notNull(),
29			'job_class' => $this->string()->notNull(),
30			'job_data' => $this->binary()->notNull(),
31			'ttr' => $this->integer()->unsigned()->notNull(),
32			'delay' => $this->integer()->unsigned()->notNull(),
33			'trace' => $this->text(),
34			'context' => $this->text(),
35			'pushed_at' => $this->integer()->unsigned()->notNull(),
36			'stopped_at' => $this->integer()->unsigned(),
37			'first_exec_id' => $this->bigInteger(),
38			'last_exec_id' => $this->bigInteger(),
39			]);
40			$this->createIndex('ind_qp_parent_id', $this->env->pushTableName, 'parent_id');
41			$this->createIndex('ind_qp_job_uid', $this->env->pushTableName, ['sender_name', 'job_uid']);
42			$this->createIndex('ind_qp_job_class', $this->env->pushTableName, 'job_class');
43			$this->createIndex('ind_qp_first_exec_id', $this->env->pushTableName, 'first_exec_id');
44			$this->createIndex('ind_qp_last_exec_id', $this->env->pushTableName, 'last_exec_id');
45
46			$this->createTable($this->env->execTableName, [
47			'id' => $this->bigPrimaryKey(),
48			'push_id' => $this->bigInteger()->notNull(),
49			'worker_id' => $this->bigInteger(),
50			'attempt' => $this->integer()->unsigned()->notNull(),
51			'started_at' => $this->integer()->unsigned()->notNull(),
52			'finished_at' => $this->integer()->unsigned(),
53			'memory_usage' => $this->bigInteger()->unsigned(),
54			'error' => $this->text(),
55			'retry' => $this->boolean(),
56			]);
57			$this->createIndex('ind_qe_push_id', $this->env->execTableName, 'push_id');
58			$this->createIndex('ind_qe_worker_id', $this->env->execTableName, 'worker_id');
59
60			$this->createTable($this->env->workerTableName, [
61			'id' => $this->bigPrimaryKey(),
62			'sender_name' => $this->string(32)->notNull(),
63			'host' => $this->string(64),
64			'pid' => $this->integer()->unsigned(),
65			'started_at' => $this->integer()->unsigned()->notNull(),
66			'pinged_at' => $this->integer()->unsigned()->notNull(),
67			'stopped_at' => $this->integer()->unsigned(),
68			'finished_at' => $this->integer()->unsigned(),
69			'last_exec_id' => $this->bigInteger(),
70			]);
71			$this->createIndex('ind_qw_finished_at', $this->env->workerTableName, 'finished_at');
72			$this->createIndex('ind_qw_last_exec_id', $this->env->workerTableName, 'last_exec_id');
73			}
74
75			/**
76			* @inheritdoc
77			*/
78			public function safeDown()
79			{
80			$this->dropTable($this->env->workerTableName);
81			$this->dropTable($this->env->execTableName);
82			$this->dropTable($this->env->pushTableName);
83			}
84			}
85

zhuravljov / yii2-queue-monitor

M180807000000Schema::safeUp() A last analyzed 2020-08-04 21:36 UTC

Complexity

Size

Duplication

Importance

How to fix Long Method

Long Method

Duplication Side-by-Side

Filter issues like

M180807000000Schema::safeUp() A
last analyzed 2020-08-04 21:36 UTC