Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (athena.apache.org: domain of zachary.zolton@gmail.com
 designates 74.125.82.180 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAEoytmgQ6L=4F3jMnErsMydTNR+GL0UG6P+HNthw0uqza9VD=Q@mail.gmail.com>
References: 
 <CAEoytmjn-q-XSUQAsj8bKuuxTdVcHo2xQcACd_PUDB-39EdzDg@mail.gmail.com>
 <CAGnHtbLULuOZ9A_ajh4AzkftsXhhCTDVzg8tQ=avDScGpg8x7A@mail.gmail.com>
 <CAEoytmhLRihcans273+s7gL65crqRqRHsmevY2F5h5LdygnzVw@mail.gmail.com>
 <CAAL6JQj9u-QsdK_6yfPyFO7sQ9TnYfgiOcOP79R0GiuEmnDoMw@mail.gmail.com>
 <CAEoytmgnWYeZ_fzmJ1-_VxPJ9UoM6NRiZiik0VsRAzaKOc2osw@mail.gmail.com>
 <CAGnHtbK1Mt5M4deYaWiMsh98+QByxSGt6MBa=mx0kPNGj6gGUA@mail.gmail.com>
 <CAEoytmgQ6L=4F3jMnErsMydTNR+GL0UG6P+HNthw0uqza9VD=Q@mail.gmail.com>
From: Zachary Zolton <zachary.zolton@gmail.com>
Date: Fri, 5 Aug 2011 18:53:32 -0500
Message-ID: 
 <CAGnHtbKEeJp_uWW0Z86fsyJ-Pz7fiVXW==HUmES8ppBjmoS_uw@mail.gmail.com>
Subject: Re: View collation by one key and sorting by another key
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Matthew,

Your welcome. Also, flipping the keys around might be another
interesting index--for seeing counts of all itemIds for a particular
day.


Cheers,

Zach

On Fri, Aug 5, 2011 at 6:10 PM, Matthew Slade
<matthew.slade@moonlight42.com> wrote:
> Hi Zach (and Randall)
>
> Thanks. I totally see the value now in splitting the date into it's
> components to get a controlled grain for grouping with the itemId as the
> first key. :)
>
> Thanks for all your help.
>
> Matthew
>
> On Sat, Aug 6, 2011 at 12:54 AM, Zachary Zolton <zachary.zolton@gmail.com=
>wrote:
>
>> If you want oranges sold over time, try this view:
>>
>> map: function(doc) {
>> =A0var dateOfPurchase =3D trimOffTimePart(doc.dateOfPurchase);
>> =A0emit([doc.itemId, dateOfPurchase], null);
>> }
>>
>> reduce: _count
>>
>> Now, query to get the counts:
>>
>> http://couch/db/_design/app/_view/items-sold-by-date?group=3Dtrue&startk=
ey=3D[
>> "oranges"]&endkey=3D["oranges",{}]
>>
>> (You'll have to URL encode those keys, too...)
>>
>> That should result in a row with a count of oranges sold for each day.
>> More like what you were looking for? (^_^
>>
>> --Zach
>>
>>
>> On Fri, Aug 5, 2011 at 5:34 PM, Matthew Slade
>> <matthew.slade@moonlight42.com> wrote:
>> > Hi Randall
>> >
>> > Thanks, I'm aware of the ability to split out the date into multiple k=
eys
>> > for easier collation. However that's not really the issue here. My
>> problem
>> > is with the additional level of sorting that might be required to make
>> the
>> > reduced data meaningful. ie I want to know only about oranges and not
>> other
>> > fruit in my particular date time collation.
>> >
>> > Matthew
>> >
>> > On Sat, Aug 6, 2011 at 12:19 AM, Randall Leeds <randall.leeds@gmail.co=
m
>> >wrote:
>> >
>> >> On Fri, Aug 5, 2011 at 15:00, Matthew Slade
>> >> <matthew.slade@moonlight42.com> wrote:
>> >> > Hi Zach (and everyone else)
>> >> >
>> >> > Thanks for the info. Unfortunately my game is already big and the
>> >> proposed
>> >> > solution wouldn't really be suitable although _lists seem interesti=
ng
>> and
>> >> > I'll definitely investigate them. I do find this quite a limitation=
 to
>> >> > couchdb especially when one is working a lot with dated documents.
>> >> >
>> >> > Another question I have in a similar vein:
>> >> >
>> >> > Given a set of documents being created for transaction for the
>> purchase
>> >> of
>> >> > fruit for example.
>> >> >
>> >> > * {
>> >> > "_id":"uniqueOrderId",
>> >> > "dateOfPurchase": "2011-07-06T10:24:52",
>> >> > "itemId": "oranges"
>> >> > }*
>> >> >
>> >> > Could one collate the view entries by the date and then reduce base=
d
>> off
>> >> of
>> >> > part of the value. ie How could I easily answer the question "*How
>> many
>> >> > oranges were sold on Wednesday*?" efficiently with potentially huge
>> >> numbers
>> >> > of transaction documents in my database.
>> >>
>> >> You should separate the key you emit into an array of the date pieces
>> >> like [YYYY, MM, DD, ...].
>> >> Then you can use ?group_level=3DX with your reduce query to get hourl=
y,
>> >> daily, monthly, etc summaries.
>> >>
>> >> -Randall
>> >
>>
>