Win\Database\Sql\Queries\Select

Complexity

Total Complexity

7

Size/Duplication

Total Lines	67
Duplicated Lines	0 %

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	init()	0	6	1
A	__construct()	0	4	1
A	getValues()	0	3	1
A	toString()	0	7	1
A	execute()	0	6	1
A	count()	0	7	1
A	orderBy()	0	3	1

<?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);
	}
}