Elgg  Version 3.0
QueryExecuting.php
Go to the documentation of this file.
1 <?php
2 
3 namespace Elgg\Database;
4 
5 use Closure;
6 use ElggBatch;
7 
11 interface QueryExecuting {
12 
17  public function count();
18 
28  public function calculate($function, $property, $property_type = null);
29 
39  public function get($limit = null, $offset = null, $callback = null);
40 
50  public function batch($limit = null, $offset = null, $callback = null);
51 
56  public function execute();
57 
68  public function filter(Closure $closure);
69 
77  public function select($expression);
78 
95  public function join($joined_table, $joined_alias = null, $x = null, $comparison = null, $y = null, $type = null, $case_sensitive = null);
96 
104  public function groupBy($expression);
105 
113  public function having($expression);
114 
123  public function orderBy($expression, $direction);
124 
125 }
having($expression)
Add HAVING.
if(!$count) $offset
Definition: pagination.php:26
$type
Definition: delete.php:21
select($expression)
Add SELECT.
orderBy($expression, $direction)
Add ORDER BY.
groupBy($expression)
Add GROUP BY.
calculate($function, $property, $property_type=null)
Apply numeric calculation to a column.
$limit
Definition: userpicker.php:52
join($joined_table, $joined_alias=null, $x=null, $comparison=null, $y=null, $type=null, $case_sensitive=null)
Add JOIN clause Join a database table on an $x to $y comparison.
execute()
Apply correct execution method based on calculation, count or other criteria.
batch($limit=null, $offset=null, $callback=null)
Fetch rows as an ElggBatch.
This interface defines methods for building fluent interactions with a database repository.
filter(Closure $closure)
Filter query prior to execution Callback function will receive QueryBuilder as the first argument and...