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