diff options
| author | wei <> | 2006-12-04 02:42:57 +0000 |
|---|---|---|
| committer | wei <> | 2006-12-04 02:42:57 +0000 |
| commit | 562979c4a8fe47952edf7986d4144624e41630f7 (patch) | |
| tree | b79c3fd28e1aedb40d04e148da4b0763c928a3a5 /tests/simple_unit/ActiveRecord/ActiveRecordFinderTestCase.php | |
| parent | 91fe694c8755aa2d05743946a3681be7232420b6 (diff) | |
add unit tests for active record and sqlmap
Diffstat (limited to 'tests/simple_unit/ActiveRecord/ActiveRecordFinderTestCase.php')
| -rw-r--r-- | tests/simple_unit/ActiveRecord/ActiveRecordFinderTestCase.php | 45 |
1 files changed, 45 insertions, 0 deletions
diff --git a/tests/simple_unit/ActiveRecord/ActiveRecordFinderTestCase.php b/tests/simple_unit/ActiveRecord/ActiveRecordFinderTestCase.php new file mode 100644 index 00000000..597f8a6b --- /dev/null +++ b/tests/simple_unit/ActiveRecord/ActiveRecordFinderTestCase.php @@ -0,0 +1,45 @@ +<?php +Prado::using('System.Data.ActiveRecord.TActiveRecord');
+require_once(dirname(__FILE__).'/records/DepartmentRecord.php');
+
+class ActiveRecordFinderTestCase extends UnitTestCase
+{
+ function setup()
+ {
+ $conn = new TDbConnection('pgsql:host=localhost;dbname=test', 'test','test');
+ 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->assertEqual(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);
+ }
+
+}
+ +?>
\ No newline at end of file |