From 2c221ea67d0512961beea8fbcb30b23865c16bb0 Mon Sep 17 00:00:00 2001
From: wei <>
Date: Wed, 20 Dec 2006 03:15:04 +0000
Subject: Add quickstart docs for Active Record and SqlMap

---
 tests/simple_unit/SqlMap/maps/MySql/Account.xml        |  8 ++++----
 tests/simple_unit/SqlMap/maps/MySql/ActiveRecord.xml   | 16 ++++++++++++++++
 tests/simple_unit/SqlMap/maps/MySql/DynamicAccount.xml |  3 ++-
 tests/simple_unit/SqlMap/maps/MySql/Order.xml          | 18 +++++++++---------
 4 files changed, 31 insertions(+), 14 deletions(-)
 create mode 100644 tests/simple_unit/SqlMap/maps/MySql/ActiveRecord.xml

(limited to 'tests/simple_unit/SqlMap/maps/MySql')

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">
-- 
cgit v1.2.3