Zortje\MySQLKeeper\Database\Table\Column

Complexity

Total Complexity

10

Size/Duplication

Total Lines	138
Duplicated Lines	0 %

Coupling/Cohesion

Components	2
Dependencies	0

Test Coverage

Coverage

40%

Importance

Changes	11
Bugs	0	Features	0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	getField()	0	3	1
A	getCollation()	0	3	1
A	__construct()	0	9	1
A	hasCollation()	0	5	1
A	isPrimaryKey()	0	5	1
A	isAutoIncrement()	0	5	1
A	getResult()	0	10	1
A	checkAutoIncrement()	0	13	3

<?php

namespace Zortje\MySQLKeeper\Database\Table;

/**
 * Class Column
 *
 * @package Zortje\MySQLKeeper\Database\Table
 */
class Column {

	/**
	 * @var string
	 */
	private $field;

	/**
	 * @var string
	 */
	private $type;

	/**
	 * @var string
	 */
	private $collation;

	/**
	 * @var string
	 */
	private $null;

	/**
	 * @var string
	 */
	private $key;

	/**
	 * @var null|string
	 */
	private $default;

	/**
	 * @var string
	 */
	private $extra;

	/**
	 * @param array $column Column information
	 */
	public function __construct($column) {
		$this->field     = $column['Field'];
		$this->type      = $column['Type'];
		$this->collation = $column['Collation'];
		$this->null      = $column['Null'];
		$this->key       = $column['Key'];
		$this->default   = $column['Default'];
		$this->extra     = $column['Extra'];
	}

	/**
	 * Get Column field
	 *
	 * @return string Column field
	 */
	public function getField() {
		return $this->field;
	}

	/**
	 * Get Column collation
	 *
	 * @return string Column collation
	 */
	public function getCollation() {
		return $this->collation;
	}

	/**
	 * Get has Column collation
	 *
	 * @return bool TRUE if Column has collation, otherwise FALSE
	 */
	public function hasCollation() {
		$hasCollation = strlen($this->getCollation()) > 0;

		return $hasCollation;
	}

	/**
	 * Is Column primary key
	 *
	 * @return bool TRUE if primary key, otherwise FALSE
	 */
	public function isPrimaryKey() {
		$isPrimaryKey = $this->key === 'PRI';

		return $isPrimaryKey;
	}

	/**
	 * Is Column auto increment
	 *
	 * @return bool TRUE if auto increment, otherwise FALSE
	 */
	public function isAutoIncrement() {
		$isAutoIncrement = $this->extra === 'auto_increment';

		return $isAutoIncrement;
	}

	/**
	 * Get result for column
	 *
	 * @return array Result
	 */
	public function getResult() {
		$result = [];

		/**
		 * auto_increment checks
		 */
		$result = array_merge($result, $this->checkAutoIncrement($this));

		return $result;
	}

	/**
	 * Check auto increment column
	 *
	 * @param Column $column Table column
	 *
	 * @return array Result
	 */
	public function checkAutoIncrement(Column $column) {
		$result = [];

		if ($column->isAutoIncrement() === true && $column->isPrimaryKey() === false) {
			$result[] = [
				'type'        => 'column',
				'field'       => $column->getField(),
				'description' => 'Set as auto_increment but has no primary key'
			];
		}

		return $result;
	}
}