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

Complexity

Total Complexity

17

Size/Duplication

Total Lines	114
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

7 Methods

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

<?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.7
 */

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.

    }

    /**
     * @inheritDoc
     * @throws DatabaseException
     */
    public function isNull(string $column): DbalInterface
    {
        return $this->criteria($column, '=', null);
    }

    /**
     * @inheritDoc
     * @throws DatabaseException
     */
    public function isNotNull(string $column): DbalInterface
    {
        return $this->criteria($column, '!=', null);
    }

    /**
     * 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)
    {
        $escapeMap = [
            '\\' => '\\\\',
            '.' => '\.',
            '^' => '\^',
            '$' => '\$',
            '*' => '\*',
            '+' => '\+',
            '?' => '\?',
            '(' => '\(',
            ')' => '\)',
            '[' => '\[',
            ']' => '\]',
            '{' => '\{',
            '}' => '\}',
            '|' => '\|'
        ];

        if (is_array($value)) {
            return array_map(function ($v) use ($escapeMap) {
                return is_string($v) ? strtr($v, $escapeMap) : $v;
            }, $value);
        }

        return is_string($value) ? strtr($value, $escapeMap) : $value;
    }
}