ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: How to not verbosely declare resultmaps?
Date Tue, 20 Dec 2005 16:12:06 GMT
We can't use #, because it is the parameter syntax, and no, we won't parse
the SQL to figure out what is a result and what is a parameter.  :-)


Cheers,
Clinton

On 12/20/05, Jozef Hribik <jozef.hribik@apsoft.sk> wrote:
>
> Hi Clinton,
>
> +1 abd I would like to have one more option ;-)
> #COLUMN:KEY:TYPE#
>
> <select id="elions.uw.selectInfoProductInsured" resultClass="map">
> SELECT #p.T01_NAME:name:String#, #p.T01_AGE:age:Integer#
>   FROM T01_PERSON p
> </select>
>
> Cheers
> Jozef
>
> Clinton Begin wrote:
>
> >
> > I would love to add inline result map support.  :-)
> >
> > Unfortunately you and I are the minority.  But that doesn't mean we
> > cannot do it.  So, my question to you is:  how would you like to see
> > the syntax?
> >
> > Here are some options:
> >
> > $NAME:VARCHAR$
> > !NAME:VARCHAR!
> > @NAME:VARCHAR@
> > "NAME:VARCHAR"
> > |NAME:VARCHAR|   << I like the pipes, but does anyone know of any
> > potential issues with using it?
> >
> > In hindsight, I wish I had used @@ for inline parameters and ## for
> > inline result maps (because it looks like a little row set!).
> >
> > Cheers,
> > Clinton
> >
> >
> >
> > On 12/19/05, *Yusuf* <Yusuf@ekalife.co.id
> > <mailto:Yusuf@ekalife.co.id>> wrote:
> >
> >     Dear All,
> >     I've been using ibatis for about 1 year now, and i'm very
> >     satisfied with
> >     it!
> >     I wanted to ask if i can do this:
> >
> >     <select id="elions.uw.selectInfoProductInsured" resultClass="map">
> >     SELECT name, age, address, income
> >       FROM person
> >     </select>
> >
> >     but I wanted the default datatype for NAME is String, AGE is
> >     Integer, and INCOME is Double, not the default BigDecimal..
> >     without specifying resultMaps or resultClasses (because i have so
> >     many
> >     queries like this and it would be very verbose to declare them one
> by
> >     one)
> >
> >     I know we can declare something like this in insert statements like
> >
> >     <insert id="..">
> >     INSERT INTO person (name, age) VALUES (#name:VARCHAR:-#,
> >     #age:NUMBER:0#)
> >     </insert>
> >
> >     but can it be done in select statements to in ibatis? for example
> like
> >     this maybe:
> >
> >     <select id="elions.uw.selectInfoProductInsured" resultClass="map">
> >     SELECT name:String, age:Integer, address:String, income:Double
> >       FROM person
> >     </select>
> >
> >     Thank you...
> >
> >
>
>

Mime
View raw message