public function testFilterBy()
{
$c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
$c->filterBy('Title', 'foo');
$sql = 'SELECT FROM `book` WHERE book.TITLE=:p1';
$params = array(array('table' => 'book', 'column' => 'TITLE', 'value' => 'foo'));
$this->assertCriteriaTranslation($c, $sql, $params, 'filterBy() accepts a simple column name');
$c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book');
$c->filterBy('Title', 'foo', Criteria::NOT_EQUAL);
$sql = 'SELECT FROM `book` WHERE book.TITLE<>:p1';
$params = array(array('table' => 'book', 'column' => 'TITLE', 'value' => 'foo'));
$this->assertCriteriaTranslation($c, $sql, $params, 'filterBy() accepts a sicustom comparator');
$c = new ModelCriteria('bookstore', 'Propel\\Tests\\Bookstore\\Book', 'b');
$c->filterBy('Title', 'foo');
$sql = 'SELECT FROM `book` WHERE book.TITLE=:p1';
$params = array(array('table' => 'book', 'column' => 'TITLE', 'value' => 'foo'));
$this->assertCriteriaTranslation($c, $sql, $params, 'filterBy() accepts a simple column name, even if initialized with an alias');
}
