CreateTable::primaryKey() - Code Metrics - Inspection of ":octocat:" - chillerlan/php-database - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( d508c6...ead087 )

by smiley

created 2017-06-16 01:17 UTC

CreateTable::primaryKey() A

↳ Parent: CreateTable

Complexity

Conditions	1
Paths	1

Size

Total Lines	6
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	6
c	0
b	0
f	0
rs	9.4285
cc	1
eloc	4
nc	1
nop	2

<?php
/**
 * Class CreateTable
 *
 * @filesource   CreateTable.php
 * @created      03.06.2017
 * @package      chillerlan\Database\Query\Dialects\SQLite
 * @author       Smiley <[email protected]>
 * @copyright    2017 Smiley
 * @license      MIT
 */

namespace chillerlan\Database\Query\Dialects\SQLite;

use chillerlan\Database\Query\CreateTableInterface;
use chillerlan\Database\Query\CreateTableAbstract;
use chillerlan\Database\Query\QueryException;

/**
 * @link https://www.sqlite.org/lang_createtable.html
 */
class CreateTable extends CreateTableAbstract{

	protected $dir;

	public function primaryKey(string $field, string $dir = null):CreateTableInterface{
		$this->primaryKey = $field;
		$this->dir = strtoupper($this->dir);

		return $this;
	}


	public function sql():string{

		if(empty($this->name)){
			throw new QueryException('no name specified');
		}

		$sql = 'CREATE ';
		$sql .= $this->temp ? ' TEMPORARY ' : '';
		$sql .= 'TABLE ';
		$sql .= $this->ifNotExists ? 'IF NOT EXISTS ' : '';

		$n = explode('.', $this->name);

		$sql .= $this->quote($n[count($n)-1]);

		if(!empty($this->cols)){
			$sql .= ' ('.PHP_EOL."\t".implode(','.PHP_EOL."\t", $this->cols);

			if($this->primaryKey){
				$sql .=','.PHP_EOL."\t".'PRIMARY KEY ('.$this->quote($this->primaryKey)
				       .(in_array($this->dir, ['ASC', 'DESC']) ? $this->dir : '').')';
			}

			$sql .= PHP_EOL.')';
		}

		$sql .= '';

		return $sql;
	}

	protected function fieldspec(
		string $name,
		string $type,
		$length = null,
		string $attribute = null,
		string $collation = null,
		bool $isNull = null,
		string $defaultType = null,
		$defaultValue = null,
		string $extra = null
	){
		$name = trim($name);
		$type = strtoupper(trim($type));
		$collation = strtoupper($collation);

		$field = ['"'.$name.'"'];

		$type_translation = [
			'MEDIUMTEXT' => 'TEXT',
			'LONGTEXT'   => 'TEXT',
		][$type] ?? $type;



		if(is_int($length)&& in_array($type, ['CHAR', 'NCHAR','VARCHAR', 'NVARCHAR', 'CHARACTER'])
		    || is_string($length) && count(explode(',', $length)) === 2 && $type === 'DECIMAL'){
			$field[] = $type_translation.'('. $length . ')';
		}
		else{
			$field[] = $type_translation;
		}

		if(is_bool($isNull)){
			$field[] = $isNull ? 'NULL' : 'NOT NULL';
		}

		if($collation && in_array($collation, ['BINARY', 'NOCASE', 'RTRIM'])){
			$field[] = 'COLLATE '.$collation;
		}


		$defaultType = strtoupper($defaultType);

		if($defaultType === 'USER_DEFINED'){
			$field[] = 'DEFAULT \''.$defaultValue.'\'';
		}
		else if(in_array($defaultType, ['CURRENT_DATE', 'CURRENT_TIME', 'CURRENT_TIMESTAMP'])){
			$field[] = 'DEFAULT '.$defaultType;
		}
		else if($defaultType === 'NULL' && $isNull === true){
			$field[] = 'DEFAULT NULL';
		}



		if($attribute){
''   == false // true
''   == null  // true
'ab' == false // false
'ab' == null  // false

// It is often better to use strict comparison
'' === false // false
'' === null  // false
			$field[] = $attribute;
		}

		if($extra){
''   == false // true
''   == null  // true
'ab' == false // false
'ab' == null  // false

// It is often better to use strict comparison
'' === false // false
'' === null  // false
			$field[] = $extra;
		}

		return implode(' ', $field);
	}
}


