summaryrefslogtreecommitdiff
path: root/tests/simple_unit/SqlMap/maps/MySql
diff options
context:
space:
mode:
Diffstat (limited to 'tests/simple_unit/SqlMap/maps/MySql')
-rw-r--r--tests/simple_unit/SqlMap/maps/MySql/Account.xml8
-rw-r--r--tests/simple_unit/SqlMap/maps/MySql/ActiveRecord.xml16
-rw-r--r--tests/simple_unit/SqlMap/maps/MySql/DynamicAccount.xml3
-rw-r--r--tests/simple_unit/SqlMap/maps/MySql/Order.xml18
4 files changed, 31 insertions, 14 deletions
diff --git a/tests/simple_unit/SqlMap/maps/MySql/Account.xml b/tests/simple_unit/SqlMap/maps/MySql/Account.xml
index 146e0e90..77a1d433 100644
--- a/tests/simple_unit/SqlMap/maps/MySql/Account.xml
+++ b/tests/simple_unit/SqlMap/maps/MySql/Account.xml
@@ -70,7 +70,7 @@
<result property="FirstName" column="Account_FirstName"/>
<result property="LastName" column="Account_LastName"/>
<result property="EmailAddress" column="Account_Email" nullValue="no_email@provided.com"/>
- <result property="BannerOptions" column="Account_Banner_Option" dbType="Varchar" typeHandler="OuiNonBool"/>
+ <result property="BannerOptions" column="Account_Banner_Option" typeHandler="OuiNonBool"/>
<result property="CartOptions" column="Account_Cart_Option" typeHandler="HundredsBool"/>
</resultMap>
<resultMap id="indexed-account-result" class="Account">
@@ -551,9 +551,9 @@
<!-- accounts and orders -->
<select id="getAccountWithOrders" resultMap="Account-with-Orders">
- SELECT * FROM accounts
- LEFT JOIN orders ON
- accounts.account_id = orders.account_id
+ SELECT * FROM Accounts
+ LEFT JOIN Orders ON
+ Accounts.account_id = Orders.account_id
</select>
<resultMap id="Account-with-Orders" class="AccountWithOrders" groupBy="Account_Id">
diff --git a/tests/simple_unit/SqlMap/maps/MySql/ActiveRecord.xml b/tests/simple_unit/SqlMap/maps/MySql/ActiveRecord.xml
new file mode 100644
index 00000000..1c48010f
--- /dev/null
+++ b/tests/simple_unit/SqlMap/maps/MySql/ActiveRecord.xml
@@ -0,0 +1,16 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<sqlMap>
+
+ <select id="GetActiveRecordAccounts" resultClass="ActiveAccount">
+ select
+ Account_Id,
+ Account_FirstName,
+ Account_LastName,
+ Account_Email,
+ Account_Banner_Option,
+ Account_Cart_Option
+ from Accounts
+ order by Account_Id
+ </select>
+
+</sqlMap> \ No newline at end of file
diff --git a/tests/simple_unit/SqlMap/maps/MySql/DynamicAccount.xml b/tests/simple_unit/SqlMap/maps/MySql/DynamicAccount.xml
index ff89720b..ee565158 100644
--- a/tests/simple_unit/SqlMap/maps/MySql/DynamicAccount.xml
+++ b/tests/simple_unit/SqlMap/maps/MySql/DynamicAccount.xml
@@ -49,7 +49,7 @@
</dynamic>
</select>
- <!-- IBATISNET-114: remapResults -->
+ <!-- IBATISNET-114: remapResults
<statement id="DynamicSqlOnColumnSelection"
parameterClass="Account"
resultClass="Account"
@@ -69,6 +69,7 @@
FROM
Accounts
</statement>
+ -->
<statement id="DynamicIsEqual"
parameterClass="string"
diff --git a/tests/simple_unit/SqlMap/maps/MySql/Order.xml b/tests/simple_unit/SqlMap/maps/MySql/Order.xml
index 2e4eb616..ac3b7b84 100644
--- a/tests/simple_unit/SqlMap/maps/MySql/Order.xml
+++ b/tests/simple_unit/SqlMap/maps/MySql/Order.xml
@@ -76,15 +76,15 @@
</resultMap>
<resultMap id="order-with-types-result" class="Order">
- <result property="Id" column="Order_Id" dbType="Int32"/>
- <result property="Date" column="Order_Date" type="date" dbType="DateTime "/>
- <result property="CardExpiry" column="Order_CardExpiry" dbType="VarChar"/>
- <result property="CardType" column="Order_CardType" dbType="VarChar"/>
- <result property="CardNumber" column="Order_CardNumber" dbType="VarChar"/>
- <result property="Street" column="Order_Street" dbType="VarChar"/>
- <result property="City" column="Order_City" dbType="VarChar"/>
- <result property="Province" column="Order_Province" dbType="VarChar"/>
- <result property="PostalCode" column="Order_PostalCode" dbType="VarChar"/>
+ <result property="Id" column="Order_Id" />
+ <result property="Date" column="Order_Date" type="date" />
+ <result property="CardExpiry" column="Order_CardExpiry" />
+ <result property="CardType" column="Order_CardType" />
+ <result property="CardNumber" column="Order_CardNumber" />
+ <result property="Street" column="Order_Street" />
+ <result property="City" column="Order_City" />
+ <result property="Province" column="Order_Province" />
+ <result property="PostalCode" column="Order_PostalCode" />
</resultMap>
<resultMap id="lite-order-result-by-index" class="Order">