Asymptix/Framework

View on GitHub
framework/db/DBQueryCondition.php

Summary

Maintainability
D
1 day
Test Coverage

Function __construct has a Cognitive Complexity of 32 (exceeds 5 allowed). Consider refactoring.
Open

    public function __construct(DBField $field, $conditionType, $value) {
        $this->type = self::sqlConditionType($conditionType);
        if (!Tools::isInstanceOf($value, "DBField")) {
            $this->field = $field;

Severity: Minor
Found in framework/db/DBQueryCondition.php - About 4 hrs to fix

Cognitive Complexity

Cognitive Complexity is a measure of how difficult a unit of code is to intuitively understand. Unlike Cyclomatic Complexity, which determines how difficult your code will be to test, Cognitive Complexity tells you how difficult your code will be to read and comprehend.

A method's cognitive complexity is based on a few simple rules:

  • Code is not considered more complex when it uses shorthand that the language provides for collapsing multiple statements into one
  • Code is considered more complex for each "break in the linear flow of the code"
  • Code is considered more complex when "flow breaking structures are nested"

Further reading

Method __construct has 91 lines of code (exceeds 25 allowed). Consider refactoring.
Open

    public function __construct(DBField $field, $conditionType, $value) {
        $this->type = self::sqlConditionType($conditionType);
        if (!Tools::isInstanceOf($value, "DBField")) {
            $this->field = $field;

Severity: Major
Found in framework/db/DBQueryCondition.php - About 3 hrs to fix

    Function getSQLCondition has a Cognitive Complexity of 18 (exceeds 5 allowed). Consider refactoring.
    Open

        public static function getSQLCondition($queryCondition, $operator = "") {
            $operator = strtoupper(trim($operator));
            if ($operator === "OR" || $operator === "AND") {
                if (is_array($queryCondition)) {
                    if ($operator === "AND") {
    Severity: Minor
    Found in framework/db/DBQueryCondition.php - About 2 hrs to fix

    Cognitive Complexity

    Cognitive Complexity is a measure of how difficult a unit of code is to intuitively understand. Unlike Cyclomatic Complexity, which determines how difficult your code will be to test, Cognitive Complexity tells you how difficult your code will be to read and comprehend.

    A method's cognitive complexity is based on a few simple rules:

    • Code is not considered more complex when it uses shorthand that the language provides for collapsing multiple statements into one
    • Code is considered more complex for each "break in the linear flow of the code"
    • Code is considered more complex when "flow breaking structures are nested"

    Further reading

    Method getSQLCondition has 28 lines of code (exceeds 25 allowed). Consider refactoring.
    Open

        public static function getSQLCondition($queryCondition, $operator = "") {
            $operator = strtoupper(trim($operator));
            if ($operator === "OR" || $operator === "AND") {
                if (is_array($queryCondition)) {
                    if ($operator === "AND") {
    Severity: Minor
    Found in framework/db/DBQueryCondition.php - About 1 hr to fix

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

          private static function sqlConditionType($conditionType) {
              $conditionType = preg_replace("#[[:blank:]]{2,}#", " ", strtolower(trim($conditionType)));
      
              $conditionTypes = [
                  // Equal operator
      Severity: Minor
      Found in framework/db/DBQueryCondition.php - About 1 hr to fix

        The method __construct() has 105 lines of code. Current threshold is set to 100. Avoid really long methods.
        Open

            public function __construct(DBField $field, $conditionType, $value) {
                $this->type = self::sqlConditionType($conditionType);
                if (!Tools::isInstanceOf($value, "DBField")) {
                    $this->field = $field;
        
        
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        The method __construct() has a Cyclomatic Complexity of 30. The configured cyclomatic complexity threshold is 10.
        Open

            public function __construct(DBField $field, $conditionType, $value) {
                $this->type = self::sqlConditionType($conditionType);
                if (!Tools::isInstanceOf($value, "DBField")) {
                    $this->field = $field;
        
        
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        CyclomaticComplexity

        Since: 0.1

        Complexity is determined by the number of decision points in a method plus one for the method entry. The decision points are 'if', 'while', 'for', and 'case labels'. Generally, 1-4 is low complexity, 5-7 indicates moderate complexity, 8-10 is high complexity, and 11+ is very high complexity.

        Example

        // Cyclomatic Complexity = 11
        class Foo {
        1   public function example() {
        2       if ($a == $b) {
        3           if ($a1 == $b1) {
                        fiddle();
        4           } elseif ($a2 == $b2) {
                        fiddle();
                    } else {
                        fiddle();
                    }
        5       } elseif ($c == $d) {
        6           while ($c == $d) {
                        fiddle();
                    }
        7        } elseif ($e == $f) {
        8           for ($n = 0; $n < $h; $n++) {
                        fiddle();
                    }
                } else {
                    switch ($z) {
        9               case 1:
                            fiddle();
                            break;
        10              case 2:
                            fiddle();
                            break;
        11              case 3:
                            fiddle();
                            break;
                        default:
                            fiddle();
                            break;
                    }
                }
            }
        }

        Source https://phpmd.org/rules/codesize.html#cyclomaticcomplexity

        Avoid using static access to class 'Asymptix\db\DBField' in method '__construct'.
        Open

                                                . DBField::sqlValue($this->field->type, $value);
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        StaticAccess

        Since: 1.4.0

        Static access causes unexchangeable dependencies to other classes and leads to hard to test code. Avoid using static access at all costs and instead inject dependencies through the constructor. The only case when static access is acceptable is when used for factory methods.

        Example

        class Foo
        {
            public function bar()
            {
                Bar::baz();
            }
        }

        Source https://phpmd.org/rules/cleancode.html#staticaccess

        Avoid using static access to class 'Asymptix\db\DBField' in method '__construct'.
        Open

                            $this->preparedData = [DBField::sqlValue($this->field->type, $value)];
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        StaticAccess

        Since: 1.4.0

        Static access causes unexchangeable dependencies to other classes and leads to hard to test code. Avoid using static access at all costs and instead inject dependencies through the constructor. The only case when static access is acceptable is when used for factory methods.

        Example

        class Foo
        {
            public function bar()
            {
                Bar::baz();
            }
        }

        Source https://phpmd.org/rules/cleancode.html#staticaccess

        The method __construct uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
        Open

                } else {
                    $field1 = $field;
                    $field2 = $value;
        
                    switch ($this->type) {
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        ElseExpression

        Since: 1.4.0

        An if expression with an else branch is basically not necessary. You can rewrite the conditions in a way that the else clause is not necessary and the code becomes simpler to read. To achieve this, use early return statements, though you may need to split the code it several smaller methods. For very simple assignments you could also use the ternary operations.

        Example

        class Foo
        {
            public function bar($flag)
            {
                if ($flag) {
                    // one branch
                } else {
                    // another branch
                }
            }
        }

        Source https://phpmd.org/rules/cleancode.html#elseexpression

        Avoid using static access to class 'Asymptix\db\DBField' in method '__construct'.
        Open

                            $this->value = DBField::castValue($this->field->type, $value);
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        StaticAccess

        Since: 1.4.0

        Static access causes unexchangeable dependencies to other classes and leads to hard to test code. Avoid using static access at all costs and instead inject dependencies through the constructor. The only case when static access is acceptable is when used for factory methods.

        Example

        class Foo
        {
            public function bar()
            {
                Bar::baz();
            }
        }

        Source https://phpmd.org/rules/cleancode.html#staticaccess

        Avoid using static access to class 'Asymptix\db\DBField' in method '__construct'.
        Open

                                                . DBField::sqlValue($this->field->type, $value);
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        StaticAccess

        Since: 1.4.0

        Static access causes unexchangeable dependencies to other classes and leads to hard to test code. Avoid using static access at all costs and instead inject dependencies through the constructor. The only case when static access is acceptable is when used for factory methods.

        Example

        class Foo
        {
            public function bar()
            {
                Bar::baz();
            }
        }

        Source https://phpmd.org/rules/cleancode.html#staticaccess

        The method getSQLCondition uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
        Open

                } else {
                    if (is_array($queryCondition)) {
                        foreach ($queryCondition as $operation => $conditions) {
                            return trim(
                                str_replace(["(1 AND ", "(0 OR "], "(",
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        ElseExpression

        Since: 1.4.0

        An if expression with an else branch is basically not necessary. You can rewrite the conditions in a way that the else clause is not necessary and the code becomes simpler to read. To achieve this, use early return statements, though you may need to split the code it several smaller methods. For very simple assignments you could also use the ternary operations.

        Example

        class Foo
        {
            public function bar($flag)
            {
                if ($flag) {
                    // one branch
                } else {
                    // another branch
                }
            }
        }

        Source https://phpmd.org/rules/cleancode.html#elseexpression

        The method getSQLCondition uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
        Open

                        } else {
                            $cond = " (0";
                        }
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        ElseExpression

        Since: 1.4.0

        An if expression with an else branch is basically not necessary. You can rewrite the conditions in a way that the else clause is not necessary and the code becomes simpler to read. To achieve this, use early return statements, though you may need to split the code it several smaller methods. For very simple assignments you could also use the ternary operations.

        Example

        class Foo
        {
            public function bar($flag)
            {
                if ($flag) {
                    // one branch
                } else {
                    // another branch
                }
            }
        }

        Source https://phpmd.org/rules/cleancode.html#elseexpression

        Avoid using static access to class '\Asymptix\core\Tools' in method 'getSQLCondition'.
        Open

                    } elseif (Tools::isInstanceOf($queryCondition, "\Asymptix\db\DBQueryCondition")) {
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        StaticAccess

        Since: 1.4.0

        Static access causes unexchangeable dependencies to other classes and leads to hard to test code. Avoid using static access at all costs and instead inject dependencies through the constructor. The only case when static access is acceptable is when used for factory methods.

        Example

        class Foo
        {
            public function bar()
            {
                Bar::baz();
            }
        }

        Source https://phpmd.org/rules/cleancode.html#staticaccess

        Avoid using static access to class 'Asymptix\db\DBField' in method '__construct'.
        Open

                                    $dataList[] = DBField::sqlValue($this->field->type, $dataItem);
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        StaticAccess

        Since: 1.4.0

        Static access causes unexchangeable dependencies to other classes and leads to hard to test code. Avoid using static access at all costs and instead inject dependencies through the constructor. The only case when static access is acceptable is when used for factory methods.

        Example

        class Foo
        {
            public function bar()
            {
                Bar::baz();
            }
        }

        Source https://phpmd.org/rules/cleancode.html#staticaccess

        The method __construct uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
        Open

                                } else {
                                    $this->sqlCondition = "1";
        
                                    return;
                                }
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        ElseExpression

        Since: 1.4.0

        An if expression with an else branch is basically not necessary. You can rewrite the conditions in a way that the else clause is not necessary and the code becomes simpler to read. To achieve this, use early return statements, though you may need to split the code it several smaller methods. For very simple assignments you could also use the ternary operations.

        Example

        class Foo
        {
            public function bar($flag)
            {
                if ($flag) {
                    // one branch
                } else {
                    // another branch
                }
            }
        }

        Source https://phpmd.org/rules/cleancode.html#elseexpression

        Avoid using static access to class 'Asymptix\db\DBField' in method '__construct'.
        Open

                                $to = DBField::sqlValue($this->field->type, $value[1]);
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        StaticAccess

        Since: 1.4.0

        Static access causes unexchangeable dependencies to other classes and leads to hard to test code. Avoid using static access at all costs and instead inject dependencies through the constructor. The only case when static access is acceptable is when used for factory methods.

        Example

        class Foo
        {
            public function bar()
            {
                Bar::baz();
            }
        }

        Source https://phpmd.org/rules/cleancode.html#staticaccess

        The method __construct uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
        Open

                            } else {
                                throw new DBQueryConditionException("Invalid data for 'IN'/'NOT IN' condition");
                            }
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        ElseExpression

        Since: 1.4.0

        An if expression with an else branch is basically not necessary. You can rewrite the conditions in a way that the else clause is not necessary and the code becomes simpler to read. To achieve this, use early return statements, though you may need to split the code it several smaller methods. For very simple assignments you could also use the ternary operations.

        Example

        class Foo
        {
            public function bar($flag)
            {
                if ($flag) {
                    // one branch
                } else {
                    // another branch
                }
            }
        }

        Source https://phpmd.org/rules/cleancode.html#elseexpression

        Avoid using static access to class 'Asymptix\db\DBField' in method '__construct'.
        Open

                                $from = DBField::sqlValue($this->field->type, $value[0]);
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        StaticAccess

        Since: 1.4.0

        Static access causes unexchangeable dependencies to other classes and leads to hard to test code. Avoid using static access at all costs and instead inject dependencies through the constructor. The only case when static access is acceptable is when used for factory methods.

        Example

        class Foo
        {
            public function bar()
            {
                Bar::baz();
            }
        }

        Source https://phpmd.org/rules/cleancode.html#staticaccess

        The method __construct uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
        Open

                            } else {
                                throw new DBQueryConditionException("Invalid data for 'BETWEEN' condition");
                            }
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        ElseExpression

        Since: 1.4.0

        An if expression with an else branch is basically not necessary. You can rewrite the conditions in a way that the else clause is not necessary and the code becomes simpler to read. To achieve this, use early return statements, though you may need to split the code it several smaller methods. For very simple assignments you could also use the ternary operations.

        Example

        class Foo
        {
            public function bar($flag)
            {
                if ($flag) {
                    // one branch
                } else {
                    // another branch
                }
            }
        }

        Source https://phpmd.org/rules/cleancode.html#elseexpression

        Avoid using static access to class '\Asymptix\core\Tools' in method '__construct'.
        Open

                if (!Tools::isInstanceOf($value, "DBField")) {
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        StaticAccess

        Since: 1.4.0

        Static access causes unexchangeable dependencies to other classes and leads to hard to test code. Avoid using static access at all costs and instead inject dependencies through the constructor. The only case when static access is acceptable is when used for factory methods.

        Example

        class Foo
        {
            public function bar()
            {
                Bar::baz();
            }
        }

        Source https://phpmd.org/rules/cleancode.html#staticaccess

        Avoid using static access to class 'Asymptix\db\DBField' in method '__construct'.
        Open

                            $this->value = DBField::castValue($this->field->type, $value);
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        StaticAccess

        Since: 1.4.0

        Static access causes unexchangeable dependencies to other classes and leads to hard to test code. Avoid using static access at all costs and instead inject dependencies through the constructor. The only case when static access is acceptable is when used for factory methods.

        Example

        class Foo
        {
            public function bar()
            {
                Bar::baz();
            }
        }

        Source https://phpmd.org/rules/cleancode.html#staticaccess

        Avoid using static access to class 'Asymptix\db\DBField' in method '__construct'.
        Open

                            $this->preparedData = [DBField::sqlValue($this->field->type, $value)];
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        StaticAccess

        Since: 1.4.0

        Static access causes unexchangeable dependencies to other classes and leads to hard to test code. Avoid using static access at all costs and instead inject dependencies through the constructor. The only case when static access is acceptable is when used for factory methods.

        Example

        class Foo
        {
            public function bar()
            {
                Bar::baz();
            }
        }

        Source https://phpmd.org/rules/cleancode.html#staticaccess

        TODO found
        Open

                    //TODO: add all conditions from http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by fixme

        Avoid variables with short names like $to. Configured minimum length is 3.
        Open

                                $to = DBField::sqlValue($this->field->type, $value[1]);
        Severity: Minor
        Found in framework/db/DBQueryCondition.php by phpmd

        ShortVariable

        Since: 0.2

        Detects when a field, local, or parameter has a very short name.

        Example

        class Something {
            private $q = 15; // VIOLATION - Field
            public static function main( array $as ) { // VIOLATION - Formal
                $r = 20 + $this->q; // VIOLATION - Local
                for (int $i = 0; $i < 10; $i++) { // Not a Violation (inside FOR)
                    $r += $this->q;
                }
            }
        }

        Source https://phpmd.org/rules/naming.html#shortvariable

        There are no issues that match your filters.

        Category
        Status