Delete::execute() - Code Metrics - gamernetwork/yolk-database - Measure and Improve Code Quality continuously with Scrutinizer

Delete::execute() A
last analyzed 2016-05-18 08:44 UTC

↳ Parent: Delete

Complexity

Conditions	1
Paths	1

Size

Total Lines	6
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

<?php
/*
 * This file is part of Yolk - Gamer Network's PHP Framework.
 *
 * Copyright (c) 2013 Gamer Network Ltd.
 *
 * Distributed under the MIT License, a copy of which is available in the
 * LICENSE file that was bundled with this package, or online at:
 * https://github.com/gamernetwork/yolk-database
 */

namespace yolk\database\query;

use yolk\contracts\database\DatabaseConnection;

/**
 * Generic.
 */
class Delete extends BaseQuery {

	protected $from;

	public function __construct( DatabaseConnection $db ) {
		parent::__construct($db);
		$this->from = '';
	}

	public function from( $table ) {
		$this->from = $this->quoteIdentifier($table);
		return $this;
	}

	public function execute() {
		return $this->db->execute(
			$this->__toString(),
			$this->params
		);
	}

	protected function compile() {

		return array_merge(
			[
				"DELETE FROM {$this->from}",
			],
			$this->compileWhere(),
			$this->compileOrderBy(),
			$this->compileLimit()
		);

	}

	protected function compileLimit() {


		$sql = [];

		if( $this->limit ) {
0   == false // true
0   == null  // true
123 == false // false
123 == null  // false

// It is often better to use strict comparison
0 === false // false
0 === null  // false
			$sql[] = "LIMIT :limit";
			$this->params['limit']  = $this->limit;
		}

		return $sql;

	}

}

// EOF

1		<?php
2		/*
3		* This file is part of Yolk - Gamer Network's PHP Framework.
4		*
5		* Copyright (c) 2013 Gamer Network Ltd.
6		*
7		* Distributed under the MIT License, a copy of which is available in the
8		* LICENSE file that was bundled with this package, or online at:
9		* https://github.com/gamernetwork/yolk-database
10		*/
11
12		namespace yolk\database\query;
13
14		use yolk\contracts\database\DatabaseConnection;
15
16		/**
17		* Generic.
18		*/
19		class Delete extends BaseQuery {
20
21		protected $from;
22
23		public function __construct( DatabaseConnection $db ) {
24		parent::__construct($db);
25		$this->from = '';
26		}
27
28		public function from( $table ) {
29		$this->from = $this->quoteIdentifier($table);
30		return $this;
31		}
32
33		public function execute() {
34		return $this->db->execute(
35		$this->__toString(),
36		$this->params
37		);
38		}
39
40		protected function compile() {
41
42		return array_merge(
43		[
44		"DELETE FROM {$this->from}",
45		],
46		$this->compileWhere(),
47		$this->compileOrderBy(),
48		$this->compileLimit()
49		);
50
51		}
52
53	View Code Duplication	protected function compileLimit() {
		0 ignored issues – show Duplication introduced 2016-02-25 17:13 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
54
55		$sql = [];
56
57		if( $this->limit ) {
		0 ignored issues – show Bug Best Practice introduced 2016-02-25 17:13 UTC by Report Bug Copy Issue Report The expression `$this->limit` of type `integer\|null` is loosely compared to `true`; this is ambiguous if the integer can be zero. 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 `integer` values, zero is a special case, in particular the following results might be unexpected: 0 == false // true 0 == null // true 123 == false // false 123 == null // false // It is often better to use strict comparison 0 === false // false 0 === null // false Loading history...
58		$sql[] = "LIMIT :limit";
59		$this->params['limit'] = $this->limit;
60		}
61
62		return $sql;
63
64		}
65
66		}
67
68		// EOF

gamernetwork / yolk-database

Delete::execute() A last analyzed 2016-05-18 08:44 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

Delete::execute() A
last analyzed 2016-05-18 08:44 UTC