Repository.php

Go to the documentation of this file.

<?php

namespace Elgg\Database;

use Elgg\Database\Clauses\GroupByClause;
use Elgg\Database\Clauses\HavingClause;
use Elgg\Database\Clauses\JoinClause;
use Elgg\Database\Clauses\OrderByClause;
use Elgg\Database\Clauses\SelectClause;
use Elgg\Database\Clauses\WhereClause;
use Elgg\Exceptions\DataFormatException;

abstract class Repository implements QueryExecuting {

    protected $options;

    public function __construct(array $options = []) {
        $this->options = new QueryOptions($options, \ArrayObject::ARRAY_AS_PROPS);
    }

    public function __get($name) {
        if (!isset($this->options->$name)) {
            return;
        }

        $val = &$this->options->$name;

        return $val;
    }

    public function __set($name, $value) {
        $this->options->$name = $value;
    }

    public function __unset($name) {
        unset($this->options->$name);
    }

    public function __isset($name) {
        return isset($this->options->$name);
    }

    public static function with(array $options = []) {
        $query = new static($options);

        return $query;
    }

    public static function find(array $options = []) {
        try {
            return static::with($options)->execute();
        } catch (DataFormatException $e) {
            return elgg_extract('count', $options) ? 0 : false;
        }
    }

    public function batch($limit = null, $offset = null, $callback = null) {

        $options = $this->options->getArrayCopy();

        $options['limit'] = (int) $limit;
        $options['offset'] = (int) $offset;
        $options['callback'] = $callback;
        unset($options['count'],
            $options['batch'],
            $options['batch_size'],
            $options['batch_inc_offset']
        );

        $batch_size = $this->options->batch_size;
        $batch_inc_offset = $this->options->batch_inc_offset;

        return new \ElggBatch([static::class, 'find'], $options, null, $batch_size, $batch_inc_offset);
    }

    public function filter(\Closure $closure) {
        $this->options->where(new WhereClause($closure));

        return $this;
    }

    public function select($expression) {
        $this->options->select(new SelectClause($expression));

        return $this;
    }

    public function join($joined_table, $joined_alias = null, $x = null, $comparison = null, $y = null, $type = null, $case_sensitive = null) {
        $join = new JoinClause($joined_table, $joined_alias, function (QueryBuilder $qb, $joined_alias) use ($x, $comparison, $y, $type, $case_sensitive) {
            return $qb->compare("$joined_alias.$x", $comparison, $y, $type, $case_sensitive);
        });
        $this->options->join($join);

        return $this;
    }

    public function groupBy($expression) {
        $this->options->groupBy(new GroupByClause($expression));

        return $this;
    }

    public function having($expression) {
        $this->options->having(new HavingClause($expression));

        return $this;
    }

    public function orderBy($expression, $direction) {
        $this->options->orderBy(new OrderByClause($expression, $direction));

        return $this;
    }

    public function expandInto(QueryBuilder $qb, $table_alias = null) {
        foreach ($this->options->selects as $select_clause) {
            $select_clause->prepare($qb, $table_alias);
        }

        foreach ($this->options->group_by as $group_by_clause) {
            $group_by_clause->prepare($qb, $table_alias);
        }

        foreach ($this->options->having as $having_clause) {
            $having_clause->prepare($qb, $table_alias);
        }

        if (!empty($this->options->order_by)) {
            foreach ($this->options->order_by as $order_by_clause) {
                $order_by_clause->prepare($qb, $table_alias);
            }
        }
    }
}