http://git-wip-us.apache.org/repos/asf/airavata-php-gateway/blob/80fd786e/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php ---------------------------------------------------------------------- diff --git a/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php b/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php deleted file mode 100755 index 1fb9665..0000000 --- a/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php +++ /dev/null @@ -1,2187 +0,0 @@ -<?php namespace Illuminate\Database\Query; - -use Closure; -use Illuminate\Support\Collection; -use Illuminate\Database\ConnectionInterface; -use Illuminate\Database\Query\Grammars\Grammar; -use Illuminate\Database\Query\Processors\Processor; - -class Builder { - - /** - * The database connection instance. - * - * @var \Illuminate\Database\Connection - */ - protected $connection; - - /** - * The database query grammar instance. - * - * @var \Illuminate\Database\Query\Grammars\Grammar - */ - protected $grammar; - - /** - * The database query post processor instance. - * - * @var \Illuminate\Database\Query\Processors\Processor - */ - protected $processor; - - /** - * The current query value bindings. - * - * @var array - */ - protected $bindings = array( - 'select' => [], - 'join' => [], - 'where' => [], - 'having' => [], - 'order' => [], - ); - - /** - * An aggregate function and column to be run. - * - * @var array - */ - public $aggregate; - - /** - * The columns that should be returned. - * - * @var array - */ - public $columns; - - /** - * Indicates if the query returns distinct results. - * - * @var bool - */ - public $distinct = false; - - /** - * The table which the query is targeting. - * - * @var string - */ - public $from; - - /** - * The table joins for the query. - * - * @var array - */ - public $joins; - - /** - * The where constraints for the query. - * - * @var array - */ - public $wheres; - - /** - * The groupings for the query. - * - * @var array - */ - public $groups; - - /** - * The having constraints for the query. - * - * @var array - */ - public $havings; - - /** - * The orderings for the query. - * - * @var array - */ - public $orders; - - /** - * The maximum number of records to return. - * - * @var int - */ - public $limit; - - /** - * The number of records to skip. - * - * @var int - */ - public $offset; - - /** - * The query union statements. - * - * @var array - */ - public $unions; - - /** - * The maximum number of union records to return. - * - * @var int - */ - public $unionLimit; - - /** - * The number of union records to skip. - * - * @var int - */ - public $unionOffset; - - /** - * The orderings for the union query. - * - * @var array - */ - public $unionOrders; - - /** - * Indicates whether row locking is being used. - * - * @var string|bool - */ - public $lock; - - /** - * The backups of fields while doing a pagination count. - * - * @var array - */ - protected $backups = array(); - - /** - * The key that should be used when caching the query. - * - * @var string - */ - protected $cacheKey; - - /** - * The number of minutes to cache the query. - * - * @var int - */ - protected $cacheMinutes; - - /** - * The tags for the query cache. - * - * @var array - */ - protected $cacheTags; - - /** - * The cache driver to be used. - * - * @var string - */ - protected $cacheDriver; - - /** - * All of the available clause operators. - * - * @var array - */ - protected $operators = array( - '=', '<', '>', '<=', '>=', '<>', '!=', - 'like', 'not like', 'between', 'ilike', - '&', '|', '^', '<<', '>>', - 'rlike', 'regexp', 'not regexp', - ); - - /** - * Whether use write pdo for select. - * - * @var bool - */ - protected $useWritePdo = false; - - /** - * Create a new query builder instance. - * - * @param \Illuminate\Database\ConnectionInterface $connection - * @param \Illuminate\Database\Query\Grammars\Grammar $grammar - * @param \Illuminate\Database\Query\Processors\Processor $processor - * @return void - */ - public function __construct(ConnectionInterface $connection, - Grammar $grammar, - Processor $processor) - { - $this->grammar = $grammar; - $this->processor = $processor; - $this->connection = $connection; - } - - /** - * Set the columns to be selected. - * - * @param array $columns - * @return $this - */ - public function select($columns = array('*')) - { - $this->columns = is_array($columns) ? $columns : func_get_args(); - - return $this; - } - - /** - * Add a new "raw" select expression to the query. - * - * @param string $expression - * @return \Illuminate\Database\Query\Builder|static - */ - public function selectRaw($expression) - { - return $this->select(new Expression($expression)); - } - - /** - * Add a new select column to the query. - * - * @param mixed $column - * @return $this - */ - public function addSelect($column) - { - $column = is_array($column) ? $column : func_get_args(); - - $this->columns = array_merge((array) $this->columns, $column); - - return $this; - } - - /** - * Force the query to only return distinct results. - * - * @return $this - */ - public function distinct() - { - $this->distinct = true; - - return $this; - } - - /** - * Set the table which the query is targeting. - * - * @param string $table - * @return $this - */ - public function from($table) - { - $this->from = $table; - - return $this; - } - - /** - * Add a join clause to the query. - * - * @param string $table - * @param string $one - * @param string $operator - * @param string $two - * @param string $type - * @param bool $where - * @return $this - */ - public function join($table, $one, $operator = null, $two = null, $type = 'inner', $where = false) - { - // If the first "column" of the join is really a Closure instance the developer - // is trying to build a join with a complex "on" clause containing more than - // one condition, so we'll add the join and call a Closure with the query. - if ($one instanceof Closure) - { - $this->joins[] = new JoinClause($type, $table); - - call_user_func($one, end($this->joins)); - } - - // If the column is simply a string, we can assume the join simply has a basic - // "on" clause with a single condition. So we will just build the join with - // this simple join clauses attached to it. There is not a join callback. - else - { - $join = new JoinClause($type, $table); - - $this->joins[] = $join->on( - $one, $operator, $two, 'and', $where - ); - } - - return $this; - } - - /** - * Add a "join where" clause to the query. - * - * @param string $table - * @param string $one - * @param string $operator - * @param string $two - * @param string $type - * @return \Illuminate\Database\Query\Builder|static - */ - public function joinWhere($table, $one, $operator, $two, $type = 'inner') - { - return $this->join($table, $one, $operator, $two, $type, true); - } - - /** - * Add a left join to the query. - * - * @param string $table - * @param string $first - * @param string $operator - * @param string $second - * @return \Illuminate\Database\Query\Builder|static - */ - public function leftJoin($table, $first, $operator = null, $second = null) - { - return $this->join($table, $first, $operator, $second, 'left'); - } - - /** - * Add a "join where" clause to the query. - * - * @param string $table - * @param string $one - * @param string $operator - * @param string $two - * @return \Illuminate\Database\Query\Builder|static - */ - public function leftJoinWhere($table, $one, $operator, $two) - { - return $this->joinWhere($table, $one, $operator, $two, 'left'); - } - - /** - * Add a right join to the query. - * - * @param string $table - * @param string $first - * @param string $operator - * @param string $second - * @return \Illuminate\Database\Query\Builder|static - */ - public function rightJoin($table, $first, $operator = null, $second = null) - { - return $this->join($table, $first, $operator, $second, 'right'); - } - - /** - * Add a "right join where" clause to the query. - * - * @param string $table - * @param string $one - * @param string $operator - * @param string $two - * @return \Illuminate\Database\Query\Builder|static - */ - public function rightJoinWhere($table, $one, $operator, $two) - { - return $this->joinWhere($table, $one, $operator, $two, 'right'); - } - - /** - * Add a basic where clause to the query. - * - * @param string $column - * @param string $operator - * @param mixed $value - * @param string $boolean - * @return $this - * - * @throws \InvalidArgumentException - */ - public function where($column, $operator = null, $value = null, $boolean = 'and') - { - // If the column is an array, we will assume it is an array of key-value pairs - // and can add them each as a where clause. We will maintain the boolean we - // received when the method was called and pass it into the nested where. - if (is_array($column)) - { - return $this->whereNested(function($query) use ($column) - { - foreach ($column as $key => $value) - { - $query->where($key, '=', $value); - } - }, $boolean); - } - - // Here we will make some assumptions about the operator. If only 2 values are - // passed to the method, we will assume that the operator is an equals sign - // and keep going. Otherwise, we'll require the operator to be passed in. - if (func_num_args() == 2) - { - list($value, $operator) = array($operator, '='); - } - elseif ($this->invalidOperatorAndValue($operator, $value)) - { - throw new \InvalidArgumentException("Value must be provided."); - } - - // If the columns is actually a Closure instance, we will assume the developer - // wants to begin a nested where statement which is wrapped in parenthesis. - // We'll add that Closure to the query then return back out immediately. - if ($column instanceof Closure) - { - return $this->whereNested($column, $boolean); - } - - // If the given operator is not found in the list of valid operators we will - // assume that the developer is just short-cutting the '=' operators and - // we will set the operators to '=' and set the values appropriately. - if ( ! in_array(strtolower($operator), $this->operators, true)) - { - list($value, $operator) = array($operator, '='); - } - - // If the value is a Closure, it means the developer is performing an entire - // sub-select within the query and we will need to compile the sub-select - // within the where clause to get the appropriate query record results. - if ($value instanceof Closure) - { - return $this->whereSub($column, $operator, $value, $boolean); - } - - // If the value is "null", we will just assume the developer wants to add a - // where null clause to the query. So, we will allow a short-cut here to - // that method for convenience so the developer doesn't have to check. - if (is_null($value)) - { - return $this->whereNull($column, $boolean, $operator != '='); - } - - // Now that we are working with just a simple query we can put the elements - // in our array and add the query binding to our array of bindings that - // will be bound to each SQL statements when it is finally executed. - $type = 'Basic'; - - $this->wheres[] = compact('type', 'column', 'operator', 'value', 'boolean'); - - if ( ! $value instanceof Expression) - { - $this->addBinding($value, 'where'); - } - - return $this; - } - - /** - * Add an "or where" clause to the query. - * - * @param string $column - * @param string $operator - * @param mixed $value - * @return \Illuminate\Database\Query\Builder|static - */ - public function orWhere($column, $operator = null, $value = null) - { - return $this->where($column, $operator, $value, 'or'); - } - - /** - * Determine if the given operator and value combination is legal. - * - * @param string $operator - * @param mixed $value - * @return bool - */ - protected function invalidOperatorAndValue($operator, $value) - { - $isOperator = in_array($operator, $this->operators); - - return ($isOperator && $operator != '=' && is_null($value)); - } - - /** - * Add a raw where clause to the query. - * - * @param string $sql - * @param array $bindings - * @param string $boolean - * @return $this - */ - public function whereRaw($sql, array $bindings = array(), $boolean = 'and') - { - $type = 'raw'; - - $this->wheres[] = compact('type', 'sql', 'boolean'); - - $this->addBinding($bindings, 'where'); - - return $this; - } - - /** - * Add a raw or where clause to the query. - * - * @param string $sql - * @param array $bindings - * @return \Illuminate\Database\Query\Builder|static - */ - public function orWhereRaw($sql, array $bindings = array()) - { - return $this->whereRaw($sql, $bindings, 'or'); - } - - /** - * Add a where between statement to the query. - * - * @param string $column - * @param array $values - * @param string $boolean - * @param bool $not - * @return $this - */ - public function whereBetween($column, array $values, $boolean = 'and', $not = false) - { - $type = 'between'; - - $this->wheres[] = compact('column', 'type', 'boolean', 'not'); - - $this->addBinding($values, 'where'); - - return $this; - } - - /** - * Add an or where between statement to the query. - * - * @param string $column - * @param array $values - * @return \Illuminate\Database\Query\Builder|static - */ - public function orWhereBetween($column, array $values) - { - return $this->whereBetween($column, $values, 'or'); - } - - /** - * Add a where not between statement to the query. - * - * @param string $column - * @param array $values - * @param string $boolean - * @return \Illuminate\Database\Query\Builder|static - */ - public function whereNotBetween($column, array $values, $boolean = 'and') - { - return $this->whereBetween($column, $values, $boolean, true); - } - - /** - * Add an or where not between statement to the query. - * - * @param string $column - * @param array $values - * @return \Illuminate\Database\Query\Builder|static - */ - public function orWhereNotBetween($column, array $values) - { - return $this->whereNotBetween($column, $values, 'or'); - } - - /** - * Add a nested where statement to the query. - * - * @param \Closure $callback - * @param string $boolean - * @return \Illuminate\Database\Query\Builder|static - */ - public function whereNested(Closure $callback, $boolean = 'and') - { - // To handle nested queries we'll actually create a brand new query instance - // and pass it off to the Closure that we have. The Closure can simply do - // do whatever it wants to a query then we will store it for compiling. - $query = $this->newQuery(); - - $query->from($this->from); - - call_user_func($callback, $query); - - return $this->addNestedWhereQuery($query, $boolean); - } - - /** - * Add another query builder as a nested where to the query builder. - * - * @param \Illuminate\Database\Query\Builder|static $query - * @param string $boolean - * @return $this - */ - public function addNestedWhereQuery($query, $boolean = 'and') - { - if (count($query->wheres)) - { - $type = 'Nested'; - - $this->wheres[] = compact('type', 'query', 'boolean'); - - $this->mergeBindings($query); - } - - return $this; - } - - /** - * Add a full sub-select to the query. - * - * @param string $column - * @param string $operator - * @param \Closure $callback - * @param string $boolean - * @return $this - */ - protected function whereSub($column, $operator, Closure $callback, $boolean) - { - $type = 'Sub'; - - $query = $this->newQuery(); - - // Once we have the query instance we can simply execute it so it can add all - // of the sub-select's conditions to itself, and then we can cache it off - // in the array of where clauses for the "main" parent query instance. - call_user_func($callback, $query); - - $this->wheres[] = compact('type', 'column', 'operator', 'query', 'boolean'); - - $this->mergeBindings($query); - - return $this; - } - - /** - * Add an exists clause to the query. - * - * @param \Closure $callback - * @param string $boolean - * @param bool $not - * @return $this - */ - public function whereExists(Closure $callback, $boolean = 'and', $not = false) - { - $type = $not ? 'NotExists' : 'Exists'; - - $query = $this->newQuery(); - - // Similar to the sub-select clause, we will create a new query instance so - // the developer may cleanly specify the entire exists query and we will - // compile the whole thing in the grammar and insert it into the SQL. - call_user_func($callback, $query); - - $this->wheres[] = compact('type', 'operator', 'query', 'boolean'); - - $this->mergeBindings($query); - - return $this; - } - - /** - * Add an or exists clause to the query. - * - * @param \Closure $callback - * @param bool $not - * @return \Illuminate\Database\Query\Builder|static - */ - public function orWhereExists(Closure $callback, $not = false) - { - return $this->whereExists($callback, 'or', $not); - } - - /** - * Add a where not exists clause to the query. - * - * @param \Closure $callback - * @param string $boolean - * @return \Illuminate\Database\Query\Builder|static - */ - public function whereNotExists(Closure $callback, $boolean = 'and') - { - return $this->whereExists($callback, $boolean, true); - } - - /** - * Add a where not exists clause to the query. - * - * @param \Closure $callback - * @return \Illuminate\Database\Query\Builder|static - */ - public function orWhereNotExists(Closure $callback) - { - return $this->orWhereExists($callback, true); - } - - /** - * Add a "where in" clause to the query. - * - * @param string $column - * @param mixed $values - * @param string $boolean - * @param bool $not - * @return $this - */ - public function whereIn($column, $values, $boolean = 'and', $not = false) - { - $type = $not ? 'NotIn' : 'In'; - - // If the value of the where in clause is actually a Closure, we will assume that - // the developer is using a full sub-select for this "in" statement, and will - // execute those Closures, then we can re-construct the entire sub-selects. - if ($values instanceof Closure) - { - return $this->whereInSub($column, $values, $boolean, $not); - } - - $this->wheres[] = compact('type', 'column', 'values', 'boolean'); - - $this->addBinding($values, 'where'); - - return $this; - } - - /** - * Add an "or where in" clause to the query. - * - * @param string $column - * @param mixed $values - * @return \Illuminate\Database\Query\Builder|static - */ - public function orWhereIn($column, $values) - { - return $this->whereIn($column, $values, 'or'); - } - - /** - * Add a "where not in" clause to the query. - * - * @param string $column - * @param mixed $values - * @param string $boolean - * @return \Illuminate\Database\Query\Builder|static - */ - public function whereNotIn($column, $values, $boolean = 'and') - { - return $this->whereIn($column, $values, $boolean, true); - } - - /** - * Add an "or where not in" clause to the query. - * - * @param string $column - * @param mixed $values - * @return \Illuminate\Database\Query\Builder|static - */ - public function orWhereNotIn($column, $values) - { - return $this->whereNotIn($column, $values, 'or'); - } - - /** - * Add a where in with a sub-select to the query. - * - * @param string $column - * @param \Closure $callback - * @param string $boolean - * @param bool $not - * @return $this - */ - protected function whereInSub($column, Closure $callback, $boolean, $not) - { - $type = $not ? 'NotInSub' : 'InSub'; - - // To create the exists sub-select, we will actually create a query and call the - // provided callback with the query so the developer may set any of the query - // conditions they want for the in clause, then we'll put it in this array. - call_user_func($callback, $query = $this->newQuery()); - - $this->wheres[] = compact('type', 'column', 'query', 'boolean'); - - $this->mergeBindings($query); - - return $this; - } - - /** - * Add a "where null" clause to the query. - * - * @param string $column - * @param string $boolean - * @param bool $not - * @return $this - */ - public function whereNull($column, $boolean = 'and', $not = false) - { - $type = $not ? 'NotNull' : 'Null'; - - $this->wheres[] = compact('type', 'column', 'boolean'); - - return $this; - } - - /** - * Add an "or where null" clause to the query. - * - * @param string $column - * @return \Illuminate\Database\Query\Builder|static - */ - public function orWhereNull($column) - { - return $this->whereNull($column, 'or'); - } - - /** - * Add a "where not null" clause to the query. - * - * @param string $column - * @param string $boolean - * @return \Illuminate\Database\Query\Builder|static - */ - public function whereNotNull($column, $boolean = 'and') - { - return $this->whereNull($column, $boolean, true); - } - - /** - * Add an "or where not null" clause to the query. - * - * @param string $column - * @return \Illuminate\Database\Query\Builder|static - */ - public function orWhereNotNull($column) - { - return $this->whereNotNull($column, 'or'); - } - - /** - * Add a "where date" statement to the query. - * - * @param string $column - * @param string $operator - * @param int $value - * @param string $boolean - * @return \Illuminate\Database\Query\Builder|static - */ - public function whereDate($column, $operator, $value, $boolean = 'and') - { - return $this->addDateBasedWhere('Date', $column, $operator, $value, $boolean); - } - - /** - * Add a "where day" statement to the query. - * - * @param string $column - * @param string $operator - * @param int $value - * @param string $boolean - * @return \Illuminate\Database\Query\Builder|static - */ - public function whereDay($column, $operator, $value, $boolean = 'and') - { - return $this->addDateBasedWhere('Day', $column, $operator, $value, $boolean); - } - - /** - * Add a "where month" statement to the query. - * - * @param string $column - * @param string $operator - * @param int $value - * @param string $boolean - * @return \Illuminate\Database\Query\Builder|static - */ - public function whereMonth($column, $operator, $value, $boolean = 'and') - { - return $this->addDateBasedWhere('Month', $column, $operator, $value, $boolean); - } - - /** - * Add a "where year" statement to the query. - * - * @param string $column - * @param string $operator - * @param int $value - * @param string $boolean - * @return \Illuminate\Database\Query\Builder|static - */ - public function whereYear($column, $operator, $value, $boolean = 'and') - { - return $this->addDateBasedWhere('Year', $column, $operator, $value, $boolean); - } - - /** - * Add a date based (year, month, day) statement to the query. - * - * @param string $type - * @param string $column - * @param string $operator - * @param int $value - * @param string $boolean - * @return $this - */ - protected function addDateBasedWhere($type, $column, $operator, $value, $boolean = 'and') - { - $this->wheres[] = compact('column', 'type', 'boolean', 'operator', 'value'); - - $this->addBinding($value, 'where'); - - return $this; - } - - /** - * Handles dynamic "where" clauses to the query. - * - * @param string $method - * @param string $parameters - * @return $this - */ - public function dynamicWhere($method, $parameters) - { - $finder = substr($method, 5); - - $segments = preg_split('/(And|Or)(?=[A-Z])/', $finder, -1, PREG_SPLIT_DELIM_CAPTURE); - - // The connector variable will determine which connector will be used for the - // query condition. We will change it as we come across new boolean values - // in the dynamic method strings, which could contain a number of these. - $connector = 'and'; - - $index = 0; - - foreach ($segments as $segment) - { - // If the segment is not a boolean connector, we can assume it is a column's name - // and we will add it to the query as a new constraint as a where clause, then - // we can keep iterating through the dynamic method string's segments again. - if ($segment != 'And' && $segment != 'Or') - { - $this->addDynamic($segment, $connector, $parameters, $index); - - $index++; - } - - // Otherwise, we will store the connector so we know how the next where clause we - // find in the query should be connected to the previous ones, meaning we will - // have the proper boolean connector to connect the next where clause found. - else - { - $connector = $segment; - } - } - - return $this; - } - - /** - * Add a single dynamic where clause statement to the query. - * - * @param string $segment - * @param string $connector - * @param array $parameters - * @param int $index - * @return void - */ - protected function addDynamic($segment, $connector, $parameters, $index) - { - // Once we have parsed out the columns and formatted the boolean operators we - // are ready to add it to this query as a where clause just like any other - // clause on the query. Then we'll increment the parameter index values. - $bool = strtolower($connector); - - $this->where(snake_case($segment), '=', $parameters[$index], $bool); - } - - /** - * Add a "group by" clause to the query. - * - * @param array|string $column,... - * @return $this - */ - public function groupBy() - { - foreach (func_get_args() as $arg) - { - $this->groups = array_merge((array) $this->groups, is_array($arg) ? $arg : [$arg]); - } - - return $this; - } - - /** - * Add a "having" clause to the query. - * - * @param string $column - * @param string $operator - * @param string $value - * @param string $boolean - * @return $this - */ - public function having($column, $operator = null, $value = null, $boolean = 'and') - { - $type = 'basic'; - - $this->havings[] = compact('type', 'column', 'operator', 'value', 'boolean'); - - $this->addBinding($value, 'having'); - - return $this; - } - - /** - * Add a "or having" clause to the query. - * - * @param string $column - * @param string $operator - * @param string $value - * @return \Illuminate\Database\Query\Builder|static - */ - public function orHaving($column, $operator = null, $value = null) - { - return $this->having($column, $operator, $value, 'or'); - } - - /** - * Add a raw having clause to the query. - * - * @param string $sql - * @param array $bindings - * @param string $boolean - * @return $this - */ - public function havingRaw($sql, array $bindings = array(), $boolean = 'and') - { - $type = 'raw'; - - $this->havings[] = compact('type', 'sql', 'boolean'); - - $this->addBinding($bindings, 'having'); - - return $this; - } - - /** - * Add a raw or having clause to the query. - * - * @param string $sql - * @param array $bindings - * @return \Illuminate\Database\Query\Builder|static - */ - public function orHavingRaw($sql, array $bindings = array()) - { - return $this->havingRaw($sql, $bindings, 'or'); - } - - /** - * Add an "order by" clause to the query. - * - * @param string $column - * @param string $direction - * @return $this - */ - public function orderBy($column, $direction = 'asc') - { - $property = $this->unions ? 'unionOrders' : 'orders'; - $direction = strtolower($direction) == 'asc' ? 'asc' : 'desc'; - - $this->{$property}[] = compact('column', 'direction'); - - return $this; - } - - /** - * Add an "order by" clause for a timestamp to the query. - * - * @param string $column - * @return \Illuminate\Database\Query\Builder|static - */ - public function latest($column = 'created_at') - { - return $this->orderBy($column, 'desc'); - } - - /** - * Add an "order by" clause for a timestamp to the query. - * - * @param string $column - * @return \Illuminate\Database\Query\Builder|static - */ - public function oldest($column = 'created_at') - { - return $this->orderBy($column, 'asc'); - } - - /** - * Add a raw "order by" clause to the query. - * - * @param string $sql - * @param array $bindings - * @return $this - */ - public function orderByRaw($sql, $bindings = array()) - { - $type = 'raw'; - - $this->orders[] = compact('type', 'sql'); - - $this->addBinding($bindings, 'order'); - - return $this; - } - - /** - * Set the "offset" value of the query. - * - * @param int $value - * @return $this - */ - public function offset($value) - { - $property = $this->unions ? 'unionOffset' : 'offset'; - - $this->$property = 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); - } - - /** - * Set the "limit" value of the query. - * - * @param int $value - * @return $this - */ - public function limit($value) - { - $property = $this->unions ? 'unionLimit' : 'limit'; - - if ($value > 0) $this->$property = $value; - - return $this; - } - - /** - * Alias to set the "limit" value of the query. - * - * @param int $value - * @return \Illuminate\Database\Query\Builder|static - */ - public function take($value) - { - return $this->limit($value); - } - - /** - * 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); - } - - /** - * Add a union statement to the query. - * - * @param \Illuminate\Database\Query\Builder|\Closure $query - * @param bool $all - * @return \Illuminate\Database\Query\Builder|static - */ - public function union($query, $all = false) - { - if ($query instanceof Closure) - { - call_user_func($query, $query = $this->newQuery()); - } - - $this->unions[] = compact('query', 'all'); - - return $this->mergeBindings($query); - } - - /** - * Add a union all statement to the query. - * - * @param \Illuminate\Database\Query\Builder|\Closure $query - * @return \Illuminate\Database\Query\Builder|static - */ - public function unionAll($query) - { - return $this->union($query, true); - } - - /** - * Lock the selected rows in the table. - * - * @param bool $value - * @return $this - */ - public function lock($value = true) - { - $this->lock = $value; - - return $this; - } - - /** - * Lock the selected rows in the table for updating. - * - * @return \Illuminate\Database\Query\Builder - */ - public function lockForUpdate() - { - return $this->lock(true); - } - - /** - * Share lock the selected rows in the table. - * - * @return \Illuminate\Database\Query\Builder - */ - public function sharedLock() - { - return $this->lock(false); - } - - /** - * Get the SQL representation of the query. - * - * @return string - */ - public function toSql() - { - return $this->grammar->compileSelect($this); - } - - /** - * Indicate that the query results should be cached. - * - * @param \DateTime|int $minutes - * @param string $key - * @return $this - */ - public function remember($minutes, $key = null) - { - list($this->cacheMinutes, $this->cacheKey) = array($minutes, $key); - - return $this; - } - - /** - * Indicate that the query results should be cached forever. - * - * @param string $key - * @return \Illuminate\Database\Query\Builder|static - */ - public function rememberForever($key = null) - { - return $this->remember(-1, $key); - } - - /** - * Indicate that the results, if cached, should use the given cache tags. - * - * @param array|mixed $cacheTags - * @return $this - */ - public function cacheTags($cacheTags) - { - $this->cacheTags = $cacheTags; - - return $this; - } - - /** - * Indicate that the results, if cached, should use the given cache driver. - * - * @param string $cacheDriver - * @return $this - */ - public function cacheDriver($cacheDriver) - { - $this->cacheDriver = $cacheDriver; - - return $this; - } - - /** - * Execute a query for a single record by ID. - * - * @param int $id - * @param array $columns - * @return mixed|static - */ - public function find($id, $columns = array('*')) - { - return $this->where('id', '=', $id)->first($columns); - } - - /** - * Pluck a single column's value from the first result of a query. - * - * @param string $column - * @return mixed - */ - public function pluck($column) - { - $result = (array) $this->first(array($column)); - - return count($result) > 0 ? reset($result) : null; - } - - /** - * Execute the query and get the first result. - * - * @param array $columns - * @return mixed|static - */ - public function first($columns = array('*')) - { - $results = $this->take(1)->get($columns); - - return count($results) > 0 ? reset($results) : null; - } - - /** - * Execute the query as a "select" statement. - * - * @param array $columns - * @return array|static[] - */ - public function get($columns = array('*')) - { - if ( ! is_null($this->cacheMinutes)) return $this->getCached($columns); - - return $this->getFresh($columns); - } - - /** - * Execute the query as a fresh "select" statement. - * - * @param array $columns - * @return array|static[] - */ - public function getFresh($columns = array('*')) - { - if (is_null($this->columns)) $this->columns = $columns; - - return $this->processor->processSelect($this, $this->runSelect()); - } - - /** - * Run the query as a "select" statement against the connection. - * - * @return array - */ - protected function runSelect() - { - if ($this->useWritePdo) - { - return $this->connection->select($this->toSql(), $this->getBindings(), false); - } - - return $this->connection->select($this->toSql(), $this->getBindings()); - } - - /** - * Execute the query as a cached "select" statement. - * - * @param array $columns - * @return array - */ - public function getCached($columns = array('*')) - { - if (is_null($this->columns)) $this->columns = $columns; - - // If the query is requested to be cached, we will cache it using a unique key - // for this database connection and query statement, including the bindings - // that are used on this query, providing great convenience when caching. - list($key, $minutes) = $this->getCacheInfo(); - - $cache = $this->getCache(); - - $callback = $this->getCacheCallback($columns); - - // If the "minutes" value is less than zero, we will use that as the indicator - // that the value should be remembered values should be stored indefinitely - // and if we have minutes we will use the typical remember function here. - if ($minutes < 0) - { - return $cache->rememberForever($key, $callback); - } - - return $cache->remember($key, $minutes, $callback); - } - - /** - * Get the cache object with tags assigned, if applicable. - * - * @return \Illuminate\Cache\CacheManager - */ - protected function getCache() - { - $cache = $this->connection->getCacheManager()->driver($this->cacheDriver); - - return $this->cacheTags ? $cache->tags($this->cacheTags) : $cache; - } - - /** - * Get the cache key and cache minutes as an array. - * - * @return array - */ - protected function getCacheInfo() - { - return array($this->getCacheKey(), $this->cacheMinutes); - } - - /** - * Get a unique cache key for the complete query. - * - * @return string - */ - public function getCacheKey() - { - return $this->cacheKey ?: $this->generateCacheKey(); - } - - /** - * Generate the unique cache key for the query. - * - * @return string - */ - public function generateCacheKey() - { - $name = $this->connection->getName(); - - return md5($name.$this->toSql().serialize($this->getBindings())); - } - - /** - * Get the Closure callback used when caching queries. - * - * @param array $columns - * @return \Closure - */ - protected function getCacheCallback($columns) - { - return function() use ($columns) { return $this->getFresh($columns); }; - } - - /** - * Chunk the results of the query. - * - * @param int $count - * @param callable $callback - * @return void - */ - public function chunk($count, callable $callback) - { - $results = $this->forPage($page = 1, $count)->get(); - - while (count($results) > 0) - { - // On each chunk result set, we will pass them to the callback and then let the - // developer take care of everything within the callback, which allows us to - // keep the memory low for spinning through large result sets for working. - call_user_func($callback, $results); - - $page++; - - $results = $this->forPage($page, $count)->get(); - } - } - - /** - * Get an array with the values of a given column. - * - * @param string $column - * @param string $key - * @return array - */ - public function lists($column, $key = null) - { - $columns = $this->getListSelect($column, $key); - - // First we will just get all of the column values for the record result set - // then we can associate those values with the column if it was specified - // otherwise we can just give these values back without a specific key. - $results = new Collection($this->get($columns)); - - $values = $results->fetch($columns[0])->all(); - - // If a key was specified and we have results, we will go ahead and combine - // the values with the keys of all of the records so that the values can - // be accessed by the key of the rows instead of simply being numeric. - if ( ! is_null($key) && count($results) > 0) - { - $keys = $results->fetch($key)->all(); - - return array_combine($keys, $values); - } - - return $values; - } - - /** - * Get the columns that should be used in a list array. - * - * @param string $column - * @param string $key - * @return array - */ - protected function getListSelect($column, $key) - { - $select = is_null($key) ? array($column) : array($column, $key); - - // If the selected column contains a "dot", we will remove it so that the list - // operation can run normally. Specifying the table is not needed, since we - // really want the names of the columns as it is in this resulting array. - if (($dot = strpos($select[0], '.')) !== false) - { - $select[0] = substr($select[0], $dot + 1); - } - - return $select; - } - - /** - * Concatenate values of a given column as a string. - * - * @param string $column - * @param string $glue - * @return string - */ - public function implode($column, $glue = null) - { - if (is_null($glue)) return implode($this->lists($column)); - - return implode($glue, $this->lists($column)); - } - - /** - * Get a paginator for the "select" statement. - * - * @param int $perPage - * @param array $columns - * @return \Illuminate\Pagination\Paginator - */ - public function paginate($perPage = 15, $columns = array('*')) - { - $paginator = $this->connection->getPaginator(); - - if (isset($this->groups)) - { - return $this->groupedPaginate($paginator, $perPage, $columns); - } - - return $this->ungroupedPaginate($paginator, $perPage, $columns); - } - - /** - * Create a paginator for a grouped pagination statement. - * - * @param \Illuminate\Pagination\Factory $paginator - * @param int $perPage - * @param array $columns - * @return \Illuminate\Pagination\Paginator - */ - protected function groupedPaginate($paginator, $perPage, $columns) - { - $results = $this->get($columns); - - return $this->buildRawPaginator($paginator, $results, $perPage); - } - - /** - * Build a paginator instance from a raw result array. - * - * @param \Illuminate\Pagination\Factory $paginator - * @param array $results - * @param int $perPage - * @return \Illuminate\Pagination\Paginator - */ - public function buildRawPaginator($paginator, $results, $perPage) - { - // For queries which have a group by, we will actually retrieve the entire set - // of rows from the table and "slice" them via PHP. This is inefficient and - // the developer must be aware of this behavior; however, it's an option. - $start = ($paginator->getCurrentPage() - 1) * $perPage; - - $sliced = array_slice($results, $start, $perPage); - - return $paginator->make($sliced, count($results), $perPage); - } - - /** - * Create a paginator for an un-grouped pagination statement. - * - * @param \Illuminate\Pagination\Factory $paginator - * @param int $perPage - * @param array $columns - * @return \Illuminate\Pagination\Paginator - */ - protected function ungroupedPaginate($paginator, $perPage, $columns) - { - $total = $this->getPaginationCount(); - - // Once we have the total number of records to be paginated, we can grab the - // current page and the result array. Then we are ready to create a brand - // new Paginator instances for the results which will create the links. - $page = $paginator->getCurrentPage($total); - - $results = $this->forPage($page, $perPage)->get($columns); - - return $paginator->make($results, $total, $perPage); - } - - /** - * Get the count of the total records for pagination. - * - * @return int - */ - public function getPaginationCount() - { - $this->backupFieldsForCount(); - - // Because some database engines may throw errors if we leave the ordering - // statements on the query, we will "back them up" and remove them from - // the query. Once we have the count we will put them back onto this. - $total = $this->count(); - - $this->restoreFieldsForCount(); - - return $total; - } - - /** - * Get a paginator only supporting simple next and previous links. - * - * This is more efficient on larger data-sets, etc. - * - * @param int $perPage - * @param array $columns - * @return \Illuminate\Pagination\Paginator - */ - public function simplePaginate($perPage = null, $columns = array('*')) - { - $paginator = $this->connection->getPaginator(); - - $page = $paginator->getCurrentPage(); - - $perPage = $perPage ?: $this->model->getPerPage(); - - $this->skip(($page - 1) * $perPage)->take($perPage + 1); - - return $paginator->make($this->get($columns), $perPage); - } - - /** - * Backup certain fields for a pagination count. - * - * @return void - */ - protected function backupFieldsForCount() - { - foreach (array('orders', 'limit', 'offset') as $field) - { - $this->backups[$field] = $this->{$field}; - - $this->{$field} = null; - } - - } - - /** - * Restore certain fields for a pagination count. - * - * @return void - */ - protected function restoreFieldsForCount() - { - foreach (array('orders', 'limit', 'offset') as $field) - { - $this->{$field} = $this->backups[$field]; - } - - $this->backups = array(); - } - - /** - * Determine if any rows exist for the current query. - * - * @return bool - */ - public function exists() - { - $limit = $this->limit; - - $result = $this->limit(1)->count() > 0; - - $this->limit($limit); - - return $result; - } - - /** - * Retrieve the "count" result of the query. - * - * @param string $columns - * @return int - */ - public function count($columns = '*') - { - if ( ! is_array($columns)) - { - $columns = array($columns); - } - - return (int) $this->aggregate(__FUNCTION__, $columns); - } - - /** - * Retrieve the minimum value of a given column. - * - * @param string $column - * @return mixed - */ - public function min($column) - { - return $this->aggregate(__FUNCTION__, array($column)); - } - - /** - * Retrieve the maximum value of a given column. - * - * @param string $column - * @return mixed - */ - public function max($column) - { - return $this->aggregate(__FUNCTION__, array($column)); - } - - /** - * Retrieve the sum of the values of a given column. - * - * @param string $column - * @return mixed - */ - public function sum($column) - { - $result = $this->aggregate(__FUNCTION__, array($column)); - - return $result ?: 0; - } - - /** - * Retrieve the average of the values of a given column. - * - * @param string $column - * @return mixed - */ - public function avg($column) - { - return $this->aggregate(__FUNCTION__, array($column)); - } - - /** - * Execute an aggregate function on the database. - * - * @param string $function - * @param array $columns - * @return mixed - */ - public function aggregate($function, $columns = array('*')) - { - $this->aggregate = compact('function', 'columns'); - - $previousColumns = $this->columns; - - $results = $this->get($columns); - - // Once we have executed the query, we will reset the aggregate property so - // that more select queries can be executed against the database without - // the aggregate value getting in the way when the grammar builds it. - $this->aggregate = null; - - $this->columns = $previousColumns; - - if (isset($results[0])) - { - $result = array_change_key_case((array) $results[0]); - - return $result['aggregate']; - } - } - - /** - * Insert a new record into the database. - * - * @param array $values - * @return bool - */ - public function insert(array $values) - { - // Since every insert gets treated like a batch insert, we will make sure the - // bindings are structured in a way that is convenient for building these - // inserts statements by verifying the elements are actually an array. - if ( ! is_array(reset($values))) - { - $values = array($values); - } - - // Since every insert gets treated like a batch insert, we will make sure the - // bindings are structured in a way that is convenient for building these - // inserts statements by verifying the elements are actually an array. - else - { - foreach ($values as $key => $value) - { - ksort($value); $values[$key] = $value; - } - } - - // We'll treat every insert like a batch insert so we can easily insert each - // of the records into the database consistently. This will make it much - // easier on the grammars to just handle one type of record insertion. - $bindings = array(); - - foreach ($values as $record) - { - foreach ($record as $value) - { - $bindings[] = $value; - } - } - - $sql = $this->grammar->compileInsert($this, $values); - - // Once we have compiled the insert statement's SQL we can execute it on the - // connection and return a result as a boolean success indicator as that - // is the same type of result returned by the raw connection instance. - $bindings = $this->cleanBindings($bindings); - - return $this->connection->insert($sql, $bindings); - } - - /** - * Insert a new record and get the value of the primary key. - * - * @param array $values - * @param string $sequence - * @return int - */ - public function insertGetId(array $values, $sequence = null) - { - $sql = $this->grammar->compileInsertGetId($this, $values, $sequence); - - $values = $this->cleanBindings($values); - - return $this->processor->processInsertGetId($this, $sql, $values, $sequence); - } - - /** - * Update a record in the database. - * - * @param array $values - * @return int - */ - public function update(array $values) - { - $bindings = array_values(array_merge($values, $this->getBindings())); - - $sql = $this->grammar->compileUpdate($this, $values); - - return $this->connection->update($sql, $this->cleanBindings($bindings)); - } - - /** - * Increment a column's value by a given amount. - * - * @param string $column - * @param int $amount - * @param array $extra - * @return int - */ - public function increment($column, $amount = 1, array $extra = array()) - { - $wrapped = $this->grammar->wrap($column); - - $columns = array_merge(array($column => $this->raw("$wrapped + $amount")), $extra); - - return $this->update($columns); - } - - /** - * Decrement a column's value by a given amount. - * - * @param string $column - * @param int $amount - * @param array $extra - * @return int - */ - public function decrement($column, $amount = 1, array $extra = array()) - { - $wrapped = $this->grammar->wrap($column); - - $columns = array_merge(array($column => $this->raw("$wrapped - $amount")), $extra); - - return $this->update($columns); - } - - /** - * Delete a record from the database. - * - * @param mixed $id - * @return int - */ - public function delete($id = null) - { - // If an ID is passed to the method, we will set the where clause to check - // the ID to allow developers to simply and quickly remove a single row - // from their database without manually specifying the where clauses. - if ( ! is_null($id)) $this->where('id', '=', $id); - - $sql = $this->grammar->compileDelete($this); - - return $this->connection->delete($sql, $this->getBindings()); - } - - /** - * Run a truncate statement on the table. - * - * @return void - */ - public function truncate() - { - foreach ($this->grammar->compileTruncate($this) as $sql => $bindings) - { - $this->connection->statement($sql, $bindings); - } - } - - /** - * Get a new instance of the query builder. - * - * @return \Illuminate\Database\Query\Builder - */ - public function newQuery() - { - return new Builder($this->connection, $this->grammar, $this->processor); - } - - /** - * Merge an array of where clauses and bindings. - * - * @param array $wheres - * @param array $bindings - * @return void - */ - public function mergeWheres($wheres, $bindings) - { - $this->wheres = array_merge((array) $this->wheres, (array) $wheres); - - $this->bindings['where'] = array_values(array_merge($this->bindings['where'], (array) $bindings)); - } - - /** - * Remove all of the expressions from a list of bindings. - * - * @param array $bindings - * @return array - */ - protected function cleanBindings(array $bindings) - { - return array_values(array_filter($bindings, function($binding) - { - return ! $binding instanceof Expression; - })); - } - - /** - * Create a raw database expression. - * - * @param mixed $value - * @return \Illuminate\Database\Query\Expression - */ - public function raw($value) - { - return $this->connection->raw($value); - } - - /** - * Get the current query value bindings in a flattened array. - * - * @return array - */ - public function getBindings() - { - return array_flatten($this->bindings); - } - - /** - * Get the raw array of bindings. - * - * @return array - */ - public function getRawBindings() - { - return $this->bindings; - } - - /** - * Set the bindings on the query builder. - * - * @param array $bindings - * @param string $type - * @return $this - * - * @throws \InvalidArgumentException - */ - public function setBindings(array $bindings, $type = 'where') - { - if ( ! array_key_exists($type, $this->bindings)) - { - throw new \InvalidArgumentException("Invalid binding type: {$type}."); - } - - $this->bindings[$type] = $bindings; - - return $this; - } - - /** - * Add a binding to the query. - * - * @param mixed $value - * @param string $type - * @return $this - * - * @throws \InvalidArgumentException - */ - public function addBinding($value, $type = 'where') - { - if ( ! array_key_exists($type, $this->bindings)) - { - throw new \InvalidArgumentException("Invalid binding type: {$type}."); - } - - if (is_array($value)) - { - $this->bindings[$type] = array_values(array_merge($this->bindings[$type], $value)); - } - else - { - $this->bindings[$type][] = $value; - } - - return $this; - } - - /** - * Merge an array of bindings into our bindings. - * - * @param \Illuminate\Database\Query\Builder $query - * @return $this - */ - public function mergeBindings(Builder $query) - { - $this->bindings = array_merge_recursive($this->bindings, $query->bindings); - - return $this; - } - - /** - * Get the database connection instance. - * - * @return \Illuminate\Database\ConnectionInterface - */ - public function getConnection() - { - return $this->connection; - } - - /** - * Get the database query processor instance. - * - * @return \Illuminate\Database\Query\Processors\Processor - */ - public function getProcessor() - { - return $this->processor; - } - - /** - * Get the query grammar instance. - * - * @return \Illuminate\Database\Grammar - */ - public function getGrammar() - { - return $this->grammar; - } - - /** - * Use the write pdo for query. - * - * @return $this - */ - public function useWritePdo() - { - $this->useWritePdo = true; - - return $this; - } - - /** - * Handle dynamic method calls into the method. - * - * @param string $method - * @param array $parameters - * @return mixed - * - * @throws \BadMethodCallException - */ - public function __call($method, $parameters) - { - if (starts_with($method, 'where')) - { - return $this->dynamicWhere($method, $parameters); - } - - $className = get_class($this); - - throw new \BadMethodCallException("Call to undefined method {$className}::{$method}()"); - } - -}
http://git-wip-us.apache.org/repos/asf/airavata-php-gateway/blob/80fd786e/vendor/laravel/framework/src/Illuminate/Database/Query/Expression.php ---------------------------------------------------------------------- diff --git a/vendor/laravel/framework/src/Illuminate/Database/Query/Expression.php b/vendor/laravel/framework/src/Illuminate/Database/Query/Expression.php deleted file mode 100755 index 68d2236..0000000 --- a/vendor/laravel/framework/src/Illuminate/Database/Query/Expression.php +++ /dev/null @@ -1,43 +0,0 @@ -<?php namespace Illuminate\Database\Query; - -class Expression { - - /** - * The value of the expression. - * - * @var mixed - */ - protected $value; - - /** - * Create a new raw query expression. - * - * @param mixed $value - * @return void - */ - public function __construct($value) - { - $this->value = $value; - } - - /** - * Get the value of the expression. - * - * @return mixed - */ - public function getValue() - { - return $this->value; - } - - /** - * Get the value of the expression. - * - * @return string - */ - public function __toString() - { - return (string) $this->getValue(); - } - -} http://git-wip-us.apache.org/repos/asf/airavata-php-gateway/blob/80fd786e/vendor/laravel/framework/src/Illuminate/Database/Query/Grammars/Grammar.php ---------------------------------------------------------------------- diff --git a/vendor/laravel/framework/src/Illuminate/Database/Query/Grammars/Grammar.php b/vendor/laravel/framework/src/Illuminate/Database/Query/Grammars/Grammar.php deleted file mode 100755 index 6998370..0000000 --- a/vendor/laravel/framework/src/Illuminate/Database/Query/Grammars/Grammar.php +++ /dev/null @@ -1,759 +0,0 @@ -<?php namespace Illuminate\Database\Query\Grammars; - -use Illuminate\Database\Query\Builder; -use Illuminate\Database\Grammar as BaseGrammar; - -class Grammar extends BaseGrammar { - - /** - * The components that make up a select clause. - * - * @var array - */ - protected $selectComponents = array( - 'aggregate', - 'columns', - 'from', - 'joins', - 'wheres', - 'groups', - 'havings', - 'orders', - 'limit', - 'offset', - 'unions', - 'lock', - ); - - /** - * Compile a select query into SQL. - * - * @param \Illuminate\Database\Query\Builder - * @return string - */ - public function compileSelect(Builder $query) - { - if (is_null($query->columns)) $query->columns = array('*'); - - return trim($this->concatenate($this->compileComponents($query))); - } - - /** - * Compile the components necessary for a select clause. - * - * @param \Illuminate\Database\Query\Builder - * @return array - */ - protected function compileComponents(Builder $query) - { - $sql = array(); - - foreach ($this->selectComponents as $component) - { - // To compile the query, we'll spin through each component of the query and - // see if that component exists. If it does we'll just call the compiler - // function for the component which is responsible for making the SQL. - if ( ! is_null($query->$component)) - { - $method = 'compile'.ucfirst($component); - - $sql[$component] = $this->$method($query, $query->$component); - } - } - - return $sql; - } - - /** - * Compile an aggregated select clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $aggregate - * @return string - */ - protected function compileAggregate(Builder $query, $aggregate) - { - $column = $this->columnize($aggregate['columns']); - - // If the query has a "distinct" constraint and we're not asking for all columns - // we need to prepend "distinct" onto the column name so that the query takes - // it into account when it performs the aggregating operations on the data. - if ($query->distinct && $column !== '*') - { - $column = 'distinct '.$column; - } - - return 'select '.$aggregate['function'].'('.$column.') as aggregate'; - } - - /** - * Compile the "select *" portion of the query. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $columns - * @return string - */ - protected function compileColumns(Builder $query, $columns) - { - // If the query is actually performing an aggregating select, we will let that - // compiler handle the building of the select clauses, as it will need some - // more syntax that is best handled by that function to keep things neat. - if ( ! is_null($query->aggregate)) return; - - $select = $query->distinct ? 'select distinct ' : 'select '; - - return $select.$this->columnize($columns); - } - - /** - * Compile the "from" portion of the query. - * - * @param \Illuminate\Database\Query\Builder $query - * @param string $table - * @return string - */ - protected function compileFrom(Builder $query, $table) - { - return 'from '.$this->wrapTable($table); - } - - /** - * Compile the "join" portions of the query. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $joins - * @return string - */ - protected function compileJoins(Builder $query, $joins) - { - $sql = array(); - - $query->setBindings(array(), 'join'); - - foreach ($joins as $join) - { - $table = $this->wrapTable($join->table); - - // First we need to build all of the "on" clauses for the join. There may be many - // of these clauses so we will need to iterate through each one and build them - // separately, then we'll join them up into a single string when we're done. - $clauses = array(); - - foreach ($join->clauses as $clause) - { - $clauses[] = $this->compileJoinConstraint($clause); - } - - foreach ($join->bindings as $binding) - { - $query->addBinding($binding, 'join'); - } - - // Once we have constructed the clauses, we'll need to take the boolean connector - // off of the first clause as it obviously will not be required on that clause - // because it leads the rest of the clauses, thus not requiring any boolean. - $clauses[0] = $this->removeLeadingBoolean($clauses[0]); - - $clauses = implode(' ', $clauses); - - $type = $join->type; - - // Once we have everything ready to go, we will just concatenate all the parts to - // build the final join statement SQL for the query and we can then return the - // final clause back to the callers as a single, stringified join statement. - $sql[] = "$type join $table on $clauses"; - } - - return implode(' ', $sql); - } - - /** - * Create a join clause constraint segment. - * - * @param array $clause - * @return string - */ - protected function compileJoinConstraint(array $clause) - { - $first = $this->wrap($clause['first']); - - $second = $clause['where'] ? '?' : $this->wrap($clause['second']); - - return "{$clause['boolean']} $first {$clause['operator']} $second"; - } - - /** - * Compile the "where" portions of the query. - * - * @param \Illuminate\Database\Query\Builder $query - * @return string - */ - protected function compileWheres(Builder $query) - { - $sql = array(); - - if (is_null($query->wheres)) return ''; - - // Each type of where clauses has its own compiler function which is responsible - // for actually creating the where clauses SQL. This helps keep the code nice - // and maintainable since each clause has a very small method that it uses. - foreach ($query->wheres as $where) - { - $method = "where{$where['type']}"; - - $sql[] = $where['boolean'].' '.$this->$method($query, $where); - } - - // If we actually have some where clauses, we will strip off the first boolean - // operator, which is added by the query builders for convenience so we can - // avoid checking for the first clauses in each of the compilers methods. - if (count($sql) > 0) - { - $sql = implode(' ', $sql); - - return 'where '.preg_replace('/and |or /', '', $sql, 1); - } - - return ''; - } - - /** - * Compile a nested where clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereNested(Builder $query, $where) - { - $nested = $where['query']; - - return '('.substr($this->compileWheres($nested), 6).')'; - } - - /** - * Compile a where condition with a sub-select. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereSub(Builder $query, $where) - { - $select = $this->compileSelect($where['query']); - - return $this->wrap($where['column']).' '.$where['operator']." ($select)"; - } - - /** - * Compile a basic where clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereBasic(Builder $query, $where) - { - $value = $this->parameter($where['value']); - - return $this->wrap($where['column']).' '.$where['operator'].' '.$value; - } - - /** - * Compile a "between" where clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereBetween(Builder $query, $where) - { - $between = $where['not'] ? 'not between' : 'between'; - - return $this->wrap($where['column']).' '.$between.' ? and ?'; - } - - /** - * Compile a where exists clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereExists(Builder $query, $where) - { - return 'exists ('.$this->compileSelect($where['query']).')'; - } - - /** - * Compile a where exists clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereNotExists(Builder $query, $where) - { - return 'not exists ('.$this->compileSelect($where['query']).')'; - } - - /** - * Compile a "where in" clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereIn(Builder $query, $where) - { - if (empty($where['values'])) return '0 = 1'; - - $values = $this->parameterize($where['values']); - - return $this->wrap($where['column']).' in ('.$values.')'; - } - - /** - * Compile a "where not in" clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereNotIn(Builder $query, $where) - { - if (empty($where['values'])) return '1 = 1'; - - $values = $this->parameterize($where['values']); - - return $this->wrap($where['column']).' not in ('.$values.')'; - } - - /** - * Compile a where in sub-select clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereInSub(Builder $query, $where) - { - $select = $this->compileSelect($where['query']); - - return $this->wrap($where['column']).' in ('.$select.')'; - } - - /** - * Compile a where not in sub-select clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereNotInSub(Builder $query, $where) - { - $select = $this->compileSelect($where['query']); - - return $this->wrap($where['column']).' not in ('.$select.')'; - } - - /** - * Compile a "where null" clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereNull(Builder $query, $where) - { - return $this->wrap($where['column']).' is null'; - } - - /** - * Compile a "where not null" clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereNotNull(Builder $query, $where) - { - return $this->wrap($where['column']).' is not null'; - } - - /** - * Compile a "where date" clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereDate(Builder $query, $where) - { - return $this->dateBasedWhere('date', $query, $where); - } - - /** - * Compile a "where day" clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereDay(Builder $query, $where) - { - return $this->dateBasedWhere('day', $query, $where); - } - - /** - * Compile a "where month" clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereMonth(Builder $query, $where) - { - return $this->dateBasedWhere('month', $query, $where); - } - - /** - * Compile a "where year" clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereYear(Builder $query, $where) - { - return $this->dateBasedWhere('year', $query, $where); - } - - /** - * Compile a date based where clause. - * - * @param string $type - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function dateBasedWhere($type, Builder $query, $where) - { - $value = $this->parameter($where['value']); - - return $type.'('.$this->wrap($where['column']).') '.$where['operator'].' '.$value; - } - - /** - * Compile a raw where clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereRaw(Builder $query, $where) - { - return $where['sql']; - } - - /** - * Compile the "group by" portions of the query. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $groups - * @return string - */ - protected function compileGroups(Builder $query, $groups) - { - return 'group by '.$this->columnize($groups); - } - - /** - * Compile the "having" portions of the query. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $havings - * @return string - */ - protected function compileHavings(Builder $query, $havings) - { - $sql = implode(' ', array_map(array($this, 'compileHaving'), $havings)); - - return 'having '.preg_replace('/and |or /', '', $sql, 1); - } - - /** - * Compile a single having clause. - * - * @param array $having - * @return string - */ - protected function compileHaving(array $having) - { - // If the having clause is "raw", we can just return the clause straight away - // without doing any more processing on it. Otherwise, we will compile the - // clause into SQL based on the components that make it up from builder. - if ($having['type'] === 'raw') - { - return $having['boolean'].' '.$having['sql']; - } - - return $this->compileBasicHaving($having); - } - - /** - * Compile a basic having clause. - * - * @param array $having - * @return string - */ - protected function compileBasicHaving($having) - { - $column = $this->wrap($having['column']); - - $parameter = $this->parameter($having['value']); - - return $having['boolean'].' '.$column.' '.$having['operator'].' '.$parameter; - } - - /** - * Compile the "order by" portions of the query. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $orders - * @return string - */ - protected function compileOrders(Builder $query, $orders) - { - return 'order by '.implode(', ', array_map(function($order) - { - if (isset($order['sql'])) return $order['sql']; - - return $this->wrap($order['column']).' '.$order['direction']; - } - , $orders)); - } - - /** - * Compile the "limit" portions of the query. - * - * @param \Illuminate\Database\Query\Builder $query - * @param int $limit - * @return string - */ - protected function compileLimit(Builder $query, $limit) - { - return 'limit '.(int) $limit; - } - - /** - * Compile the "offset" portions of the query. - * - * @param \Illuminate\Database\Query\Builder $query - * @param int $offset - * @return string - */ - protected function compileOffset(Builder $query, $offset) - { - return 'offset '.(int) $offset; - } - - /** - * Compile the "union" queries attached to the main query. - * - * @param \Illuminate\Database\Query\Builder $query - * @return string - */ - protected function compileUnions(Builder $query) - { - $sql = ''; - - foreach ($query->unions as $union) - { - $sql .= $this->compileUnion($union); - } - - if (isset($query->unionOrders)) - { - $sql .= ' '.$this->compileOrders($query, $query->unionOrders); - } - - if (isset($query->unionLimit)) - { - $sql .= ' '.$this->compileLimit($query, $query->unionLimit); - } - - if (isset($query->unionOffset)) - { - $sql .= ' '.$this->compileOffset($query, $query->unionOffset); - } - - return ltrim($sql); - } - - /** - * Compile a single union statement. - * - * @param array $union - * @return string - */ - protected function compileUnion(array $union) - { - $joiner = $union['all'] ? ' union all ' : ' union '; - - return $joiner.$union['query']->toSql(); - } - - /** - * Compile an insert statement into SQL. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $values - * @return string - */ - public function compileInsert(Builder $query, array $values) - { - // Essentially we will force every insert to be treated as a batch insert which - // simply makes creating the SQL easier for us since we can utilize the same - // basic routine regardless of an amount of records given to us to insert. - $table = $this->wrapTable($query->from); - - if ( ! is_array(reset($values))) - { - $values = array($values); - } - - $columns = $this->columnize(array_keys(reset($values))); - - // We need to build a list of parameter place-holders of values that are bound - // to the query. Each insert should have the exact same amount of parameter - // bindings so we can just go off the first list of values in this array. - $parameters = $this->parameterize(reset($values)); - - $value = array_fill(0, count($values), "($parameters)"); - - $parameters = implode(', ', $value); - - return "insert into $table ($columns) values $parameters"; - } - - /** - * Compile an insert and get ID statement into SQL. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $values - * @param string $sequence - * @return string - */ - public function compileInsertGetId(Builder $query, $values, $sequence) - { - return $this->compileInsert($query, $values); - } - - /** - * Compile an update statement into SQL. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $values - * @return string - */ - public function compileUpdate(Builder $query, $values) - { - $table = $this->wrapTable($query->from); - - // Each one of the columns in the update statements needs to be wrapped in the - // keyword identifiers, also a place-holder needs to be created for each of - // the values in the list of bindings so we can make the sets statements. - $columns = array(); - - foreach ($values as $key => $value) - { - $columns[] = $this->wrap($key).' = '.$this->parameter($value); - } - - $columns = implode(', ', $columns); - - // If the query has any "join" clauses, we will setup the joins on the builder - // and compile them so we can attach them to this update, as update queries - // can get join statements to attach to other tables when they're needed. - if (isset($query->joins)) - { - $joins = ' '.$this->compileJoins($query, $query->joins); - } - else - { - $joins = ''; - } - - // Of course, update queries may also be constrained by where clauses so we'll - // need to compile the where clauses and attach it to the query so only the - // intended records are updated by the SQL statements we generate to run. - $where = $this->compileWheres($query); - - return trim("update {$table}{$joins} set $columns $where"); - } - - /** - * Compile a delete statement into SQL. - * - * @param \Illuminate\Database\Query\Builder $query - * @return string - */ - public function compileDelete(Builder $query) - { - $table = $this->wrapTable($query->from); - - $where = is_array($query->wheres) ? $this->compileWheres($query) : ''; - - return trim("delete from $table ".$where); - } - - /** - * Compile a truncate table statement into SQL. - * - * @param \Illuminate\Database\Query\Builder $query - * @return array - */ - public function compileTruncate(Builder $query) - { - return array('truncate '.$this->wrapTable($query->from) => array()); - } - - /** - * Compile the lock into SQL. - * - * @param \Illuminate\Database\Query\Builder $query - * @param bool|string $value - * @return string - */ - protected function compileLock(Builder $query, $value) - { - return is_string($value) ? $value : ''; - } - - /** - * Concatenate an array of segments, removing empties. - * - * @param array $segments - * @return string - */ - protected function concatenate($segments) - { - return implode(' ', array_filter($segments, function($value) - { - return (string) $value !== ''; - })); - } - - /** - * Remove the leading boolean from a statement. - * - * @param string $value - * @return string - */ - protected function removeLeadingBoolean($value) - { - return preg_replace('/and |or /', '', $value, 1); - } - -} http://git-wip-us.apache.org/repos/asf/airavata-php-gateway/blob/80fd786e/vendor/laravel/framework/src/Illuminate/Database/Query/Grammars/MySqlGrammar.php ---------------------------------------------------------------------- diff --git a/vendor/laravel/framework/src/Illuminate/Database/Query/Grammars/MySqlGrammar.php b/vendor/laravel/framework/src/Illuminate/Database/Query/Grammars/MySqlGrammar.php deleted file mode 100755 index b068e2b..0000000 --- a/vendor/laravel/framework/src/Illuminate/Database/Query/Grammars/MySqlGrammar.php +++ /dev/null @@ -1,130 +0,0 @@ -<?php namespace Illuminate\Database\Query\Grammars; - -use Illuminate\Database\Query\Builder; - -class MySqlGrammar extends Grammar { - - /** - * The components that make up a select clause. - * - * @var array - */ - protected $selectComponents = array( - 'aggregate', - 'columns', - 'from', - 'joins', - 'wheres', - 'groups', - 'havings', - 'orders', - 'limit', - 'offset', - 'lock', - ); - - /** - * Compile a select query into SQL. - * - * @param \Illuminate\Database\Query\Builder - * @return string - */ - public function compileSelect(Builder $query) - { - $sql = parent::compileSelect($query); - - if ($query->unions) - { - $sql = '('.$sql.') '.$this->compileUnions($query); - } - - return $sql; - } - - /** - * Compile a single union statement. - * - * @param array $union - * @return string - */ - protected function compileUnion(array $union) - { - $joiner = $union['all'] ? ' union all ' : ' union '; - - return $joiner.'('.$union['query']->toSql().')'; - } - - /** - * Compile the lock into SQL. - * - * @param \Illuminate\Database\Query\Builder $query - * @param bool|string $value - * @return string - */ - protected function compileLock(Builder $query, $value) - { - if (is_string($value)) return $value; - - return $value ? 'for update' : 'lock in share mode'; - } - - /** - * Compile an update statement into SQL. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $values - * @return string - */ - public function compileUpdate(Builder $query, $values) - { - $sql = parent::compileUpdate($query, $values); - - if (isset($query->orders)) - { - $sql .= ' '.$this->compileOrders($query, $query->orders); - } - - if (isset($query->limit)) - { - $sql .= ' '.$this->compileLimit($query, $query->limit); - } - - return rtrim($sql); - } - - /** - * Compile a delete statement into SQL. - * - * @param \Illuminate\Database\Query\Builder $query - * @return string - */ - public function compileDelete(Builder $query) - { - $table = $this->wrapTable($query->from); - - $where = is_array($query->wheres) ? $this->compileWheres($query) : ''; - - if (isset($query->joins)) - { - $joins = ' '.$this->compileJoins($query, $query->joins); - - return trim("delete $table from {$table}{$joins} $where"); - } - - return trim("delete from $table $where"); - } - - /** - * Wrap a single string in keyword identifiers. - * - * @param string $value - * @return string - */ - protected function wrapValue($value) - { - if ($value === '*') return $value; - - return '`'.str_replace('`', '``', $value).'`'; - } - -} http://git-wip-us.apache.org/repos/asf/airavata-php-gateway/blob/80fd786e/vendor/laravel/framework/src/Illuminate/Database/Query/Grammars/PostgresGrammar.php ---------------------------------------------------------------------- diff --git a/vendor/laravel/framework/src/Illuminate/Database/Query/Grammars/PostgresGrammar.php b/vendor/laravel/framework/src/Illuminate/Database/Query/Grammars/PostgresGrammar.php deleted file mode 100755 index 7a8df9c..0000000 --- a/vendor/laravel/framework/src/Illuminate/Database/Query/Grammars/PostgresGrammar.php +++ /dev/null @@ -1,174 +0,0 @@ -<?php namespace Illuminate\Database\Query\Grammars; - -use Illuminate\Database\Query\Builder; - -class PostgresGrammar extends Grammar { - - /** - * All of the available clause operators. - * - * @var array - */ - protected $operators = array( - '=', '<', '>', '<=', '>=', '<>', '!=', - 'like', 'not like', 'between', 'ilike', - '&', '|', '#', '<<', '>>', - ); - - /** - * Compile the lock into SQL. - * - * @param \Illuminate\Database\Query\Builder $query - * @param bool|string $value - * @return string - */ - protected function compileLock(Builder $query, $value) - { - if (is_string($value)) return $value; - - return $value ? 'for update' : 'for share'; - } - - /** - * Compile an update statement into SQL. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $values - * @return string - */ - public function compileUpdate(Builder $query, $values) - { - $table = $this->wrapTable($query->from); - - // Each one of the columns in the update statements needs to be wrapped in the - // keyword identifiers, also a place-holder needs to be created for each of - // the values in the list of bindings so we can make the sets statements. - $columns = $this->compileUpdateColumns($values); - - $from = $this->compileUpdateFrom($query); - - $where = $this->compileUpdateWheres($query); - - return trim("update {$table} set {$columns}{$from} $where"); - } - - /** - * Compile the columns for the update statement. - * - * @param array $values - * @return string - */ - protected function compileUpdateColumns($values) - { - $columns = array(); - - // When gathering the columns for an update statement, we'll wrap each of the - // columns and convert it to a parameter value. Then we will concatenate a - // list of the columns that can be added into this update query clauses. - foreach ($values as $key => $value) - { - $columns[] = $this->wrap($key).' = '.$this->parameter($value); - } - - return implode(', ', $columns); - } - - /** - * Compile the "from" clause for an update with a join. - * - * @param \Illuminate\Database\Query\Builder $query - * @return string - */ - protected function compileUpdateFrom(Builder $query) - { - if ( ! isset($query->joins)) return ''; - - $froms = array(); - - // When using Postgres, updates with joins list the joined tables in the from - // clause, which is different than other systems like MySQL. Here, we will - // compile out the tables that are joined and add them to a from clause. - foreach ($query->joins as $join) - { - $froms[] = $this->wrapTable($join->table); - } - - if (count($froms) > 0) return ' from '.implode(', ', $froms); - } - - /** - * Compile the additional where clauses for updates with joins. - * - * @param \Illuminate\Database\Query\Builder $query - * @return string - */ - protected function compileUpdateWheres(Builder $query) - { - $baseWhere = $this->compileWheres($query); - - if ( ! isset($query->joins)) return $baseWhere; - - // Once we compile the join constraints, we will either use them as the where - // clause or append them to the existing base where clauses. If we need to - // strip the leading boolean we will do so when using as the only where. - $joinWhere = $this->compileUpdateJoinWheres($query); - - if (trim($baseWhere) == '') - { - return 'where '.$this->removeLeadingBoolean($joinWhere); - } - - return $baseWhere.' '.$joinWhere; - } - - /** - * Compile the "join" clauses for an update. - * - * @param \Illuminate\Database\Query\Builder $query - * @return string - */ - protected function compileUpdateJoinWheres(Builder $query) - { - $joinWheres = array(); - - // Here we will just loop through all of the join constraints and compile them - // all out then implode them. This should give us "where" like syntax after - // everything has been built and then we will join it to the real wheres. - foreach ($query->joins as $join) - { - foreach ($join->clauses as $clause) - { - $joinWheres[] = $this->compileJoinConstraint($clause); - } - } - - return implode(' ', $joinWheres); - } - - /** - * Compile an insert and get ID statement into SQL. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $values - * @param string $sequence - * @return string - */ - public function compileInsertGetId(Builder $query, $values, $sequence) - { - if (is_null($sequence)) $sequence = 'id'; - - return $this->compileInsert($query, $values).' returning '.$this->wrap($sequence); - } - - /** - * Compile a truncate table statement into SQL. - * - * @param \Illuminate\Database\Query\Builder $query - * @return array - */ - public function compileTruncate(Builder $query) - { - return array('truncate '.$this->wrapTable($query->from).' restart identity' => array()); - } - -} http://git-wip-us.apache.org/repos/asf/airavata-php-gateway/blob/80fd786e/vendor/laravel/framework/src/Illuminate/Database/Query/Grammars/SQLiteGrammar.php ---------------------------------------------------------------------- diff --git a/vendor/laravel/framework/src/Illuminate/Database/Query/Grammars/SQLiteGrammar.php b/vendor/laravel/framework/src/Illuminate/Database/Query/Grammars/SQLiteGrammar.php deleted file mode 100755 index 01558d3..0000000 --- a/vendor/laravel/framework/src/Illuminate/Database/Query/Grammars/SQLiteGrammar.php +++ /dev/null @@ -1,130 +0,0 @@ -<?php namespace Illuminate\Database\Query\Grammars; - -use Illuminate\Database\Query\Builder; - -class SQLiteGrammar extends Grammar { - - /** - * All of the available clause operators. - * - * @var array - */ - protected $operators = array( - '=', '<', '>', '<=', '>=', '<>', '!=', - 'like', 'not like', 'between', 'ilike', - '&', '|', '<<', '>>', - ); - - /** - * Compile an insert statement into SQL. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $values - * @return string - */ - public function compileInsert(Builder $query, array $values) - { - // Essentially we will force every insert to be treated as a batch insert which - // simply makes creating the SQL easier for us since we can utilize the same - // basic routine regardless of an amount of records given to us to insert. - $table = $this->wrapTable($query->from); - - if ( ! is_array(reset($values))) - { - $values = array($values); - } - - // If there is only one record being inserted, we will just use the usual query - // grammar insert builder because no special syntax is needed for the single - // row inserts in SQLite. However, if there are multiples, we'll continue. - if (count($values) == 1) - { - return parent::compileInsert($query, reset($values)); - } - - $names = $this->columnize(array_keys(reset($values))); - - $columns = array(); - - // SQLite requires us to build the multi-row insert as a listing of select with - // unions joining them together. So we'll build out this list of columns and - // then join them all together with select unions to complete the queries. - foreach (array_keys(reset($values)) as $column) - { - $columns[] = '? as '.$this->wrap($column); - } - - $columns = array_fill(0, count($values), implode(', ', $columns)); - - return "insert into $table ($names) select ".implode(' union select ', $columns); - } - - /** - * Compile a truncate table statement into SQL. - * - * @param \Illuminate\Database\Query\Builder $query - * @return array - */ - public function compileTruncate(Builder $query) - { - $sql = array('delete from sqlite_sequence where name = ?' => array($query->from)); - - $sql['delete from '.$this->wrapTable($query->from)] = array(); - - return $sql; - } - - /** - * Compile a "where day" clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereDay(Builder $query, $where) - { - return $this->dateBasedWhere('%d', $query, $where); - } - - /** - * Compile a "where month" clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereMonth(Builder $query, $where) - { - return $this->dateBasedWhere('%m', $query, $where); - } - - /** - * Compile a "where year" clause. - * - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function whereYear(Builder $query, $where) - { - return $this->dateBasedWhere('%Y', $query, $where); - } - - /** - * Compile a date based where clause. - * - * @param string $type - * @param \Illuminate\Database\Query\Builder $query - * @param array $where - * @return string - */ - protected function dateBasedWhere($type, Builder $query, $where) - { - $value = str_pad($where['value'], 2, '0', STR_PAD_LEFT); - - $value = $this->parameter($value); - - return 'strftime(\''.$type.'\', '.$this->wrap($where['column']).') '.$where['operator'].' '.$value; - } - -}
