public function testItCanConvertQueryToString() { $sql = 'SELECT a'; $this->object->select('a'); $this->assertEquals($sql, $this->object->toSql()); $sql .= ' FROM table'; $this->object->from('table'); $this->assertEquals($sql, $this->object->toSql()); $sql .= ' INNER JOIN table2'; $this->object->innerJoin('table2'); $this->assertEquals($sql, $this->object->toSql()); $sql .= ' WHERE a = "b" AND b = 1'; $this->object->where('a', 'b')->where(array('b' => 1)); $this->assertEquals($sql, $this->object->toSql()); $sql .= ' GROUP BY group1, group2'; $this->object->groupBy(array('group1'))->groupBy('group2'); $this->assertEquals($sql, $this->object->toSql()); $sql .= ' ORDER BY foo, bar DESC'; $this->object->orderBy(array('foo', 'bar DESC')); $this->assertEquals($sql, $this->object->toSql()); $sql .= ' LIMIT 10'; $this->object->limit(10); $this->assertEquals($sql, $this->object->toSql()); $sql .= ', 3'; $this->object->limit(10, 3); $this->assertEquals($sql, $this->object->toSql()); }