Puzzle\QueryBuilder\Queries\Snippets\Joins\AbstractJoin

Complexity

Total Complexity

13

Size/Duplication

Total Lines	83
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Test Coverage

Coverage

100%

Importance

Changes

0

8 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	5	1
A	using()	0	8	1
A	on()	0	7	1
A	toString()	0	13	1
A	hasNeededTable()	0	8	3
	getJoinDeclaration()	0	1	?
A	buildUsingConditionClause()	0	9	2
A	buildOnConditionClause()	0	14	4

<?php

declare(strict_types = 1);

namespace Puzzle\QueryBuilder\Queries\Snippets\Joins;

use Puzzle\QueryBuilder\Snippet;
use Puzzle\QueryBuilder\Queries\Snippets\Join;
use Puzzle\QueryBuilder\Queries\Snippets;
use Puzzle\QueryBuilder\Queries\Snippets\NeedTableAware;

abstract class AbstractJoin implements Join, Snippet, NeedTableAware
{
    private
        $table,

It is generally advisable to only define one property per statement.

        $using,
        $on;

    public function __construct(string $table, ?string $alias = null)
    {
        $this->table = new Snippets\TableName($table, $alias);
        $this->on = [];
    }

    /**
     * @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
    {
        $this->on = [];

        $this->using = new Snippets\Using($column);

        return $this;
    }

    public function on(?string $leftColumn, ?string $rightColumn): self
    {
        $this->using = null;
        $this->on[] = new Snippets\On($leftColumn, $rightColumn);

        return $this;
    }

    public function toString(): string
    {
        $joinQueryPart = sprintf(
            '%s %s',
            $this->getJoinDeclaration(),
            $this->table->toString()
        );

        $joinQueryPart .= $this->buildOnConditionClause();
        $joinQueryPart .= $this->buildUsingConditionClause();

        return $joinQueryPart;
    }

    public function hasNeededTable(string $tableName): bool
    {
        if($this->table->getName() === $tableName || $this->table->getAlias() === $tableName)
        {
            return true;
        }
        return false;
    }

    abstract protected function getJoinDeclaration(): string;

    private function buildUsingConditionClause(): string
    {
        if(!$this->using instanceof Snippet)
        {
            return '';
        }

        return ' ' . $this->using->toString();
    }

    private function buildOnConditionClause(): string
    {
        $conditionClause = array();

        foreach($this->on as $on)
        {
            if($on instanceof Snippet)
            {
                $conditionClause[] = $on->toString();
            }
        }

        return empty($conditionClause) ? '' : ' ' . implode('', $conditionClause);
    }
}