lib/Ajde/Query.php

Summary

Maintainability
B
6 hrs
Test Coverage

Function getSql has a Cognitive Complexity of 27 (exceeds 5 allowed). Consider refactoring.
Open

    public function getSql()
    {
        $sql = '';
        $distinct = $this->distinct ? 'DISTINCT ' : '';

Severity: Minor
Found in lib/Ajde/Query.php - About 3 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 getSql has 57 lines of code (exceeds 25 allowed). Consider refactoring.
Open

    public function getSql()
    {
        $sql = '';
        $distinct = $this->distinct ? 'DISTINCT ' : '';

Severity: Major
Found in lib/Ajde/Query.php - About 2 hrs to fix

    The method getSql() has an NPath complexity of 11520. The configured NPath complexity threshold is 200.
    Open

        public function getSql()
        {
            $sql = '';
            $distinct = $this->distinct ? 'DISTINCT ' : '';
    
    
    Severity: Minor
    Found in lib/Ajde/Query.php by phpmd

    NPathComplexity

    Since: 0.1

    The NPath complexity of a method is the number of acyclic execution paths through that method. A threshold of 200 is generally considered the point where measures should be taken to reduce complexity.

    Example

    class Foo {
        function bar() {
            // lots of complicated code
        }
    }

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

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

        public function getSql()
        {
            $sql = '';
            $distinct = $this->distinct ? 'DISTINCT ' : '';
    
    
    Severity: Minor
    Found in lib/Ajde/Query.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

    Missing class import via use statement (line '101', column '23').
    Open

                throw new Ajde_Exception('FROM clause can not be empty in query');
    Severity: Minor
    Found in lib/Ajde/Query.php by phpmd

    MissingImport

    Since: 2.7.0

    Importing all external classes in a file through use statements makes them clearly visible.

    Example

    function make() {
        return new \stdClass();
    }

    Source http://phpmd.org/rules/cleancode.html#MissingImport

    Missing class import via use statement (line '71', column '23').
    Open

                throw new Ajde_Exception('Collection ordering direction "'.$direction.'" not valid');
    Severity: Minor
    Found in lib/Ajde/Query.php by phpmd

    MissingImport

    Since: 2.7.0

    Importing all external classes in a file through use statements makes them clearly visible.

    Example

    function make() {
        return new \stdClass();
    }

    Source http://phpmd.org/rules/cleancode.html#MissingImport

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

            } else {
                $sql .= ' FROM '.implode(', ', $this->from);
            }
    Severity: Minor
    Found in lib/Ajde/Query.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 getSql uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
    Open

            } else {
                $sql .= 'SELECT '.$distinct.implode(', ', $this->select);
            }
    Severity: Minor
    Found in lib/Ajde/Query.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

    TODO found
    Open

                // TODO:
    Severity: Minor
    Found in lib/Ajde/Query.php by fixme

    TODO found
    Open

                // TODO:
    Severity: Minor
    Found in lib/Ajde/Query.php by fixme

    The class Ajde_Query is not named in CamelCase.
    Open

    class Ajde_Query extends Ajde_Object_Standard
    {
        const ORDER_ASC = 'ASC';
        const ORDER_DESC = 'DESC';
    
    
    Severity: Minor
    Found in lib/Ajde/Query.php by phpmd

    CamelCaseClassName

    Since: 0.2

    It is considered best practice to use the CamelCase notation to name classes.

    Example

    class class_name {
    }

    Source

    There are no issues that match your filters.

    Category
    Status