keboola/php-datatypes

View on GitHub
src/Definition/MySQL.php

Summary

Maintainability
F
3 days
Test Coverage

Function validateLength has a Cognitive Complexity of 67 (exceeds 5 allowed). Consider refactoring.
Open

    private function validateLength(string $type, $length = null): void
    {
        $valid = true;
        switch (strtoupper($type)) {
            case 'CHAR':
Severity: Minor
Found in src/Definition/MySQL.php - About 1 day 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 validateLength has 124 lines of code (exceeds 25 allowed). Consider refactoring.
Open

    private function validateLength(string $type, $length = null): void
    {
        $valid = true;
        switch (strtoupper($type)) {
            case 'CHAR':
Severity: Major
Found in src/Definition/MySQL.php - About 4 hrs to fix

    The class MySQL has an overall complexity of 100 which is very high. The configured complexity threshold is 50.
    Invalid

    class MySQL extends Common
    {
        public const TYPES = [
            'INTEGER', 'INT',
            'TINYINT', 'SMALLINT', 'MEDIUMINT', 'BIGINT',
    Severity: Minor
    Found in src/Definition/MySQL.php by phpmd

    File MySQL.php has 257 lines of code (exceeds 250 allowed). Consider refactoring.
    Open

    <?php
    
    declare(strict_types=1);
    
    namespace Keboola\Datatype\Definition;
    Severity: Minor
    Found in src/Definition/MySQL.php - About 2 hrs to fix

      Method getBasetype has 33 lines of code (exceeds 25 allowed). Consider refactoring.
      Open

          public function getBasetype(): string
          {
              switch (strtoupper($this->type)) {
                  case 'INT':
                  case 'INTEGER':
      Severity: Minor
      Found in src/Definition/MySQL.php - About 1 hr to fix

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

            public function getBasetype(): string
            {
                switch (strtoupper($this->type)) {
                    case 'INT':
                    case 'INTEGER':
        Severity: Minor
        Found in src/Definition/MySQL.php - About 35 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 validateLength() has 132 lines of code. Current threshold is set to 100. Avoid really long methods.
        Open

            private function validateLength(string $type, $length = null): void
            {
                $valid = true;
                switch (strtoupper($type)) {
                    case 'CHAR':
        Severity: Minor
        Found in src/Definition/MySQL.php by phpmd

        The method validateLength() has an NPath complexity of 1888. The configured NPath complexity threshold is 200.
        Open

            private function validateLength(string $type, $length = null): void
            {
                $valid = true;
                switch (strtoupper($type)) {
                    case 'CHAR':
        Severity: Minor
        Found in src/Definition/MySQL.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 validateLength() has a Cyclomatic Complexity of 63. The configured cyclomatic complexity threshold is 10.
        Open

            private function validateLength(string $type, $length = null): void
            {
                $valid = true;
                switch (strtoupper($type)) {
                    case 'CHAR':
        Severity: Minor
        Found in src/Definition/MySQL.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

        The method getBasetype() has a Cyclomatic Complexity of 18. The configured cyclomatic complexity threshold is 10.
        Invalid

            public function getBasetype(): string
            {
                switch (strtoupper($this->type)) {
                    case 'INT':
                    case 'INTEGER':
        Severity: Minor
        Found in src/Definition/MySQL.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 unused parameters such as '$basetype'.
        Open

            public static function getTypeByBasetype(string $basetype): string
        Severity: Minor
        Found in src/Definition/MySQL.php by phpmd

        UnusedFormalParameter

        Since: 0.2

        Avoid passing parameters to methods or constructors and then not using those parameters.

        Example

        class Foo
        {
            private function bar($howdy)
            {
                // $howdy is not used
            }
        }

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

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

            private function getLengthFromArray(array $lengthOptions): ?string
            {
                $expectedOptions = ['character_maximum', 'numeric_precision', 'numeric_scale'];
                $diff = array_diff(array_keys($lengthOptions), $expectedOptions);
                if ($diff !== []) {
        Severity: Major
        Found in src/Definition/MySQL.php and 2 other locations - About 6 hrs to fix
        src/Definition/Redshift.php on lines 108..127
        src/Definition/Snowflake.php on lines 168..187

        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 217.

        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

        There are no issues that match your filters.

        Category
        Status