From 562979c4a8fe47952edf7986d4144624e41630f7 Mon Sep 17 00:00:00 2001
From: wei <>
Date: Mon, 4 Dec 2006 02:42:57 +0000
Subject: add unit tests for active record and sqlmap

---
 .../ActiveRecord/ActiveRecordFinderTestCase.php    | 45 ++++++++++++++++++++++
 1 file changed, 45 insertions(+)
 create mode 100644 tests/simple_unit/ActiveRecord/ActiveRecordFinderTestCase.php

(limited to 'tests/simple_unit/ActiveRecord/ActiveRecordFinderTestCase.php')

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
-- 
cgit v1.2.3