function test_twoAndExpression() { $query = new SQL_Query('table'); $query->addGroup('name'); $query->addGroup('STRLEN(name)'); $this->assertEquals(array('name', 'STRLEN(name)'), $query->getGroup()); }
function test_default() { $query = new SQL_Query('table'); $query->addGroup('id'); $query->resetGroup(); $this->assertEquals(null, $query->getGroup()); }
function test_twoParas() { $query = new SQL_Query(); $query->addGroup('name', 'MAX(num)'); $ren = new $this->_renderer($query); $this->assertStringEquals('name , MAX(num)', $ren->renderGroup()); }
function test_selectWithAllParts() { $query = new SQL_Query('city'); $query->addSelect('*', 'name', 'id'); $query->addDontSelect('name'); $query->addWhere('id', '<>', 42); $query->addOrder(array('country_id', true)); $query->addGroup('surname'); $ren = new $this->_renderer($query); $this->assertStringEquals('SELECT *,id FROM city ' . 'WHERE id <> 42 GROUP BY surname ORDER BY country_id DESC', $ren->render()); }