Select::__toString() - Code Metrics - Inspection of "Merge pull request #19 from Divergence/develop" - Divergence/framework - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Branch — release (bd7374)

by Henry

created 2023-07-26 13:13 UTC

Select::__toString() B

↳ Parent: Select

Complexity

Conditions	7
Paths	64

Size

Total Lines	16
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	10
CRAP Score	7

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	7
eloc	10
c	1
b	0
f	0
nc	64
nop	0
dl	0
loc	16
ccs	10
cts	10
cp	1
crap	7
rs	8.8333

<?php

namespace Divergence\IO\Database\Query;

class Select extends AbstractQuery
{
    public ?string $where;
    public ?string $having;
    public ?string $limit;
    public ?string $order;
    public string $expression = '*';
    public bool $calcFoundRows = false;

    public function expression(string $expression): Select
    {
        $this->expression = $expression;
        return $this;
    }

    public function where(string $where): Select
    {
        $this->where = $where;
        return $this;
    }

    public function having(string $having): Select
    {
        $this->having = $having;
        return $this;
    }

    public function limit(string $limit): Select
    {
        if (!empty($limit)) {
            $this->limit = $limit;
        }
        return $this;
    }

    public function order(string $order): Select
    {
        if (!empty($order)) {
            $this->order = $order;
        }
        return $this;
    }

    public function calcFoundRows(): Select
    {
        $this->calcFoundRows = true;
        return $this;
    }

    public function __toString(): string
    {
        $expression = ($this->calcFoundRows ? 'SQL_CALC_FOUND_ROWS ' : '') . $this->expression;

        if (isset($this->tableAlias)) {
            $from = sprintf('`%s` AS `%s`', $this->table, $this->tableAlias);
        } else {
            $from = sprintf('`%s`', $this->table);
        }

        $limit = isset($this->limit) ? ' LIMIT '.$this->limit : '';
        $where = isset($this->where) ? ' WHERE ('.$this->where.')' : '';
        $having = isset($this->having) ? ' HAVING ('.$this->having.')' : '';
        $order = isset($this->order) ? ' ORDER BY '.$this->order : '';

        return sprintf('SELECT %s FROM %s %s %s %s %s', $expression, $from, $where, $having, $order, $limit);
    }
}


1		<?php
2
3		namespace Divergence\IO\Database\Query;
4
5		class Select extends AbstractQuery
6		{
7		public ?string $where;
8		public ?string $having;
9		public ?string $limit;
10		public ?string $order;
11		public string $expression = '*';
12		public bool $calcFoundRows = false;
13
14	17	public function expression(string $expression): Select
15		{
16	17	$this->expression = $expression;
17	17	return $this;
18		}
19
20	68	public function where(string $where): Select
21		{
22	68	$this->where = $where;
23	68	return $this;
24		}
25
26	1	public function having(string $having): Select
27		{
28	1	$this->having = $having;
29	1	return $this;
30		}
31
32	67	public function limit(string $limit): Select
33		{
34	67	if (!empty($limit)) {
35	67	$this->limit = $limit;
36		}
37	67	return $this;
38		}
39
40	68	public function order(string $order): Select
41		{
42	68	if (!empty($order)) {
43	14	$this->order = $order;
44		}
45	68	return $this;
46		}
47
48	13	public function calcFoundRows(): Select
49		{
50	13	$this->calcFoundRows = true;
51	13	return $this;
52		}
53
54	78	public function __toString(): string
55		{
56	78	$expression = ($this->calcFoundRows ? 'SQL_CALC_FOUND_ROWS ' : '') . $this->expression;
57
58	78	if (isset($this->tableAlias)) {
59	17	$from = sprintf('`%s` AS `%s`', $this->table, $this->tableAlias);
60		} else {
61	71	$from = sprintf('`%s`', $this->table);
62		}
63
64	78	$limit = isset($this->limit) ? ' LIMIT '.$this->limit : '';
65	78	$where = isset($this->where) ? ' WHERE ('.$this->where.')' : '';
66	78	$having = isset($this->having) ? ' HAVING ('.$this->having.')' : '';
67	78	$order = isset($this->order) ? ' ORDER BY '.$this->order : '';
68
69	78	return sprintf('SELECT %s FROM %s %s %s %s %s', $expression, $from, $where, $having, $order, $limit);
70		}
71		}
72

Divergence / framework

Branch — release (bd7374)

Select::__toString() B

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like