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