Willry\QueryBuilder\Query

Complexity

Total Complexity

14

Size/Duplication

Total Lines	117
Duplicated Lines	0 %

Importance

Changes	11
Bugs	0	Features	0

10 Methods

Rating	Name	Duplication	Size	Complexity
A	select()	0	4	1
A	selectRaw()	0	5	1
A	get()	0	12	2
A	order()	0	5	1
A	groupBy()	0	5	1
A	having()	0	5	1
A	first()	0	16	3
A	offset()	0	4	1
A	count()	0	12	2
A	limit()	0	4	1

<?php

namespace Willry\QueryBuilder;

class Query extends Base
{

    /**
     * @param string $columns
     * @return $this
     */
    public function selectRaw(string $columns = "*", array $params = []): self
    {
        $this->setBindings($params, 'select');
        $this->columns = array_merge($this->columns, explode(',', $columns));
        return $this;
    }

    public function select(array $columns = ['*']): self
    {
        $this->columns = array_merge($this->columns, $columns);
        return $this;
    }

    /**
     * @param string $columnOrder
     */
    public function order(string $columnOrder): self
    {
        $this->order = "ORDER BY ?";
        $this->setBindings([$columnOrder], 'order');
        return $this;
    }

    /**
     * @param array $group
     * @return DB

The type Willry\QueryBuilder\DB was not found. Maybe you did not declare it correctly or list all dependencies?

     */
    public function groupBy(string $group): self
    {

        $this->groupBy = "GROUP BY {$group}";
        return $this;

The expression return $this returns the type Willry\QueryBuilder\Query which is incompatible with the documented return type Willry\QueryBuilder\DB.

    }

    /**
     * @param string $having
     * @return DB
     */
    public function having(string $having, array $params = []): self
    {
        $this->having = "HAVING {$having}";
        $this->setBindings($params, 'having');
        return $this;

The expression return $this returns the type Willry\QueryBuilder\Query which is incompatible with the documented return type Willry\QueryBuilder\DB.

    }

    /**
     * @param int $limit
     */
    public function limit(int $limit): static
    {
        $this->limit = "LIMIT $limit";
        return $this;
    }

    /**
     * @param int $offset
     * @return DB
     */
    public function offset(int $offset): static
    {
        $this->offset = "OFFSET $offset";
        return $this;

The expression return $this returns the type Willry\QueryBuilder\Query which is incompatible with the documented return type Willry\QueryBuilder\DB.

    }

    public function get(): ?array
    {
        $this->mountQuery();

        try {
            $stmt = $this->db->prepare($this->query);
            QueryHelpers::bind($stmt, $this->flatBindings());
            $stmt->execute();

            return $stmt->fetchAll(\PDO::FETCH_CLASS);
        } catch (\PDOException $exception) {
            $this->handleError($exception);
        }
    }

    public function first(): ?\stdClass
    {
        $this->mountQuery();

        try {
            $stmt = $this->db->prepare($this->query);
            QueryHelpers::bind($stmt, $this->flatBindings());
            $stmt->execute();

            if (!$stmt->rowCount()) {
                return null;
            }

            return $stmt->fetchObject();
        } catch (\PDOException $exception) {
            $this->handleError($exception);
        }
    }

    public function count(): ?int
    {
        $this->mountQuery();

        try {
            $stmt = $this->db->prepare($this->query);
            QueryHelpers::bind($stmt, $this->flatBindings());
            $stmt->execute();

            return $stmt->rowCount();
        } catch (\PDOException $exception) {
            $this->handleError($exception);
        }
    }
}