Query::getHaving() - Code Metrics - Inspection of "#66 worst rated operations" - xsolve-pl/salesforce-client - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#67)

by Paweł

created 2017-01-23 09:07 UTC

Query::getHaving() A

↳ Parent: Query

Complexity

Conditions	1
Paths	1

Size

Total Lines	4
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	2
CRAP Score	1

Importance

Changes

Metric	Value
dl	0
loc	4
ccs	2
cts	2
cp	1
rs	10
c	0
b	0
f	0
cc	1
eloc	2
nc	1
nop	0
crap	1

<?php

namespace Xsolve\SalesforceClient\QueryBuilder;

use Xsolve\SalesforceClient\QueryBuilder\Expr\Compare\AbstractCompare;
use Xsolve\SalesforceClient\QueryBuilder\Expr\ExprInterface;
use Xsolve\SalesforceClient\QueryBuilder\Expr\From\AbstractFrom;
use Xsolve\SalesforceClient\QueryBuilder\Expr\GroupBy\AbstractGroupBy;
use Xsolve\SalesforceClient\QueryBuilder\Expr\OrderBy\AbstractOrderBy;
use Xsolve\SalesforceClient\QueryBuilder\Expr\Select\AbstractSelect;
use Xsolve\SalesforceClient\QueryBuilder\Visitor\Parameters\ParametersReplacingVisitor;
use Xsolve\SalesforceClient\QueryBuilder\Visitor\VisiteeInterface;
use Xsolve\SalesforceClient\QueryBuilder\Visitor\VisitorInterface;

class Query
{
    /**
     * @var AbstractSelect[]
     */
    private $selects = [];

    /**
     * @var AbstractFrom|null
     */
    private $from;

    /**
     * @var AbstractCompare|null
     */
    private $where;

    /**
     * @var AbstractGroupBy|null
     */
    private $groupBy;

    /**
     * @var AbstractCompare|null
     */
    private $having;

    /**
     * @var AbstractOrderBy|null
     */
    private $orderBy;

    /**
     * @var int|null
     */
    private $limit;

    /**
     * @var int|null
     */
    private $offset;

    /**
     * @var VisitorInterface[]
     */
    private $visitors;

    /**
     * @param VisitorInterface[] $visitors
     */
    public function __construct(array $visitors = [])
    {
        $this->visitors = $visitors;
    }

    public function addSelect(AbstractSelect $select)
    {
        $this->selects[] = $select;
    }

    public function setFrom(AbstractFrom $from)
    {
        $this->from = $from;
    }

    public function setWhere(AbstractCompare $where)
    {
        $this->where = $where;
    }

    public function setGroupBy(AbstractGroupBy $groupBy)
    {
        $this->groupBy = $groupBy;
    }

    public function setHaving(AbstractCompare $having)
    {
        $this->having = $having;
    }

    /**
     * @return AbstractCompare|null
     */
    public function getWhere()
    {
        return $this->where;
    }

    /**
     * @return AbstractCompare|null
     */
    public function getHaving()
    {
        return $this->having;
    }

    public function setOrderBy(AbstractOrderBy $orderBy)
    {
        $this->orderBy = $orderBy;
    }

    public function setLimit(int $limit)
    {
        $this->limit = $limit;
    }

    public function setOffset(int $offset)
    {
        $this->offset = $offset;
    }

    public function setParameters(array $parameters)
    {
        $this->visitors[] = new ParametersReplacingVisitor($parameters);
    }

    public function parse(): string
    {
        $this->validate();
        $this->visitQueryParts();

        return $this->parseSelect()
            . $this->parseWhere()
            . $this->parseGroupBy()
            . $this->parseHaving()
            . $this->parseOrderBy()
            . $this->parseLimit()
            . $this->parseOffset();
    }

    private function validate()
    {
        if (empty($this->selects) || null === $this->from) {
            throw new \LogicException('At least SELECT and FROM must be defined');
        }
    }

    private function visitQueryParts()
    {
        foreach ($this->visitors as $visitor) {
            foreach ($this->getQueryParts() as $queryPart) {
                if ($queryPart instanceof VisiteeInterface) {
                    $queryPart->accept($visitor);
                }
            }
        }
    }

