function test_default() { $query = new SQL_Query('table'); $query->addOrder(array('col', true)); $query->resetOrder(); $this->assertEquals(array(), $query->getOrder()); }
function test_collateAndDesc() { $query = new SQL_Query('table'); // add a collate clause // this should become: ORDER BY col COLLATE collate_name ASC, col2 $query->addOrder(array('col', false, 'col1')); $query->addOrder('col2'); $this->assertEquals(array(array('col', false, 'col1'), array('col2', false)), $query->getOrder()); }