Re: Type safe queries & more

[Aristedes Maniatis <ar...@maniatis.org>]

I just stumbled on another Java ORM which copies many ideas from Ruby Rails.

   http://code.google.com/p/activejdbc/

Some of the API concepts there are nice and similar to what is described below. It is Apache licensed, so there are no problems with us borrowing any class definitions if we find them useful. However they don't appear to have attempted any type safety at all.

Ari


On 16/09/11 7:35 PM, Aristedes Maniatis wrote:
> On 16/09/11 6:57 PM, Durchholz, Joachim wrote:
>> User.fetch( dataContext,
>> new Query(
>> User.FIRSTNAME.like( "joe%" )
>> .and(User.AGE.between( 20, 30 )))
>> .sort( User.FIRSTNAME.asc().then( User.LASTNAME.asc() )
>> )
>
> Another approach is to use the keys only as function parameters.
>
> User.where(User.FIRSTNAME, Query.LIKE, "joe%").and(User.AGE, Query.BETWEEN, "20,30").sort(User.FIRSTNAME, Query.ASC).sort(User.LASTNAME, Query.ASC).limit(10)
>
> or with strings:
>
> User.where("firstname LIKE joe%").and("age BETWEEN 20,30").sort("firstname ASC").sort("lastname ASC").limit(10)
>
>
> You could also pre-define qualifiers like this:
>
> debtors = User.where("owing > 0)
>
> and then later on use it in this nice natural speech kind of way:
>
> debtors.where("firstname LIKE joe%")
>
> All we need for this is to make .and() and .where() equivalent functions.
>
>
> Please reply to the dev@ list only.
>
> Thanks
> Ari
>

-- 
-------------------------->
Aristedes Maniatis
GPG fingerprint CBFB 84B4 738D 4E87 5E5C  5EFA EF6A 7D2E 3E49 102A