1			<?php
2			/**
3			* Class CreateTable
4			*
5			* @filesource CreateTable.php
6			* @created 03.06.2017
7			* @package chillerlan\Database\Query\Dialects\SQLite
8			* @author Smiley <[email protected]>
9			* @copyright 2017 Smiley
10			* @license MIT
11			*/
12
13			namespace chillerlan\Database\Query\Dialects\SQLite;
14
15			use chillerlan\Database\Query\CreateTableInterface;
16			use chillerlan\Database\Query\CreateTableAbstract;
17			use chillerlan\Database\Query\QueryException;
18
19			/**
20			* @link https://www.sqlite.org/lang_createtable.html
21			*/
22			class CreateTable extends CreateTableAbstract{
23
24			protected $dir;
25
26			public function primaryKey(string $field, string $dir = null):CreateTableInterface{
27			$this->primaryKey = $field;
28			$this->dir = strtoupper($this->dir);
29
30			return $this;
31			}
32
33
34			public function sql():string{
35
36			if(empty($this->name)){
37			throw new QueryException('no name specified');
38			}
39
40			$sql = 'CREATE ';
41			$sql .= $this->temp ? ' TEMPORARY ' : '';
42			$sql .= 'TABLE ';
43			$sql .= $this->ifNotExists ? 'IF NOT EXISTS ' : '';
44
45			$n = explode('.', $this->name);
46
47			$sql .= $this->quote($n[count($n)-1]);
48
49			if(!empty($this->cols)){
50			$sql .= ' ('.PHP_EOL."\t".implode(','.PHP_EOL."\t", $this->cols);
51
52			if($this->primaryKey){
53			$sql .=','.PHP_EOL."\t".'PRIMARY KEY ('.$this->quote($this->primaryKey)
54			.(in_array($this->dir, ['ASC', 'DESC']) ? $this->dir : '').')';
55			}
56
57			$sql .= PHP_EOL.')';
58			}
59
60			$sql .= '';
61
62			return $sql;
63			}
64
65			protected function fieldspec(
66			string $name,
67			string $type,
68			$length = null,
69			string $attribute = null,
70			string $collation = null,
71			bool $isNull = null,
72			string $defaultType = null,
73			$defaultValue = null,
74			string $extra = null
75			){
76			$name = trim($name);
77			$type = strtoupper(trim($type));
78			$collation = strtoupper($collation);
79
80			$field = ['"'.$name.'"'];
81
82			$type_translation = [
83			'MEDIUMTEXT' => 'TEXT',
84			'LONGTEXT' => 'TEXT',
85			][$type] ?? $type;
86
87
88
89			if(is_int($length)&& in_array($type, ['CHAR', 'NCHAR','VARCHAR', 'NVARCHAR', 'CHARACTER'])
90			\|\| is_string($length) && count(explode(',', $length)) === 2 && $type === 'DECIMAL'){
91			$field[] = $type_translation.'('. $length . ')';
92			}
93			else{
94			$field[] = $type_translation;
95			}
96
97			if(is_bool($isNull)){
98			$field[] = $isNull ? 'NULL' : 'NOT NULL';
99			}
100
101			if($collation && in_array($collation, ['BINARY', 'NOCASE', 'RTRIM'])){
102			$field[] = 'COLLATE '.$collation;
103			}
104
105
106			$defaultType = strtoupper($defaultType);
107
108			if($defaultType === 'USER_DEFINED'){
109			$field[] = 'DEFAULT \''.$defaultValue.'\'';
110			}
111			else if(in_array($defaultType, ['CURRENT_DATE', 'CURRENT_TIME', 'CURRENT_TIMESTAMP'])){
112			$field[] = 'DEFAULT '.$defaultType;
113			}
114			else if($defaultType === 'NULL' && $isNull === true){
115			$field[] = 'DEFAULT NULL';
116			}
117
118
119
120			if($attribute){
			0 ignored issues – show Bug Best Practice introduced 2017-06-16 01:20 UTC by Report Bug Copy Issue Report The expression `$attribute` of type `null\|string` is loosely compared to `true`; this is ambiguous if the string can be empty. You might want to explicitly use `!== null` instead. In PHP, under loose comparison (like `==`, or `!=`, or `switch` conditions), values of different types might be equal. For `string` values, the empty string `''` is a special case, in particular the following results might be unexpected: '' == false // true '' == null // true 'ab' == false // false 'ab' == null // false // It is often better to use strict comparison '' === false // false '' === null // false Loading history...
121			$field[] = $attribute;
122			}
123
124			if($extra){
			0 ignored issues – show Bug Best Practice introduced 2017-06-16 01:20 UTC by Report Bug Copy Issue Report The expression `$extra` of type `null\|string` is loosely compared to `true`; this is ambiguous if the string can be empty. You might want to explicitly use `!== null` instead. In PHP, under loose comparison (like `==`, or `!=`, or `switch` conditions), values of different types might be equal. For `string` values, the empty string `''` is a special case, in particular the following results might be unexpected: '' == false // true '' == null // true 'ab' == false // false 'ab' == null // false // It is often better to use strict comparison '' === false // false '' === null // false Loading history...
125			$field[] = $extra;
126			}
127
128			return implode(' ', $field);
129			}
130			}
131

chillerlan / php-database

Push — master ( d508c6...ead087 )

CreateTable::primaryKey() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like