Puzzle\QueryBuilder\Queries\Snippets\Builders\Join

Complexity

Total Complexity

9

Size/Duplication

Total Lines	69
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

Test Coverage

Coverage

100%

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	innerJoin()	0	6	1
A	leftJoin()	0	6	1
A	rightJoin()	0	6	1
A	on()	0	7	1
A	using()	0	7	1
A	buildJoin()	0	11	2
A	getLastJoin()	0	11	2

<?php

declare(strict_types = 1);

namespace Puzzle\QueryBuilder\Queries\Snippets\Builders;

use Puzzle\QueryBuilder\Queries\Snippets;

trait Join
{
    protected
        $joins = array();

The visibility should be declared for property $joins.

    public function innerJoin(string $table, ?string $alias = null): self
    {
        $this->joins[] = new Snippets\Joins\InnerJoin($table, $alias);

        return $this;
    }

    public function leftJoin(string $table, ?string $alias = null): self
    {
        $this->joins[] = new Snippets\Joins\LeftJoin($table, $alias);

        return $this;
    }

    public function rightJoin(string $table, ?string $alias = null): self
    {
        $this->joins[] = new Snippets\Joins\RightJoin($table, $alias);

        return $this;
    }

    public function on(string $leftColumn, string $rightColumn): self
    {
        $join = $this->getLastJoin();
        $join->on($leftColumn, $rightColumn);

        return $this;
    }

    /**
     * @param array[string]|string $column

The doc-type array[string]|string could not be parsed: Expected "]" at position 2, but found "string". (view supported doc-types)

     */
    public function using($column): self
    {
        $join = $this->getLastJoin();
        $join->using($column);

        return $this;
    }

    protected function buildJoin(): string
    {
        $joins = [];

        foreach($this->joins as $innerJoin)
        {
            $joins[] = $innerJoin->toString();
        }

        return implode(' ', $joins);
    }

    private function getLastJoin(): Snippets\Join
    {
        $lastJoins = end($this->joins);

        if(! $lastJoins instanceof Snippets\Join)
        {
            throw new \LogicException('Erreur dans la récupération de la dernière jointure');
        }

        return $lastJoins;
    }
}