• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Creating Database Reports with EOF
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Creating Database Reports with EOF


  • Subject: Re: Creating Database Reports with EOF
  • From: Timmy <email@hidden>
  • Date: Fri, 14 Mar 2008 15:32:20 -0700

On Mar 14, 2008, at 12:35 PM, Petite Abeille wrote:

On Mar 14, 2008, at 8:15 PM, Sennikov, Dimitri wrote:

How would I be able to do that in WO with EOF? Is there an easier way
than to get qualifiers for each month and create new FetchSpecifications
for each of the months? Wouldn't this method create too much overhead
(ie 12 queries just for one report).

Short answer: don't bother with EOF for reporting and let the database do the heavy lifting. You can always make the resulting data set available to EOF through your favorite database level representation such as views, store procedures, pipelined functions or such.


EOF is meant to shield you away from SQL, in the same way as WOF shield you from HTTP.

But for any non-trivial DMLs, you most likely want to use SQL directly.

Good advice. However, the only thing I would add to this is that EOF's role is to manage an object graph and relationships - and it does so by hiding the sql. The SQL you're trying to run appears to be pretty abstracted from that focus. If your data model included a relationship between "months" and "projects" then it would be quite simple to create a report like this. Or, even if there were just a "month" entity, each month could use raw rows to get the count of projects that fall between its own begin and end dates.


You probably already understand this and I'm just talking. :-)

T
-----
Timothy Worman
Programmer/Analyst
Graduate School of Education and Information Studies
University of California Los Angeles

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden


References: 
 >New Tool: Click to Open (From: Chuck Hill <email@hidden>)
 >Creating Database Reports with EOF (From: "Sennikov, Dimitri" <email@hidden>)
 >Re: Creating Database Reports with EOF (From: Petite Abeille <email@hidden>)

  • Prev by Date: Re: WO vs. Ruby on Rails
  • Next by Date: Re: WWDC 08
  • Previous by thread: Re: Creating Database Reports with EOF
  • Next by thread: Tutorial
  • Index(es):
    • Date
    • Thread