From f6a5e7589396854e10e023c25237b47e512ff047 Mon Sep 17 00:00:00 2001
From: wei <>
Date: Fri, 14 Apr 2006 11:23:56 +0000
Subject: Adding SQLMap unit tests. Allow sqlmap to use Prado's caching module
 to cache records.

---
 tests/unit/SQLMap/resources/data.db    | Bin 0 -> 5120 bytes
 tests/unit/SQLMap/resources/person.xml |  26 ++++++++++++++++++++++++++
 tests/unit/SQLMap/resources/sqlmap.xml |  12 ++++++++++++
 tests/unit/SQLMap/resources/test.db    | Bin 0 -> 5120 bytes
 tests/unit/SQLMap/resources/tests.db   |   0
 5 files changed, 38 insertions(+)
 create mode 100644 tests/unit/SQLMap/resources/data.db
 create mode 100644 tests/unit/SQLMap/resources/person.xml
 create mode 100644 tests/unit/SQLMap/resources/sqlmap.xml
 create mode 100644 tests/unit/SQLMap/resources/test.db
 create mode 100644 tests/unit/SQLMap/resources/tests.db

(limited to 'tests/unit/SQLMap/resources')

diff --git a/tests/unit/SQLMap/resources/data.db b/tests/unit/SQLMap/resources/data.db
new file mode 100644
index 00000000..b8c158cc
Binary files /dev/null and b/tests/unit/SQLMap/resources/data.db differ
diff --git a/tests/unit/SQLMap/resources/person.xml b/tests/unit/SQLMap/resources/person.xml
new file mode 100644
index 00000000..f5db33f9
--- /dev/null
+++ b/tests/unit/SQLMap/resources/person.xml
@@ -0,0 +1,26 @@
+<?xml version="1.0" encoding="utf-8" ?>
+<sqlMap	namespace="Person" >
+
+	<typeAlias alias="Person" type="Person" />
+
+	<resultMap id="SelectResult" class="Person">
+		<result property="ID" column="per_id" />
+		<result property="FirstName" column="per_first_name" />
+		<result property="LastName" column="per_last_name" />
+		<result property="BirthDate" column="per_birth_date" />
+		<result property="WeightInKilograms" column="per_weight_kg" />
+		<result property="HeightInMeters" column="per_height_m" />
+	</resultMap>
+
+	<select id="Person.SelectAll" resultMap="SelectResult">
+		SELECT
+			per_id,
+			per_first_name,
+			per_last_name,
+			per_birth_date,
+			per_weight_kg,
+			per_height_m
+		FROM 
+			person
+	</select>
+</sqlMap>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/resources/sqlmap.xml b/tests/unit/SQLMap/resources/sqlmap.xml
new file mode 100644
index 00000000..b15e9862
--- /dev/null
+++ b/tests/unit/SQLMap/resources/sqlmap.xml
@@ -0,0 +1,12 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<sqlMapConfig>
+
+	<provider class="TAdodbProvider">
+		<datasource driver="sqlite" host="resources/test.db" />
+	</provider>
+
+	<sqlMaps>
+		<sqlMap id="Person" resource="person.xml"/>
+	</sqlMaps>
+
+</sqlMapConfig>
\ No newline at end of file
diff --git a/tests/unit/SQLMap/resources/test.db b/tests/unit/SQLMap/resources/test.db
new file mode 100644
index 00000000..f939682e
Binary files /dev/null and b/tests/unit/SQLMap/resources/test.db differ
diff --git a/tests/unit/SQLMap/resources/tests.db b/tests/unit/SQLMap/resources/tests.db
new file mode 100644
index 00000000..e69de29b
-- 
cgit v1.3.1