public function testBasic()
{
$this->assertInstanceOf('Zend\\Db\\Sql\\Select', $this->filterSelect->getSelect());
$this->assertInstanceOf('Zend\\Db\\Sql\\Sql', $this->filterSelect->getSql());
// Test two filters
$filter = new \ZfcDatagrid\Filter();
$filter->setFromColumn($this->column, '~myValue,123');
$filter2 = new \ZfcDatagrid\Filter();
$filter2->setFromColumn($this->column2, '~myValue,123');
$filterSelect = clone $this->filterSelect;
$filterSelect->applyFilter($filter);
$filterSelect->applyFilter($filter2);
$select = $filterSelect->getSelect();
/* @var $where \Zend\Db\Sql\Where */
$where = $select->getRawState('where');
$predicates = $where->getPredicates();
$this->assertEquals(2, count($predicates));
}
