cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Emerson CastaƱeda <eme...@gmail.com>
Subject Re: Howto Include Time/Date Functions in Query Expressions
Date Thu, 15 Mar 2012 15:29:19 GMT
Hi Mike

My context: I am handling a table with 50 millions of rows and its size is
increasing up  every day some thousands. So, my question goes around
performance of the view's solution that you propose.

Do you think view performance  will be better than using SQLTemplate
queries?

Thanks

EMERSON

On Thu, Mar 15, 2012 at 3:07 PM, Mike Kienenberger <mkienenb@gmail.com>wrote:

> Depending on your database and usage, another option is to set up a
> view and let the database create derived columns for these, then you
> can treat them as regular Cayenne data object fields.
>
> 2012/3/14 Emerson CastaƱeda <emecas@gmail.com>:
> > HI everyone
> >
> > I have a table with a timestamp field, so  I'm thinking about how to
> write
> > the next query without define a store procedure, but directly from my
> java
> > code:
> >
> > select *
> > from  table1
> > where
> > id = 1 and
> > extract(day from timestampField)='04' and
> > extract(month from timestampField)='04' and
> > extract(year from timestampField)='2009'
> >
> > I'd like to know if that is possible using cayenne, maybe some thing like
> > this?
> >
> >
> > SelectQuery query = new SelectQuery(Table1.class);
> > query.andQualifier(<??EXPRESSION???>)
> >
> > OR
> >
> > SelectQuery query = new SelectQuery(Table1.class);
> > query.andQualifier( ExpressionFactory.likeIgnoreCaseExp(
> >                        Table1.timestampproperty, "%"));
> >
> >
> > Thank you for your time
> >
> > EMERSON
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message