summaryrefslogtreecommitdiff
path: root/tests/unit/SQLMap/resources
diff options
context:
space:
mode:
authorwei <>2006-04-14 11:23:56 +0000
committerwei <>2006-04-14 11:23:56 +0000
commitf6a5e7589396854e10e023c25237b47e512ff047 (patch)
tree2b313bb8b66869235ee06b9cae2af2f7645cf5c9 /tests/unit/SQLMap/resources
parent3d3f8d3832921f99daf8ce1953304763c2e76c62 (diff)
Adding SQLMap unit tests. Allow sqlmap to use Prado's caching module to cache records.
Diffstat (limited to 'tests/unit/SQLMap/resources')
-rw-r--r--tests/unit/SQLMap/resources/data.dbbin0 -> 5120 bytes
-rw-r--r--tests/unit/SQLMap/resources/person.xml26
-rw-r--r--tests/unit/SQLMap/resources/sqlmap.xml12
-rw-r--r--tests/unit/SQLMap/resources/test.dbbin0 -> 5120 bytes
-rw-r--r--tests/unit/SQLMap/resources/tests.db0
5 files changed, 38 insertions, 0 deletions
diff --git a/tests/unit/SQLMap/resources/data.db b/tests/unit/SQLMap/resources/data.db
new file mode 100644
index 00000000..b8c158cc
--- /dev/null
+++ b/tests/unit/SQLMap/resources/data.db
Binary files 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
--- /dev/null
+++ b/tests/unit/SQLMap/resources/test.db
Binary files differ
diff --git a/tests/unit/SQLMap/resources/tests.db b/tests/unit/SQLMap/resources/tests.db
new file mode 100644
index 00000000..e69de29b
--- /dev/null
+++ b/tests/unit/SQLMap/resources/tests.db