Mailing-List: contact user-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@couchdb.apache.org
Received-SPF: pass (nike.apache.org: domain of anandology@gmail.com designates
 209.85.161.52 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type:content-transfer-encoding;
        b=gHCt0Yv/K+6v0+CXV7faWKVvyFhI6uBbUR+yTH+fftGYo/i+N9V5PYK+aGlGkoF8xD
         4BfJoIFNqol9ChVslIL64xRHUkAuuiqRdpo4owfqURerf/0nsfUVGC8VXcvS9wh5hCmK
         TJv1h7wsix0ICKwGh90hA3rMq57qQY4I3lEgI=
MIME-Version: 1.0
In-Reply-To: <AANLkTinZdCW3Q4eRqg6ydokVe0CkgTHROQ1LqoZ2bNmx@mail.gmail.com>
References: <AANLkTinZdCW3Q4eRqg6ydokVe0CkgTHROQ1LqoZ2bNmx@mail.gmail.com>
From: Anand Chitipothu <anandology@gmail.com>
Date: Sat, 13 Nov 2010 09:58:45 +0530
Message-ID: <AANLkTik947jrV+T0aSJjs4zsPBsW=9VbNkMSh76qzoRJ@mail.gmail.com>
Subject: Re: CouchDB model Problem
To: user@couchdb.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

2010/11/12 Luis Carlos Junges <luis.junges@gmail.com>:
> Hi,
>
> I would like to use couchdb for a project but i am unsure how to model it=
.
> Basically i will have to store products and theirs respectives prices fro=
m
> several =A0stores. So, for a product product1, for example, i will have a
> price p1 for store1, a price p2 for store 2 and so on...Considering that
> those prices will be updated automatically, i was thinking in something l=
ike
> this:
>
> A document for the product with all information about it with id equal to
> the product reference number
> example:
>
> id:product1
> name: Product 1
>
>
> A document with the price and store id
> id:89923848298398989d9fsd
> revision:1
> store:45
> price:5.67
> refcode:product1
> updated: timestamp here
>
>
> id:8992384829832938495298345
> revision:3
> store:46
> price:3.67
> refcode:product1
> updated: timestamp here
>
>
> My idea is that each store will update their own prices. Now the problem =
i
> am no sure how to solve is that i can have multiple price documents with
> differents ids (see example below) for the same store (a database
> inconsistency). Could i use mapreduce to collect all the price documents =
for
> a specific product =A0and get only the latest one based on the time is
> updated. If so, how can i do that? i mean, how would be the map and reduc=
e
> function? I would also like to delete the old ones.
>
>
>
> id:8992384829832938495298345
> revision:1
> store:46
> price:3.67
> refcode:product1
> updated timestamp here
>
>
> id:92839198234
> revision:1
> store:46
> price:6.23
> refcode:product1
> updated timestamp here
>
>
> I would appreciate any help

How about using "$product-$store" as the _id for the document. In the
above example, _id will be "product1-46". This will make sure that
there are no duplicate price documents.

Anand