From ebe35517b35dc87eaec1333263cb78e9bd4ef2e1 Mon Sep 17 00:00:00 2001
From: wei <>
Date: Fri, 2 Feb 2007 05:29:00 +0000
Subject: add unit test for sqlmap statement extends

---
 tests/simple_unit/SqlMap/StatementExtendsTest.php | 29 +++++++++++++++++++++++
 tests/simple_unit/SqlMap/common.php               |  4 ++--
 tests/simple_unit/SqlMap/maps/tests.xml           | 19 +++++++++++++++
 3 files changed, 50 insertions(+), 2 deletions(-)
 create mode 100644 tests/simple_unit/SqlMap/StatementExtendsTest.php
 create mode 100644 tests/simple_unit/SqlMap/maps/tests.xml

(limited to 'tests/simple_unit')

diff --git a/tests/simple_unit/SqlMap/StatementExtendsTest.php b/tests/simple_unit/SqlMap/StatementExtendsTest.php
new file mode 100644
index 00000000..4d87ca58
--- /dev/null
+++ b/tests/simple_unit/SqlMap/StatementExtendsTest.php
@@ -0,0 +1,29 @@
+<?php
+
+Prado::using('System.Data.SqlMap.TSqlMapConfig');
+class StatementExtendsTest extends UnitTestCase
+{
+	protected $sqlmap;
+
+	function setup()
+	{
+		$config = new TSqlMapConfig();
+		$config->ConfigFile = dirname(__FILE__).'/maps/tests.xml';
+		$this->sqlmap = $config->getClient();
+	}
+
+	function test_extends1()
+	{
+		$manager = $this->sqlmap->SqlMapManager;
+		$sql = $manager->getMappedStatement('test')->getSqlString();
+
+		$this->assertPattern('/img_request/', $sql);
+		$this->assertNoPattern('/img_progress/', $sql);
+
+		$sql2 = $manager->getMappedStatement('GetAllProgress')->getSqlString();
+		$this->assertPattern('/img_request/', $sql2);
+		$this->assertPattern('/img_progress/', $sql2);
+	}
+}
+
+?>
\ No newline at end of file
diff --git a/tests/simple_unit/SqlMap/common.php b/tests/simple_unit/SqlMap/common.php
index aed11671..f414ad50 100644
--- a/tests/simple_unit/SqlMap/common.php
+++ b/tests/simple_unit/SqlMap/common.php
@@ -143,9 +143,9 @@ class BaseTestConfig
 	{
 		//change this to connection to a different database
 
-		return new MySQLBaseTestConfig();
+		//return new MySQLBaseTestConfig();
 
-		//return new SQLiteBaseTestConfig();
+		return new SQLiteBaseTestConfig();
 
 		//return new MSSQLBaseTestConfig();
 	}
diff --git a/tests/simple_unit/SqlMap/maps/tests.xml b/tests/simple_unit/SqlMap/maps/tests.xml
new file mode 100644
index 00000000..5e93cae4
--- /dev/null
+++ b/tests/simple_unit/SqlMap/maps/tests.xml
@@ -0,0 +1,19 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<sqlmap>
+
+<statement id="test" parameterClass="array" >
+	<![CDATA[
+		SELECT a.*, b.*
+		FROM img_request a
+			left join hello_mst b on a.img_pat_id=b.pat_id
+		WHERE (img_requested_ap_dt >= #fromdt# and img_requested_ap_dt <= #todt#)
+	]]>
+</statement>
+
+<select id="GetAllProgress" parameterClass="array" extends="test">
+	<![CDATA[
+	AND img_progress =#status#
+	]]>	
+</select>
+
+</sqlmap>
\ No newline at end of file
-- 
cgit v1.2.3