HandlesAliases::registerTableAlias() - Code Metrics - Inspection of "fix: table alias was set to null in returndocs" - LaravelFreelancerNL/laravel-arangodb - Measure and Improve Code Quality continuously with Scrutinizer

Failed Conditions

Push — 184-support-wheredoesnthaverel... ( 76eefa...5b2c01 )

by Bas

created 2025-01-19 00:02 UTC

HandlesAliases::registerTableAlias() B

↳ Parent: HandlesAliases

Complexity

Conditions	10
Paths	24

Size

Total Lines	29
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	11
CRAP Score	11.897

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	10
eloc	14
c	1
b	0
f	0
nc	24
nop	2
dl	0
loc	29
ccs	11
cts	15
cp	0.7332
crap	11.897
rs	7.6666

How to fix Complexity

<?php

declare(strict_types=1);

namespace LaravelFreelancerNL\Aranguent\Query\Concerns;

use Exception;
use Illuminate\Database\Eloquent\Builder as IlluminateEloquentBuilder;
use Illuminate\Database\Eloquent\Relations\Relation;
use Illuminate\Database\Query\Expression;
use Illuminate\Support\Str;
use Illuminate\Database\Query\Builder as IlluminateQueryBuilder;
use LaravelFreelancerNL\Aranguent\Query\Builder;

trait HandlesAliases
{
    /**
     * @var array<string, Expression|string>
     */
    public array $tableAliases = [];

    /**
     * @var array<string, Expression|string>
     */
    public array $columnAliases = [];

    /**
     * @param  array<mixed>|string  $column
     * @return array<mixed>|string
     */
    public function convertColumnId(array|string|Expression $column): array|string|Expression
    {

        if ($column instanceof Expression) {

            return $column;
        }

        return $this->convertIdToKey($column);
        return $this->/** @scrutinizer ignore-call */ convertIdToKey($column);
    }

    /**
     * Extract table and alias from sql alias notation (entity AS `alias`)
     *
     * @return array<int|string, Expression|string>
     *
     * @throws Exception
     */
    public function extractAlias(string $entity, int|null|string $key = null): array
    {
        $results = preg_split("/\sas\s/i", $entity);

        if ($results === false) {
            throw new Exception('Column splitting failed');
        }

        if (isset($results[1])) {
            $results[1] = trim($results[1], '`');
        }
        if (!isset($results[1]) && is_string($key)) {
            $results[1] = $key;
        }
        if (!isset($results[1])) {
            $results[1] = $results[0];
        }

        return $results;
    }

    public function generateTableAlias(string|Expression $table, string $postfix = 'Doc'): string
    {
        if ($table instanceof Expression) {
            return 'Expression' . spl_object_id($table);
        }
        return Str::camel(Str::singular($table)) . $postfix;
    }

    public function getTableAlias(string|Expression $table): float|int|null|string
    {
        if ($table instanceof Expression) {
            $table = 'Expression' . spl_object_id($table);
        }

        if ($this->isTableAlias($table)) {
            return $table;
        }

        if (!isset($this->tableAliases[$table])) {
            return null;
        }

        return $this->grammar->getValue($this->tableAliases[$table]);
    }

    public function getColumnAlias(string $column): Expression|null|string
    {
        if (isset($this->columnAliases[$column])) {
            return $this->columnAliases[$column];
        }

        return null;
    }

    /**
     * @return array<string, Expression|string>
     */
    public function getTableAliases(): array
    {
        return $this->tableAliases;
    }

    /**
     * @param array<string, Expression|string>|IlluminateQueryBuilder $aliases
     * @return void
     */
    public function importTableAliases(array|IlluminateQueryBuilder $aliases): void
    {
        if ($aliases instanceof IlluminateQueryBuilder) {

            assert($aliases instanceof Builder);
            $aliases = $aliases->getTableAliases();
        }

        $this->tableAliases = array_merge($this->tableAliases, $aliases);
    }

    /**
     * @param IlluminateEloquentBuilder|IlluminateQueryBuilder|Relation $query
     * @return void
     */
    public function exchangeTableAliases($query): void
    {
        assert($query instanceof Builder);

        $this->importTableAliases($query);
        $query->importTableAliases($this);
        $query->importTableAliases(/** @scrutinizer ignore-type */ $this);
    }

    public function isTableAlias(string $value): bool
    {
        return in_array($value, $this->tableAliases);
    }

    public function isTable(string $value): bool
    {
        return array_key_exists($value, $this->tableAliases);
    }

    public function prefixAlias(string $target, string $value): string
    {
        /** @phpstan-ignore-next-line */
        $alias =  $this->grammar->getValue($this->getTableAlias($target));

        if (Str::startsWith($value, $alias . '.')) {
            return $value;
        }

        return $alias . '.' . $value;
    }

    /**
     * @throws Exception
     */
    public function registerColumnAlias(string $column, ?string $alias = null): bool
    {
        if (preg_match("/\sas\s/i", $column)) {
            [$column, $alias] = $this->extractAlias($column);
        }

        if (isset($alias) && !$column instanceof Expression) {
            $this->columnAliases[$column] = $alias;

            return true;
        }

        return false;
    }

    /**
     * @SuppressWarnings(PHPMD.CyclomaticComplexity)
     */
    public function registerTableAlias(string|Expression $table, ?string $alias = null): string
    {
        if ($table instanceof Expression  && $alias !== null) {
            $table = 'Expression' . spl_object_id($table);
        }

        if ($table instanceof Expression && $alias === null) {
            $table = 'Expression' . spl_object_id($table);
            $alias = $table;
        }

        /** @phpstan-ignore-next-line  */
        if ($alias == null && is_string($table) && stripos($table, ' as ') !== false) {

            $tableParts = [];

            if (preg_match("/(^.*) as (.*?)$/", $table, $tableParts)) {
                $table = $tableParts[1];
                $alias = $tableParts[2];
            }
        }

        if ($alias == null) {
            $alias = $this->generateTableAlias($table);
        }

        /** @phpstan-ignore-next-line  */
        $this->tableAliases[$table] = $alias;

        return $alias;
    }

    public function replaceTableForAlias(string $reference): string
    {
        $referenceParts = explode('.', $reference);
        $first = array_shift($referenceParts);
        /** @phpstan-ignore-next-line */
        $alias = $this->grammar->getValue($this->getTableAlias($first));
        if ($alias == null) {
            $alias = $first;
        }
        array_unshift($referenceParts, $alias);

        return implode('.', $referenceParts);
    }
}


LaravelFreelancerNL / laravel-arangodb

Push — 184-support-wheredoesnthaverel... ( 76eefa...5b2c01 )

HandlesAliases::registerTableAlias() B

Complexity

Size

Duplication

Code Coverage

Importance

How to fix Complexity

Long Method

Duplication Side-by-Side

Filter issues like