This post originated from an RSS feed registered with Java Buzz by Brian McCallister. Original Post: Thinking About Queries Feed Title: Waste of Time Feed URL: http://kasparov.skife.org/blog/index.rss Feed Description: A simple waste of time and weblog experiment Latest Java Buzz Posts Latest Java Buzz Posts by Brian McCallister Latest Posts From Waste of Time

I got into a very fun discussion with James Strachan about Groovy Data Objects -- which are modeled more after ADO than JDO. GDO looks like

collection.select {
   where { b > 100 && b < 5000 }
   orderBy {
     ascending { [ b, c] }
     desceding { x }
  }

Or, for projections

collection.select {
   property b {
     get { bar.order.amount}
     set { bar.order.amount = it }
   }
   where { b > 100 && b < 5000 }
   orderBy {
     ascending { [ b, c] }
     desceding { x }
  }

The idea of a query as an closure is appealing. I may have to try to do a GDO style query-as-closure for OJB during the hackathon. Groovy provides access to the AST of GroovyObjects, so traversing that building a query-by-criteria shouldn't be terrible. Off to code I go.