diff options
Diffstat (limited to 'tests/simple_unit/SqlMap/maps/MySql')
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">
|