diff options
Diffstat (limited to 'tests/unit/SQLMap/maps/sqlite')
| -rw-r--r-- | tests/unit/SQLMap/maps/sqlite/Account.xml | 641 | ||||
| -rw-r--r-- | tests/unit/SQLMap/maps/sqlite/Category.xml | 162 | ||||
| -rw-r--r-- | tests/unit/SQLMap/maps/sqlite/Complex.xml | 23 | ||||
| -rw-r--r-- | tests/unit/SQLMap/maps/sqlite/Document.xml | 53 | ||||
| -rw-r--r-- | tests/unit/SQLMap/maps/sqlite/DynamicAccount.xml | 448 | ||||
| -rw-r--r-- | tests/unit/SQLMap/maps/sqlite/Enumeration.xml | 59 | ||||
| -rw-r--r-- | tests/unit/SQLMap/maps/sqlite/LineItem.xml | 188 | ||||
| -rw-r--r-- | tests/unit/SQLMap/maps/sqlite/Order.xml | 507 | ||||
| -rw-r--r-- | tests/unit/SQLMap/maps/sqlite/Other.xml | 170 | ||||
| -rw-r--r-- | tests/unit/SQLMap/maps/sqlite/ResultClass.xml | 130 |
10 files changed, 0 insertions, 2381 deletions
diff --git a/tests/unit/SQLMap/maps/sqlite/Account.xml b/tests/unit/SQLMap/maps/sqlite/Account.xml deleted file mode 100644 index 032febbc..00000000 --- a/tests/unit/SQLMap/maps/sqlite/Account.xml +++ /dev/null @@ -1,641 +0,0 @@ -<?xml version="1.0" encoding="UTF-8" ?>
-<sqlMap namespace="Account" >
-
- <!-- =============================================
- <resultMap
- name="name"
- class="name"
- extend="resultMapId"
- >
- <result
- property="name"
- column="name"
- columnIndex="name"
- nullValue="value"
- select="name"
- resultMap="name"
- lazyLoad="true/false"
- dbType=""
- />
- <procedure
- name="name"
- parameterMap="name"
- >
- <statement
- name="name"
- parameterClass="name"
- parameterMap="name"
- resultClass="name"
- resultMap="name"
- listClass="name"
- >
- <parameterMap
- name="name"
- class=""
- >
- <parameter
- property="name"
- dbType=""
- output="true/false"
- type=""
- nullValue=""
- extend="parameterMapId"
- />
-
- ============================================= -->
-
- <cacheModel id="account-cache" implementation="LRU" >
- <flushInterval hours="24"/>
- <flushOnExecute statement="UpdateAccountViaInlineParameters"/>
- <flushOnExecute statement="UpdateAccountViaParameterMap"/>
- <property name="size" value="10"/>
- </cacheModel>
-
- <!--
- <cacheModel name="account-cache" implementation="LRU" >
- <flushInterval hours="24"/>
- <flushOnExecute statement="UpdateAccountViaInlineParameters"/>
- <flushOnExecute statement="UpdateAccountViaParameterMap"/>
- <property name="CacheSize" value="50"/>
- </cacheModel>
- -->
-
-
- <alias>
- <typeAlias alias="HundredsBool" type="IBatisNet.DataMapper.Test.Domain.HundredsTypeHandlerCallback, IBatisNet.DataMapper.Test"/>
- </alias>
-
- <resultMap id="account-result" class="Account" >
- <result property="Id" column="Account_Id"/>
- <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="CartOptions" column="Account_Cart_Option" typeHandler="HundredsBool"/>
- </resultMap>
- <resultMap id="indexed-account-result" class="Account">
- <result property="Id" column="Account_Id" columnIndex="0"/>
- <result property="FirstName" column="Account_FirstName" columnIndex="1"/>
- <result property="LastName" column="Account_LastName" columnIndex="2"/>
- <result property="EmailAddress" column="Account_Email" columnIndex="3" nullValue="no_email@provided.com"/>
- </resultMap>
- <resultMap id="account-result-nullable-email" class="Account">
- <result property="Id" column="Account_Id"/>
- <result property="FirstName" column="Account_FirstName"/>
- <result property="LastName" column="Account_LastName"/>
- <result property="EmailAddress" column="Account_Email"/>
- </resultMap>
-
- <resultMap id="email-result" class="string">
- <result property="value" column="Account_Email"/>
- </resultMap>
-
- <resultMap id="account-hashtable-result" class="array">
- <result property="Id" column="Account_Id"/>
- <result property="FirstName" column="Account_FirstName"/>
- <result property="LastName" column="Account_LastName"/>
- <result property="EmailAddress" column="Account_Email"/>
- </resultMap>
-
-
- <!-- =============================================
- MAPPED STATEMENTS - w/Inline Parameters
- =============================================
- -->
-
- <select id="GetAllAccountsAsArrayListViaResultClass"
- resultClass="TList">
- select
- Account_Id as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- order by Account_Id
- </select>
-
- <select id="GetAccountsDynamic" resultMap="account-result" parameterClass="Hashtable" >
- select * from Accounts
- <dynamic prepend="where">
- <isParameterPresent>
- <isNotEmpty prepend="and" property="FirstName" >
- Account_FirstName LIKE '%$FirstName$%'
- </isNotEmpty>
- <isNotEmpty prepend="and" property="LastName" >
- Account_LastName LIKE '%$LastName$%'
- </isNotEmpty>
- <isNotEmpty prepend="and" property="EmailAddress" >
- Account_Email LIKE '%$EmailAddress$%'
- </isNotEmpty>
- </isParameterPresent>
- </dynamic>
- order by Account_LastName
- limit 0, $MaximumAllowed$
- </select>
-
- <select id="SelectWithProperty"
- resultMap="account-result">
- select *
- from Accounts
- where Account_FirstName = ${accountName}
- </select>
-
- <select id="GetCachedAccountsViaResultMap"
- resultMap="account-result"
- cacheModel="account-cache" >
- select *
- from Accounts
- order by Account_Id
- </select>
-
- <select id="GetNoAccountWithCache"
- parameterClass="Integer"
- resultMap="account-hashtable-result"
- cacheModel="account-cache">
- select *
- from Accounts
- where Account_Id = #value#
- </select>
-
- <select id="GetAccountAsHashtable"
- parameterClass="Integer"
- resultMap="account-hashtable-result">
- select *
- from Accounts
- where Account_Id = #value#
- </select>
-
- <select id="GetAllAccountsAsHashMapViaResultMap"
- resultMap="account-hashtable-result">
- select *
- from Accounts
- order by Account_Id
- </select>
-
- <select id="GetAccountAsHashtableResultClass"
- parameterClass="int"
- resultClass="array">
- select
- Account_Id as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- where Account_Id = #value#
- </select>
-
- <select id="GetAllAccountsAsHashtableViaResultClass"
- resultClass="array">
- select
- Account_Id as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- order by Account_Id
- </select>
-
- <select id="GetAccountViaColumnName"
- parameterClass="int"
- resultMap="account-result">
- select
- Account_Id,
- Account_FirstName,
- Account_LastName,
- Account_Email,
- Account_Banner_Option,
- Account_Cart_Option
- from Accounts
- where Account_Id = #value#
- </select>
-
- <select id="GetAccountViaColumnIndex"
- parameterClass="int"
- resultMap="indexed-account-result">
- select
- Account_Id,
- Account_FirstName,
- Account_LastName,
- Account_Email
- from Accounts
- where Account_Id = #value#
- </select>
-
- <select id="GetAllAccountsViaResultMap"
- resultMap="account-result">
- select * from Accounts
- order by Account_Id
- </select>
-
- <select id="GetAllAccountsViaResultClass"
- resultClass="Account">
- select
- Account_Id as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- order by Account_Id
- </select>
-
- <select id="GetFewAccountsViaResultMap"
- resultMap="account-result">
- <![CDATA[
- select * from Accounts
- where Account_Id < 2
- order by Account_Id
- ]]>
- </select>
-
- <select id="GetNoAccountsViaResultMap"
- resultMap="account-result">
- select * from Accounts
- where Account_Id > 1000
- order by Account_Id
- </select>
-
-
- <select id="GetAccountNullableEmail"
- resultMap="account-result-nullable-email">
- select
- Account_Id,
- Account_FirstName,
- Account_LastName,
- Account_Email
- from Accounts
- where Account_Id = #value#
- </select>
-
- <select id="GetAccountViaResultClass"
- resultClass="Account">
- <![CDATA[
- select
- Account_Id as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- where Account_Id = #value#
- ]]>
- </select>
-
- <select id="GetAccountViaInlineParameters"
- resultMap="indexed-account-result">
- select
- Account_Id,
- Account_FirstName,
- Account_LastName,
- Account_Email
- from Accounts
- where Account_Id = #Id# and Account_Id = #Id#
- </select>
-
- <select id="GetEmailAddressViaResultClass" resultClass="string">
- select Account_Email as value
- from Accounts
- where Account_Id = #value#
- </select>
-
- <select id="GetEmailAddressViaResultMap"
- parameterClass="int"
- resultMap="email-result">
- select Account_Email
- from Accounts
- where Account_Id = #value#
- </select>
-
- <select id="GetAllEmailAddressesViaResultClass"
- resultClass="string">
- select Account_Email
- from Accounts
- order by Account_Id
- </select>
-
- <select id="GetAllEmailAddressesViaResultMap"
- resultMap="email-result">
- select Account_Email
- from Accounts
- order by Account_Id
- </select>
-
- <insert id="InsertAccountViaParameterMap"
- parameterMap="account-insert-params">
- insert into Accounts
- (Account_Id, Account_FirstName, Account_LastName, Account_Email, Account_Banner_Option, Account_Cart_Option)
- values
- (?, ?, ?, ?, ?, ?)
- </insert>
-
- <update id="UpdateAccountViaParameterMap"
- parameterMap="update-params">
- update Accounts set
- Account_FirstName = ?,
- Account_LastName = ?,
- Account_Email = ?
- where
- Account_Id = ?
- </update>
-
- <update id="UpdateAccountViaParameterMap2"
- parameterMap="update-params2">
- update Accounts set
- Account_Id = ?,
- Account_FirstName = ?,
- Account_LastName = ?,
- Account_Email = ?
- where
- Account_Id = ?
- </update>
-
- <delete id="DeleteAccountViaInlineParameters">
- delete from Accounts
- where
- Account_Id = #Id#
- </delete>
-
- <select id="GetAccountComplexMapping"
- resultMap="indexed-account-result"
- parameterClass="array">
- select *
- from Accounts
- where
- Account_FirstName = #Account.FirstName#
- And Account_LastName = #Order.City#
- </select>
-
- <select id="GetDynamicOrderedEmailAddressesViaResultMap"
- resultMap="email-result">
- select Account_Email
- from Accounts
- order by $value$
- </select>
-
- <!-- Dynamic statements -->
- <select id="GetAllAccountsViaResultMapWithDynamicElement"
- resultMap="account-result">
- select * from Accounts
- where Account_Email $value$ '%@%'
- order by Account_Id
- </select>
-
- <select id="SimpleDynamicSubstitution"
- parameterClass="Hashtable"
- resultClass="Account">
- $statement$
- </select>
-
- <!-- Public Fields -->
- <insert id="InsertAccountViaPublicFields">
- insert into Accounts
- (Account_Id, Account_FirstName, Account_LastName, Account_Email)
- values
- (#Id#, #FirstName#, #LastName#, #EmailAddress#
- )
- </insert>
-
-
- <!-- Inline Parameters -->
- <update id="UpdateAccountViaInlineParameters"
- parameterClass="Account">
- update Accounts set
- Account_FirstName = #FirstName#,
- Account_LastName = #LastName#,
- Account_Email = #EmailAddress, dbType=VarChar, nullValue=no_email@provided.com#
- where
- Account_Id = #Id#
- </update>
-
- <insert id="InsertAccountViaInlineParameters"
- parameterClass="Account" >
- insert into Accounts
- (Account_Id, Account_FirstName, Account_LastName, Account_Email)
- values
- (#Id#, #FirstName#, #LastName#, #EmailAddress, dbType=VarChar, nullValue=no_email@provided.com#
- )
- </insert>
-
- <insert id="InsertAccountNullableEmail"
- parameterClass="Account" >
- insert into Accounts
- (Account_Id, Account_FirstName, Account_LastName, Account_Email)
- values
- ( #Id#, #FirstName#, #LastName#, #EmailAddress, dbType=VarChar# )
- </insert>
-
- <insert id="InsertAccountUknownParameterClass">
- insert into Accounts
- (Account_Id, Account_FirstName, Account_LastName, Account_Email)
- values
- ( #Id#, #FirstName#, #LastName#, #EmailAddress, dbType=VarChar# )
- </insert>
-
- <delete id="DeleteAccount"
- parameterClass="Account">
- delete from Accounts
- where Account_Id = #Id#
- and Account_Id = #Id#
- </delete>
-
- <!-- Extends statement -->
- <select id="GetAllAccounts"
- resultMap="indexed-account-result">
- select
- Account_Id,
- Account_FirstName,
- Account_LastName,
- Account_Email
- from Accounts
- </select>
-
- <select id="GetAllAccountsOrderByName"
- extends="GetAllAccounts"
- resultMap="indexed-account-result">
- order by Account_FirstName
- </select>
-
- <select id="GetOneAccount"
- extends="GetAllAccounts"
- resultMap="indexed-account-result">
- where Account_Id = #value#
- </select>
-
- <select id="GetSomeAccount"
- extends="GetAllAccounts"
- parameterClass="Hashtable"
- resultMap="indexed-account-result">
- where Account_Id between #lowID# and #hightID#
- </select>
-
- <select id="SelectAccountJIRA29" parameterClass="map" resultClass="Account">
- select
- Account_Id as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- where Account_FirstName = '##$AccountName$##'
- </select>
-
- <select id="SelectAccountJIRA29-2"
- parameterClass="Hashtable"
- resultClass="Account">
- select
- Account_Id as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- where 1=1
- <isNotEmpty prepend="AND" property="Foo">
- (Account_FirstName = '##$Foo$##')
- </isNotEmpty>
- </select>
-
- <select id="GetAccountWithRepeatingProperty"
- parameterClass="Account"
- resultMap="indexed-account-result">
- select
- Account_Id,
- Account_FirstName,
- Account_LastName,
- Account_Email
- from Accounts
- where Account_Id = #Id# and
- Account_Id = #Id# and
- Account_FirstName = #FirstName# and
- Account_LastName = #LastName# and
- Account_Id = #Id#
- </select>
-
- <select id="GetAllAccountsViaCustomTypeHandler"
- resultMap="account-result">
- select * from Accounts
- order by Account_Id
- </select>
-
- <!-- JIRA-110 -->
- <select id="GetManyAccound" resultClass="Account">
- SELECT
- Account_Id as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- FROM Accounts
- </select>
-
- <select id="Get1Account" extends="GetManyAccound" resultClass="Account">WHERE Account_Id=1</select>
-
- <statement id="GetAccounts" resultMap="account-result">
- SELECT *
- FROM
- Accounts
- </statement>
- <!-- JIRA-110 -->
-
- <insert id="InsertAccountDynamic" parameterClass="Account">
- INSERT INTO Accounts
- (Account_Id, Account_FirstName, Account_LastName, Account_Email)
- VALUES(#Id#, #FirstName#, #LastName#
- <dynamic prepend=",">
- <isNotNull prepend="," property="EmailAddress">
- #EmailAddress#
- </isNotNull>
- <isNull prepend="," property="EmailAddress">
- null
- </isNull>
- </dynamic>
- )
- </insert>
-
-
- <!-- accounts and orders -->
-
- <select id="getAccountWithOrders" resultMap="Account-with-Orders">
- SELECT
- Accounts.Account_Id as Account_Id,
- Accounts.Account_FirstName as Account_FirstName,
- Accounts.Account_LastName as Account_LastName,
- Accounts.Account_Email as Account_Email,
- Accounts.Account_Banner_Option as Account_Banner_Option,
- Accounts.Account_Cart_Option as Account_Cart_Option,
- Orders.Order_Id as Order_Id,
- Orders.Order_Date as Order_Date,
- Orders.Order_CardType as Order_CardType,
- Orders.Order_CardNumber as Order_CardNumber,
- Orders.Order_CardExpiry as Order_CardExpiry,
- Orders.Order_Street as Order_Street,
- Orders.Order_City as Order_City,
- Orders.Order_Province as Order_Province,
- Orders.Order_PostalCode as Order_PostalCode,
- Orders.Order_FavouriteLineItem as Order_FavouriteLineItem
- FROM accounts
- LEFT JOIN orders ON
- accounts.account_id = orders.account_id
- </select>
-
- <resultMap id="Account-with-Orders" class="AccountWithOrders" groupBy="Account_Id">
- <result property="Id" column="Account_Id"/>
- <result property="FirstName" column="Account_FirstName"/>
- <result property="LastName" column="Account_LastName"/>
- <result property="EmailAddress" column="Account_Email" />
- <result property="Orders" resultMapping="account-orders" />
- </resultMap>
-
- <resultMap id="account-orders" class="Order">
- <result property="Id" column="Order_Id"/>
- <result property="Date" type="date" column="Order_Date" nullValue="0001-01-01 00:00:00"/>
- <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>
-
-
- <!-- For procedure, the parameters of the parameterMap must in the same order
- as for the procedure paramaters-->
- <procedure id="InsertAccountViaStoreProcedure" parameterMap="account-insert-params">
- ps_InsertAccount
- </procedure>
-
- <procedure id="SwapEmailAddresses" parameterMap="swap-params">
- ps_swap_email_address
- </procedure>
-
- <!-- =============================================
- OPTIONAL EXPLICIT PARAMETER MAP
- ============================================= -->
-
- <parameterMap id="swap-params">
- <parameter property="email1" column="First_Email" />
- <parameter property="email2" column="Second_Email" />
- </parameterMap>
-
- <parameterMap id="account-insert-params">
- <parameter property="Id" />
- <parameter property="FirstName" />
- <parameter property="LastName" />
- <parameter property="EmailAddress" nullValue="no_email@provided.com"/>
- <parameter property="BannerOptions" dbType="Varchar" type="bool"/>
- <parameter property="CartOptions" column="Account_Cart_Option" typeHandler="HundredsBool"/>
- </parameterMap>
-
- <parameterMap id="update-params">
- <parameter property="FirstName" />
- <parameter property="LastName" />
- <parameter property="EmailAddress" nullValue="no_email@provided.com"/>
- <parameter property="Id" />
- </parameterMap>
-
- <parameterMap id="update-params2">
- <parameter property="Id" />
- <parameter property="FirstName" />
- <parameter property="LastName" />
- <parameter property="EmailAddress" nullValue="no_email@provided.com"/>
- <parameter property="Id" />
- </parameterMap>
-
-
-</sqlMap>
\ No newline at end of file diff --git a/tests/unit/SQLMap/maps/sqlite/Category.xml b/tests/unit/SQLMap/maps/sqlite/Category.xml deleted file mode 100644 index ec81449b..00000000 --- a/tests/unit/SQLMap/maps/sqlite/Category.xml +++ /dev/null @@ -1,162 +0,0 @@ -<?xml version="1.0" encoding="utf-8"?>
-<sqlMap namespace="Category" >
-
- <alias>
- <typeAlias alias="Category" type="IBatisNet.DataMapper.Test.Domain.Category, IBatisNet.DataMapper.Test"/>
- </alias>
-
-
- <select id="GetCategory" parameterClass="Integer" resultClass="Category">
- select
- Category_ID as Id,
- Category_Name as Name,
- Category_Guid as GuidString
- from Categories
- where Category_ID = #value#
- </select>
-
- <select id="GetCategoryGuid" parameterClass="Integer" resultClass="guid">
- select
- Category_Guid as value
- from Categories
- where Category_ID = #value#
- </select>
-
- <!-- Test for statement as insert -->
- <!-- Needs to be <insert> vs <statement> for MySql due to selectKey -->
- <insert id="InsertCategory" parameterClass="Category">
- <selectKey property="Id" type="post" resultClass="int">
- select LAST_INSERT_ID() as value
- </selectKey>
- insert into Categories
- (Category_Name, Category_Guid)
- values
- (#Name#, #GuidString:Varchar#);
- </insert>
-
- <!-- -->
- <insert id="InsertCategoryViaInsertStatement" parameterClass="Category" >
- <selectKey property="Id" type="post" resultClass="int">
- select LAST_INSERT_ID() as value
- </selectKey>
- insert into Categories
- (Category_Name, Category_Guid)
- values
- (#Name#, #GuidString:Varchar#)
- </insert>
-
- <!-- Needs to be <insert> vs <statement> for MySql due to selectKey -->
- <insert id="InsertCategoryViaParameterMap" parameterMap="InsertParam">
- <selectKey property="Id" type="post" resultClass="int">
- select LAST_INSERT_ID() as value
- </selectKey>
- insert into Categories
- (Category_Name, Category_Guid)
- values
- (?,?);
- </insert>
-
- <!-- Needs to be <insert> vs <statement> for MySql due to selectKey -->
- <insert id="InsertCategoryNull" parameterMap="insert-null-params">
- <selectKey property="Id" type="post" resultClass="int">
- select LAST_INSERT_ID() as value
- </selectKey>
- insert into Categories
- (Category_Name, Category_Guid)
- values
- (?,?);
- </insert>
-
- <update id="UpdateCategoryViaParameterMap" parameterMap="UpdateParam">
- update Categories set
- Category_Name =?,
- Category_Guid = ?
- where
- Category_Id = ?
- </update>
-
- <procedure id="InsertCategoryViaStoreProcedure" parameterMap="category-insert-params">
- ps_InsertCategorie
- </procedure>
-
- <insert id="InsertCategoryGenerate" parameterMap="insert-generate-params">
- <selectKey property="Id" type="post" resultClass="int">
- select LAST_INSERT_ID() as value
- </selectKey>
- <generate table="Categories" />
- </insert>
-
- <update id="UpdateCategoryGenerate" parameterMap="update-generate-params">
- <generate table="Categories" by="Category_Id"/>
- </update>
-
- <delete id="DeleteCategoryGenerate" parameterMap="delete-generate-params">
- <generate table="Categories" by="Category_Id, Category_Name"/>
- </delete>
-
- <select id="SelectByPKCategoryGenerate" resultClass="Category" parameterClass="Category" parameterMap="select-generate-params">
- <generate table="Categories" by="Category_Id"/>
- </select>
-
- <select id="SelectAllCategoryGenerate" resultClass="Category" parameterMap="select-generate-params">
- <generate table="Categories" />
- </select>
-
- <statement id="DynamicGuid"
- resultClass="Category"
- parameterClass="Category">
- select
- Category_ID as Id,
- Category_Name as Name,
- Category_Guid as Guid
- from Categories
- <dynamic prepend="where">
- <isNotEqual prepend="and" property="Guid" compareProperty="EmptyGuid">
- Category_Guid=#GuidString:Varchar#
- </isNotEqual>
- </dynamic>
- </statement>
- <parameterMap id="category-insert-params">
- <parameter property="Id" column="Category_Id" dbType="Int32" />
- <parameter property="Name" column="Category_Name"/>
- <parameter property="GuidString" column="Category_Guid" dbType="Varchar"/>
- </parameterMap>
-
- <parameterMap id="InsertParam">
- <parameter property="Name" column="Category_Name"/>
- <parameter property="GuidString" column="Category_Guid" dbType="Varchar"/>
- </parameterMap>
-
- <parameterMap id="insert-null-params">
- <parameter property="Name" column="Category_Name"/>
- <parameter property="GuidString" column="Category_Guid" nullValue="00000000-0000-0000-0000-000000000000" dbType="Varchar"/>
- </parameterMap>
-
- <parameterMap id="UpdateParam" extends="InsertParam">
- <parameter property="Id" column="Category_Id" />
- </parameterMap>
-
- <!-- Used by generated statement -->
-
- <parameterMap id="insert-generate-params">
- <parameter property="Name" column="Category_Name"/>
- <parameter property="GuidString" column="Category_Guid" dbType="Varchar"/>
- </parameterMap>
-
- <parameterMap id="update-generate-params" extends="insert-generate-params">
- <parameter property="Id" column="Category_Id" />
- </parameterMap>
-
- <parameterMap id="delete-generate-params">
- <parameter property="Id" column="Category_Id" />
- <parameter property="Name" column="Category_Name"/>
- </parameterMap>
-
- <parameterMap id="select-generate-params">
- <parameter property="Id" column="Category_Id" />
- <parameter property="Name" column="Category_Name"/>
- <parameter property="GuidString" column="Category_Guid" dbType="Varchar"/>
- </parameterMap>
-
-
-</sqlMap>
diff --git a/tests/unit/SQLMap/maps/sqlite/Complex.xml b/tests/unit/SQLMap/maps/sqlite/Complex.xml deleted file mode 100644 index f6da811d..00000000 --- a/tests/unit/SQLMap/maps/sqlite/Complex.xml +++ /dev/null @@ -1,23 +0,0 @@ -<?xml version="1.0" encoding="utf-8" ?>
-<sqlMap namespace="Complex" >
-
- <statements>
-
- <statement id="ComplexMap"
- resultClass="int" >
- select Account_ID from Accounts where Account_ID = #obj.Map.Id#
- </statement>
-
- <insert id="InsertComplexAccountViaInlineDefaultNull"
- parameterClass="Hashtable" >
- insert into Accounts
- (Account_ID, Account_FirstName, Account_LastName, Account_Email)
- values
- (#obj.Map.acct.Id#, #obj.Map.acct.FirstName#, #obj.Map.acct.LastName#, #obj.Map.acct.EmailAddress:Varchar:no_email@provided.com#
- )
- </insert>
-
- </statements>
-
-
-</sqlMap>
diff --git a/tests/unit/SQLMap/maps/sqlite/Document.xml b/tests/unit/SQLMap/maps/sqlite/Document.xml deleted file mode 100644 index 8796865c..00000000 --- a/tests/unit/SQLMap/maps/sqlite/Document.xml +++ /dev/null @@ -1,53 +0,0 @@ -<?xml version="1.0" encoding="utf-8" ?>
-<sqlMap namespace="Document" >
-
- <resultMap id="document" class="Document">
- <result property="Id" column="Document_Id" type="integer" />
- <result property="Title" column="Document_Title"/>
- <discriminator column="Document_Type" type="string"/>
- <subMap value="Book" resultMapping="book" />
- <subMap value="Newspaper" resultMapping="newspaper" />
- </resultMap>
-
- <resultMap id="document-custom-handler" class="Document">
- <result property="Id" column="Document_Id" type="integer"/>
- <result property="Title" column="Document_Title"/>
- <discriminator column="Document_Type" typeHandler="CustomInheritance"/>
- <subMap value="Book" resultMapping="book" />
- <subMap value="Newspaper" resultMapping="newspaper" />
- </resultMap>
-
- <resultMap id="book" class="Book" extends="document">
- <result property="PageNumber" column="Document_PageNumber"/>
- </resultMap>
-
- <resultMap id="newspaper" class="Newspaper" extends="document">
- <result property="City" column="Document_City"/>
- </resultMap>
-
- <statement id="GetAllDocument"
- resultMap="document">
- select
- *
- from Documents
- order by Document_Type, Document_Id
- </statement>
-
- <select id="GetTypedCollection"
- listClass="DocumentCollection"
- resultMap="document">
- select
- *
- from Documents
- order by Document_Type, Document_Id
- </select>
-
- <select id="GetAllDocumentWithCustomTypeHandler"
- resultMap="document-custom-handler">
- select
- *
- from Documents
- order by Document_Type, Document_Id
- </select>
-
-</sqlMap>
\ No newline at end of file diff --git a/tests/unit/SQLMap/maps/sqlite/DynamicAccount.xml b/tests/unit/SQLMap/maps/sqlite/DynamicAccount.xml deleted file mode 100644 index ff89720b..00000000 --- a/tests/unit/SQLMap/maps/sqlite/DynamicAccount.xml +++ /dev/null @@ -1,448 +0,0 @@ -<?xml version="1.0" encoding="utf-8" ?>
-<sqlMap namespace="Account" >
-
- <alias>
- <typeAlias alias="Search" type="IBatisNet.DataMapper.Test.Domain.Search, IBatisNet.DataMapper.Test"/>
- </alias>
-
- <statements>
-
- <select id="DynamicAll"
- parameterClass="Account"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- </select>
-
- <select id="DynamicWithExtend"
- extends="DynamicAll"
- parameterClass="Account"
- resultClass="Account">
- <dynamic prepend="WHERE" >
- <isGreaterThan prepend="AND" property="Id" compareValue="0" >
- Account_ID = #Id#
- </isGreaterThan>
- <isNotNull prepend="AND" property="Ids" >
- Account_ID in
- <iterate property="Ids" open="(" close=")" conjunction="," >
- #Ids[]#
- </iterate>
- </isNotNull>
- <isNotEmpty prepend="AND" property="FirstName" >
- Account_FirstName = #FirstName#
- </isNotEmpty>
- <isNotEmpty prepend="AND" property="LastName" >
- Account_LastName = #LastName#
- </isNotEmpty>
- <isNotEmpty prepend="AND" property="EmailAddress" >
- <isEqual property="EmailAddress" compareValue="Joe">
- Account_Email = 'clinton.begin@ibatis.com'
- </isEqual>
- <isNotEqual property="EmailAddress" compareValue="Joe">
- Account_Email = #EmailAddress#
- </isNotEqual>
- </isNotEmpty>
- </dynamic>
- </select>
-
- <!-- IBATISNET-114: remapResults -->
- <statement id="DynamicSqlOnColumnSelection"
- parameterClass="Account"
- resultClass="Account"
- remapResults="true">
- SELECT
- Account_ID as Id,
- <dynamic>
- <isEqual property="LastName" compareValue="Dalton" >
- Account_FirstName as FirstName,
- </isEqual>
- <isEqual property="LastName" compareValue="Dalton" >
- Account_LastName as LastName,
- </isEqual>
- </dynamic>
-
- Account_Email as EmailAddress
- FROM
- Accounts
- </statement>
-
- <statement id="DynamicIsEqual"
- parameterClass="string"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- <isEqual compareValue="Joe" >
- where Account_FirstName = 'Joe'
- </isEqual>
- </statement>
-
- <statement id="DynamicIsParameterPresent"
- parameterClass="integer"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- <isParameterPresent >
- where Account_ID = #value#
- </isParameterPresent>
- </statement>
-
- <statement id="DynamicIsNotEmpty"
- parameterClass="string"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- <isNotEmpty>
- where Account_FirstName = #value#
- </isNotEmpty>
- </statement>
-
- <statement id="DynamicIsGreater"
- parameterClass="int"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- <isGreaterThan compareValue="3" >
- where Account_ID = 1
- </isGreaterThan>
- </statement>
-
- <statement id="DynamicIsGreaterEqual"
- parameterClass="int"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- <isGreaterEqual compareValue="3" >
- where Account_ID = 1
- </isGreaterEqual>
- </statement>
-
- <statement id="DynamicIsLess"
- parameterClass="int"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- <isLessThan compareValue="3" >
- where Account_ID = 1
- </isLessThan>
- </statement>
-
- <statement id="DynamicIsLessEqual"
- parameterClass="int"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- <isLessEqual compareValue="3" >
- where Account_ID = 1
- </isLessEqual>
- </statement>
-
- <statement id="DynamicIsNotNull"
- parameterClass="string"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- <isNotNull>
- where Account_ID = 1
- </isNotNull>
- </statement>
-
- <statement id="DynamicIsPropertyAvailable"
- parameterClass="string"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- <isPropertyAvailable property="Id" >
- where Account_ID = 1
- </isPropertyAvailable>
- </statement>
-
-
- <statement id="DynamicSubst"
- parameterClass="map"
- resultClass="Account">
- <dynamic>
- $statement$
- </dynamic>
- </statement>
-
- <statement id="DynamicIterate"
- parameterClass="list"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- WHERE Account_ID IN
- <iterate open="(" close=")" conjunction=",">
- #[]#
- </iterate>
- </statement>
-
- <statement id="DynamicIterate2"
- parameterClass="Account"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- WHERE Account_ID IN
- <iterate property="Ids" open="(" close=")" conjunction="," >
- #Ids[]#
- </iterate>
- </statement>
-
- <statement id="MultiDynamicIterate"
- parameterClass="list"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- WHERE Account_ID IN
- <iterate open="(" close=")" conjunction=",">
- #[]#
- </iterate>
- and Account_ID IN
- <iterate open="(" close=")" conjunction=",">
- #[]#
- </iterate>
- </statement>
-
-
- <statement id="DynamicQueryByExample"
- parameterClass="Account"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- <dynamic prepend="WHERE" >
- <isGreaterThan prepend="AND" property="Id" compareValue="0" >
- Account_ID = #Id#
- </isGreaterThan>
- <isNotNull prepend="AND" property="Ids" >
- Account_ID in
- <iterate property="Ids" open="(" close=")" conjunction="," >
- #Ids[]#
- </iterate>
- </isNotNull>
- <isNotEmpty prepend="AND" property="FirstName" >
- Account_FirstName = #FirstName#
- </isNotEmpty>
- <isNotEmpty prepend="AND" property="LastName" >
- Account_LastName = #LastName#
- </isNotEmpty>
- <isNotEmpty prepend="AND" property="EmailAddress" >
- <isEqual property="EmailAddress" compareValue="Joe">
- Account_Email = 'clinton.begin@ibatis.com'
- </isEqual>
- <isNotEqual property="EmailAddress" compareValue="Joe">
- Account_Email = #EmailAddress#
- </isNotEqual>
- </isNotEmpty>
- </dynamic>
- </statement>
-
- <statement id="DynamicIterateWithPrepend1"
- parameterClass="list"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- <dynamic prepend="where" >
- Account_ID IN
- <iterate open="(" close=")" conjunction=",">
- #[]#
- </iterate>
- </dynamic>
- </statement>
-
- <statement id="DynamicIterateWithPrepend2"
- parameterClass="list"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- <dynamic prepend="where" >
- <iterate open="(" close=")" conjunction="OR">
- Account_ID = #[]#
- </iterate>
- </dynamic>
- </statement>
-
- <statement id="DynamicIterateWithPrepend3"
- parameterClass="list"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- <dynamic prepend="where" >
- <isParameterPresent prepend="BLAH!" >
- <iterate open="(" close=")" conjunction="OR">
- Account_ID = #[]#
- </iterate>
- </isParameterPresent>
- </dynamic>
- </statement>
-
- <statement id="DynamicWithPrepend"
- parameterClass="Account"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- <dynamic prepend="where">
- <isParameterPresent>
- <isNotEmpty prepend="and" property="Id" >
- Account_ID = #Id#
- </isNotEmpty>
- <isNotEmpty prepend="and" property="FirstName" >
- Account_FirstName = #FirstName#
- </isNotEmpty>
- <isNotEmpty prepend="and" property="LastName" >
- Account_LastName = #LastName#
- </isNotEmpty>
- </isParameterPresent>
- </dynamic>
- </statement>
-
- <statement id="DynamicWithTwoDynamicElements"
- parameterClass="Account"
- resultClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- <dynamic prepend="where">
- <isNotEmpty prepend="BLAH!" property="Id" >
- Account_ID = #Id#
- </isNotEmpty>
- </dynamic>
- <dynamic prepend="and">
- <isNotEmpty prepend="BLAH!" property="FirstName" >
- Account_FirstName = #FirstName#
- </isNotEmpty>
- <isNotEmpty prepend="and" property="LastName" >
- Account_LastName = #LastName#
- </isNotEmpty>
- </dynamic>
- </statement>
-
- <statement id="ComplexDynamicStatement"
- cacheModel="account-cache"
- resultClass="Account"
- parameterClass="Account">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- <dynamic prepend="WHERE">
- <isNotNull prepend="AND" property="FirstName">
- (Account_FirstName = #FirstName#
- <isNotNull prepend="OR" property="LastName">
- Account_LastName = #LastName#
- </isNotNull>
- )
- </isNotNull>
- <isNotNull prepend="AND" property="EmailAddress">
- Account_Email like #EmailAddress#
- </isNotNull>
- <isGreaterThan prepend="AND" property="Id" compareValue="0">
- Account_ID = #Id#
- </isGreaterThan>
- </dynamic>
- order by Account_LastName
- </statement>
-
- <statement id="Jira-IBATISNET-11"
- resultClass="Account"
- parameterClass="Search">
- select
- Account_ID as Id,
- Account_FirstName as FirstName,
- Account_LastName as LastName,
- Account_Email as EmailAddress
- from Accounts
- <dynamic prepend="where">
- <isNotNull prepend="and" property="NumberSearch">
- ((Account_ID $Operande$ #NumberSearch#) or
- (Account_ID $Operande$ #NumberSearch#))
- </isNotNull>
- <isEqual prepend="and" property="StartDate" compareValue="25/12/2004">
- <![CDATA[Account_FirstName >= #StartDate# ]]>
- </isEqual>
- <isEqual prepend="and" property="StartDateAnd" compareValue="true">
- <![CDATA[Account_LastName >= #StartDate# ]]>
- </isEqual>
- </dynamic>
-
- order by Account_LastName
- </statement>
- </statements>
-
-
-</sqlMap>
\ No newline at end of file diff --git a/tests/unit/SQLMap/maps/sqlite/Enumeration.xml b/tests/unit/SQLMap/maps/sqlite/Enumeration.xml deleted file mode 100644 index b321259e..00000000 --- a/tests/unit/SQLMap/maps/sqlite/Enumeration.xml +++ /dev/null @@ -1,59 +0,0 @@ -<?xml version="1.0" encoding="utf-8"?>
-<sqlMap namespace="Enumeration" >
-
- <alias>
- <typeAlias alias="Enumeration" type="IBatisNet.DataMapper.Test.Domain.Enumeration, IBatisNet.DataMapper.Test"/>
- </alias>
-
- <resultMaps>
- <resultMap id="enumeration-result" class="Enumeration" >
- <result property="Id" column="Enum_ID"/>
- <result property="Day" column="Enum_Day"/>
- <result property="Color" column="Enum_Color"/>
- <result property="Month" column="Enum_Month" nullValue="All"/>
- </resultMap>
- </resultMaps>
-
- <statements>
-
- <select id="GetEnumerationNullValue"
- parameterClass="Integer"
- resultMap="enumeration-result">
- select
- Enum_ID,
- Enum_Day,
- Enum_Color,
- Enum_Month
- from Enumerations
- where Enum_ID = #value#
- </select>
-
- <select id="GetEnumeration" parameterClass="Integer" resultClass="Enumeration">
- select
- Enum_ID as Id,
- Enum_Day as Day,
- Enum_Color as Color,
- Enum_Month as Month
- from Enumerations
- where Enum_ID = #value#
- </select>
-
- <insert id="InsertEnumViaParameterMap" parameterMap="insert-params" >
- insert into Enumerations
- (Enum_ID, Enum_Day, Enum_Color, Enum_Month)
- values
- (?, ?, ?, ?)
- </insert>
-
- </statements>
-
- <parameterMaps>
- <parameterMap id="insert-params">
- <parameter property="Id" column="Enum_ID" />
- <parameter property="Day" column="Enum_Day"/>
- <parameter property="Color" column="Enum_Color" />
- <parameter property="Month" column="Enum_Month" nullValue="All"/>
- </parameterMap>
- </parameterMaps>
-
-</sqlMap>
diff --git a/tests/unit/SQLMap/maps/sqlite/LineItem.xml b/tests/unit/SQLMap/maps/sqlite/LineItem.xml deleted file mode 100644 index c9778d9d..00000000 --- a/tests/unit/SQLMap/maps/sqlite/LineItem.xml +++ /dev/null @@ -1,188 +0,0 @@ -<?xml version="1.0" encoding="UTF-8" ?>
-
-<sqlMap namespace="LineItem" >
-
- <alias>
- <typeAlias alias="LineItem" type="IBatisNet.DataMapper.Test.Domain.LineItem, IBatisNet.DataMapper.Test" />
- <typeAlias alias="LineItemCollection" type="IBatisNet.DataMapper.Test.Domain.LineItemCollection, IBatisNet.DataMapper.Test" />
- </alias>
-
- <resultMap id="LineItem-Price" class="float">
- <result property="value" column="LineItem_Price"/>
- </resultMap>
-
- <resultMap id="LineItem" class="LineItem">
- <result property="Id" column="LineItem_Id"/>
- <result property="Code" column="LineItem_Code"/>
- <result property="Quantity" column="LineItem_Quantity"/>
- <result property="Price" column="LineItem_Price"/>
- </resultMap>
-
- <resultMap id="LineItemWithNullReplacement" class="LineItem">
- <result property="Id" column="LineItem_Id"/>
- <result property="Code" column="LineItem_Code"/>
- <result property="Quantity" column="LineItem_Quantity"/>
- <result property="Price" column="LineItem_Price" nullValue="-77.77"/>
- </resultMap>
-
-
- <statement id="GetLineItemPrice"
- parameterClass="array"
- resultMap="LineItem-Price" >
- select
- LineItem_Price
- from LineItems
- where Order_ID = #Order_ID#
- and LineItem_ID = #LineItem_ID#
- </statement>
-
- <statement id="GetLineItemsForOrder"
- parameterClass="int"
- listClass="TList"
- resultClass="LineItem">
- select
- LineItem_ID as Id,
- LineItem_Code as Code,
- LineItem_Quantity as Quantity,
- LineItem_Price as Price
- from LineItems where Order_ID = #value#
- </statement>
-
-
- <statement id="GetLineItemsForOrderWithListClass"
- parameterClass="int"
- listClass="LineItemCollection"
- resultClass="LineItem">
- select
- LineItem_ID as Id,
- LineItem_Code as Code,
- LineItem_Quantity as Quantity,
- LineItem_Price as Price
- from LineItems where Order_ID = #value#
- order by LineItem_Code
- </statement>
-
- <statement id="GetSpecificLineItem"
- parameterClass="array"
- resultClass="LineItem">
- select
- LineItem_ID as Id,
- LineItem_Code as Code,
- LineItem_Quantity as Quantity,
- LineItem_Price as Price
- from LineItems
- where Order_ID = #Order_ID#
- and LineItem_ID = #LineItem_ID#
- </statement>
-
- <statement id="GetSpecificLineItemWithPicture"
- parameterClass="array"
- resultClass="LineItem">
- select
- LineItem_ID as Id,
- LineItem_Code as Code,
- LineItem_Quantity as Quantity,
- LineItem_Price as Price,
- LineItem_Picture as PictureData
- from LineItems
- where Order_ID = #Order_ID#
- and LineItem_ID = #LineItem_ID#
- </statement>
-
- <select id="GetDynSpecificLineItem"
- parameterClass="array"
- resultClass="LineItem">
- select
- LineItem_ID as Id,
- LineItem_Code as Code,
- LineItem_Quantity as Quantity,
- LineItem_Price as Price
- from LineItems
- where Order_ID = #Order_ID#
- <dynamic>
- <isNotNull property="LineItem_ID">
- and LineItem_ID = #LineItem_ID#
- </isNotNull>
- </dynamic>
- </select>
-
- <statement id="GetSpecificLineItemWithNullReplacement"
- parameterClass="int"
- resultMap="LineItemWithNullReplacement">
- select
- LineItem_ID,
- LineItem_Code,
- LineItem_Quantity,
- LineItem_Price
- from LineItems
- where LineItem_ID = #value#
- </statement>
-
- <statement id="InsertLineItem"
- parameterMap="line-item-insert-params" >
- insert into LineItems
- (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price)
- values
- (?, ?, ?, ?, ?);
- </statement>
-
- <statement id="InsertLineItemWithPicture"
- parameterMap="line-item-insert-params-picture" >
- insert into LineItems
- (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price, LineItem_Picture)
- values
- (?, ?, ?, ?, ?, ?);
- </statement>
-
- <insert id="InsertLineItemPostKey" parameterClass="LineItem">
- insert into LineItems
- (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price)
- values
- (#Id#, #Order.Id#, #Code#, #Quantity#, #Price, type=float#)
- <selectKey property="Id" type="post" resultClass="int" >
- select 99 from LineItems where LineItem_ID = 1 and Order_ID=1
- </selectKey>
- </insert>
-
- <insert id="InsertLineItemPreKey" parameterClass="LineItem">
- <selectKey property="Id" type="pre" resultClass="int" >
- select 99 from LineItems where LineItem_ID = 1 and Order_ID=1
- </selectKey>
- insert into LineItems
- (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price)
- values
- (#Id#, #Order.Id#, #Code#, #Quantity#, #Price, type=float#)
- </insert>
-
- <insert id="InsertLineItemNoKey" parameterClass="LineItem">
- insert into LineItems
- (LineItem_ID, Order_ID, LineItem_Code, LineItem_Quantity, LineItem_Price)
- values
- (#Id#, #Order.Id#, #Code#, #Quantity#, #Price, type=float#)
- </insert>
-
- <!-- JIRA 23 -->
- <delete id="DeleteWithComments" >
- <!-- Delete LineItems -->
- delete from LineItems where Order_ID = 10;
- <!-- Delete LineItems -->
- </delete>
-
- <parameterMap id="line-item-insert-params">
- <parameter property="Id" />
- <parameter property="Order.Id" />
- <parameter property="Code" />
- <parameter property="Quantity" />
- <parameter property="Price" dbType="Decimal" nullValue="-99.99"/>
- </parameterMap>
-
- <parameterMap id="line-item-insert-params-picture">
- <parameter property="Id" />
- <parameter property="Order.Id" />
- <parameter property="Code" />
- <parameter property="Quantity" />
- <parameter property="Price" dbType="Decimal" nullValue="-99.99"/>
- <parameter property="PictureData" dbType="Blob" />
- </parameterMap>
-
-</sqlMap>
\ No newline at end of file diff --git a/tests/unit/SQLMap/maps/sqlite/Order.xml b/tests/unit/SQLMap/maps/sqlite/Order.xml deleted file mode 100644 index 38009b1a..00000000 --- a/tests/unit/SQLMap/maps/sqlite/Order.xml +++ /dev/null @@ -1,507 +0,0 @@ -<?xml version="1.0" encoding="UTF-8" ?>
-
-<sqlMap namespace="Order">
-
- <alias>
- <typeAlias alias="Order" type="IBatisNet.DataMapper.Test.Domain.Order, IBatisNet.DataMapper.Test" />
- </alias>
-
- <!-- If the type is not specified, ADO.NET infers the
- data provider Type of the Parameter from the Value property
- of the Parameter object. -->
-
-
- <resultMap id="credit-card-result" class="string">
- <result property="value" column="Order_CardNumber"/>
- </resultMap>
- <!-- -->
- <resultMap id="order-with-lines-result" class="Order"
- extends="lite-order-result-by-name" >
- <result property="LineItemsList" lazyLoad="true" type="TList" column="Order_Id" select="GetLineItemsForOrder" />
- </resultMap>
-
- <resultMap id="order-with-lines-result-no-lazy-load" class="Order"
- extends="lite-order-result-by-name" >
- <result property="LineItemsList" type="TList" column="Order_Id" select="GetLineItemsForOrder" />
- </resultMap>
-
- <resultMap id="order-with-lines-result-statement-namespaces" class="Order"
- extends="lite-order-result-by-name" >
- <result property="LineItemsList" lazyLoad="true" type="TList" column="Order_Id" select="LineItem.GetLineItemsForOrder" />
- </resultMap>
-
- <resultMap id="order-with-lines-collection" class="Order"
- extends="lite-order-result-by-name" >
- <result property="LineItems" column="Order_Id" lazyLoad="true"
- select="GetLineItemsForOrderWithListClass" />
- </resultMap>
-
- <resultMap id="order-with-lines-collection-no-lazy-load" class="Order"
- extends="lite-order-result-by-name" >
- <result property="LineItems" column="Order_Id"
- select="GetLineItemsForOrderWithListClass" />
- </resultMap>
-
- <resultMap id="order-with-lines-array" class="Order"
- extends="lite-order-result-by-name">
- <result property="LineItemsArray" column="Order_Id" select="GetLineItemsForOrder"/>
- </resultMap>
-
- <resultMap id="lite-order-map-result" class="array">
- <result property="Id" type="Int" column="Order_Id"/>
- <result property="Date" type="date" column="Order_Date"/>
- <result property="CardExpiry" type="string" column="Order_CardExpiry"/>
- <result property="CardType" type="string" column="Order_CardType"/>
- <result property="CardNumber" type="string" column="Order_CardNumber"/>
- <result property="Street" type="string" column="Order_Street"/>
- <result property="City" type="string" column="Order_City"/>
- <result property="Province" type="string" column="Order_Province"/>
- <result property="PostalCode" type="string" column="Order_PostalCode"/>
- </resultMap>
-
- <resultMap id="lite-order-result-by-name" class="Order">
- <result property="Id" column="Order_Id"/>
- <result property="Date" type="date" column="Order_Date" nullValue="0001-01-01 00:00:00"/>
- <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="order-hash" class="array">
- <result property="Date" column="Order_Date" nullValue="0001-01-01 00:00:00"/>
- </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"/>
- </resultMap>
-
- <resultMap id="lite-order-result-by-index" class="Order">
- <result property="Id" column="Order_Id" columnIndex="0"/>
- <result property="Date" column="Order_Date" type="date" columnIndex="1" />
- <result property="CardExpiry" column="Order_CardExpiry" columnIndex="2"/>
- <result property="CardType" column="Order_CardType" columnIndex="3" />
- <result property="CardNumber" column="Order_CardNumber" columnIndex="4" />
- <result property="Street" column="Order_Street" columnIndex="5" />
- <result property="City" column="Order_City" columnIndex="6" />
- <result property="Province" column="Order_Province" columnIndex="7"/>
- <result property="PostalCode" column="Order_PostalCode" columnIndex="8" />
- </resultMap>
-
- <resultMap id="order-with-account-result" class="Order">
- <result property="Id" column="Order_Id"/>
- <result property="Date" type="date" column="Order_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"/>
- <result property="Account" column="Account_Id" select="GetAccountViaColumnName" />
- </resultMap>
-
- <resultMap id="order-with-collection-result" class="Order">
- <result property="Id" column="Order_Id"/>
- <result property="Date" type="date" column="Order_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"/>
- <result property="LineItemsList" column="Order_Id" select="GetLineItemsForOrder" />
- <result property="LineItems" column="Order_Id" select="GetLineItemsForOrder" lazyLoad="false" />
- </resultMap>
-
- <resultMap id="order-with-favourite-line-item" class="Order">
- <result property="Id" column="Order_Id"/>
- <result property="Date" column="Order_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"/>
- <result property="FavouriteLineItem"
- column="Order_ID=Order_Id,LineItem_ID=Order_FavouriteLineItem"
- select="GetSpecificLineItem" />
- </resultMap>
-
- <resultMap id="order-with-dyn-favourite-line-item" class="Order">
- <result property="Id" column="Order_Id"/>
- <result property="Date" column="Order_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"/>
- <result property="FavouriteLineItem"
- column="Order_ID=Order_Id,LineItem_ID=Order_FavouriteLineItem"
- select="GetDynSpecificLineItem" />
- </resultMap>
-
- <resultMap id="order-joined-favourite" class="Order">
- <result property="Id" column="Order_Id"/>
- <result property="Date" type="date" column="Order_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"/>
- <result property="FavouriteLineItem" resultMapping="LineItem" />
- </resultMap>
-
- <resultMap id="order-joined-favourite2" class="Order">
- <result property="Id" column="Order_Id"/>
- <result property="Date" type="date" column="Order_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"/>
- <result property="FavouriteLineItem.Id" column="LineItem_Id"/>
- <result property="FavouriteLineItem.Code" column="LineItem_Code"/>
- <result property="FavouriteLineItem.Quantity" column="LineItem_Quantity"/>
- <result property="FavouriteLineItem.Price" column="LineItem_Price"/>
- </resultMap>
-
- <resultMap id="order-joined-with-account" class="Order">
- <result property="Id" column="Order_Id"/>
- <result property="Date" type="date" column="Order_Date" nullValue="01/01/0001 00:00:00"/>
- <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"/>
- <result property="Account" resultMapping="account-result-nullable-email" />
- </resultMap>
-
- <statement id="GetOrderLiteByColumnName"
- parameterClass="integer"
- resultMap="lite-order-result-by-name" >
- select * from Orders where Order_Id = #value#
- </statement>
-
- <statement id="GetOrderByHashTable"
- parameterClass="Int"
- resultMap="order-hash" >
- select Order_Date from Orders where Order_Id = #value#
- </statement>
-
- <statement id="GetOrderLiteByColumnIndex"
- parameterClass="Int"
- resultMap="lite-order-result-by-index" >
- select
- Order_Id,
- Order_Date,
- Order_CardExpiry,
- Order_CardType,
- Order_CardNumber,
- Order_Street,
- Order_City,
- Order_Province,
- Order_PostalCode
- from Orders where Order_Id = #value#
- </statement>
-
- <statement id="GetOrderWithTypes"
- parameterClass="Int"
- resultMap="order-with-types-result" >
- select * from Orders where Order_Id = #value#
- </statement>
-
- <statement id="GetOrderWithLineItems"
- parameterClass="Integer"
- ListClass="TList"
- resultMap="order-with-lines-result" >
- select * from Orders where Order_Id = #value#
- </statement>
-
-
- <statement id="GetOrderWithLineItemsNoLazyLoad"
- parameterClass="Integer"
- resultMap="order-with-lines-result-no-lazy-load" >
- select * from Orders where Order_Id = #value#
- </statement>
-
- <statement id="GetOrderWithLineItemsUsingStatementNamespaces"
- parameterClass="Integer"
- resultMap="order-with-lines-result-statement-namespaces" >
- select * from Orders where Order_Id = #value#
- </statement>
-
- <statement id="GetAllOrderWithLineItems"
- resultMap="order-with-lines-result" >
- select * from Orders
- </statement>
-
- <statement id="GetOrderCardExpiryViaResultClass"
- parameterClass="int"
- resultClass="date">
- select
- Order_Date as 'datetime'
- from Orders where Order_Id = #value#
- </statement>
-
- <statement id="GetOrderWithAccount"
- parameterClass="int"
- resultMap="order-with-account-result" >
- select * from Orders where Order_Id = #value#
- </statement>
-
- <statement id="GetOrderWithLineItemsCollection"
- parameterClass="Integer"
- resultMap="order-with-collection-result" >
- select * from Orders where Order_Id = #value#
- </statement>
-
- <statement id="GetOrderJoinedFavourite"
- parameterClass="Integer"
- resultMap="order-joined-favourite" >
- select
- Orders.Order_Id as Order_Id,
- Orders.Account_Id as Account_Id,
- Orders.Order_Date as Order_Date,
- Orders.Order_CardType as Order_CardType,
- Orders.Order_CardNumber as Order_CardNumber,
- Orders.Order_CardExpiry as Order_CardExpiry,
- Orders.Order_Street as Order_Street,
- Orders.Order_City as Order_City,
- Orders.Order_Province as Order_Province,
- Orders.Order_PostalCode as Order_PostalCode,
- Orders.Order_FavouriteLineItem as Order_FavouriteLineItem,
- LineItems.LineItem_Id as LineItem_Id,
- LineItems.Order_Id as Order_Id,
- LineItems.LineItem_Code as LineItem_Code,
- LineItems.LineItem_Quantity as LineItem_Quantity,
- LineItems.LineItem_Price as LineItem_Price,
- LineItems.LineItem_Picture as LineItem_Picture
-
- from Orders, LineItems
- where Orders.Order_Id = LineItems.Order_Id
- and Order_FavouriteLineItem = LineItems.LineItem_ID
- and Orders.Order_Id = #value#
- </statement>
-
- <statement id="GetOrderJoinedFavourite2"
- parameterClass="Integer"
- resultMap="order-joined-favourite2" >
- select
-
- Orders.Order_Id as Order_Id,
- Orders.Account_Id as Account_Id,
- Orders.Order_Date as Order_Date,
- Orders.Order_CardType as Order_CardType,
- Orders.Order_CardNumber as Order_CardNumber,
- Orders.Order_CardExpiry as Order_CardExpiry,
- Orders.Order_Street as Order_Street,
- Orders.Order_City as Order_City,
- Orders.Order_Province as Order_Province,
- Orders.Order_PostalCode as Order_PostalCode,
- Orders.Order_FavouriteLineItem as Order_FavouriteLineItem,
- LineItems.LineItem_Id as LineItem_Id,
- LineItems.Order_Id as Order_Id,
- LineItems.LineItem_Code as LineItem_Code,
- LineItems.LineItem_Quantity as LineItem_Quantity,
- LineItems.LineItem_Price as LineItem_Price,
- LineItems.LineItem_Picture as LineItem_Picture
-
- from Orders, LineItems
- where Orders.Order_Id = LineItems.Order_Id
- and Order_FavouriteLineItem = LineItems.LineItem_ID
- and Orders.Order_Id = #value#
- </statement>
-
- <statement id="GetOrderJoinedFavourite3"
- parameterClass="Integer"
- resultClass="Order" >
- select
- Orders.Order_Id as Id,
- Order_Date as Date,
- Order_CardExpiry as CardExpiry,
- Order_CardType as CardType,
- Order_CardNumber as CardNumber,
- Order_Street as Street,
- Order_City as City,
- Order_Province as Province,
- Order_PostalCode as PostalCode,
- LineItem_ID as "FavouriteLineItem.Id",
- LineItem_Code as "FavouriteLineItem.Code",
- LineItem_Quantity as "FavouriteLineItem.Quantity",
- LineItem_Price as "FavouriteLineItem.Price"
- from Orders, LineItems
- where Orders.Order_Id = LineItems.Order_Id
- and Order_FavouriteLineItem = LineItems.LineItem_ID
- and Orders.Order_Id = #value#
- </statement>
-
- <statement id="GetOrderWithFavouriteLineItem"
- parameterClass="int"
- resultMap="order-with-favourite-line-item" >
- select * from Orders where Order_Id = #value#
- </statement>
-
- <statement id="GetOrderWithLineItemCollection"
- parameterClass="int"
- resultMap="order-with-lines-collection" >
- select * from Orders where Order_Id = #value#
- </statement>
-
- <statement id="GetOrderWithLineItemCollectionNoLazy"
- parameterClass="int"
- resultMap="order-with-lines-collection-no-lazy-load" >
- select * from Orders where Order_Id = #value#
- </statement>
-
- <statement id="GetOrderAsHastable"
- parameterClass="Integer"
- resultMap="lite-order-map-result" >
- select * from Orders where Order_Id = #value#
- </statement>
-
- <statement id="GetOrderWithLineItemArray"
- parameterClass="int"
- resultMap="order-with-lines-array">
- select * from Orders where Order_Id = #value#
- </statement>
-
- <statement id="GetAllCreditCardNumbersFromOrders"
- resultMap="credit-card-result" >
- select distinct Order_CardNumber from Orders
- order by Order_CardNumber
- </statement>
-
- <statement id="InsertOrderViaParameterMap"
- parameterMap="order-insert-params-full" >
- insert into Orders
- (Order_Id, Account_ID, Order_Date, Order_CardExpiry, Order_CardType,
- Order_CardNumber, Order_Street, Order_City, Order_Province, Order_PostalCode )
- values
- (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
- </statement>
-
- <statement id="InsertOrderViaExtendParameterMap"
- parameterMap="insert-extend" >
- insert into Orders
- (Order_Id, Account_ID, Order_Date, Order_CardExpiry, Order_CardType,
- Order_CardNumber, Order_Street, Order_City, Order_Province, Order_PostalCode )
- values
- (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
- </statement>
-
- <statement id="InsertOrderViaPublicFields">
- insert into Orders
- (Order_Id, Account_ID, Order_Date, Order_CardExpiry, Order_CardType,
- Order_CardNumber, Order_Street, Order_City, Order_Province, Order_PostalCode )
- values
- (#Id#, #Account.Id#, #Date#, #CardExpiry#, #CardType#, #CardNumber#, #Street#, #City#, #Province#, #PostalCode#)
- </statement>
-
- <select id="GetOrderWithDynFavouriteLineItem"
- parameterClass="Integer"
- resultMap="order-with-dyn-favourite-line-item">
- select * from Orders where Order_Id = #value#
- </select>
-
- <select id="SelectOrderByDate"
- parameterClass="array"
- resultMap="lite-order-result-by-name">
- select * from Orders where Order_Date = #Foo#
- </select>
-
- <select id="SelectOrderByDateDynamic"
- parameterClass="array"
- resultMap="lite-order-result-by-name">
- select * from Orders
- where 1=1
- <isNotEmpty prepend="AND" property="Foo">
- (Order_Date = '$Foo$')
- </isNotEmpty>
- </select>
-
- <select id="GetAccountJIRA45"
- parameterClass="int"
- resultMap="indexed-account-result">
- select
- Account_Id,
- Account_FirstName,
- Account_LastName,
- Account_Email
- from Accounts
- where Account_ID = #value#
- </select>
-
- <select id="GetOrderJoinWithAccount"
- parameterClass="Integer"
- resultMap="order-joined-with-account">
- select
- Order_Id,
- Order_Date,
- Order_CardExpiry,
- Order_CardType,
- Order_CardNumber,
- Order_Street,
- Order_City,
- Order_Province,
- Order_PostalCode,
- acc.Account_ID as Account_ID,
- acc.Account_FirstName as Account_FirstName,
- acc.Account_LastName as Account_LastName,
- acc.Account_Email as Account_Email
- from Orders as ord
- LEFT OUTER JOIN Accounts as acc on acc.Account_ID = ord.Account_ID
- where Order_Id = #value#
- </select>
-
- <parameterMap id="order-insert-params-full">
- <parameter property="Id" dbType="Int32"/>
- <parameter property="Account.Id"/>
- <parameter property="Date" nullValue="0001-01-01 00:00:00" />
- <parameter property="CardExpiry" />
- <parameter property="CardType" />
- <parameter property="CardNumber" />
- <parameter property="Street" />
- <parameter property="City" />
- <parameter property="Province" />
- <parameter property="PostalCode" />
- </parameterMap>
-
- <parameterMap id="params-parent"> <!-- 1043181 support request -->
- <parameter property="Id" dbType="Int32"/>
- <parameter property="Account.Id"/>
- <parameter property="Date" nullValue="0001-01-01 00:00:00" />
- <parameter property="CardExpiry" />
- <parameter property="CardType" />
- <parameter property="CardNumber" />
- <parameter property="Street" />
- <parameter property="City" />
- <parameter property="Province" />
- <parameter property="PostalCode" />
- </parameterMap>
-
- <parameterMap id="insert-extend" extends="params-parent">
- </parameterMap>
-
-</sqlMap>
\ No newline at end of file diff --git a/tests/unit/SQLMap/maps/sqlite/Other.xml b/tests/unit/SQLMap/maps/sqlite/Other.xml deleted file mode 100644 index ca9b7a33..00000000 --- a/tests/unit/SQLMap/maps/sqlite/Other.xml +++ /dev/null @@ -1,170 +0,0 @@ -<?xml version="1.0" encoding="utf-8"?>
-<sqlMap namespace="Other" >
-
- <resultMap id="other-result" class="Other" >
- <result property="Int" column="Other_Int"/>
- <result property="Long" column="Other_Long"/>
- <result property="Bool" column="Other_Bit"/>
- <result property="Bool2" column="Other_String" typeHandler="OuiNonBool"/>
- </resultMap>
-
- <resultMap id="other-result-V1" class="Other" >
- <result property="Int" column="Other_Int"/>
- <result property="Long" column="Other_Long"/>
- <result property="Bool" column="Other_Bit"/>
- <result property="Bool2" column="Other_String" />
- </resultMap>
-
- <resultMap id="A-result" class="A" >
- <result property="Id" column="A_ID"/>
- <result property="Libelle" column="A_Libelle"/>
- <result property="B" resultMapping="B-result"/>
- <result property="E" resultMapping="E-result"/>
- <result property="F" resultMapping="F-result"/>
- </resultMap>
-
- <resultMap id="B-result" class="B" >
- <result property="Id" column="B_ID"/>
- <result property="Libelle" column="B_Libelle"/>
- <result property="C" resultMapping="C-result"/>
- <result property="D" resultMapping="D-result"/>
- </resultMap>
-
- <resultMap id="C-result" class="C" >
- <result property="Id" column="C_ID"/>
- <result property="Libelle" column="C_Libelle"/>
- </resultMap>
-
- <resultMap id="D-result" class="D" >
- <result property="Id" column="D_ID"/>
- <result property="Libelle" column="D_Libelle"/>
- </resultMap>
-
- <resultMap id="E-result" class="E" >
- <result property="Id" column="E_ID"/>
- <result property="Libelle" column="E_Libelle"/>
- </resultMap>
-
- <resultMap id="F-result" class="F" >
- <result property="Id" column="F_ID"/>
- <result property="Libelle" column="F_Libelle"/>
- </resultMap>
-
- <select id="SelectComplexJoined" resultMap="A-result">
- SELECT
- A.Id AS A_ID,
- A.A_Libelle AS A_Libelle,
- B.ID AS B_ID,
- B.B_Libelle AS B_Libelle,
- C.ID AS C_ID,
- C.C_Libelle AS C_Libelle,
- D.ID AS D_ID,
- D.D_Libelle AS D_Libelle,
- E.ID AS E_ID,
- E.E_Libelle AS E_Libelle,
- F.ID AS F_ID,
- F.F_Libelle AS F_Libelle
- FROM A
- LEFT OUTER JOIN B ON A.B_ID = B.ID
- LEFT OUTER JOIN C ON B.C_ID = C.ID
- LEFT OUTER JOIN D ON B.D_ID = D.ID
- LEFT OUTER JOIN E ON A.E_ID = E.ID
- LEFT OUTER JOIN F ON A.F_ID = F.ID
- </select>
-
-
- <statement id="DynamicSelectByIntLong"
- parameterClass="Hashtable"
- resultMap="other-result">
- select
- Other_Int,
- Other_Long,
- Other_Bit,
- Other_String
- from Others
- <dynamic prepend="WHERE">
- <isNotEqual prepend="AND" property="year" compareValue="0">
- Other_Int = #year#
- </isNotEqual>
-
- <isNotEqual prepend="AND" property="areaid" compareValue="0">
- Other_Long = #areaid#
- </isNotEqual>
- </dynamic>
- </statement>
-
- <statement id="DynamicSelectByBool"
- parameterClass="Other"
- resultMap="other-result">
- select
- Other_Int,
- Other_Long,
- Other_Bit,
- Other_String
- from Others
- Where Other_Bit = #Bool#
- </statement>
-
- <statement id="InsertBool"
- parameterClass="Other">
- Insert into Others
- ( Other_Int, Other_Long, Other_Bit, Other_String )
- values
- ( #Int#, #Long#, #Bool#, 'Yes')
- </statement>
-
- <statement id="InsertCustomTypeHandler"
- parameterMap="other-insert-params">
- Insert into Others
- ( Other_Int, Other_Long, Other_Bit, Other_String )
- values
- ( ?, ?, ?, ?)
- </statement>
-
- <statement id="SelectByInt"
- parameterClass="int"
- resultMap="other-result">
- select
- Other_Int,
- Other_Long,
- Other_Bit,
- Other_String
- from Others
- Where Other_Int = #value#
- </statement>
-
- <statement id="SelectByIntV1"
- parameterClass="int"
- resultMap="other-result-V1">
- select
- Other_Int,
- Other_Long,
- Other_Bit,
- Other_String
- from Others
- Where Other_Int = #value#
- </statement>
-
- <statement id="InsertInlineCustomTypeHandlerV1"
- parameterClass="Other">
- Insert into Others
- ( Other_Int, Other_Long, Other_Bit, Other_String )
- values
- ( #Int#, #Long#, #Bool#, #Bool2,type=bool,dbType=Varchar#)
- </statement>
-
- <statement id="InsertInlineCustomTypeHandlerV2"
- parameterClass="Other">
- Insert into Others
- ( Other_Int, Other_Long, Other_Bit, Other_String )
- values
- ( #Int#, #Long#, #Bool#, #Bool2,typeHandler=OuiNonBool#)
- </statement>
-
- <parameterMap id="other-insert-params">
- <parameter property="Int" />
- <parameter property="Long" />
- <parameter property="Bool" />
- <parameter property="Bool2" typeHandler="OuiNonBool"/>
- </parameterMap>
-</sqlMap>
diff --git a/tests/unit/SQLMap/maps/sqlite/ResultClass.xml b/tests/unit/SQLMap/maps/sqlite/ResultClass.xml deleted file mode 100644 index 37985ba7..00000000 --- a/tests/unit/SQLMap/maps/sqlite/ResultClass.xml +++ /dev/null @@ -1,130 +0,0 @@ -<?xml version="1.0" encoding="UTF-8" ?>
-
-<sqlMap namespace="ResultClass" >
-
- <statement id="GetBoolean"
- parameterClass="Int"
- resultClass="bool" >
- select 1 from Orders where Order_ID = #dummy#
- </statement>
- <statement id="GetBooleanWithoutResultClass"
- parameterClass="Int"
- extends="GetBoolean">
- </statement>
-
- <statement id="GetByte"
- parameterClass="Int"
- resultClass="string" >
- select 155 from Orders where Order_ID = #value#
- </statement>
- <statement id="GetByteWithoutResultClass"
- parameterClass="Int"
- extends="GetByte">
- </statement>
-
- <!--
- NOTE: Use MySql 4.0.2 or higher for "cast"
- -->
- <statement id="GetChar"
- parameterClass="Int"
- resultClass="string" >
- select 'a' from Orders where Order_ID = #value#
- </statement>
- <statement id="GetCharWithoutResultClass"
- parameterClass="Int"
- extends="GetChar">
- </statement>
-
- <statement id="GetDate"
- parameterClass="Int"
- resultClass="TDateTime" >
- select '2003-02-15 8:15:00' as datetime from Orders where Order_ID = #value#
- </statement>
- <statement id="GetDateWithoutResultClass"
- parameterClass="Int"
- extends="GetDate">
- </statement>
-
- <statement id="GetDecimal"
- parameterClass="Int"
- resultClass="float" >
- select 1.56 from Orders where Order_ID = #value#
- </statement>
- <statement id="GetDecimalWithoutResultClass"
- parameterClass="Int"
- extends="GetDecimal">
- </statement>
-
- <statement id="GetDouble"
- parameterClass="Int"
- resultClass="float" >
- select 99.5 from Orders where Order_ID= #value#
- </statement>
- <statement id="GetDoubleWithoutResultClass"
- parameterClass="Int"
- extends="GetDouble">
- </statement>
-
- <!--
- Use binary for cast for MySql
- -->
- <statement id="GetGuid"
- parameterClass="Int"
- resultClass="guid" >
- select cast('CD5ABF17-4BBC-4C86-92F1-257735414CF4' as binary) from Orders where Order_ID = #value#
- </statement>
- <statement id="GetGuidWithoutResultClass" parameterClass="Int" extends="GetGuid">
- </statement>
-
- <statement id="GetInt16"
- parameterClass="Int"
- resultClass="int" >
- select 32111 from Orders where Order_ID = #value#
- </statement>
- <statement id="GetInt16WithoutResultClass"
- parameterClass="Int"
- extends="GetInt16">
- </statement>
-
- <statement id="GetInt32"
- parameterClass="Int"
- resultClass="int" >
- select 999999 from Orders where Order_ID = #value#
- </statement>
- <statement id="GetInt32WithoutResultClass"
- parameterClass="Int"
- extends="GetInt32">
- </statement>
-
- <statement id="GetInt64"
- parameterClass="Int"
- resultClass="double" >
- select 9223372036854775800 from Orders where Order_ID = #value#
- </statement>
- <statement id="GetInt64WithoutResultClass"
- parameterClass="Int"
- extends="GetInt64">
- </statement>
-
- <statement id="GetSingle"
- parameterClass="Int"
- resultClass="float" >
- select 92233.5 from Orders where Order_ID = #value#
- </statement>
- <statement id="GetSingleWithoutResultClass"
- parameterClass="Int"
- extends="GetSingle">
- </statement>
-
- <statement id="GetString"
- parameterClass="Int"
- resultClass="string" >
- select 'VISA'
- from Orders where Order_ID = #value#
- </statement>
- <statement id="GetStringWithoutResultClass"
- parameterClass="Int"
- extends="GetString">
- </statement>
-
-</sqlMap>
\ No newline at end of file |