Awesome! This is one of those things I always wanted to get implemented
but it was always getting pushed down my priority list. Thanks for
taking on that work.
I'll definitely take a look this week. If you could work it up for
trunk that would be better. New features should really not get added to
maintenance releases.
On Wed, 2009-09-02 at 17:17 -0400, Rob Hasselbaum wrote:
Hi,
I've submitted a patch with unit tests for HHH-272 and I'm interested
in feedback. The patch allows users to specify custom SQL get and set
expressions for property columns. This can be used to call SQL
functions or perform some other kind of database-side conversion
without giving up automatic statement generation. You use it like
this:
<property name="creditCardNumber">
<column name="credit_card_num" sql-set="encrypt(?)"
sql-get="decrypt(credit_card_num)"/>
</property>
This is similar to a formula property with two differences. First, the
data is backed by a real column, which gets exported with the schema.
And second. the data is read-write, not read-only. The sql-get
expression gets applied in predicates, order clauses, projections,
etc.
The patch should work for all property columns including those in
components and composite-elements. I didn't try to get id, key, index,
or other kinds of non-property columns to work. It is built on top of
the 3.3.2.GA tag, but I can port it to trunk if necessary. I also have
a patch nearly ready to expose this functionality in Hibernate
Annotations in case the Core patch is accepted. If any commiters could
have a look, I'd appreciate it.
Thanks for your time,
-Rob Hasselbaum
_______________________________________________
hibernate-dev mailing list
hibernate-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev --
Steve Ebersole <steve(a)hibernate.org>
Hibernate.org