LaravelFreelancerNL\Aranguent\Query\Concerns\HandlesAliases

Complexity

Total Complexity

35

Size/Duplication

Total Lines	165
Duplicated Lines	0 %

Importance

Changes

0

12 Methods

Rating	Name	Duplication	Size	Complexity
A	getTableAlias()	0	11	3
A	getTableAliases()	0	3	1
A	registerColumnAlias()	0	13	3
A	extractAlias()	0	19	6
A	getColumnAlias()	0	7	2
A	isTableAlias()	0	3	1
A	generateTableAlias()	0	6	2
B	registerTableAlias()	0	25	8
A	importTableAliases()	0	7	3
A	replaceTableForAlias()	0	11	2
A	convertColumnId()	0	8	2
A	prefixAlias()	0	9	2

<?php

declare(strict_types=1);

namespace LaravelFreelancerNL\Aranguent\Query\Concerns;

use Exception;
use Illuminate\Database\Query\Expression;
use Illuminate\Support\Str;
use Illuminate\Database\Query\Builder as IlluminateQueryBuilder;

trait HandlesAliases
{
    protected $tableAliases = [];

    protected $columnAliases = [];

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

        if ($column instanceof Expression) {

$column is never a sub-type of Illuminate\Database\Query\Expression.

            return $column;
        }

        return $this->convertIdToKey($column);

It seems like convertIdToKey() must be provided by classes using this trait. How about adding it as abstract method to this trait?

    }

    /**
     * Extract table and alias from sql alias notation (entity AS `alias`)
     *
     * @return array<mixed>
     *
     * @throws Exception
     */
    public function extractAlias(string $entity, int|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): string|null
    {
        if ($table instanceof Expression) {
            $table = 'Expression' . spl_object_id($table);
        }

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

        return null;
    }

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

        return null;
    }

    public function getTableAliases(): array
    {
        return $this->tableAliases;
    }

    public function importTableAliases(array|IlluminateQueryBuilder $aliases): void
    {
        if ($aliases instanceof IlluminateQueryBuilder) {

$aliases is never a sub-type of Illuminate\Database\Query\Builder.

            $aliases = $aliases->getTableAliases();
        }
        foreach($aliases as $key => $value) {
            $this->tableAliases[$key] = $value;
        }
    }

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

    public function prefixAlias(string $target, string $value): string
    {
        $alias = $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)) {
            $this->columnAliases[$column] = $alias;

            return true;
        }

        return false;
    }

    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;
        }

        if ($alias == null && stripos($table, ' as ') !== false) {

It seems like $table can also be of type Illuminate\Database\Query\Expression; however, parameter $haystack of stripos() does only seem to accept string, maybe add an additional type check?

It seems like you are loosely comparing $alias of type null|string against null; this is ambiguous if the string can be empty. Consider using a strict comparison === instead.

            $tableParts = [];
            preg_match("/(^.*) as (.*?)$/", $table, $tableParts);

It seems like $table can also be of type Illuminate\Database\Query\Expression; however, parameter $subject of preg_match() does only seem to accept string, maybe add an additional type check?

            $table = $tableParts[1];
            $alias = $tableParts[2];
        }

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

        $this->tableAliases[$table] = $alias;

        return $alias;
    }

    public function replaceTableForAlias($reference): string
    {
        $referenceParts = explode('.', $reference);
        $first = array_shift($referenceParts);
        $alias = $this->getTableAlias($first);
        if ($alias == null) {

It seems like you are loosely comparing $alias of type null|string against null; this is ambiguous if the string can be empty. Consider using a strict comparison === instead.

            $alias = $first;
        }
        array_unshift($referenceParts, $alias);

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