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());
}
