Wandu\Database\Query\Expression\LogicalExpression

Complexity

Total Complexity

17

Size/Duplication

Total Lines	102
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Test Coverage

Coverage

100%

Importance

Changes

0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	where()	0	4	1
A	andWhere()	0	5	1
A	orWhere()	0	5	1
D	addWhereQuery()	0	30	9
A	toSql()	0	14	4
A	getBindings()	0	6	1

<?php
namespace Wandu\Database\Query\Expression;

use Wandu\Database\Contracts\ExpressionInterface;

/**
 * LogicalExpression = '(' ComparisonExpression (' AND '|' OR ') LogicalExpression ')' | ComparisonExpression
 *
 * @example `abc` = 30
 * @example (`abc` = 30 AND `foo` = 30 OR `foo` = 40)
 */
class LogicalExpression implements ExpressionInterface
{
    /** @var array */
    protected $operators = [];
    
    /** @var \Wandu\Database\Contracts\ExpressionInterface[] */
    protected $expressions = [];

    /**
     * @param string|array|callable $name
     * @param string $operator
     * @param string $value
     * @return static
     */
    public function where($name, $operator = null, $value = null)
    {
        return $this->andWhere($name, $operator, $value);
    }

    /**
     * @param string|array|callable $name
     * @param string $operator
     * @param string $value
     * @return static
     */
    public function andWhere($name, $operator = null, $value = null)
    {
        $this->addWhereQuery('AND', $name, $operator, $value);
        return $this;
    }

    /**
     * @param string|array|callable $name
     * @param string $operator
     * @param string $value
     * @return static
     */
    public function orWhere($name, $operator = null, $value = null)
    {
        $this->addWhereQuery('OR', $name, $operator, $value);
        return $this;
    }

    protected function addWhereQuery($logicalOp, $name, $operator = null, $value = null)
    {
        if (!is_string($name) && is_callable($name)) {
            $newWhere = new LogicalExpression();
            $newWhereResult = call_user_func($name, $newWhere);
            $this->operators[] = $logicalOp;
            $this->expressions[] = $newWhereResult ?: $newWhere;
        } elseif (!is_array($name)) {
            if (!isset($value)) {
                $value = $operator;
                $operator = '=';
            }
            $this->operators[] = $logicalOp;
            $this->expressions[] = new ComparisonExpression($name, $operator, $value);
        } else {
            foreach ($name as $column => $value) {
                if (is_array($value)) {
                    $newWhere = new LogicalExpression();
                    foreach ($value as $innerOperator => $innerValue) {
                        $newWhere->andWhere($column, $innerOperator, $innerValue);

It seems like $column can also be of type integer; however, Wandu\Database\Query\Expression\LogicalExpression::andWhere() does only seem to accept callable, maybe add an additional type check?

                    }
                    $this->operators[] = $logicalOp;
                    $this->expressions[] = $newWhere;
                } else {
                    $this->operators[] = $logicalOp;
                    $this->expressions[] = new ComparisonExpression($column, '=', $value);
                }
            }
        }
    }

    /**
     * {@inheritdoc}
     */
    public function toSql()
    {
        $sql = '';
        foreach ($this->expressions as $index => $expression) {
            if ($index) {
                $sql .= ' ' . $this->operators[$index] . ' ';
            }
            $sql .= $expression->toSql();
        }
        if (count($this->expressions) > 1) {
            $sql = "(" . $sql . ")";
        }
        return $sql;
    }

    /**
     * {@inheritdoc}
     */
    public function getBindings()
    {
        return array_reduce($this->expressions, function ($carry, ExpressionInterface $expression) {
            return array_merge($carry, $expression->getBindings());
        }, []);
    }
}