Select::orderBy() - Code Metrics - Inspection of "scrutinizer" - winframework/winphp - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Branch — v1.4.0 (e4576e)

by Wanderson

created 2019-03-02 21:12 UTC

Select::orderBy() A

↳ Parent: Select

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	1
nc	1
nop	1
dl	0
loc	3
rs	10
c	0
b	0
f	0

<?php

namespace Win\Database\Sql\Queries;

use Win\Database\RepositoryInterface;
use Win\Database\Sql\Clauses\Limit;
use Win\Database\Sql\Clauses\OrderBy;
use Win\Database\Sql\Clauses\Where;
use Win\Database\Sql\Query;

/**
 * SELECT * FROM
 */
class Select extends Query
{
	/** @var string[] */
	public $columns;

	/** @var Where */
	public $where;

	/** @var Limit */
	public $limit;

	/** @var OrderBy */
	protected $orderBy;

	public function __construct(RepositoryInterface $repository)
	{
		parent::__construct($repository);
		$this->init();
	}

	protected function init()
	{
		$this->columns = ['*'];
		$this->where = new Where();
		$this->limit = new Limit();
		$this->orderBy = new OrderBy();
	}

	/** @return string */
	public function toString()
	{
		return 'SELECT ' . implode(',', $this->columns) . ' FROM '
				. $this->table
				. $this->where
				. $this->orderBy
				. $this->limit;
	}

	/** @return mixed[] */
	public function getValues()
	{
		return $this->where->values();
	}

	/** @return int */
	public function count()
	{
		$this->columns = ['count(*)'];
		$stmt = $this->conn->stmt($this, $this->getValues());
		$this->init();

		return $stmt->fetchColumn();
	}

	/** @return mixed[] */
	public function execute()
	{
		$all = $this->conn->fetchAll($this, $this->getValues());
		$this->init();

		return $all;
	}

	/** @param string $orderBy */
	public function orderBy($orderBy)
	{
		$this->orderBy->set($orderBy);
	}
}


1			<?php
2
3			namespace Win\Database\Sql\Queries;
4
5			use Win\Database\RepositoryInterface;
6			use Win\Database\Sql\Clauses\Limit;
7			use Win\Database\Sql\Clauses\OrderBy;
8			use Win\Database\Sql\Clauses\Where;
9			use Win\Database\Sql\Query;
10
11			/**
12			* SELECT * FROM
13			*/
14			class Select extends Query
15			{
16			/** @var string[] */
17			public $columns;
18
19			/** @var Where */
20			public $where;
21
22			/** @var Limit */
23			public $limit;
24
25			/** @var OrderBy */
26			protected $orderBy;
27
28			public function __construct(RepositoryInterface $repository)
29			{
30			parent::__construct($repository);
31			$this->init();
32			}
33
34			protected function init()
35			{
36			$this->columns = ['*'];
37			$this->where = new Where();
38			$this->limit = new Limit();
39			$this->orderBy = new OrderBy();
40			}
41
42			/** @return string */
43			public function toString()
44			{
45			return 'SELECT ' . implode(',', $this->columns) . ' FROM '
46			. $this->table
47			. $this->where
48			. $this->orderBy
49			. $this->limit;
50			}
51
52			/** @return mixed[] */
53			public function getValues()
54			{
55			return $this->where->values();
56			}
57
58			/** @return int */
59			public function count()
60			{
61			$this->columns = ['count(*)'];
62			$stmt = $this->conn->stmt($this, $this->getValues());
63			$this->init();
64
65			return $stmt->fetchColumn();
66			}
67
68			/** @return mixed[] */
69			public function execute()
70			{
71			$all = $this->conn->fetchAll($this, $this->getValues());
72			$this->init();
73
74			return $all;
75			}
76
77			/** @param string $orderBy */
78			public function orderBy($orderBy)
79			{
80			$this->orderBy->set($orderBy);
81			}
82			}
83

winframework / winphp

Branch — v1.4.0 (e4576e)

Select::orderBy() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like