lib/Ajde/Db/PDOStatement.php

Summary

Maintainability
B
6 hrs
Test Coverage

Function execute has a Cognitive Complexity of 21 (exceeds 5 allowed). Consider refactoring.
Open

    public function execute($input_parameters = null)
    {
        $log = ['query' => ''];
        if (config('app.debug') === true) {
            //$cache = Ajde_Db_Cache::getInstance();
Severity: Minor
Found in lib/Ajde/Db/PDOStatement.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 execute has 51 lines of code (exceeds 25 allowed). Consider refactoring.
Open

    public function execute($input_parameters = null)
    {
        $log = ['query' => ''];
        if (config('app.debug') === true) {
            //$cache = Ajde_Db_Cache::getInstance();
Severity: Major
Found in lib/Ajde/Db/PDOStatement.php - About 2 hrs to fix

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

        public static function getEmulatedSql($sql, $PDOValues)
        {
            // @see http://stackoverflow.com/questions/210564/pdo-prepared-statements/1376838#1376838
            $keys = [];
            $values = [];
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.php - About 55 mins 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

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

        public function execute($input_parameters = null)
        {
            $log = ['query' => ''];
            if (config('app.debug') === true) {
                //$cache = Ajde_Db_Cache::getInstance();
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.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 '82', column '27').
    Open

                    throw new Ajde_Db_IntegrityException($e->getMessage());
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.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 '89', column '31').
    Open

                        throw new Ajde_Db_Exception($e->getMessage());
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.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 execute uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
    Open

                    } else {
                        Ajde_Exception_Log::logException($e);
                        die('DB connection problem. <a href="?install=1">Install database?</a>');
                    }
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.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 execute uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
    Open

                } else {
                    if (config('app.debug') === true) {
                        if (isset($this->queryString)) {
                            dump($this->queryString);
                        }
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.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 execute uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
    Open

                } else {
                    $log = ['query' => '[PS] '.$this->queryString];
                }
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.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 getEmulatedSql uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
    Open

                } else {
                    $values[] = '"'.$value.'"';
                }
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.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 'Ajde_Exception_Log' in method 'execute'.
    Open

                        Ajde_Exception_Log::logException($e);
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.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 getEmulatedSql uses an else expression. Else clauses are basically not necessary and you can simplify the code by not using them.
    Open

                } else {
                    $keys[] = '/[?]/';
                }
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.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 empty try-catch blocks in execute.
    Open

                    } catch (Exception $e) {
                    }
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.php by phpmd

    EmptyCatchBlock

    Since: 2.7.0

    Usually empty try-catch is a bad idea because you are silently swallowing an error condition and then continuing execution. Occasionally this may be the right thing to do, but often it's a sign that a developer saw an exception, didn't know what to do about it, and so used an empty catch to silence the problem.

    Example

    class Foo {
    
      public function bar()
      {
          try {
              // ...
          } catch (Exception $e) {} // empty catch block
      }
    }

    Source https://phpmd.org/rules/design.html#emptycatchblock

    The method execute() contains an exit expression.
    Open

                        die('DB connection problem. <a href="?install=1">Install database?</a>');
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.php by phpmd

    ExitExpression

    Since: 0.2

    An exit-expression within regular code is untestable and therefore it should be avoided. Consider to move the exit-expression into some kind of startup script where an error/exception code is returned to the calling environment.

    Example

    class Foo {
        public function bar($param)  {
            if ($param === 42) {
                exit(23);
            }
        }
    }

    Source https://phpmd.org/rules/design.html#exitexpression

    Avoid unused local variables such as '$count'.
    Open

            $query = preg_replace($keys, $values, $sql, -1, $count);
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.php by phpmd

    UnusedLocalVariable

    Since: 0.2

    Detects when a local variable is declared and/or assigned, but not used.

    Example

    class Foo {
        public function doSomething()
        {
            $i = 5; // Unused
        }
    }

    Source https://phpmd.org/rules/unusedcode.html#unusedlocalvariable

    Identical blocks of code found in 2 locations. Consider refactoring.
    Open

                } else {
                    if (config('app.debug') === true) {
                        if (isset($this->queryString)) {
                            dump($this->queryString);
                        }
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.php and 1 other location - About 50 mins to fix
    lib/Ajde/Db/PDO.php on lines 32..43

    Duplicated Code

    Duplicated code can lead to software that is hard to understand and difficult to change. The Don't Repeat Yourself (DRY) principle states:

    Every piece of knowledge must have a single, unambiguous, authoritative representation within a system.

    When you violate DRY, bugs and maintenance problems are sure to follow. Duplicated code has a tendency to both continue to replicate and also to diverge (leaving bugs as two similar implementations differ in subtle ways).

    Tuning

    This issue has a mass of 97.

    We set useful threshold defaults for the languages we support but you may want to adjust these settings based on your project guidelines.

    The threshold configuration represents the minimum mass a code block must have to be analyzed for duplication. The lower the threshold, the more fine-grained the comparison.

    If the engine is too easily reporting duplication, try raising the threshold. If you suspect that the engine isn't catching enough duplication, try lowering the threshold. The best setting tends to differ from language to language.

    See codeclimate-duplication's documentation for more information about tuning the mass threshold in your .codeclimate.yml.

    Refactorings

    Further Reading

    The class Ajde_Db_PDOStatement is not named in CamelCase.
    Open

    class Ajde_Db_PDOStatement extends PDOStatement
    {
        /**
         * @see http://www.php.net/manual/en/book.pdo.php#73568
         */
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.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

    The parameter $input_parameters is not named in camelCase.
    Open

        public function execute($input_parameters = null)
        {
            $log = ['query' => ''];
            if (config('app.debug') === true) {
                //$cache = Ajde_Db_Cache::getInstance();
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.php by phpmd

    CamelCaseParameterName

    Since: 0.2

    It is considered best practice to use the camelCase notation to name parameters.

    Example

    class ClassName {
        public function doSomething($user_name) {
        }
    }

    Source

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

                $i = 0;
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.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

    The parameter $PDOValues is not named in camelCase.
    Open

        public static function getEmulatedSql($sql, $PDOValues)
        {
            // @see http://stackoverflow.com/questions/210564/pdo-prepared-statements/1376838#1376838
            $keys = [];
            $values = [];
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.php by phpmd

    CamelCaseParameterName

    Since: 0.2

    It is considered best practice to use the camelCase notation to name parameters.

    Example

    class ClassName {
        public function doSomething($user_name) {
        }
    }

    Source

    The variable $input_parameters is not named in camelCase.
    Open

        public function execute($input_parameters = null)
        {
            $log = ['query' => ''];
            if (config('app.debug') === true) {
                //$cache = Ajde_Db_Cache::getInstance();
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.php by phpmd

    CamelCaseVariableName

    Since: 0.2

    It is considered best practice to use the camelCase notation to name variables.

    Example

    class ClassName {
        public function doSomething() {
            $data_module = new DataModule();
        }
    }

    Source

    The variable $input_parameters is not named in camelCase.
    Open

        public function execute($input_parameters = null)
        {
            $log = ['query' => ''];
            if (config('app.debug') === true) {
                //$cache = Ajde_Db_Cache::getInstance();
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.php by phpmd

    CamelCaseVariableName

    Since: 0.2

    It is considered best practice to use the camelCase notation to name variables.

    Example

    class ClassName {
        public function doSomething() {
            $data_module = new DataModule();
        }
    }

    Source

    The variable $input_parameters is not named in camelCase.
    Open

        public function execute($input_parameters = null)
        {
            $log = ['query' => ''];
            if (config('app.debug') === true) {
                //$cache = Ajde_Db_Cache::getInstance();
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.php by phpmd

    CamelCaseVariableName

    Since: 0.2

    It is considered best practice to use the camelCase notation to name variables.

    Example

    class ClassName {
        public function doSomething() {
            $data_module = new DataModule();
        }
    }

    Source

    The variable $PDOValues is not named in camelCase.
    Open

        public static function getEmulatedSql($sql, $PDOValues)
        {
            // @see http://stackoverflow.com/questions/210564/pdo-prepared-statements/1376838#1376838
            $keys = [];
            $values = [];
    Severity: Minor
    Found in lib/Ajde/Db/PDOStatement.php by phpmd

    CamelCaseVariableName

    Since: 0.2

    It is considered best practice to use the camelCase notation to name variables.

    Example

    class ClassName {
        public function doSomething() {
            $data_module = new DataModule();
        }
    }

    Source

    There are no issues that match your filters.

    Category
    Status