chillerlan\Database\Query\UpdateAbstract

Complexity

Total Complexity

12

Size/Duplication

Total Lines	108
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Importance

Changes

0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	sql()	0	18	3
A	table()	0	5	1
B	set()	0	24	5
A	where()	0	3	1
A	openBracket()	0	3	1
A	closeBracket()	0	3	1

<?php
/**
 * Class UpdateAbstract
 *
 * @filesource   UpdateAbstract.php
 * @created      03.06.2017
 * @package      chillerlan\Database\Query\Dialects
 * @author       Smiley <smiley@chillerlan.net>
 * @copyright    2017 Smiley
 * @license      MIT
 */

namespace chillerlan\Database\Query;

use chillerlan\Database\Query\Traits\WhereTrait;

abstract class UpdateAbstract extends StatementAbstract implements UpdateInterface{
	use WhereTrait;

	/**
	 * @var string
	 */
	protected $table;

	/**
	 * @var array
	 */
	protected $set = [];

	/**
	 * @return string
	 * @throws \chillerlan\Database\Query\QueryException
	 */
	public function sql():string{

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

		if(empty($this->set)){
			throw new QueryException('no fields to update specified');
		}

		$sql  = 'UPDATE ';
		$sql .= $this->quote($this->table);
		$sql .= ' SET ';
		$sql .= implode(', ', $this->set);
		$sql .= $this->_getWhere();

		return $sql;
	}

	/**
	 * @param string|null $tablename
	 *
	 * @return \chillerlan\Database\Query\UpdateInterface
	 */
	public function table(string $tablename):UpdateInterface{
		$this->table = $tablename;

		return $this;
	}

	/**
	 * @param array $set
	 * @param bool  $bind
	 *
	 * @return \chillerlan\Database\Query\UpdateInterface
	 */
	public function set(array $set, bool $bind = true):UpdateInterface{

		foreach($set as $k => $v){

			if($v instanceof StatementInterface){
				$this->set[] = $this->quote($k).' = ('.$v->sql().')';
				$this->bindValues = array_merge($this->bindValues, $v->bindValues());
			}
			elseif(is_array($v)){

This elseif statement is empty, and could be removed.

				// [expr, bindval1, bindval2, ...]

47% of this comment could be valid code. Did you maybe forget this after debugging?

			}
			else{
				if($bind){
					$this->set[] = $this->quote($k).' = ?';
					$this->bindValues[] = $v;
				}
				else{
					$this->set[] = $this->quote($k).' = '.$v;
				}
			}
		}

		return $this;
	}

	/**
	 * @param        $val1
	 * @param        $val2
	 * @param string $operator
	 * @param bool   $bind
	 * @param string $join
	 *
	 * @return \chillerlan\Database\Query\UpdateInterface
	 */
	public function where($val1, $val2, $operator = '=', $bind = true, $join = 'AND'):UpdateInterface{
		return $this->_addWhere($val1, $val2, $operator, $bind, $join);
	}

	/**
	 * @param null $join
	 *
	 * @return \chillerlan\Database\Query\UpdateInterface
	 */
	public function openBracket($join = null):UpdateInterface{
		return $this->_openBracket($join); // @codeCoverageIgnore
	}

	/**
	 * @return \chillerlan\Database\Query\UpdateInterface
	 */
	public function closeBracket():UpdateInterface{
		return $this->_closeBracket(); // @codeCoverageIgnore
	}

}