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 pawelstawicki@gmail.com
 designates 209.85.219.216 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=iWfgGYl+wlm2XHxvb/HmxKarYXPZDIqB7lIzNuVtYkKv1OK2sq1AbnQCbKbtbo3hRB
         R2x02hAXA4G41NYN7cSOV7um+50NdczpPEcIoD/youaMPuxAVpMvXlf/B6KDGccIcTJm
         h4JuYrGIUUsgPIbNwc+zO1GjzB3ySwZjZosII=
MIME-Version: 1.0
In-Reply-To: <1bca98390912150640m597009e5m78d29461d92a6ae0@mail.gmail.com>
References: <1bca98390912150640m597009e5m78d29461d92a6ae0@mail.gmail.com>
From: =?UTF-8?Q?Pawe=C5=82_Stawicki?= <pawelstawicki@gmail.com>
Date: Wed, 16 Dec 2009 00:36:39 +0100
Message-ID: <6adfa88d0912151536v5c70834hfdb3caea9e238253@mail.gmail.com>
Subject: Re: returning document list and a count of related documents
To: user@couchdb.apache.org
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hmm... Maybe try to have document as a key?

// map.js
function(doc) {
=C2=A0if (doc.type =3D=3D "post") {
=C2=A0 =C2=A0map(doc, 0);
=C2=A0} else if (doc.type =3D=3D "comment") {
=C2=A0 =C2=A0map({'_id':doc.post}, 1);
=C2=A0}
}

// reduce.js
function(keys, values, rereduce) {
=C2=A0 =C2=A0 =C2=A0 =C2=A0return sum(values);
}


Then call view with "group=3Dtrue" parameter. You should get document as
key, and number of comments as value.

Another solution, if you need post id as a key and post document as value:
// map.js
function(doc) {
=C2=A0if (doc.type =3D=3D "post") {
=C2=A0 =C2=A0map(doc._id, [doc, 0]);
=C2=A0} else if (doc.type =3D=3D "comment") {
=C2=A0 =C2=A0map(doc.post, [{'_id':doc.post}, 1]);
=C2=A0}
}

// reduce.js
function(keys, values, rereduce) {
  if (!rereduce) {
    var commentsCount =3D 0;
    values.forEach(function(array) {
      commentsCount +=3D array[1];
    }
    return [values[0][0], commentsCount;
  } else {
    var commentsCount =3D 0;
    values.forEach(function(array) {
      commentsCount +=3D array[1];
    }
    return [values[0], commentsCount;
  }
}

WARNING: will work only with "group=3Dtrue" parameter.

I am not sure it will work, but it definitely won't work with
group_level =3D 0 (which is default), so use group=3Dtrue. It should give
you post id as a key, and post document and comments count as value.


Regards
--=20
Pawe=C5=82 Stawicki
http://pawelstawicki.blogspot.com
http://szczecin.jug.pl
http://www.java4people.com