clause array

From SkyPHP

The clause array specifies the clauses to be added to an aql statement or model.

Contents 1 Keys 2 Sample Clause Arrays 3 Usage 4 Developer Note

Keys

• where
• offset
• limit
• order by | orderby | order_by
• group by | groupby | group_by (not yet supported)
• having (not yet supported)
• distinct on (not yet supported)

Sample Clause Arrays

$clause = array(
	'address' => array(
		'where' => array(
			"county = 'Palm Beach'",
			"city = 'Boca Raton'"
		),
		'order by' => "county asc, city asc"
	)
);

$clause = array(
	'where' => array(
		"county = 'Palm Beach'",
		"city = 'Boca Raton'"
	),
	'order by' => "county asc, city asc"
);

$clause = array(
	'where' => "county = 'Palm Beach' and city = 'Boca Raton'",
	'order by' => "county asc, city asc"
);

Usage

aql::grid(array(
   'model' => $model,
   'columns' => $col,
   'clause' => $clause
));

aql::select($aql,$clause);

Developer Note

to support group by, aql::recurse() $needles will have to be updated