Quantum\Libraries\Database\Adapters\Sleekdb\Statements\Criteria

Complexity

Total Complexity

15

Size/Duplication

Total Lines	79
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	criteria()	0	9	2
A	orCriteria()	0	7	3
A	criterias()	0	11	4
A	sanitizeValue()	0	9	4
A	having()	0	9	2

<?php

/**
 * Quantum PHP Framework
 *
 * An open source software development framework for PHP
 *
 * @package Quantum
 * @author Arman Ag. <arman.ag@softberg.org>
 * @copyright Copyright (c) 2018 Softberg LLC (https://softberg.org)
 * @link http://quantum.softberg.org/
 * @since 2.9.6
 */

namespace Quantum\Libraries\Database\Adapters\Sleekdb\Statements;

use Quantum\Libraries\Database\Exceptions\DatabaseException;
use Quantum\Libraries\Database\Contracts\DbalInterface;

/**
 * Trait Criteria
 * @package Quantum\Libraries\Database
 */
trait Criteria
{

    /**
     * @inheritDoc
     * @throws DatabaseException
     */
    public function criteria(string $column, string $operator, $value = null): DbalInterface
    {
        if (!in_array($operator, $this->operators)) {
            throw DatabaseException::operatorNotSupported($operator);
        }

        $this->criterias[] = [$column, $operator, $this->sanitizeValue($value)];

The property criterias does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        return $this;

The expression return $this returns the type Quantum\Libraries\Database\Adapters\Sleekdb\Statements\Criteria which is incompatible with the type-hinted return Quantum\Libraries\Database\Contracts\DbalInterface.

    }

    /**
     * @inheritDoc
     * @throws DatabaseException
     */
    public function criterias(...$criterias): DbalInterface
    {
        foreach ($criterias as $criteria) {
            if (isset($criteria[0]) && is_array($criteria[0])) {
                $this->orCriteria($criteria);
            } else {
                $this->criteria(...$criteria);

The call to Quantum\Libraries\Database\Adapters\Sleekdb\Statements\Criteria::criteria() has too few arguments starting with operator.

            }
        }

        return $this;

The expression return $this returns the type Quantum\Libraries\Database\Adapters\Sleekdb\Statements\Criteria which is incompatible with the type-hinted return Quantum\Libraries\Database\Contracts\DbalInterface.

    }

    /**
     * @inheritDoc
     * @throws DatabaseException
     */
    public function having(string $column, string $operator, string $value = null): DbalInterface
    {
        if (!in_array($operator, $this->operators)) {
            throw DatabaseException::operatorNotSupported($operator);
        }

        $this->havings[] = [$column, $operator, $value];

The property havings does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

        return $this;

The expression return $this returns the type Quantum\Libraries\Database\Adapters\Sleekdb\Statements\Criteria which is incompatible with the type-hinted return Quantum\Libraries\Database\Contracts\DbalInterface.

    }

    /**
     * Adds one or more OR criteria in brackets
     * @param array $orCriterias
     * @throws DatabaseException
     */
    protected function orCriteria(array $orCriterias)
    {
        foreach ($orCriterias as $index => $criteria) {
            $this->criteria(...$criteria);

The call to Quantum\Libraries\Database\Adapters\Sleekdb\Statements\Criteria::criteria() has too few arguments starting with operator.

            if ($index != array_key_last($orCriterias)) {
                $this->criterias[] = 'OR';

The property criterias does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly.

            }
        }
    }

    /**
     * @param $value
     * @return mixed|string|null
     */
    protected function sanitizeValue($value)
    {
        if (is_array($value)) {
            return array_map(function ($v) {
                return is_string($v) ? preg_quote($v, '/') : $v;
            }, $value);
        }

        return is_string($value) ? preg_quote($value, '/') : $value;
    }
}