From: "Abinoam Jr." Date: 2012-01-26T07:59:50+09:00 Subject: Re: Ruby Database Query with Grouping --f46d04428d2c5e2ff404b76238e3 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi Courtney, Tell me if this code runs. Abinoam Jr. On Wed, Jan 25, 2012 at 7:42 PM, Abinoam Jr. wrote: > Hi, > > One of the problem(s) is here... > > t_ImmaterialSizes2 =3D 0 > > t_ImmaterialSizes2, as you wrote, points to an Array (line 4). > > You should access its content by index like > t_ImmaterialSizes2[102] > > Another of note is at > > t_DateProcessed.each do |date| > > #PUT EACH SETS OF ITEMS THAT ARE NEEDED FOR THE REPORT TO THE CONSOLE > (EVENTUALLY WILL BE OUTPUT TO A FILE) > puts "#{t_DateProcessed} , #{t_ImmaterialSizes2}" > > end > > Look, "each t_DateProcessed item is passed 'through' the variable date". > So, inside the each block, 'date' is what you want. > > I'll try to refactor and send to you because I think the way you're > going is not pointing toward what you want. (just a minute). > > Abinoam Jr. > > On Wed, Jan 25, 2012 at 7:16 PM, Courtney Fay wrot= e: >> I am working in an application that has a Lucene and apache derby >> database. =A0As my ruby skills are quite new, I am not sure where ruby >> ends and the application begins. >> >> At this point, I am trying to run some counts for data that has been >> indexed in the system. =A0Attached is the beginning of a script. =A0I kn= ow >> it's wrong. =A0Let me preface with that. =A0What I am trying to get is >> different counts, and group them by a piece of captured metatdata called >> "DateProcessed". >> >> What I would end up with is something like >> >> Date Processed =A0- Count of Items - SizeBytes of Items - Immaterial Ite= ms >> - SizeBytes of Immaterial Items - etc >> >> 1/1/12 - 500 - 20934823 - 210 - 239048 >> 1/9/12 - 1000 - 40102983 - 330 - 435875 >> >> etc. >> >> What I get with the current attached script is this: >> 1/1/12 - 500 - 20934823 - 210 - 239048 >> 1/1/12 - 500 - 20934823 - 210 - 239048 >> 1/1/12 - 500 - 20934823 - 210 - 239048 >> 1/1/12 - 500 - 20934823 - 210 - 239048 >> 1/1/12 - 500 - 20934823 - 210 - 239048 >> 1/1/12 - 500 - 20934823 - 210 - 239048 >> 1/1/12 - 500 - 20934823 - 210 - 239048 >> 1/1/12 - 500 - 20934823 - 210 - 239048 >> 1/1/12 - 500 - 20934823 - 210 - 239048 >> 1/1/12 - 500 - 20934823 - 210 - 239048 >> 1/1/12 - 500 - 20934823 - 210 - 239048 >> 1/1/12 - 500 - 20934823 - 210 - 239048 >> >> >> etc. >> >> Can anyone help me? =A0I am hoping that as I learn to fish, my questions >> will get better and I will become more independent. >> >> Attachments: >> http://www.ruby-forum.com/attachment/6934/countsbydate.rb >> >> >> -- >> Posted via http://www.ruby-forum.com/. >> > --f46d04428d2c5e2ff404b76238e3 Content-Type: application/x-ruby; name="courtney.rb" Content-Disposition: attachment; filename="courtney.rb" Content-Transfer-Encoding: base64 X-Attachment-Id: f_gxuyhoug1 I1NUQVJUIFRJTUUgVE8gQ09OU09MRQpwdXRzICJTdGFydGVkIE91dHB1dCAje1RpbWUubm93fSIK CgojdF9JbW1hdGVyaWFsU2l6ZXMgPSBBcnJheS5uZXcKI3RfSW1tYXRlcmlhbFNpemVzMiA9IEFy cmF5Lm5ldwojdF9EYXRlUHJvY2Vzc2VkID0gQXJyYXkubmV3CgojIFRyeSB0byB1c2UgdGhlICdz bmFrZXMnCnRfaW1tYXRlcmlhbF9zaXplcyA9IEFycmF5Lm5ldwp0X2ltbWF0ZXJpYWxfc2l6ZXNf MiA9IEFycmF5Lm5ldyAjIEkgYmV0IHlvdSBjYW4gY29tZSB1cCB3aXRoIGEgYmV0dGVyICJkaXNh bWJpZ3VhdGluZyIgbmFtZS4KdF9kYXRlX3Byb2Nlc3NlZCA9IEFycmF5Lm5ldwoKI0VBQ0ggU0VB UkNIIEZPUiBUSEUgSVRFTVMgVEhBVCBBUkUgTkVFREVEIEZPUiBUSEUgUkVQT1JUClByZUV4Y2xU b3BMZXZlbCA9IGN1cnJlbnRDYXNlLnNlYXJjaCgiLWZsYWc6YXVkaXRlZCIpCgojSVRFUkFURSBU SFJPVUdIIEVBQ0ggU0VUIE9GIElURU1TIFRIQVQgQVJFIE5FRURFRCBGT1IgVEhFIFJFUE9SVApQ cmVFeGNsVG9wTGV2ZWwuZWFjaCBkbyB8aXRlbXwKCiNTVU0gRUFDSCBTRVRTIE9GIElURU1TIFRI QVQgQVJFIE5FRURFRCBGT1IgVEhFIFJFUE9SVAp0X2ltbWF0ZXJpYWxfc2l6ZXMgPDwgaXRlbS5n ZXREaWdlc3RzLmdldElucHV0U2l6ZQoKIyB0X0ltbWF0ZXJpYWxTaXplczIgPSAwCiMgdF9JbW1h dGVyaWFsU2l6ZXMuZWFjaHt8aXwgdF9JbW1hdGVyaWFsU2l6ZXMyKz1pfQoKc3VtID0gdF9pbW1h dGVyaWFsX3NpemVzLmxhc3QuaW5qZWN0KDApIHt8cHYsIG54fCBwdiArIG54fQp0X2ltbWF0ZXJp YWxfc2l6ZXMgPDwgc3VtCgojIHRoZSBhYm92ZSBjb3VsZCBzaW1wbHkgYmUKIyBzdW0gPSB0X2lt bWF0ZXJpYWxfc2l6ZXMucmVkdWNlKDorKQoKdF9kYXRlX3Byb2Nlc3NlZCA8PCBpdGVtLmdldEV2 aWRlbmNlTWV0YWRhdGFbJ0RhdGVQcm9jZXNzZWQnXQp0X2RhdGVfcHJvY2Vzc2VkLnVuaXEhCgpl bmQKCiMgTm93LCB0aGF0IHlvdSBoYXZlIDAzIHNlcGFyYXRlIGFycmF5cyAKIyB5b3UnbGwgaGF2 ZSB0byB0cmFuc3ZlcnNlIHRoZW0gc2VwYXJldGx5LiAKIyB0aGF0J3MgYSBkZXNpZ24gZmxhdy4g VGhlcmUncyBhIGJldHRlciB3YXkgdG8gZG8gaXQuCiMgTG9vaywgdGhlIGRhdGVfcHJvY2Vzc2Vk IGFuZCB0aGUgaW1tYXRlcmlhbF9zaXplXzIgbG9vayBsaWtlIAojIGF0dHJpYnV0ZXMvcHJvcGVy dGllcyBvZiB0aGUgc2FtZSBvYmplY3QuIFNvLCBJIHRoaW5rIHRoZXkgCiMgc2hvdWxkbid0IGJl IGluIHNlcGFyYXRlIGFycmF5cy4KIyBCdXQuLi4ganVzdCB0byBmb2xsb3cgeW91ciBjb2RlIGF0 IG1heGltdW0uLi4KCm1heF9peCA9IHRfZGF0ZV9wcm9jZXNzZWQuc2l6ZSAtIDEKCjAudXB0byht YXhfaXgpIGRvIHxpeHwKCiN0X2RhdGVfcHJvY2Vzc2VkLmVhY2ggZG8gfGRhdGV8CgojUFVUIEVB Q0ggU0VUUyBPRiBJVEVNUyBUSEFUIEFSRSBORUVERUQgRk9SIFRIRSBSRVBPUlQgVE8gVEhFIENP TlNPTEUgKEVWRU5UVUFMTFkgV0lMTCBCRSBPVVRQVVQgVE8gQSBGSUxFKQpwdXRzICIje3RfZGF0 ZV9wcm9jZXNzZWRbaXhdfSAsICN7dF9pbW1hdGVyaWFsX3NpemVfMltpeF19IgoKZW5kCgojRU5E IFRJTUUgVE8gQ09OU09MRQpwdXRzICJFbmRlZCBPdXRwdXQgI3tUaW1lLm5vd30iCgojIFBsZWFz ZSB0ZWxsIG1lIGlmIHRoZSBjb2RlIHJ1bnMuCg== --f46d04428d2c5e2ff404b76238e3--