/**
* @param Select $select
* @return string
*/
protected function _renderSelectOrderBy(Select $select)
{
$str = "";
if ($cnt = count($select->getAllOrderBy())) {
$orderBys = $select->getAllOrderBy();
array_walk($orderBys, function (&$orderBy) {
$orderBy = $this->_renderOrderBy($orderBy);
});
$str = "ORDER BY";
$str .= " ";
$separator = ", ";
$str .= implode($separator, $orderBys);
}
return $str;
}
public function testOrderBy()
{
$select = new Select('project');
$select->orderBy("date_created");
$ob = $select->getOrderBy();
$this->assertCount(1, $ob);
$this->assertInstanceOf('\\RBM\\SqlQuery\\OrderBy', $ob[0]);
$select->join('user', 'owner_id', 'user_id')->orderBy('name');
$ob = $select->getAllOrderBy();
$this->assertCount(2, $ob);
}
