CreateAccessCollectionsTable::change() - Code Metrics - Inspection of "Merge pull request #11121 from mrclay/hypeJunction..." - Elgg/Elgg - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 92ff78...57630a )

by Steve

created 2017-08-07 17:18 UTC

CreateAccessCollectionsTable::change() B

↳ Parent: CreateAccessCollectionsTable

Complexity

Conditions	2
Paths	2

Size

Total Lines	34
Code Lines	21

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	2
eloc	21
nc	2
nop	0
dl	0
loc	34
rs	8.8571
c	0
b	0
f	0

<?php

use Phinx\Migration\AbstractMigration;
use Phinx\Db\Adapter\MysqlAdapter;

class CreateAccessCollectionsTable extends AbstractMigration {
	/**
	 * Change Method.
	 *
	 * Write your reversible migrations using this method.
	 *
	 * More information on writing migrations is available here:
	 * http://docs.phinx.org/en/latest/migrations.html#the-abstractmigration-class
	 *
	 * The following commands can be used in this method and Phinx will
	 * automatically reverse them when rolling back:
	 *
	 *    createTable
	 *    renameTable
	 *    addColumn
	 *    renameColumn
	 *    addIndex
	 *    addForeignKey
	 *
	 * Remember to call "create()" or "update()" and NOT "save()" when working
	 * with the Table class.
	 */
	public function change() {

		if ($this->hasTable("access_collections")) {
			return;
		}

		$table = $this->table("access_collections", [
			'engine' => "InnoDB",
			'encoding' => "utf8mb4",
			'collation' => "utf8mb4_general_ci",
		]);

		$table->addColumn('name', 'text', [
			'null' => false,
			'limit' => 65535,
		]);

		$table->addColumn('owner_guid', 'integer', [
			'null' => false,
			'limit' => MysqlAdapter::INT_BIG,
			'precision' => 20,
			'signed' => false,
		]);

		$table->addIndex(['owner_guid'], [
			'name' => "owner_guid",
			'unique' => false
		]);

		$table->save();

		$prefix = $this->getAdapter()->getOption('table_prefix');
		$this->query("ALTER TABLE {$prefix}access_collections AUTO_INCREMENT=3");
	}
}


1			<?php
2
3			use Phinx\Migration\AbstractMigration;
4			use Phinx\Db\Adapter\MysqlAdapter;
5
6			class CreateAccessCollectionsTable extends AbstractMigration {
7			/**
8			* Change Method.
9			*
10			* Write your reversible migrations using this method.
11			*
12			* More information on writing migrations is available here:
13			* http://docs.phinx.org/en/latest/migrations.html#the-abstractmigration-class
14			*
15			* The following commands can be used in this method and Phinx will
16			* automatically reverse them when rolling back:
17			*
18			* createTable
19			* renameTable
20			* addColumn
21			* renameColumn
22			* addIndex
23			* addForeignKey
24			*
25			* Remember to call "create()" or "update()" and NOT "save()" when working
26			* with the Table class.
27			*/
28			public function change() {
29
30			if ($this->hasTable("access_collections")) {
31			return;
32			}
33
34			$table = $this->table("access_collections", [
35			'engine' => "InnoDB",
36			'encoding' => "utf8mb4",
37			'collation' => "utf8mb4_general_ci",
38			]);
39
40			$table->addColumn('name', 'text', [
41			'null' => false,
42			'limit' => 65535,
43			]);
44
45			$table->addColumn('owner_guid', 'integer', [
46			'null' => false,
47			'limit' => MysqlAdapter::INT_BIG,
48			'precision' => 20,
49			'signed' => false,
50			]);
51
52			$table->addIndex(['owner_guid'], [
53			'name' => "owner_guid",
54			'unique' => false
55			]);
56
57			$table->save();
58
59			$prefix = $this->getAdapter()->getOption('table_prefix');
60			$this->query("ALTER TABLE {$prefix}access_collections AUTO_INCREMENT=3");
61			}
62			}
63

Elgg / Elgg

Push — master ( 92ff78...57630a )

CreateAccessCollectionsTable::change() B

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like