I think this is a good idea too. I'll work on getting it integrated.
Jeff Butler
On 10/23/06, Landry Soules <[EMAIL PROTECTED]> wrote:
+1
I think this solution would solve many annoyances with column names.
[EMAIL PROTECTED] a écrit :
> I could use this feature, too. However, not *every* column is like
> this in our case.
>
> Our convention is tables have 4-letter abbreviations and are prefixed
> with a "T". For instances, our customer table is named TCUST_CUSTOMER.
> The fields within it are prefixed with CUST, so the name is CUST_NAME.
> Unfortunately, sometimes there are columns that don't have the prefix.
>
> So, how about offering a regex-replace feature or something similar as
> a per-table property? That way both prefix and suffix conventions and
> others could be handled with the same code:
>
> <property name="columnReplaceRegex" search="^CUST" replace=""/>
>
> -----Original Message-----
> *From:* Jeff Butler [mailto: [EMAIL PROTECTED]]
> *Sent:* Monday, October 23, 2006 2:33 PM
> *To:* [email protected]
> *Subject:* Re: column prefix with Abator
>
> Well I guess the distinction between wierd and common depends on
> the projects you've worked on :)
>
> What I really meant to convey is that there's no simple way to
> tell Abator to strip these prefixes off automatically. Maybe if
> we added something like this:
>
> <property name="stripColumnPrefixCharacters" value="3" />
>
> But there's got to be a better property name than that.
>
> Jeff Butler
>
>
>
>
>
> On 10/23/06, *Landry Soules* <[EMAIL PROTECTED]
> <mailto: [EMAIL PROTECTED]>> wrote:
>
> Thank you Jeff for your answer.
>
> So I will have to use the columnOverride tag :-(
> However i can't agree with you about the weird db design. This
> syntax is
> quite common in the enterprise world to avoid same field names
> between
> tables.
> Clinton Begin himself uses it extensively in his SQL Maps for
> Java,
> Developer Guide...
> <
> http://cvs.apache.org/dist/ibatis/ibatis.java/docs/iBATIS-SqlMaps-2_en.pdf >
>
>
>
> Jeff Butler a écrit :
> > You can do a <columnOverride> in the Abator configuration
> for each
> > column to name the Java property specifically. Not pretty,
> but that's
> > probably the best that can be done with this wierd db design.
> >
> > Jeff Butler
> >
> >
> >
> > On 10/23/06, *Landry Soules* <[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED] >
> > <mailto:[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>>> wrote:
> >
> > Hello,
> >
> > I'm a very new user of Ibatis, with abator eclipse plugin.
> > Here is my problem :
> > In my database, every column is prefixed with 2 letters
> from the
> > table
> > name :
> > for example table customer has the following columns :
> cs_first_name,
> > cs_last_name and so on.
> > When i run "generate ibatis artifacts", abator will
> generate a
> > Customer
> > bean, with csFirstName and csLastName properties, where
> i would have
> > expected firstName and lastName.
> > Did i miss a configuration parameter, or am i condamned
> to modify
> > all my
> > column names ?
> >
> > Thanks for your answer.
> >
> >
>
>
