Wandu\Database\Query\SelectQuery

Complexity

Total Complexity

5

Size/Duplication

Total Lines	38
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Test Coverage

Coverage

100%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	5	1
A	toSql()	0	16	4

<?php
namespace Wandu\Database\Query;

use Wandu\Database\Contracts\QueryInterface;
use Wandu\Database\Query\Expression\HasWhereExpression;

class SelectQuery extends HasWhereExpression implements QueryInterface
{
    /** @var string */
    protected $table;
    
    /** @var array */
    protected $columns = ['*'];
    
    /**
     * @param string $table
     * @param array $columns
     */
    public function __construct($table, array $columns = [])
    {
        $this->table = $table;
        $this->columns = $columns;
    }

    /**
     * {@inheritdoc}
     */
    public function toSql()
    {
        $columnSqlParts = [];
        foreach ($this->columns as $key => $column) {
            if ($column === '*') {
                $columnSqlParts[] = '*';
            } else {
                $columnSqlParts[] = "`{$column}`";
            }
        }
        $parts = ["SELECT ". implode(', ', $columnSqlParts) ." FROM `{$this->table}`"];
        if ($part = parent::toSql()) {
            $parts[] = $part;
        }
        return implode(' ', $parts);
    }
}