tests/unit/Data/ActiveRecord/CountRecordsTest.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36

<?php

Prado::using('System.Data.ActiveRecord.TActiveRecord');
require_once(dirname(__FILE__).'/records/DepartmentRecord.php');

/**
 * @package System.Data.ActiveRecord
 */
class CountRecordsTest extends PHPUnit_Framework_TestCase
{
	function setup()
	{
		$conn = new TDbConnection('pgsql:host=localhost;dbname=test', 'test','test');
		TActiveRecordManager::getInstance()->setDbConnection($conn);
	}

	function test_count()
	{
		$finder = DepartmentRecord::finder();
		$count = $finder->count('"order" > ?', 2);
		$this->assertTrue($count > 0);
	}

	function test_count_zero()
	{
		$finder = DepartmentRecord::finder();
		$count = $finder->count('"order" > ?', 11);
		$this->assertEqual($count,0);
	}

	function test_count_without_parameter()
	{
		$finder = DepartmentRecord::finder();
		$this->assertEqual($finder->count(), 8);
	}
}