[IBATISNET-267] Support inline paramaters and dynamic element in procedure tag

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: DataMapper 3.0
• Fix Version/s: DataMapper 3.0
• Component/s: DataMapper
• Assignee: Gilles Bayon
• Reporter: Gilles Bayon
• Due: 31/May/08
• Created: 31/May/08 13:39
• Updated: 31/May/08 13:54
• Resolved: 31/May/08 13:54

Description

Samples
========

<procedure id="SPWithInlineParameter" parameterClass="int" resultClass="Account">
ps_SelectAccount @

{Account_ID,column=Account_ID}
</procedure>

<procedure id="SPWithInlineParameterAndOutPutParam" parameterClass="map" resultClass="Account">
ps_SelectAccountWithOutPutParam @{Account_ID,column=Account_ID}

, @

{OutPut,column=OutPut}

</procedure>

<procedure id="InsertAccountViaSPAndInlineParameter" parameterClass="map" >
ps_InsertAccount
@

{Id,column=Account_ID},
@{FirstName,column=Account_FirstName},
@{LastName,column=Account_LastName},
@{EmailAddress,column=Account_Email,nullValue=[e-mail]},
@{BannerOption,column=Account_Banner_Option,dbType=Varchar,type=bool},
@{CartOption,column=Account_Cart_Option,handler=HundredsBool}
</procedure>

<procedure id="InsertAccountViaSPWithDefaultParameter" parameterClass="map" >
ps_InsertAccountWithDefault
@{Id,column=Account_ID}

,
@

{FirstName,column=Account_FirstName},
@{LastName,column=Account_LastName},
@{EmailAddress,column=Account_Email,nullValue=[e-mail]}
</procedure>

<procedure id="InsertAccountViaSPWithDynamicParameter" parameterClass="map" >
ps_InsertAccountWithDefault
@{Id,column=Account_ID}
,@{FirstName,column=Account_FirstName}

,@

{LastName,column=Account_LastName}

,@

{EmailAddress,column=Account_Email,nullValue=[e-mail]}

<isNotNull property="NullBannerOption">
,@

{NullBannerOption,column=Account_Banner_Option,dbType=Varchar,type=bool}

</isNotNull>
@

{CartOption,column=Account_Cart_Option,handler=HundredsBool}

</procedure>

Can be use in conjunction with procedure default parameter
REATE PROCEDURE dbo.[ps_InsertAccountWithDefault]
@Account_ID [int],
@Account_FirstName [nvarchar](40),
@Account_LastName [varchar](32),
@Account_Email [varchar](128),
@Account_Banner_Option [varchar](255)='Non',
@Account_Cart_Option [int] =200
AS
...