File ezQuery.php has 748 lines of code (exceeds 250 allowed). Consider refactoring.

Wontfix

<?php

namespace ezsql;

use ezsql\ezSchema;

ezQuery has 54 functions (exceeds 20 allowed). Consider refactoring.

Wontfix

class ezQuery implements ezQueryInterface
{
    protected $select_result = true;
    protected $prepareActive = false;
    protected $preparedValues = array();

Function select has a Cognitive Complexity of 37 (exceeds 5 allowed). Consider refactoring.

Open

    public function select(string $table = null, $columnFields = '*', ...$conditions)
    {
        $getFromTable = $this->fromTable;
        $getSelect_result = $this->select_result;
        $getIsInto = $this->isInto;

• Read up
  Read up

Function _query_insert_replace has a Cognitive Complexity of 34 (exceeds 5 allowed). Consider refactoring.

Open

    private function _query_insert_replace($table = '', $keyValue = null, $type = '', $execute = true)
    {
        if ((!\is_array($keyValue) && ($execute)) || empty($table)) {
            return $this->clearPrepare();
        }

• Read up
  Read up

Method select has 75 lines of code (exceeds 25 allowed). Consider refactoring.

Open

    public function select(string $table = null, $columnFields = '*', ...$conditions)
    {
        $getFromTable = $this->fromTable;
        $getSelect_result = $this->select_result;
        $getIsInto = $this->isInto;

Method create has 53 lines of code (exceeds 25 allowed). Consider refactoring.

Wontfix

    public function create(string $table = null, ...$schemas)
    {
        $vendor = get_vendor();
        if (empty($table) || empty($schemas) || empty($vendor))
            return false;

Function where has a Cognitive Complexity of 16 (exceeds 5 allowed). Consider refactoring.

Open

    public function where(...$conditions)
    {

        if (empty($conditions))
            return false;

• Read up
  Read up

Function create has a Cognitive Complexity of 15 (exceeds 5 allowed). Consider refactoring.

Open

    public function create(string $table = null, ...$schemas)
    {
        $vendor = get_vendor();
        if (empty($table) || empty($schemas) || empty($vendor))
            return false;

• Read up
  Read up

Method _query_insert_replace has 45 lines of code (exceeds 25 allowed). Consider refactoring.

Wontfix

    private function _query_insert_replace($table = '', $keyValue = null, $type = '', $execute = true)
    {
        if ((!\is_array($keyValue) && ($execute)) || empty($table)) {
            return $this->clearPrepare();
        }

Function update has a Cognitive Complexity of 13 (exceeds 5 allowed). Consider refactoring.

Open

    public function update(string $table = null, $keyValue, ...$whereConditions)
    {
        if (!\is_array($keyValue) || empty($table)) {
            return $this->clearPrepare();
        }

• Read up
  Read up

Method where has 30 lines of code (exceeds 25 allowed). Consider refactoring.

Wontfix

    public function where(...$conditions)
    {

        if (empty($conditions))
            return false;

Function alter has a Cognitive Complexity of 10 (exceeds 5 allowed). Consider refactoring.

Open

    public function alter(string $table = null, ...$alteringSchema)
    {
        if (empty($table) || empty($alteringSchema))
            return false;

• Read up
  Read up

Method retrieveConditions has 27 lines of code (exceeds 25 allowed). Consider refactoring.

Wontfix

    private function retrieveConditions($whereConditions)
    {
        $whereConditions = $this->flattenWhereConditions($whereConditions);
        $whereKey = [];
        $whereValue = [];

Consider simplifying this complex logical expression.

Open

                if ($joinSet || $skipWhere || $groupBySet || $havingSet || $orderBySet || $limitSet || $unionSet) {
                    $where = $args_by;
                    $skipWhere = true;
                }

Function retrieveConditions has a Cognitive Complexity of 9 (exceeds 5 allowed). Consider refactoring.

Open

    private function retrieveConditions($whereConditions)
    {
        $whereConditions = $this->flattenWhereConditions($whereConditions);
        $whereKey = [];
        $whereValue = [];

• Read up
  Read up

Method joining has 7 arguments (exceeds 4 allowed). Consider refactoring.

Wontfix

        String $type = \_INNER,
        string $leftTable = null,
        string $rightTable = null,
        string $leftColumn = null,
        string $rightColumn = null,

Function processConditions has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring.

Open

    private function processConditions($column, $condition, $value, $valueOrCombine, $extraCombine)
    {
        if (!\in_array($condition, \_BOOLEAN_OPERATORS))
            return $this->clearPrepare();

• Read up
  Read up

Method innerJoin has 6 arguments (exceeds 4 allowed). Consider refactoring.

Wontfix

        string $leftTable = null,
        string $rightTable = null,
        string $leftColumn = null,
        string $rightColumn = null,
        string $tableAs = null,

Method rightJoin has 6 arguments (exceeds 4 allowed). Consider refactoring.

Wontfix

        string $leftTable = null,
        string $rightTable = null,
        string $leftColumn = null,
        string $rightColumn = null,
        string $tableAs = null,

Method leftJoin has 6 arguments (exceeds 4 allowed). Consider refactoring.

Wontfix

        string $leftTable = null,
        string $rightTable = null,
        string $leftColumn = null,
        string $rightColumn = null,
        string $tableAs = null,

Method fullJoin has 6 arguments (exceeds 4 allowed). Consider refactoring.

Wontfix

        string $leftTable = null,
        string $rightTable = null,
        string $leftColumn = null,
        string $rightColumn = null,
        string $tableAs = null,

Function grouping has a Cognitive Complexity of 8 (exceeds 5 allowed). Consider refactoring.

Wontfix

    public function grouping(...$whereConditions)
    {
        if (empty($whereConditions))
            return false;

• Read up
  Read up

Consider simplifying this complex logical expression.

Wontfix

        if (($condition == \_BETWEEN) || ($condition == \_notBETWEEN)) {
            $this->conditionBetween($column, $condition, $value, $valueOrCombine, $extraCombine);
        } elseif ($condition == \_IN) {
            $this->conditionIn($column, $condition, $value, $valueOrCombine);
        } elseif (((\strtolower($value) == 'null') || ($condition == 'IS') || ($condition == 'IS NOT'))) {

Method conditions has 5 arguments (exceeds 4 allowed). Consider refactoring.

Wontfix

    private function conditions($key, $condition, $value, $combine, $extra)

Method conditionBetween has 5 arguments (exceeds 4 allowed). Consider refactoring.

Wontfix

    private function conditionBetween($key, $condition, $valueOne, $valueTwo, $combine)

Method insert_select has 5 arguments (exceeds 4 allowed). Consider refactoring.

Wontfix

    public function insert_select(string $toTable = null, $toColumns = '*', $fromTable = null, $fromColumns = '*', ...$conditions)

Method processConditions has 5 arguments (exceeds 4 allowed). Consider refactoring.

Wontfix

    private function processConditions($column, $condition, $value, $valueOrCombine, $extraCombine)

Function joining has a Cognitive Complexity of 7 (exceeds 5 allowed). Consider refactoring.

Open

    private function joining(
        String $type = \_INNER,
        string $leftTable = null,
        string $rightTable = null,
        string $leftColumn = null,

• Read up
  Read up

Avoid too many return statements within this method.

Wontfix

        return $this->clearPrepare();

Avoid too many return statements within this method.

Wontfix

                    return false;

Avoid too many return statements within this method.

Wontfix

            return " $whereOrHaving $where ";

Avoid too many return statements within this method.

Wontfix

        return ($where != '1') ? " $whereOrHaving $where " : ' ';

Avoid too many return statements within this method.

Wontfix

            return $sql;

Function create_schema has a Cognitive Complexity of 6 (exceeds 5 allowed). Consider refactoring.

Open

    private function create_schema(array ...$columnDataOptions)
    {
        if (empty($columnDataOptions))
            return false;

• Read up
  Read up