You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ibatis.apache.org by "Gilles Bayon (JIRA)" <ib...@incubator.apache.org> on 2008/05/31 15:41:45 UTC
[jira] Created: (IBATISNET-267) Support inline paramaters and
dynamic element in procedure tag
Support inline paramaters and dynamic element in procedure tag
--------------------------------------------------------------
Key: IBATISNET-267
URL: https://issues.apache.org/jira/browse/IBATISNET-267
Project: iBatis for .NET
Issue Type: Improvement
Components: DataMapper
Affects Versions: DataMapper 3.0
Reporter: Gilles Bayon
Assignee: Gilles Bayon
Fix For: DataMapper 3.0
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=no_email@provided.com},
@{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=no_email@provided.com}
</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=no_email@provided.com}
<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
...
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (IBATISNET-267) Support inline paramaters and
dynamic element in procedure tag
Posted by "Gilles Bayon (JIRA)" <ib...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/IBATISNET-267?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gilles Bayon closed IBATISNET-267.
----------------------------------
Resolution: Fixed
in SVN
> Support inline paramaters and dynamic element in procedure tag
> --------------------------------------------------------------
>
> Key: IBATISNET-267
> URL: https://issues.apache.org/jira/browse/IBATISNET-267
> Project: iBatis for .NET
> Issue Type: Improvement
> Components: DataMapper
> Affects Versions: DataMapper 3.0
> Reporter: Gilles Bayon
> Assignee: Gilles Bayon
> Fix For: DataMapper 3.0
>
>
> 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=no_email@provided.com},
> @{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=no_email@provided.com}
> </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=no_email@provided.com}
> <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
> ...
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (IBATISNET-267) Support inline paramaters and
dynamic element in procedure tag
Posted by "Gilles Bayon (JIRA)" <ib...@incubator.apache.org>.
[ https://issues.apache.org/jira/browse/IBATISNET-267?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12601386#action_12601386 ]
Gilles Bayon commented on IBATISNET-267:
----------------------------------------
This only work if you uses new inline parameter syntax with new attribute column
@{propertyName,column=string,type=string,dbype=string,direction=[Input/Output/InputOutput],nullValue=string,handler=string}
> Support inline paramaters and dynamic element in procedure tag
> --------------------------------------------------------------
>
> Key: IBATISNET-267
> URL: https://issues.apache.org/jira/browse/IBATISNET-267
> Project: iBatis for .NET
> Issue Type: Improvement
> Components: DataMapper
> Affects Versions: DataMapper 3.0
> Reporter: Gilles Bayon
> Assignee: Gilles Bayon
> Fix For: DataMapper 3.0
>
>
> 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=no_email@provided.com},
> @{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=no_email@provided.com}
> </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=no_email@provided.com}
> <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
> ...
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.