public function testPredicates() { $criteria = new Criteria('User', $this->config); $criteria->equalTo('id', 2); $criteria->notEqualTo('id', 3); $criteria->lessThan('projectId', 4); $criteria->greaterThan('id', 5); $criteria->greaterThanOrEqualTo('id', 6); $criteria->lessThanOrEqualTo('id', 7); $criteria->like('name', 'php'); $criteria->isNull('id'); $criteria->isNotNull('id'); $criteria->in('type', [1, 2, 3]); $criteria->between('id', 1, 22); $criteria->limit(4); $criteria->offset(1); $criteria->order('id'); $select = $criteria->getQuery(); $sql = $select->getSqlString($this->dbAdapter->getPlatform()); $this->assertEquals("SELECT `users`.* " . "FROM `users` " . "WHERE `users`.`id` = '2' " . "AND `users`.`id` != '3' " . "AND `users`.`project_id` < '4' " . "AND `users`.`id` > '5' " . "AND `users`.`id` >= '6' " . "AND `users`.`id` <= '7' " . "AND `users`.`name` LIKE 'php' " . "AND `users`.`id` IS NULL " . "AND `users`.`id` IS NOT NULL " . "AND `users`.`type` IN ('1', '2', '3') " . "AND `users`.`id` BETWEEN '1' AND '22' " . "ORDER BY `users`.`id` ASC " . "LIMIT '4' " . "OFFSET '1'", $sql); }