From: Courtney Fay <cfay@...>
Date: 2012-01-27T00:13:18+09:00
Subject: Re: Ruby Database Query with Grouping

Thanks for your response!  You code is actually throwing an error in the 
console:

NoMethodError: undefined method `inject' for -1:Fixnum
  (root) at <script>:26
    call at org/jruby/RubyProc.java:268
    call at org/jruby/RubyProc.java:228
    each at /builtin/java/java.util.rb:7
  (root) at <script>:18

It goes on, but that is the gist.  I would be interested in trying your 
method.  I totally acknowledge that I am self taught and just made these 
arrays because I don't know how else to accomplish this.

They are basically attributes of the same items.  We process a hard 
drive of data and the metadata and text go into the index/database.

I am just querying that with ruby to get a report of what processed on 
what date and group the totals by the date information.

I found that my ruby didn't give the exact output I mentioned last 
night.  IT was more like this:
1/1/121/9/12 - 1500 - 60934823 - 540 - 469048
1/1/121/9/12 - 1500 - 60934823 - 540 - 469048

Its putting the two dates running into each other, and summing the whole 
total and then repeating the output.  btw it took like 6 hours to get 
those 2 lines to run on an index with 2.5 million records.

Would hope to make this more efficient as I build it.  Those are just a 
couple of the numbers I need.  In the end I need to get like 20 
different aggregates into the report.  I just know that if I can get the 
best method down, I can replicate it.

Thanks for taking the time to help me!

-- 
Posted via http://www.ruby-forum.com/.