RE: [ABATOR] Future Plans

2005-12-20 Thread Yusuf
Thank you Mr. Butler! I'm already using abator to speed up our development process, and actually for the time being, after I write custom queries I just create a small script to execute in our db that will generate the resultmaps, if it can be any help, here's the query i used in oracle: SQL> C

Re: How to not verbosely declare resultmaps?

2005-12-20 Thread Clinton Begin
Arrgh!  The pain of past decisions made Wouldn't this be nice: SELECT #NAME:VARCHAR# FROM SOME_TABLE WHERE ID = @ID:NUMERIC@ Or. SELECT #NAME:VARCHAR FROM SOME_TABLE WHERE ID = @ID:NUMERIC Blah.  If only...  :-) Maybe for version 3.0 we'll change it and write a converter.  :-) Chee

RE: How to not verbosely declare resultmaps?

2005-12-20 Thread Niels Beekman
$-s are for SQL injection weren’t they J !-s can be used as operators (SELECT * FROM bla WHERE foo != ‘bar’) “-s can be used to delimit strings, so this would require old uses of “ to be escaped (am I right?) |-s can be used as string concatenator   So the only viable option left is @

RE: How to not verbosely declare resultmaps?

2005-12-20 Thread Niels Beekman
I’m not here to defend the silly operator, but there are more systems that use it, PostgreSQL for example…   Niels   From: Clinton Begin [mailto:[EMAIL PROTECTED] Sent: dinsdag 20 december 2005 17:12 To: user-java@ibatis.apache.org Subject: Re: How to not verbosely declare resu

Re: How to not verbosely declare resultmaps?

2005-12-20 Thread j-lists
I for one regard inline parameter maps as something of a neccessary evil (for dynamic SQL) and would NOT like to see the same thing introduced for result maps. It is the absence of funny escape sequences and other complications in the iBatis SQL that makes it such a pleasure to work with. Unfortuna

Re: How to not verbosely declare resultmaps?

2005-12-20 Thread Clinton Begin
Ack!  Oracle and their silly concatination operator! Cheers, Clinton On 12/20/05, Clinton Begin <[EMAIL PROTECTED]> wrote: 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, ClintonOn 12/20/05,

Re: How to not verbosely declare resultmaps?

2005-12-20 Thread Clinton Begin
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, ClintonOn 12/20/05, Jozef Hribik <[EMAIL PROTECTED]> wrote: Hi Clinton,+1 abd I would like to have one more option ;-)#COLUMN:KEY:TYPE#SELECT #p.

AW: How to not verbosely declare resultmaps?

2005-12-20 Thread Andre Peterka
Hi Clinton, One issue with the pipes might be the concatenation operator, so you'd have to be careful when parsing. Select firstname||lastname as fullname from customer Cheers, Andre > -Ursprüngliche Nachricht- > Von: Jozef Hribik [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 20. D

Re: How to not verbosely declare resultmaps?

2005-12-20 Thread Jozef Hribik
Hi Clinton, +1 abd I would like to have one more option ;-) #COLUMN:KEY:TYPE# SELECT #p.T01_NAME:name:String#, #p.T01_AGE:age:Integer# FROM T01_PERSON p Cheers Jozef Clinton Begin wrote: I would love to add inline result map support. :-) Unfortunately you and I are the minority. But t

Re: How to not verbosely declare resultmaps?

2005-12-20 Thread Clinton Begin
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:VARCH

Re: [ABATOR] Future Plans

2005-12-20 Thread Jeff Butler
Thanks for your suggestion!  Abator does not support this now.   However, I have been thinking about this feature too.  I'd like to add some way to declare table relationships and have Abator generate the appropriate queries and objects.  It would be a little different from what you've specified...