    /**
     * @return ExprInterface[]
     */
    private function getQueryParts(): array
    {
        return array_merge(
            $this->selects,
            [$this->from],
            [$this->where],
            [$this->groupBy],
            [$this->having],
            [$this->orderBy]
        );
    }

    private function parseSelect(): string
    {
        $selects = implode(', ', array_map(
            function (AbstractSelect $select): string {
                return $select->asSOQL();
            },
            $this->selects
        ));

        return sprintf('SELECT %s FROM %s', $selects, $this->from->asSOQL());
    }

    private function parseWhere(): string
    {
        if (!$this->where) {
            return '';
        }

        return sprintf(' WHERE %s', $this->where->asSOQL());
    }

    private function parseGroupBy(): string
    {
        if (!$this->groupBy) {
            return '';
        }

        return sprintf(' GROUP BY %s', $this->groupBy->asSOQL());
    }

    private function parseHaving(): string
    {
        if (!$this->having) {
            return '';
        }

        return sprintf(' HAVING %s', $this->having->asSOQL());
    }

    private function parseOrderBy(): string
    {
        if (!$this->orderBy) {
            return '';
        }

        return sprintf(' ORDER BY %s', $this->orderBy->asSOQL());
    }

    private function parseLimit(): string
    {
        if (!is_int($this->limit)) {
            return '';
        }

        return sprintf(' LIMIT %d', $this->limit);
    }

    private function parseOffset(): string
    {
        if (!is_int($this->offset)) {
            return '';
        }

        return sprintf(' OFFSET %d', $this->offset);
    }
}


