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/SqlMap/resources | |
| parent | 91fe694c8755aa2d05743946a3681be7232420b6 (diff) | |
add unit tests for active record and sqlmap
Diffstat (limited to 'tests/simple_unit/SqlMap/resources')
| -rw-r--r-- | tests/simple_unit/SqlMap/resources/data.db | bin | 0 -> 5120 bytes | |||
| -rw-r--r-- | tests/simple_unit/SqlMap/resources/person.xml | 26 | ||||
| -rw-r--r-- | tests/simple_unit/SqlMap/resources/sqlmap.xml | 12 | ||||
| -rw-r--r-- | tests/simple_unit/SqlMap/resources/test.db | bin | 0 -> 5120 bytes | |||
| -rw-r--r-- | tests/simple_unit/SqlMap/resources/tests.db | 0 |
5 files changed, 38 insertions, 0 deletions
diff --git a/tests/simple_unit/SqlMap/resources/data.db b/tests/simple_unit/SqlMap/resources/data.db Binary files differnew file mode 100644 index 00000000..b8c158cc --- /dev/null +++ b/tests/simple_unit/SqlMap/resources/data.db diff --git a/tests/simple_unit/SqlMap/resources/person.xml b/tests/simple_unit/SqlMap/resources/person.xml new file mode 100644 index 00000000..f5db33f9 --- /dev/null +++ b/tests/simple_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/simple_unit/SqlMap/resources/sqlmap.xml b/tests/simple_unit/SqlMap/resources/sqlmap.xml new file mode 100644 index 00000000..3d20321d --- /dev/null +++ b/tests/simple_unit/SqlMap/resources/sqlmap.xml @@ -0,0 +1,12 @@ +<?xml version="1.0" encoding="UTF-8" ?>
+<sqlMapConfig>
+
+ <provider class="TAdodb">
+ <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/simple_unit/SqlMap/resources/test.db b/tests/simple_unit/SqlMap/resources/test.db Binary files differnew file mode 100644 index 00000000..b8c158cc --- /dev/null +++ b/tests/simple_unit/SqlMap/resources/test.db diff --git a/tests/simple_unit/SqlMap/resources/tests.db b/tests/simple_unit/SqlMap/resources/tests.db new file mode 100644 index 00000000..e69de29b --- /dev/null +++ b/tests/simple_unit/SqlMap/resources/tests.db |