blob: f0aae0b8d25ce7d3df8f90b8b3398c113c46f5f3 (
plain)
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
37
38
39
40
41
42
43
44
45
46
|
<?php
Prado::using('System.Data.ActiveRecord.TActiveRecord');
require_once(dirname(__FILE__).'/records/DepartmentRecord.php');
/**
* @package System.Data.ActiveRecord
*/
class ActiveRecordFinderTest extends PHPUnit_Framework_TestCase
{
function setup()
{
$conn = new TDbConnection('mysql:host=localhost;dbname=prado_unitest', 'prado_unitest','prado_unitest');
TActiveRecordManager::getInstance()->setDbConnection($conn);
}
function testFindBySQL_returns_one_record()
{
$department = DepartmentRecord::finder()->find('department_id < ?', 5);
$this->assertNotNull($department);
}
function testFindBySQL_returns_zero_records()
{
$department = DepartmentRecord::finder()->find('department_id > ?', 15);
$this->assertNull($department);
}
function test_find_by_sql_returns_iterator()
{
$deps = DepartmentRecord::finder()->findAll('department_id < :id', array('id'=>5));
$this->assertEquals(count($deps),4);
}
function test_find_by_multiple_parameters()
{
$department = DepartmentRecord::finder()->find('department_id < ? AND `order` > ?', 5,2);
$this->assertNotNull($department);
}
function test_find_by_array_parameter()
{
$department = DepartmentRecord::finder()->find('department_id < ? AND `order` > ?', array(5,2));
$this->assertNotNull($department);
}
}
|
