/** * testComplexSortExpression method * * @return void */ public function testComplexSortExpression() { $result = $this->Dbo->order(array('(Model.field > 100) DESC', 'Model.field ASC')); $this->assertRegExp("/^\\s*ORDER BY\\s+\\(`Model`\\.`field`\\s+>\\s+100\\)\\s+DESC,\\s+`Model`\\.`field`\\s+ASC\\s*\$/", $result); }
/** * Tests additional order options for postgres * * @return void */ public function testOrderAdditionalParams() { $result = $this->Dbo->order(array('title' => 'DESC NULLS FIRST', 'body' => 'DESC')); $expected = ' ORDER BY "title" DESC NULLS FIRST, "body" DESC'; $this->assertEquals($expected, $result); }
/** * testComplexSortExpression method * * @return void */ public function testComplexSortExpression() { $result = $this->Dbo->order(array('(Model.field > 100) DESC', 'Model.field ASC')); $this->assertPattern("/^\s*ORDER BY\s+\(`Model`\.`field`\s+>\s+100\)\s+DESC,\s+`Model`\.`field`\s+ASC\s*$/", $result); }