1		<?php
2
3		namespace Xsolve\SalesforceClient\QueryBuilder;
4
5		use Xsolve\SalesforceClient\QueryBuilder\Expr\Compare\AbstractCompare;
6		use Xsolve\SalesforceClient\QueryBuilder\Expr\ExprInterface;
7		use Xsolve\SalesforceClient\QueryBuilder\Expr\From\AbstractFrom;
8		use Xsolve\SalesforceClient\QueryBuilder\Expr\GroupBy\AbstractGroupBy;
9		use Xsolve\SalesforceClient\QueryBuilder\Expr\OrderBy\AbstractOrderBy;
10		use Xsolve\SalesforceClient\QueryBuilder\Expr\Select\AbstractSelect;
11		use Xsolve\SalesforceClient\QueryBuilder\Visitor\Parameters\ParametersReplacingVisitor;
12		use Xsolve\SalesforceClient\QueryBuilder\Visitor\VisiteeInterface;
13		use Xsolve\SalesforceClient\QueryBuilder\Visitor\VisitorInterface;
14
15		class Query
16		{
17		/**
18		* @var AbstractSelect[]
19		*/
20		private $selects = [];
21
22		/**
23		* @var AbstractFrom\|null
24		*/
25		private $from;
26
27		/**
28		* @var AbstractCompare\|null
29		*/
30		private $where;
31
32		/**
33		* @var AbstractGroupBy\|null
34		*/
35		private $groupBy;
36
37		/**
38		* @var AbstractCompare\|null
39		*/
40		private $having;
41
42		/**
43		* @var AbstractOrderBy\|null
44		*/
45		private $orderBy;
46
47		/**
48		* @var int\|null
49		*/
50		private $limit;
51
52		/**
53		* @var int\|null
54		*/
55		private $offset;
56
57		/**
58		* @var VisitorInterface[]
59		*/
60		private $visitors;
61
62		/**
63		* @param VisitorInterface[] $visitors
64		*/
65	53	public function __construct(array $visitors = [])
66		{
67	53	$this->visitors = $visitors;
68	53	}
69
70	53	public function addSelect(AbstractSelect $select)
71		{
72	53	$this->selects[] = $select;
73	53	}
74
75	53	public function setFrom(AbstractFrom $from)
76		{
77	53	$this->from = $from;
78	53	}
79
80	19	public function setWhere(AbstractCompare $where)
81		{
82	19	$this->where = $where;
83	19	}
84
85	4	public function setGroupBy(AbstractGroupBy $groupBy)
86		{
87	4	$this->groupBy = $groupBy;
88	4	}
89
90	19	public function setHaving(AbstractCompare $having)
91		{
92	19	$this->having = $having;
93	19	}
94
95		/**
96		* @return AbstractCompare\|null
97		*/
98	1	public function getWhere()
99		{
100	1	return $this->where;
101		}
102
103		/**
104		* @return AbstractCompare\|null
105		*/
106	1	public function getHaving()
107		{
108	1	return $this->having;
109		}
110
111	4	public function setOrderBy(AbstractOrderBy $orderBy)
112		{
113	4	$this->orderBy = $orderBy;
114	4	}
115
116	2	public function setLimit(int $limit)
117		{
118	2	$this->limit = $limit;
119	2	}
120
121	2	public function setOffset(int $offset)
122		{
123	2	$this->offset = $offset;
124	2	}
125
126	19	public function setParameters(array $parameters)
127		{
128	19	$this->visitors[] = new ParametersReplacingVisitor($parameters);
129	19	}
130
131	53	public function parse(): string
132		{
133	53	$this->validate();
134	53	$this->visitQueryParts();
135	53
136	53	return $this->parseSelect()
137	53	. $this->parseWhere()
138	53	. $this->parseGroupBy()
139	53	. $this->parseHaving()
140		. $this->parseOrderBy()
141		. $this->parseLimit()
142	53	. $this->parseOffset();
143		}
144	53
145	19	private function validate()
146		{
147		if (empty($this->selects) \|\| null === $this->from) {
148	53	throw new \LogicException('At least SELECT and FROM must be defined');
149	4	}
150		}
151
152	53	private function visitQueryParts()
153	19	{
154		foreach ($this->visitors as $visitor) {
155		foreach ($this->getQueryParts() as $queryPart) {
156	53	if ($queryPart instanceof VisiteeInterface) {
157	4	$queryPart->accept($visitor);
158		}
159		}
160	53	}
161	2	}
162
163		/**
164	53	* @return ExprInterface[]
165	2	*/
166		private function getQueryParts(): array
167		{
168	53	return array_merge(
169		$this->selects,
170		[$this->from],
171	53	[$this->where],
172		[$this->groupBy],
173	53	[$this->having],
174		[$this->orderBy]
175		);
176	53	}
177
178	53	private function parseSelect(): string
179		{
180	53	$selects = implode(', ', array_map(
181	19	function (AbstractSelect $select): string {
182	19	return $select->asSOQL();
183	19	},
184		$this->selects
185		));
186
187	53	return sprintf('SELECT %s FROM %s', $selects, $this->from->asSOQL());
188		}
189
190		private function parseWhere(): string
191		{
192	19	if (!$this->where) {
193		return '';
194	19	}
195	19
196	19	return sprintf(' WHERE %s', $this->where->asSOQL());
197	19	}
198	19
199	19	private function parseGroupBy(): string
200	19	{
201		if (!$this->groupBy) {
202		return '';
203		}
204
205		return sprintf(' GROUP BY %s', $this->groupBy->asSOQL());
206		}
207
208		private function parseHaving(): string
209		{
210		if (!$this->having) {
211		return '';
212		}
213
214		return sprintf(' HAVING %s', $this->having->asSOQL());
215		}
216
217		private function parseOrderBy(): string
218		{
219		if (!$this->orderBy) {
220		return '';
221		}
222
223		return sprintf(' ORDER BY %s', $this->orderBy->asSOQL());
224		}
225
226		private function parseLimit(): string
227		{
228		if (!is_int($this->limit)) {
229		return '';
230		}
231
232		return sprintf(' LIMIT %d', $this->limit);
233		}
234
235		private function parseOffset(): string
236		{
237		if (!is_int($this->offset)) {
238		return '';
239		}
240
241		return sprintf(' OFFSET %d', $this->offset);
242		}
243		}
244

xsolve-pl / salesforce-client

Pull Request — master (#67)

Query::getHaving() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like