SupportsHasManyJsonCompositeKeys::getRelationExistenceQueryWithCompositeKey() - Code Metrics - Inspection of "Merge branch '1.10'" - staudenmeir/eloquent-json-relations - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 3263b5...c3fb84 )

by Jonas

created 2024-03-18 16:58 UTC

getRelationExistenceQueryWithCompositeKey() A

↳ Parent: SupportsHasManyJsonCompositeKeys

Complexity

Conditions	2
Paths	2

Size

Total Lines	9
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	2
eloc	6
c	1
b	0
f	0
nc	2
nop	1
dl	0
loc	9
rs	10

<?php

namespace Staudenmeir\EloquentJsonRelations\Relations\Traits\CompositeKeys;

use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Collection as BaseCollection;

trait SupportsHasManyJsonCompositeKeys
{
    /**
     * Determine whether the relationship has a composite key.
     *
     * @return bool
     */
    protected function hasCompositeKey(): bool
    {
        return is_array($this->foreignKey);
    }

    /**
     * Set the base constraints on the relation query for a composite key.
     *
     * @return void
     */
    protected function addConstraintsWithCompositeKey(): void
    {
        $columns = array_slice($this->localKey, 1);

        foreach ($columns as $column) {
            $this->query->where(
                $this->related->qualifyColumn($column),
                '=',
                $this->parent->$column
            );
        }
    }

    /**
     * Set the constraints for an eager load of the relation for a composite key.
     *
     * @param array $models
     * @return void
     */
    protected function addEagerConstraintsWithCompositeKey(array $models): void
    {
        $keys = (new BaseCollection($models))->map(
        $keys = (new BaseCollection(/** @scrutinizer ignore-type */ $models))->map(
            function (Model $model) {
                return array_map(
                    fn (string $column) => $model[$column],
                    $this->localKey
                );
            }
        )->values()->unique(null, true)->all();

        $this->query->where(
            function (Builder $query) use ($keys) {
                foreach ($keys as $key) {
                    $query->orWhere(
                        function (Builder $query) use ($key) {
                            foreach ($this->foreignKey as $i => $column) {
                                if ($i === 0) {
                                    $this->whereJsonContainsOrMemberOf(
                                           whereJsonContainsOrMemberOf(
                                        $query,
                                        $this->path,
                                        $key[$i],
                                        fn ($parentKey) => $this->parentKeyToArray($parentKey)
                                        fn ($parentKey) => $this->/** @scrutinizer ignore-call */ parentKeyToArray($parentKey)
                                    );
                                } else {
                                    $query->where(
                                        $this->related->qualifyColumn($column),
                                        '=',
                                        $key[$i]
                                    );
                                }
                            }
                        }
                    );
                }
            }
        );
    }

    /**
     * Match the eagerly loaded results to their parents for a composite key.
     *
     * @param array $models
     * @param \Illuminate\Database\Eloquent\Collection $results
     * @param string $relation
     * @return array
     */
    protected function matchWithCompositeKey(array $models, Collection $results, string $relation): array
    {
        $dictionary = $this->buildDictionaryWithCompositeKey($results);

        foreach ($models as $model) {
            $values = array_map(
                fn ($key) => $model->$key,
                $this->localKey
            );

            $key = implode("\0", $values);

            if (isset($dictionary[$key])) {
                $model->setRelation(
                    $relation,
                    $this->getRelationValue($dictionary, $key, 'many')
                           getRelationValue($dictionary, $key, 'many')
                );
            }
        }

        return $models;
    }

    /**
     * Build model dictionary keyed by the relation's composite foreign key.
     *
     * @param \Illuminate\Database\Eloquent\Collection $results
     * @return array
     */
    protected function buildDictionaryWithCompositeKey(Collection $results): array
    {
        $dictionary = [];

        $foreignKey = $this->getForeignKeyName();
        $foreignKey = $this->getForeignKeyName();

        $additionalColumns = $this->getAdditionalForeignKeyNames();

        foreach ($results as $result) {
            $additionalValues = array_map(
                fn (string $column) => $result->getAttribute($column),
                $additionalColumns
            );

            foreach($result->$foreignKey as $value) {
                $values = [$value, ...$additionalValues];

                $key = implode("\0", $values);

                $dictionary[$key][] = $result;
            }
        }

        return $dictionary;
    }

    /**
     * Add the constraints for a relationship query for a composite key.
     *
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @return void
     */
    public function getRelationExistenceQueryWithCompositeKey(Builder $query): void
    {
        $columns = $this->getAdditionalForeignKeyNames();

        foreach ($columns as $i => $column) {
            $query->whereColumn(
                $this->parent->qualifyColumn($column),
                '=',
                $query->qualifyColumn($this->localKey[$i])
            );
        }
    }

    /**
     * Get the plain additional foreign keys.
     *
     * @return array
     */
    protected function getAdditionalForeignKeyNames(): array
    {
        $names = [];

        $columns = array_slice($this->foreignKey, 1, preserve_keys: true);

        foreach ($columns as $i => $column) {
            $segments = explode('.', $column);

            $names[$i] = end($segments);
        }

        return $names;
    }
}


staudenmeir / eloquent-json-relations

Push — master ( 3263b5...c3fb84 )

getRelationExistenceQueryWithCompositeKey() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like