Hoooklife\DynamodbPodm\Query\Builder

Complexity

Total Complexity

28

Size/Duplication

Total Lines	266
Duplicated Lines	0 %

Importance

Changes

0

14 Methods

Rating	Name	Duplication	Size	Complexity
A	limit()	0	7	2
A	forPage()	0	3	1
A	take()	0	3	1
A	from()	0	4	1
A	toSql()	0	3	1
B	where()	0	39	9
A	first()	0	3	1
A	select()	0	4	2
A	addSelect()	0	5	2
A	invalidOperator()	0	4	2
A	__construct()	0	8	2
A	insert()	0	3	1
A	value()	0	4	2
A	all()	0	3	1

<?php

namespace Hoooklife\DynamodbPodm\Query;

use Hoooklife\DynamodbPodm\Collection;
use Hoooklife\DynamodbPodm\DB;
use Hoooklife\DynamodbPodm\Grammars\DynamoDBGrammar;

class Builder
{

    /**
     * 查询排序
     */
    public $limit;
    public $wheres = [];
    public $bindings = [];
    public $columns;
    public $table;


    /**
     * All of the available clause operators.
     *
     * @var array
     */
    public $operators = [
        '=', '<', '>', '<=', '>=', '<>', '!='
    ];

    public $reservedKey = [
        'key'
    ];

    /** @var DynamoDBGrammar */
    private $grammar;

    public function __construct($connection = 'default')
    {
        switch (DB::$config[$connection]['driver']) {
            case "dynamedb":
                $this->grammar = new DynamoDBGrammar($this, DB::$config[$connection]);
                break;
            default:
                throw new \Exception("bad driver");
        }
    }


    /**
     * 设置要查出的列
     *
     * @param  array|mixed $columns
     * @return $this
     */
    public function select($columns = ['*'])
    {
        $this->columns = is_array($columns) ? $columns : func_get_args();
        return $this;
    }


    public function addSelect($columns)
    {
        $columns = is_array($columns) ? $columns : func_get_args();
        $this->columns = array_merge((array)$this->columns, $columns);
        return $this;
    }


    /**
     * Set the table which the query is targeting.
     *
     * @param  string $table
     * @return $this
     */
    public function from($table)
    {
        $this->table = $table;
        return $this;
    }


    /**
     * Add a basic where clause to the query.
     *
     * @param  string|array|\Closure $column
     * @param  mixed $operator
     * @param  mixed $value
     * @param  string $boolean
     * @return $this
     */

    public function where($column, $operator = null, $value = null, $boolean = 'and')
    {
        if (is_array($column)) {
            // 递归
            foreach ($column as $key => $value) {
                if (is_numeric($key) && is_array($value)) {
                    $this->where(...array_values($value));

array_values($value) is expanded, but the parameter $column of Hoooklife\DynamodbPodm\Query\Builder::where() does not expect variable arguments.

                } else {
                    $this->where($key, '=', $value, $boolean);
                }
            }
            return $this;
            // return $this->addArrayOfWheres($column, $boolean);
        }

        if (func_num_args() === 2 || $this->invalidOperator($operator)) {
            list($value, $operator) = [$operator, '='];
        }

        // where in
        if (is_array($value)) {
            return $this->whereIn($column, $boolean);

The method whereIn() does not exist on Hoooklife\DynamodbPodm\Query\Builder. Did you maybe mean where()?

        }

        // is null
        if (is_null($value)) {
            return $this->whereNull($column, $boolean, $operator !== '=');

The method whereNull() does not exist on Hoooklife\DynamodbPodm\Query\Builder. Did you maybe mean where()?

        }

        $type = 'Basic';
        $this->wheres[] = compact(
            'type', 'column', 'operator', 'value', 'boolean'
        );


        // TODO 参数绑定
//         $this->addBinding($value, 'where');

        return $this;
    }


    /**
     * Determine if the given operator is supported.
     *
     * @param  string $operator
     * @return bool
     */
    protected function invalidOperator($operator)
    {
        return !in_array(strtolower($operator), $this->operators, true) &&
            !in_array(strtolower($operator), $this->grammar->getOperators(), true);
    }


    // /**
    //  * 向查询添加排序语句。
    //  *
    //  * @param  string  $column
    //  * @param  string  $direction
    //  * @return $this
    //  */
    // public function orderBy($columns, $direction = 'asc')
    // {
    //     $orders = is_array($columns) ? $columns : [$columns => $direction];
    //     $this->orders = array_merge($this->orders, $orders);
    //     return $this;
    // }

    // public function offset($value)
    // {
    //     $this->offset =  max(0, $value);
    //     return $this;
    // }

    //  /**
    //  * Alias to set the "offset" value of the query.
    //  *
    //  * @param  int  $value
    //  * @return \Illuminate\Database\Query\Builder|static
    //  */
    // public function skip($value)
    // {
    //     return $this->offset($value);
    // }


    /**
     * Alias to set the "limit" value of the query.
     *
     * @param  int $value
     * @return \Illuminate\Database\Query\Builder|static

The type Illuminate\Database\Query\Builder was not found. Maybe you did not declare it correctly or list all dependencies?

     */
    public function take($value)
    {
        return $this->limit($value);
    }


    /**
     * Set the "limit" value of the query.
     *
     * @param  int $value
     * @return $this
     */
    public function limit($value)
    {
        //  FIXME ??? 为啥等于0
        if ($value > 0) {
            $this->limit = $value;
        }
        return $this;
    }

    /**
     * Set the limit and offset for a given page.
     *
     * @param  int $page
     * @param  int $perPage
     * @return \Illuminate\Database\Query\Builder|static
     */
    public function forPage($page, $perPage = 15)
    {
        return $this->skip(($page - 1) * $perPage)->take($perPage);

The method skip() does not exist on Hoooklife\DynamodbPodm\Query\Builder.

    }


    /**
     * Get the SQL representation of the query.
     *
     * @return string
     */
    public function toSql()
    {
        return $this->grammar->compileSelect($this);

The method compileSelect() does not exist on Hoooklife\DynamodbPodm\Grammars\DynamoDBGrammar.

    }


    /**
     * Get a single column's value from the first result of a query.
     *
     * @param  string $column
     * @return mixed
     */
    public function value($column)
    {
        $result = (array)$this->first([$column]);
        return count($result) > 0 ? reset($result) : null;
    }


    /**
     * Execute the query and get the first result.
     *
     * @param  array $columns
     * @return \Illuminate\Database\Eloquent\Model|object|static|null

The type Illuminate\Database\Eloquent\Model was not found. Maybe you did not declare it correctly or list all dependencies?

     */
    public function first($columns = ['*'])
    {
        return reset($this->take(1)->all($columns));

$this->take(1)->all($columns) of type Hoooklife\DynamodbPodm\Collection is incompatible with the type array expected by parameter $array of reset().

    }


    /**
     * Execute the query as a "select" statement.
     *
     * @param  array $columns
     * @return Collection
     */
    public function all($columns = ['*']): Collection
    {
        return $this->grammar->all($columns);
    }

    /**
     * @param array $data
     * @return \Aws\Result
     */
    public function insert(array $data)
    {
        return $this->grammar->insert($data);
    }


}