public function test_group_by() { $qb = new QueryBuilder(); $qb->addTable('first', 'T1'); $qb->addGroupByColumn('T1', 'foo'); $qb->addGroupByStatement('T2.bar'); $expectedSQL = ' SELECT FROM first AS T1 WHERE GROUP BY T1.foo, T2.bar '; list($actual_sql, $actual_opts) = $qb->getSQL(); $this->assertEquals($this->cleanWS($expectedSQL), $this->cleanWS($actual_sql)); $this->assertEquals(array(), $actual_opts); }