Asymptix/Framework

View on GitHub
framework/db/DBQuery.php

Summary

Maintainability
A
2 hrs
Test Coverage

Function showQueryDebugInfo has a Cognitive Complexity of 14 (exceeds 5 allowed). Consider refactoring.
Open

    public static function showQueryDebugInfo($query = "", $types = "", array $params = []) {
        OutputStream::start();
        if (!empty($query)) {
            if (empty($types) && empty($params)) {
                OutputStream::message(OutputStream::MSG_INFO, "Q: " . $query);
Severity: Minor
Found in framework/db/DBQuery.php - About 1 hr 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 showQueryDebugInfo has 26 lines of code (exceeds 25 allowed). Consider refactoring.
Open

    public static function showQueryDebugInfo($query = "", $types = "", array $params = []) {
        OutputStream::start();
        if (!empty($query)) {
            if (empty($types) && empty($params)) {
                OutputStream::message(OutputStream::MSG_INFO, "Q: " . $query);
Severity: Minor
Found in framework/db/DBQuery.php - About 1 hr to fix

    Avoid using static access to class 'Asymptix\db\DBQueryType' in method 'setType'.
    Open

            if (DBQueryType::isValidQueryType($type)) {
    Severity: Minor
    Found in framework/db/DBQuery.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\core\OutputStream' in method 'showQueryDebugInfo'.
    Open

                        OutputStream::message(OutputStream::MSG_INFO, "Q: " . $query);
    Severity: Minor
    Found in framework/db/DBQuery.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\core\OutputStream' in method 'showQueryDebugInfo'.
    Open

                        OutputStream::message(OutputStream::MSG_ERROR, "Number of types is not equal parameters number.");
    Severity: Minor
    Found in framework/db/DBQuery.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\core\OutputStream' in method 'showQueryDebugInfo'.
    Open

            OutputStream::close();
    Severity: Minor
    Found in framework/db/DBQuery.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 'showQueryDebugInfo'.
    Open

                            $paramsStr[] = $types[$i] . ": " . DBField::sqlValue($types[$i], $params[$i]);
    Severity: Minor
    Found in framework/db/DBQuery.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\core\OutputStream' in method 'showQueryDebugInfo'.
    Open

                        OutputStream::message(OutputStream::MSG_INFO, "T: " . $types);
    Severity: Minor
    Found in framework/db/DBQuery.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\core\OutputStream' in method 'showQueryDebugInfo'.
    Open

                    OutputStream::message(OutputStream::MSG_INFO, "Q: " . $query);
    Severity: Minor
    Found in framework/db/DBQuery.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\core\OutputStream' in method 'showQueryDebugInfo'.
    Open

                        OutputStream::message(OutputStream::MSG_INFO, "A: [" . implode(", ", $paramsStr) . "]");
    Severity: Minor
    Found in framework/db/DBQuery.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 showQueryDebugInfo uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
    Open

            } else {
                OutputStream::message(OutputStream::MSG_WARNING, "DB query is empty.");
            }
    Severity: Minor
    Found in framework/db/DBQuery.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\DBQueryType' in method 'isSelector'.
    Open

            return DBQueryType::isSelector($this->getType());
    Severity: Minor
    Found in framework/db/DBQuery.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\core\OutputStream' in method 'showQueryDebugInfo'.
    Open

                        OutputStream::message(OutputStream::MSG_INFO, "P: " . $preparedQuery);
    Severity: Minor
    Found in framework/db/DBQuery.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 showQueryDebugInfo uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
    Open

                } else {
                    if (strlen($types) === count($params)) {
                        $query = preg_replace('/\s+/', ' ', $query);
                        $preparedQuery = $query;
    
    
    Severity: Minor
    Found in framework/db/DBQuery.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\DBQueryType' in method 'detectType'.
    Open

            return DBQueryType::detectQueryType($this->query);
    Severity: Minor
    Found in framework/db/DBQuery.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\core\OutputStream' in method 'showQueryDebugInfo'.
    Open

            OutputStream::start();
    Severity: Minor
    Found in framework/db/DBQuery.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\core\OutputStream' in method 'showQueryDebugInfo'.
    Open

                        OutputStream::message(OutputStream::MSG_INFO, "A: [" . implode(", ", $params) . "]");
    Severity: Minor
    Found in framework/db/DBQuery.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\core\OutputStream' in method 'showQueryDebugInfo'.
    Open

                OutputStream::message(OutputStream::MSG_WARNING, "DB query is empty.");
    Severity: Minor
    Found in framework/db/DBQuery.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 'showQueryDebugInfo'.
    Open

                            $query = preg_replace("/\?/", DBField::sqlValue($types[$i], $params[$i]), $query, 1);
    Severity: Minor
    Found in framework/db/DBQuery.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\DBQueryType' in method 'isModifier'.
    Open

            return DBQueryType::isModifier($this->getType());
    Severity: Minor
    Found in framework/db/DBQuery.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 setType uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
    Open

            } else {
                throw new DBCoreException("Invalid SQL query type '" . $type . "'");
            }
    Severity: Minor
    Found in framework/db/DBQuery.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 showQueryDebugInfo uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
    Open

                    } else {
                        OutputStream::message(OutputStream::MSG_ERROR, "Number of types is not equal parameters number.");
                        OutputStream::message(OutputStream::MSG_INFO, "T: " . $types);
                        OutputStream::message(OutputStream::MSG_INFO, "A: [" . implode(", ", $params) . "]");
                    }
    Severity: Minor
    Found in framework/db/DBQuery.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

    There are no issues that match your filters.

    Category
    Status