/**
* Nests another query builder query in the current query.
*
* @param RedBean_SQLHelper
*
* @return RedBean_SQLHelper
*/
public function nest(RedBean_SQLHelper $sqlHelper)
{
list($sql, $params) = $sqlHelper->getQuery();
$this->sql .= $sql;
$this->params += $params;
return $this;
}
/**
* Adds WHERE clause conditions to ownList retrieval.
* For instance to get the pages that belong to a book you would
* issue the following command: $book->ownPage
* However, to order these pages by number use:
*
* $book->with(' ORDER BY `number` ASC ')->ownPage
*
* the additional SQL snippet will be merged into the final
* query.
*
* @param string|RedBean_SQLHelper $sql SQL to be added to retrieval query.
* @param array $bindings array with parameters to bind to SQL snippet
*
* @return RedBean_OODBBean
*/
public function with($sql, $bindings = array())
{
if ($sql instanceof RedBean_SQLHelper) {
list($this->withSql, $this->withParams) = $sql->getQuery();
} else {
$this->withSql = $sql;
$this->withParams = $bindings;
}
return $this;
}