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