You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@couchdb.apache.org by Mic <mi...@gmail.com> on 2015/01/01 06:06:16 UTC
Re: map function with a helper function
Hi Sinan,
Thank you for the links and your suggestions. However, I did not quite
understand your suggestions and I tried this map function which did not
work:
function(doc) {
var judge = function (no1, no2) {
var unexpect = "X";
var letter1 = unexpect, letter2 = unexpect;
for (var i in this.chr) {
var chr = this.chr[i];
if (chr.no == no1) {
letter1 = chr.letter;
} else if (chr.no == no2) {
letter2 = chr.letter;
}
}
if (letter1 != letter2 && letter1 != unexpect && letter2 !=
unexpect) {
return true;
}
return false;
};
emit(judge(n1, n2), doc);
}
Could you please explain your ideas a little more?
Thank you in advance.
Mic
On Wed, Dec 31, 2014 at 10:57 PM, Sinan Gabel <si...@gmail.com> wrote:
> Hi!
>
> You may want to take a look at the basics here:
> http://docs.couchdb.org/en/latest/couchapp/views/index.html and Cloudant
> has some interactive samples at:
> https://cloudant.com/for-developers/all_docs/
>
> *Using map*: You may want to emit the letters and use keys to find the
> docs.
>
> *Not using map*: Name each doc something "smart", and use keys to find the
> docs.
>
> Br,
> Sinan
>
> On 31 December 2014 at 13:05, Mic <mi...@gmail.com> wrote:
>
> > Hi,
> > I tried to create a map function which should use the following
> conditions:
> >
> > - e.g. chr.no = 5 and chr.no = 6
> > - chr.letter between two objects/dicts in chr are not the same and no X
> >
> > I have the following function but I do not know how to combine it with
> > `emit`
> >
> > var judge = function (no1, no2) {
> > var unexpect = "X";
> > var letter1 = unexpect, letter2 = unexpect;
> > for (var i in this.chr) {
> > var chr = this.chr[i];
> > if (chr.no == no1) {
> > letter1 = chr.letter;
> > } else if (chr.no == no2) {
> > letter2 = chr.letter;
> > }
> > }
> > if (letter1 != letter2 && letter1 != unexpect && letter2 !=
> > unexpect) {
> > return true;
> > }
> > return false;
> > };
> >
> >
> > CouchDB has the below content:
> >
> >
> > {
> > "total_rows":5,
> > "offset":0,
> > "rows":[
> > {
> > "_id":"10",
> > "_rev":"3-5288068d2c4ef3e6a9d3f8ff4e3377dd",
> > "chr":[
> > {
> > "letter":"T",
> > "no":4
> > },
> > {
> > "letter":"A",
> > "no":5
> > },
> > {
> > "letter":"X",
> > "no":6
> > }
> > ]
> > },
> > {
> > "_id":"14",
> > "_rev":"3-21300d06c31224416b8ff71b71b304d8",
> > "chr":[
> > {
> > "letter":"T",
> > "no":4
> > },
> > {
> > "letter":"G",
> > "no":5
> > },
> > {
> > "letter":"G",
> > "no":6
> > }
> > ]
> > },
> > {
> > "_id":"7",
> > "_rev":"2-1516ba547bdd21724158bc854f39f66b",
> > "chr":[
> > {
> > "letter":"C",
> > "no":5
> > },
> > {
> > "letter":"T",
> > "no":6
> > }
> > ]
> > },
> > {
> > "_id":"8",
> > "_rev":"2-750078ccc9e74616f33a2537e41b8414",
> > "chr":[
> > {
> > "letter":"C",
> > "no":5
> > },
> > {
> > "letter":"T",
> > "no":6
> > }
> > ]
> > },
> > {
> > "_id":"9",
> > "_rev":"2-3d68352a2d98c56fd322ae674fb7c38a",
> > "chr":[
> > {
> > "letter":"A",
> > "no":5
> > },
> > {
> > "letter":"G",
> > "no":6
> > }
> > ]
> > }
> > ]
> > }
> >
> > How is it possible to write a map function combine with the above `judge`
> > function or maybe there is better way to do it?
> >
> > P.S. I also asked the same question here (
> >
> >
> http://stackoverflow.com/questions/27688196/map-function-with-a-helper-function-in-couchdb
> > )
> >
> > Thank you in advance.
> >
> > Mic
> >
>
Re: map function with a helper function
Posted by Sebastian Rothbucher <se...@googlemail.com>.
Hi,
From the top of my head, i'd emit every chr of every doc separately and then use Startkey and endkey on the view.
Obviously, this would still get documents twice if two chrs are in the range which you could Filter out in your application or with a list function
What you can not do is have more than one sort criterion per view. As the chrs is your criterion, you have none left
Hope this helps and things become a Little More clear
Regards
Sebastian
Von meinem iPhone gesendet
> Am 06.01.2015 um 13:43 schrieb Mic <mi...@gmail.com>:
>
> Hi Sebastian,
> Thank you for your response. For the below documents I would like only get
> documents with the ids 7, 8 and 9, because chr.no = 5 and chr.no = 6
> (?key=[5,6]) only contains chr.letter between them which are not the same
> and do not have X.
>
> Threfore I thought the judge function would be useful, but maybe in CouchDB
> is there a better way to do it.
>
> {
> "total_rows":5,
> "offset":0,
> "rows":[
> {
> "_id":"10",
> "_rev":"3-5288068d2c4ef3e6a9d3f8ff4e3377dd",
> "chr":[
> {
> "letter":"T",
> "no":4
> },
> {
> "letter":"A",
> "no":5
> },
> {
> "letter":"X",
> "no":6
> }
> ]
> },
> {
> "_id":"14",
> "_rev":"3-21300d06c31224416b8ff71b71b304d8",
> "chr":[
> {
> "letter":"T",
> "no":4
> },
> {
> "letter":"G",
> "no":5
> },
> {
> "letter":"G",
> "no":6
> }
> ]
> },
> {
> "_id":"7",
> "_rev":"2-1516ba547bdd21724158bc854f39f66b",
> "chr":[
> {
> "letter":"C",
> "no":5
> },
> {
> "letter":"T",
> "no":6
> }
> ]
> },
> {
> "_id":"8",
> "_rev":"2-750078ccc9e74616f33a2537e41b8414",
> "chr":[
> {
> "letter":"C",
> "no":5
> },
> {
> "letter":"T",
> "no":6
> }
> ]
> },
> {
> "_id":"9",
> "_rev":"2-3d68352a2d98c56fd322ae674fb7c38a",
> "chr":[
> {
> "letter":"A",
> "no":5
> },
> {
> "letter":"G",
> "no":6
> }
> ]
> }
> ]
> }
>
> Best wishes,
>
> Mic
>
> On Tue, Jan 6, 2015 at 4:41 AM, Sebastian Rothbucher <
> sebastianrothbucher@googlemail.com> wrote:
>
>> Hi Mic,
>>
>> the general misconception here seems to be that "this" within map refers to
>> the design doc, i.e. you'd have to have "chr" w/in the design doc - which
>> is not the case in the example you have given.
>> I think it would help to explain what you want to achieve with "judge" in
>> the first place...
>>
>> Regards
>> Sebastian
>>
>>> On Thu, Jan 1, 2015 at 6:06 AM, Mic <mi...@gmail.com> wrote:
>>>
>>> Hi Sinan,
>>> Thank you for the links and your suggestions. However, I did not quite
>>> understand your suggestions and I tried this map function which did not
>>> work:
>>>
>>> function(doc) {
>>> var judge = function (no1, no2) {
>>> var unexpect = "X";
>>> var letter1 = unexpect, letter2 = unexpect;
>>> for (var i in this.chr) {
>>> var chr = this.chr[i];
>>> if (chr.no == no1) {
>>> letter1 = chr.letter;
>>> } else if (chr.no == no2) {
>>> letter2 = chr.letter;
>>> }
>>> }
>>> if (letter1 != letter2 && letter1 != unexpect && letter2 !=
>>> unexpect) {
>>> return true;
>>> }
>>> return false;
>>> };
>>>
>>>
>>> emit(judge(n1, n2), doc);
>>> }
>>>
>>> Could you please explain your ideas a little more?
>>>
>>> Thank you in advance.
>>>
>>> Mic
>>>
>>> On Wed, Dec 31, 2014 at 10:57 PM, Sinan Gabel <si...@gmail.com>
>>> wrote:
>>>
>>>> Hi!
>>>>
>>>> You may want to take a look at the basics here:
>>>> http://docs.couchdb.org/en/latest/couchapp/views/index.html and
>> Cloudant
>>>> has some interactive samples at:
>>>> https://cloudant.com/for-developers/all_docs/
>>>>
>>>> *Using map*: You may want to emit the letters and use keys to find the
>>>> docs.
>>>>
>>>> *Not using map*: Name each doc something "smart", and use keys to find
>>> the
>>>> docs.
>>>>
>>>> Br,
>>>> Sinan
>>>>
>>>>> On 31 December 2014 at 13:05, Mic <mi...@gmail.com> wrote:
>>>>>
>>>>> Hi,
>>>>> I tried to create a map function which should use the following
>>>> conditions:
>>>>>
>>>>> - e.g. chr.no = 5 and chr.no = 6
>>>>> - chr.letter between two objects/dicts in chr are not the same and
>> no
>>> X
>>>>>
>>>>> I have the following function but I do not know how to combine it
>> with
>>>>> `emit`
>>>>>
>>>>> var judge = function (no1, no2) {
>>>>> var unexpect = "X";
>>>>> var letter1 = unexpect, letter2 = unexpect;
>>>>> for (var i in this.chr) {
>>>>> var chr = this.chr[i];
>>>>> if (chr.no == no1) {
>>>>> letter1 = chr.letter;
>>>>> } else if (chr.no == no2) {
>>>>> letter2 = chr.letter;
>>>>> }
>>>>> }
>>>>> if (letter1 != letter2 && letter1 != unexpect && letter2 !=
>>>>> unexpect) {
>>>>> return true;
>>>>> }
>>>>> return false;
>>>>> };
>>>>>
>>>>>
>>>>> CouchDB has the below content:
>>>>>
>>>>>
>>>>> {
>>>>> "total_rows":5,
>>>>> "offset":0,
>>>>> "rows":[
>>>>> {
>>>>> "_id":"10",
>>>>> "_rev":"3-5288068d2c4ef3e6a9d3f8ff4e3377dd",
>>>>> "chr":[
>>>>> {
>>>>> "letter":"T",
>>>>> "no":4
>>>>> },
>>>>> {
>>>>> "letter":"A",
>>>>> "no":5
>>>>> },
>>>>> {
>>>>> "letter":"X",
>>>>> "no":6
>>>>> }
>>>>> ]
>>>>> },
>>>>> {
>>>>> "_id":"14",
>>>>> "_rev":"3-21300d06c31224416b8ff71b71b304d8",
>>>>> "chr":[
>>>>> {
>>>>> "letter":"T",
>>>>> "no":4
>>>>> },
>>>>> {
>>>>> "letter":"G",
>>>>> "no":5
>>>>> },
>>>>> {
>>>>> "letter":"G",
>>>>> "no":6
>>>>> }
>>>>> ]
>>>>> },
>>>>> {
>>>>> "_id":"7",
>>>>> "_rev":"2-1516ba547bdd21724158bc854f39f66b",
>>>>> "chr":[
>>>>> {
>>>>> "letter":"C",
>>>>> "no":5
>>>>> },
>>>>> {
>>>>> "letter":"T",
>>>>> "no":6
>>>>> }
>>>>> ]
>>>>> },
>>>>> {
>>>>> "_id":"8",
>>>>> "_rev":"2-750078ccc9e74616f33a2537e41b8414",
>>>>> "chr":[
>>>>> {
>>>>> "letter":"C",
>>>>> "no":5
>>>>> },
>>>>> {
>>>>> "letter":"T",
>>>>> "no":6
>>>>> }
>>>>> ]
>>>>> },
>>>>> {
>>>>> "_id":"9",
>>>>> "_rev":"2-3d68352a2d98c56fd322ae674fb7c38a",
>>>>> "chr":[
>>>>> {
>>>>> "letter":"A",
>>>>> "no":5
>>>>> },
>>>>> {
>>>>> "letter":"G",
>>>>> "no":6
>>>>> }
>>>>> ]
>>>>> }
>>>>> ]
>>>>> }
>>>>>
>>>>> How is it possible to write a map function combine with the above
>>> `judge`
>>>>> function or maybe there is better way to do it?
>>>>>
>>>>> P.S. I also asked the same question here (
>> http://stackoverflow.com/questions/27688196/map-function-with-a-helper-function-in-couchdb
>>>>> )
>>>>>
>>>>> Thank you in advance.
>>>>>
>>>>> Mic
>>
Re: map function with a helper function
Posted by Sebastian Rothbucher <se...@googlemail.com>.
Hi,
you don't have to store the intermediary results in a document - you can
have them in the view. So you're on the right track but not quite there yet.
What you can do is sth like that in the map function:
function(doc){
if(!doc.chr)return;
// define judge (for doc, NOT this)
var judge = function (no1, no2) {
var unexpect = "X";
var letter1 = unexpect, letter2 = unexpect;
for (var i in doc.chr) {
var chr = doc.chr[i];
if (chr.no == no1) {
letter1 = chr.letter;
} else if (chr.no == no2) {
letter2 = chr.letter;
}
}
if (letter1 != letter2 && letter1 != unexpect && letter2 !=
unexpect) {
return true;
}
return false;
};
// determine minimum and maximum of numbers
var minNum=doc.chr[0].no;
var maxNum=doc.chr[0].no;
for(var i=0; i<doc.chr.length; i++){
minNum=Math.min(minNum, doc.chr[i].no;
maxNum=Math.max(maxNum, doc.chr[i].no;
}
// judge for all possible combinations, and emit for judge()==true - can
be several emits per doc which is OK
for(var i=minNum; i<=maxNum; i++){
for(var j=i+1; j<=maxNum; j++){
if(judge(i, j)){
emit([i, j], null);
}
}
}
}
You can then use the key argument in the view to query for e.g. [4, 6]
Hope this helps - good luck
Sebastian
On Mon, Jan 12, 2015 at 2:57 AM, Mic <mi...@gmail.com> wrote:
> Hi Sebastian,
> Thank you for your response. In your last suggestion do you mean I would
> have to create 3 views manually, because chr.no can contain 4,5 and 6? But
> what would happen if the numbers grows?
>
> In you previous suggestion you mention another solution which would return
> duplication. In my application I could remove duplication, but
> unfortunately I do not understand your solution.
>
> Meanwhile, I am thinking whether it would be not simpler to add to each
> document all possible combinations which satisfy the judge function
> *function(doc) {*
>
>
> * var judge = function (no1, no2) { var unexpect = "X";
> var letter1 = unexpect, letter2 = unexpect; for (var i
> in this.chr) { var chr = this.chr[i]; if
> (chr.no <http://chr.no/> == no1) { letter1 =
> chr.letter; } else if (chr.no <http://chr.no/> == no2) {
> letter2 = chr.letter; } }
> if (letter1 != letter2 && letter1 != unexpect && letter2 != unexpect)
> { return true; } return false;
> };*
> * emit(judge(n1, n2), doc);*
> * }*
>
> and the result would look like this:
> {
> ...
> combinations: ['4-5', '4-6', '5-6']
> ...
> }
>
> Does JavaScript/CouchDB provide a simple way to update each document and
> create an array of all combinations?
> Is it possible to query the view for only '4-6' in combinations?
>
> Thank you in advance.
>
> Mic
>
>
>
> On Wed, Jan 7, 2015 at 6:34 AM, Sebastian Rothbucher <
> sebastianrothbucher@googlemail.com> wrote:
>
> > Hi,
> > One more thing: you can not pass Parameters into the view ever. You have
> > to create all items in a view via emit before there is one query actually
> > running
> > What you can do, provided each document is small, is emit([no1, no2],
> > null) for all no1 and no2 the document can potentially (!!!) match
> > Again: the document is doc, not 'this'
> > Plus don't emit the full doc as 2nd Param, That Most often just slows
> > things down and is of no help. Null does it
> >
> > Good luck - regards
> > Sebastian
> >
> > Von meinem iPhone gesendet
> >
> > > Am 06.01.2015 um 13:43 schrieb Mic <mi...@gmail.com>:
> > >
> > > Hi Sebastian,
> > > Thank you for your response. For the below documents I would like only
> > get
> > > documents with the ids 7, 8 and 9, because chr.no = 5 and chr.no = 6
> > > (?key=[5,6]) only contains chr.letter between them which are not the
> same
> > > and do not have X.
> > >
> > > Threfore I thought the judge function would be useful, but maybe in
> > CouchDB
> > > is there a better way to do it.
> > >
> > > {
> > > "total_rows":5,
> > > "offset":0,
> > > "rows":[
> > > {
> > > "_id":"10",
> > > "_rev":"3-5288068d2c4ef3e6a9d3f8ff4e3377dd",
> > > "chr":[
> > > {
> > > "letter":"T",
> > > "no":4
> > > },
> > > {
> > > "letter":"A",
> > > "no":5
> > > },
> > > {
> > > "letter":"X",
> > > "no":6
> > > }
> > > ]
> > > },
> > > {
> > > "_id":"14",
> > > "_rev":"3-21300d06c31224416b8ff71b71b304d8",
> > > "chr":[
> > > {
> > > "letter":"T",
> > > "no":4
> > > },
> > > {
> > > "letter":"G",
> > > "no":5
> > > },
> > > {
> > > "letter":"G",
> > > "no":6
> > > }
> > > ]
> > > },
> > > {
> > > "_id":"7",
> > > "_rev":"2-1516ba547bdd21724158bc854f39f66b",
> > > "chr":[
> > > {
> > > "letter":"C",
> > > "no":5
> > > },
> > > {
> > > "letter":"T",
> > > "no":6
> > > }
> > > ]
> > > },
> > > {
> > > "_id":"8",
> > > "_rev":"2-750078ccc9e74616f33a2537e41b8414",
> > > "chr":[
> > > {
> > > "letter":"C",
> > > "no":5
> > > },
> > > {
> > > "letter":"T",
> > > "no":6
> > > }
> > > ]
> > > },
> > > {
> > > "_id":"9",
> > > "_rev":"2-3d68352a2d98c56fd322ae674fb7c38a",
> > > "chr":[
> > > {
> > > "letter":"A",
> > > "no":5
> > > },
> > > {
> > > "letter":"G",
> > > "no":6
> > > }
> > > ]
> > > }
> > > ]
> > > }
> > >
> > > Best wishes,
> > >
> > > Mic
> > >
> > > On Tue, Jan 6, 2015 at 4:41 AM, Sebastian Rothbucher <
> > > sebastianrothbucher@googlemail.com> wrote:
> > >
> > >> Hi Mic,
> > >>
> > >> the general misconception here seems to be that "this" within map
> > refers to
> > >> the design doc, i.e. you'd have to have "chr" w/in the design doc -
> > which
> > >> is not the case in the example you have given.
> > >> I think it would help to explain what you want to achieve with "judge"
> > in
> > >> the first place...
> > >>
> > >> Regards
> > >> Sebastian
> > >>
> > >>> On Thu, Jan 1, 2015 at 6:06 AM, Mic <mi...@gmail.com> wrote:
> > >>>
> > >>> Hi Sinan,
> > >>> Thank you for the links and your suggestions. However, I did not
> quite
> > >>> understand your suggestions and I tried this map function which did
> not
> > >>> work:
> > >>>
> > >>> function(doc) {
> > >>> var judge = function (no1, no2) {
> > >>> var unexpect = "X";
> > >>> var letter1 = unexpect, letter2 = unexpect;
> > >>> for (var i in this.chr) {
> > >>> var chr = this.chr[i];
> > >>> if (chr.no == no1) {
> > >>> letter1 = chr.letter;
> > >>> } else if (chr.no == no2) {
> > >>> letter2 = chr.letter;
> > >>> }
> > >>> }
> > >>> if (letter1 != letter2 && letter1 != unexpect && letter2
> !=
> > >>> unexpect) {
> > >>> return true;
> > >>> }
> > >>> return false;
> > >>> };
> > >>>
> > >>>
> > >>> emit(judge(n1, n2), doc);
> > >>> }
> > >>>
> > >>> Could you please explain your ideas a little more?
> > >>>
> > >>> Thank you in advance.
> > >>>
> > >>> Mic
> > >>>
> > >>> On Wed, Dec 31, 2014 at 10:57 PM, Sinan Gabel <sinan.gabel@gmail.com
> >
> > >>> wrote:
> > >>>
> > >>>> Hi!
> > >>>>
> > >>>> You may want to take a look at the basics here:
> > >>>> http://docs.couchdb.org/en/latest/couchapp/views/index.html and
> > >> Cloudant
> > >>>> has some interactive samples at:
> > >>>> https://cloudant.com/for-developers/all_docs/
> > >>>>
> > >>>> *Using map*: You may want to emit the letters and use keys to find
> the
> > >>>> docs.
> > >>>>
> > >>>> *Not using map*: Name each doc something "smart", and use keys to
> find
> > >>> the
> > >>>> docs.
> > >>>>
> > >>>> Br,
> > >>>> Sinan
> > >>>>
> > >>>>> On 31 December 2014 at 13:05, Mic <mi...@gmail.com> wrote:
> > >>>>>
> > >>>>> Hi,
> > >>>>> I tried to create a map function which should use the following
> > >>>> conditions:
> > >>>>>
> > >>>>> - e.g. chr.no = 5 and chr.no = 6
> > >>>>> - chr.letter between two objects/dicts in chr are not the same and
> > >> no
> > >>> X
> > >>>>>
> > >>>>> I have the following function but I do not know how to combine it
> > >> with
> > >>>>> `emit`
> > >>>>>
> > >>>>> var judge = function (no1, no2) {
> > >>>>> var unexpect = "X";
> > >>>>> var letter1 = unexpect, letter2 = unexpect;
> > >>>>> for (var i in this.chr) {
> > >>>>> var chr = this.chr[i];
> > >>>>> if (chr.no == no1) {
> > >>>>> letter1 = chr.letter;
> > >>>>> } else if (chr.no == no2) {
> > >>>>> letter2 = chr.letter;
> > >>>>> }
> > >>>>> }
> > >>>>> if (letter1 != letter2 && letter1 != unexpect && letter2 !=
> > >>>>> unexpect) {
> > >>>>> return true;
> > >>>>> }
> > >>>>> return false;
> > >>>>> };
> > >>>>>
> > >>>>>
> > >>>>> CouchDB has the below content:
> > >>>>>
> > >>>>>
> > >>>>> {
> > >>>>> "total_rows":5,
> > >>>>> "offset":0,
> > >>>>> "rows":[
> > >>>>> {
> > >>>>> "_id":"10",
> > >>>>> "_rev":"3-5288068d2c4ef3e6a9d3f8ff4e3377dd",
> > >>>>> "chr":[
> > >>>>> {
> > >>>>> "letter":"T",
> > >>>>> "no":4
> > >>>>> },
> > >>>>> {
> > >>>>> "letter":"A",
> > >>>>> "no":5
> > >>>>> },
> > >>>>> {
> > >>>>> "letter":"X",
> > >>>>> "no":6
> > >>>>> }
> > >>>>> ]
> > >>>>> },
> > >>>>> {
> > >>>>> "_id":"14",
> > >>>>> "_rev":"3-21300d06c31224416b8ff71b71b304d8",
> > >>>>> "chr":[
> > >>>>> {
> > >>>>> "letter":"T",
> > >>>>> "no":4
> > >>>>> },
> > >>>>> {
> > >>>>> "letter":"G",
> > >>>>> "no":5
> > >>>>> },
> > >>>>> {
> > >>>>> "letter":"G",
> > >>>>> "no":6
> > >>>>> }
> > >>>>> ]
> > >>>>> },
> > >>>>> {
> > >>>>> "_id":"7",
> > >>>>> "_rev":"2-1516ba547bdd21724158bc854f39f66b",
> > >>>>> "chr":[
> > >>>>> {
> > >>>>> "letter":"C",
> > >>>>> "no":5
> > >>>>> },
> > >>>>> {
> > >>>>> "letter":"T",
> > >>>>> "no":6
> > >>>>> }
> > >>>>> ]
> > >>>>> },
> > >>>>> {
> > >>>>> "_id":"8",
> > >>>>> "_rev":"2-750078ccc9e74616f33a2537e41b8414",
> > >>>>> "chr":[
> > >>>>> {
> > >>>>> "letter":"C",
> > >>>>> "no":5
> > >>>>> },
> > >>>>> {
> > >>>>> "letter":"T",
> > >>>>> "no":6
> > >>>>> }
> > >>>>> ]
> > >>>>> },
> > >>>>> {
> > >>>>> "_id":"9",
> > >>>>> "_rev":"2-3d68352a2d98c56fd322ae674fb7c38a",
> > >>>>> "chr":[
> > >>>>> {
> > >>>>> "letter":"A",
> > >>>>> "no":5
> > >>>>> },
> > >>>>> {
> > >>>>> "letter":"G",
> > >>>>> "no":6
> > >>>>> }
> > >>>>> ]
> > >>>>> }
> > >>>>> ]
> > >>>>> }
> > >>>>>
> > >>>>> How is it possible to write a map function combine with the above
> > >>> `judge`
> > >>>>> function or maybe there is better way to do it?
> > >>>>>
> > >>>>> P.S. I also asked the same question here (
> > >>
> >
> http://stackoverflow.com/questions/27688196/map-function-with-a-helper-function-in-couchdb
> > >>>>> )
> > >>>>>
> > >>>>> Thank you in advance.
> > >>>>>
> > >>>>> Mic
> > >>
> >
>
Re: map function with a helper function
Posted by Mic <mi...@gmail.com>.
Hi Sebastian,
Thank you for your response. In your last suggestion do you mean I would
have to create 3 views manually, because chr.no can contain 4,5 and 6? But
what would happen if the numbers grows?
In you previous suggestion you mention another solution which would return
duplication. In my application I could remove duplication, but
unfortunately I do not understand your solution.
Meanwhile, I am thinking whether it would be not simpler to add to each
document all possible combinations which satisfy the judge function
*function(doc) {*
* var judge = function (no1, no2) { var unexpect = "X";
var letter1 = unexpect, letter2 = unexpect; for (var i
in this.chr) { var chr = this.chr[i]; if
(chr.no <http://chr.no/> == no1) { letter1 =
chr.letter; } else if (chr.no <http://chr.no/> == no2) {
letter2 = chr.letter; } }
if (letter1 != letter2 && letter1 != unexpect && letter2 != unexpect)
{ return true; } return false;
};*
* emit(judge(n1, n2), doc);*
* }*
and the result would look like this:
{
...
combinations: ['4-5', '4-6', '5-6']
...
}
Does JavaScript/CouchDB provide a simple way to update each document and
create an array of all combinations?
Is it possible to query the view for only '4-6' in combinations?
Thank you in advance.
Mic
On Wed, Jan 7, 2015 at 6:34 AM, Sebastian Rothbucher <
sebastianrothbucher@googlemail.com> wrote:
> Hi,
> One more thing: you can not pass Parameters into the view ever. You have
> to create all items in a view via emit before there is one query actually
> running
> What you can do, provided each document is small, is emit([no1, no2],
> null) for all no1 and no2 the document can potentially (!!!) match
> Again: the document is doc, not 'this'
> Plus don't emit the full doc as 2nd Param, That Most often just slows
> things down and is of no help. Null does it
>
> Good luck - regards
> Sebastian
>
> Von meinem iPhone gesendet
>
> > Am 06.01.2015 um 13:43 schrieb Mic <mi...@gmail.com>:
> >
> > Hi Sebastian,
> > Thank you for your response. For the below documents I would like only
> get
> > documents with the ids 7, 8 and 9, because chr.no = 5 and chr.no = 6
> > (?key=[5,6]) only contains chr.letter between them which are not the same
> > and do not have X.
> >
> > Threfore I thought the judge function would be useful, but maybe in
> CouchDB
> > is there a better way to do it.
> >
> > {
> > "total_rows":5,
> > "offset":0,
> > "rows":[
> > {
> > "_id":"10",
> > "_rev":"3-5288068d2c4ef3e6a9d3f8ff4e3377dd",
> > "chr":[
> > {
> > "letter":"T",
> > "no":4
> > },
> > {
> > "letter":"A",
> > "no":5
> > },
> > {
> > "letter":"X",
> > "no":6
> > }
> > ]
> > },
> > {
> > "_id":"14",
> > "_rev":"3-21300d06c31224416b8ff71b71b304d8",
> > "chr":[
> > {
> > "letter":"T",
> > "no":4
> > },
> > {
> > "letter":"G",
> > "no":5
> > },
> > {
> > "letter":"G",
> > "no":6
> > }
> > ]
> > },
> > {
> > "_id":"7",
> > "_rev":"2-1516ba547bdd21724158bc854f39f66b",
> > "chr":[
> > {
> > "letter":"C",
> > "no":5
> > },
> > {
> > "letter":"T",
> > "no":6
> > }
> > ]
> > },
> > {
> > "_id":"8",
> > "_rev":"2-750078ccc9e74616f33a2537e41b8414",
> > "chr":[
> > {
> > "letter":"C",
> > "no":5
> > },
> > {
> > "letter":"T",
> > "no":6
> > }
> > ]
> > },
> > {
> > "_id":"9",
> > "_rev":"2-3d68352a2d98c56fd322ae674fb7c38a",
> > "chr":[
> > {
> > "letter":"A",
> > "no":5
> > },
> > {
> > "letter":"G",
> > "no":6
> > }
> > ]
> > }
> > ]
> > }
> >
> > Best wishes,
> >
> > Mic
> >
> > On Tue, Jan 6, 2015 at 4:41 AM, Sebastian Rothbucher <
> > sebastianrothbucher@googlemail.com> wrote:
> >
> >> Hi Mic,
> >>
> >> the general misconception here seems to be that "this" within map
> refers to
> >> the design doc, i.e. you'd have to have "chr" w/in the design doc -
> which
> >> is not the case in the example you have given.
> >> I think it would help to explain what you want to achieve with "judge"
> in
> >> the first place...
> >>
> >> Regards
> >> Sebastian
> >>
> >>> On Thu, Jan 1, 2015 at 6:06 AM, Mic <mi...@gmail.com> wrote:
> >>>
> >>> Hi Sinan,
> >>> Thank you for the links and your suggestions. However, I did not quite
> >>> understand your suggestions and I tried this map function which did not
> >>> work:
> >>>
> >>> function(doc) {
> >>> var judge = function (no1, no2) {
> >>> var unexpect = "X";
> >>> var letter1 = unexpect, letter2 = unexpect;
> >>> for (var i in this.chr) {
> >>> var chr = this.chr[i];
> >>> if (chr.no == no1) {
> >>> letter1 = chr.letter;
> >>> } else if (chr.no == no2) {
> >>> letter2 = chr.letter;
> >>> }
> >>> }
> >>> if (letter1 != letter2 && letter1 != unexpect && letter2 !=
> >>> unexpect) {
> >>> return true;
> >>> }
> >>> return false;
> >>> };
> >>>
> >>>
> >>> emit(judge(n1, n2), doc);
> >>> }
> >>>
> >>> Could you please explain your ideas a little more?
> >>>
> >>> Thank you in advance.
> >>>
> >>> Mic
> >>>
> >>> On Wed, Dec 31, 2014 at 10:57 PM, Sinan Gabel <si...@gmail.com>
> >>> wrote:
> >>>
> >>>> Hi!
> >>>>
> >>>> You may want to take a look at the basics here:
> >>>> http://docs.couchdb.org/en/latest/couchapp/views/index.html and
> >> Cloudant
> >>>> has some interactive samples at:
> >>>> https://cloudant.com/for-developers/all_docs/
> >>>>
> >>>> *Using map*: You may want to emit the letters and use keys to find the
> >>>> docs.
> >>>>
> >>>> *Not using map*: Name each doc something "smart", and use keys to find
> >>> the
> >>>> docs.
> >>>>
> >>>> Br,
> >>>> Sinan
> >>>>
> >>>>> On 31 December 2014 at 13:05, Mic <mi...@gmail.com> wrote:
> >>>>>
> >>>>> Hi,
> >>>>> I tried to create a map function which should use the following
> >>>> conditions:
> >>>>>
> >>>>> - e.g. chr.no = 5 and chr.no = 6
> >>>>> - chr.letter between two objects/dicts in chr are not the same and
> >> no
> >>> X
> >>>>>
> >>>>> I have the following function but I do not know how to combine it
> >> with
> >>>>> `emit`
> >>>>>
> >>>>> var judge = function (no1, no2) {
> >>>>> var unexpect = "X";
> >>>>> var letter1 = unexpect, letter2 = unexpect;
> >>>>> for (var i in this.chr) {
> >>>>> var chr = this.chr[i];
> >>>>> if (chr.no == no1) {
> >>>>> letter1 = chr.letter;
> >>>>> } else if (chr.no == no2) {
> >>>>> letter2 = chr.letter;
> >>>>> }
> >>>>> }
> >>>>> if (letter1 != letter2 && letter1 != unexpect && letter2 !=
> >>>>> unexpect) {
> >>>>> return true;
> >>>>> }
> >>>>> return false;
> >>>>> };
> >>>>>
> >>>>>
> >>>>> CouchDB has the below content:
> >>>>>
> >>>>>
> >>>>> {
> >>>>> "total_rows":5,
> >>>>> "offset":0,
> >>>>> "rows":[
> >>>>> {
> >>>>> "_id":"10",
> >>>>> "_rev":"3-5288068d2c4ef3e6a9d3f8ff4e3377dd",
> >>>>> "chr":[
> >>>>> {
> >>>>> "letter":"T",
> >>>>> "no":4
> >>>>> },
> >>>>> {
> >>>>> "letter":"A",
> >>>>> "no":5
> >>>>> },
> >>>>> {
> >>>>> "letter":"X",
> >>>>> "no":6
> >>>>> }
> >>>>> ]
> >>>>> },
> >>>>> {
> >>>>> "_id":"14",
> >>>>> "_rev":"3-21300d06c31224416b8ff71b71b304d8",
> >>>>> "chr":[
> >>>>> {
> >>>>> "letter":"T",
> >>>>> "no":4
> >>>>> },
> >>>>> {
> >>>>> "letter":"G",
> >>>>> "no":5
> >>>>> },
> >>>>> {
> >>>>> "letter":"G",
> >>>>> "no":6
> >>>>> }
> >>>>> ]
> >>>>> },
> >>>>> {
> >>>>> "_id":"7",
> >>>>> "_rev":"2-1516ba547bdd21724158bc854f39f66b",
> >>>>> "chr":[
> >>>>> {
> >>>>> "letter":"C",
> >>>>> "no":5
> >>>>> },
> >>>>> {
> >>>>> "letter":"T",
> >>>>> "no":6
> >>>>> }
> >>>>> ]
> >>>>> },
> >>>>> {
> >>>>> "_id":"8",
> >>>>> "_rev":"2-750078ccc9e74616f33a2537e41b8414",
> >>>>> "chr":[
> >>>>> {
> >>>>> "letter":"C",
> >>>>> "no":5
> >>>>> },
> >>>>> {
> >>>>> "letter":"T",
> >>>>> "no":6
> >>>>> }
> >>>>> ]
> >>>>> },
> >>>>> {
> >>>>> "_id":"9",
> >>>>> "_rev":"2-3d68352a2d98c56fd322ae674fb7c38a",
> >>>>> "chr":[
> >>>>> {
> >>>>> "letter":"A",
> >>>>> "no":5
> >>>>> },
> >>>>> {
> >>>>> "letter":"G",
> >>>>> "no":6
> >>>>> }
> >>>>> ]
> >>>>> }
> >>>>> ]
> >>>>> }
> >>>>>
> >>>>> How is it possible to write a map function combine with the above
> >>> `judge`
> >>>>> function or maybe there is better way to do it?
> >>>>>
> >>>>> P.S. I also asked the same question here (
> >>
> http://stackoverflow.com/questions/27688196/map-function-with-a-helper-function-in-couchdb
> >>>>> )
> >>>>>
> >>>>> Thank you in advance.
> >>>>>
> >>>>> Mic
> >>
>
Re: map function with a helper function
Posted by Sebastian Rothbucher <se...@googlemail.com>.
Hi,
One more thing: you can not pass Parameters into the view ever. You have to create all items in a view via emit before there is one query actually running
What you can do, provided each document is small, is emit([no1, no2], null) for all no1 and no2 the document can potentially (!!!) match
Again: the document is doc, not 'this'
Plus don't emit the full doc as 2nd Param, That Most often just slows things down and is of no help. Null does it
Good luck - regards
Sebastian
Von meinem iPhone gesendet
> Am 06.01.2015 um 13:43 schrieb Mic <mi...@gmail.com>:
>
> Hi Sebastian,
> Thank you for your response. For the below documents I would like only get
> documents with the ids 7, 8 and 9, because chr.no = 5 and chr.no = 6
> (?key=[5,6]) only contains chr.letter between them which are not the same
> and do not have X.
>
> Threfore I thought the judge function would be useful, but maybe in CouchDB
> is there a better way to do it.
>
> {
> "total_rows":5,
> "offset":0,
> "rows":[
> {
> "_id":"10",
> "_rev":"3-5288068d2c4ef3e6a9d3f8ff4e3377dd",
> "chr":[
> {
> "letter":"T",
> "no":4
> },
> {
> "letter":"A",
> "no":5
> },
> {
> "letter":"X",
> "no":6
> }
> ]
> },
> {
> "_id":"14",
> "_rev":"3-21300d06c31224416b8ff71b71b304d8",
> "chr":[
> {
> "letter":"T",
> "no":4
> },
> {
> "letter":"G",
> "no":5
> },
> {
> "letter":"G",
> "no":6
> }
> ]
> },
> {
> "_id":"7",
> "_rev":"2-1516ba547bdd21724158bc854f39f66b",
> "chr":[
> {
> "letter":"C",
> "no":5
> },
> {
> "letter":"T",
> "no":6
> }
> ]
> },
> {
> "_id":"8",
> "_rev":"2-750078ccc9e74616f33a2537e41b8414",
> "chr":[
> {
> "letter":"C",
> "no":5
> },
> {
> "letter":"T",
> "no":6
> }
> ]
> },
> {
> "_id":"9",
> "_rev":"2-3d68352a2d98c56fd322ae674fb7c38a",
> "chr":[
> {
> "letter":"A",
> "no":5
> },
> {
> "letter":"G",
> "no":6
> }
> ]
> }
> ]
> }
>
> Best wishes,
>
> Mic
>
> On Tue, Jan 6, 2015 at 4:41 AM, Sebastian Rothbucher <
> sebastianrothbucher@googlemail.com> wrote:
>
>> Hi Mic,
>>
>> the general misconception here seems to be that "this" within map refers to
>> the design doc, i.e. you'd have to have "chr" w/in the design doc - which
>> is not the case in the example you have given.
>> I think it would help to explain what you want to achieve with "judge" in
>> the first place...
>>
>> Regards
>> Sebastian
>>
>>> On Thu, Jan 1, 2015 at 6:06 AM, Mic <mi...@gmail.com> wrote:
>>>
>>> Hi Sinan,
>>> Thank you for the links and your suggestions. However, I did not quite
>>> understand your suggestions and I tried this map function which did not
>>> work:
>>>
>>> function(doc) {
>>> var judge = function (no1, no2) {
>>> var unexpect = "X";
>>> var letter1 = unexpect, letter2 = unexpect;
>>> for (var i in this.chr) {
>>> var chr = this.chr[i];
>>> if (chr.no == no1) {
>>> letter1 = chr.letter;
>>> } else if (chr.no == no2) {
>>> letter2 = chr.letter;
>>> }
>>> }
>>> if (letter1 != letter2 && letter1 != unexpect && letter2 !=
>>> unexpect) {
>>> return true;
>>> }
>>> return false;
>>> };
>>>
>>>
>>> emit(judge(n1, n2), doc);
>>> }
>>>
>>> Could you please explain your ideas a little more?
>>>
>>> Thank you in advance.
>>>
>>> Mic
>>>
>>> On Wed, Dec 31, 2014 at 10:57 PM, Sinan Gabel <si...@gmail.com>
>>> wrote:
>>>
>>>> Hi!
>>>>
>>>> You may want to take a look at the basics here:
>>>> http://docs.couchdb.org/en/latest/couchapp/views/index.html and
>> Cloudant
>>>> has some interactive samples at:
>>>> https://cloudant.com/for-developers/all_docs/
>>>>
>>>> *Using map*: You may want to emit the letters and use keys to find the
>>>> docs.
>>>>
>>>> *Not using map*: Name each doc something "smart", and use keys to find
>>> the
>>>> docs.
>>>>
>>>> Br,
>>>> Sinan
>>>>
>>>>> On 31 December 2014 at 13:05, Mic <mi...@gmail.com> wrote:
>>>>>
>>>>> Hi,
>>>>> I tried to create a map function which should use the following
>>>> conditions:
>>>>>
>>>>> - e.g. chr.no = 5 and chr.no = 6
>>>>> - chr.letter between two objects/dicts in chr are not the same and
>> no
>>> X
>>>>>
>>>>> I have the following function but I do not know how to combine it
>> with
>>>>> `emit`
>>>>>
>>>>> var judge = function (no1, no2) {
>>>>> var unexpect = "X";
>>>>> var letter1 = unexpect, letter2 = unexpect;
>>>>> for (var i in this.chr) {
>>>>> var chr = this.chr[i];
>>>>> if (chr.no == no1) {
>>>>> letter1 = chr.letter;
>>>>> } else if (chr.no == no2) {
>>>>> letter2 = chr.letter;
>>>>> }
>>>>> }
>>>>> if (letter1 != letter2 && letter1 != unexpect && letter2 !=
>>>>> unexpect) {
>>>>> return true;
>>>>> }
>>>>> return false;
>>>>> };
>>>>>
>>>>>
>>>>> CouchDB has the below content:
>>>>>
>>>>>
>>>>> {
>>>>> "total_rows":5,
>>>>> "offset":0,
>>>>> "rows":[
>>>>> {
>>>>> "_id":"10",
>>>>> "_rev":"3-5288068d2c4ef3e6a9d3f8ff4e3377dd",
>>>>> "chr":[
>>>>> {
>>>>> "letter":"T",
>>>>> "no":4
>>>>> },
>>>>> {
>>>>> "letter":"A",
>>>>> "no":5
>>>>> },
>>>>> {
>>>>> "letter":"X",
>>>>> "no":6
>>>>> }
>>>>> ]
>>>>> },
>>>>> {
>>>>> "_id":"14",
>>>>> "_rev":"3-21300d06c31224416b8ff71b71b304d8",
>>>>> "chr":[
>>>>> {
>>>>> "letter":"T",
>>>>> "no":4
>>>>> },
>>>>> {
>>>>> "letter":"G",
>>>>> "no":5
>>>>> },
>>>>> {
>>>>> "letter":"G",
>>>>> "no":6
>>>>> }
>>>>> ]
>>>>> },
>>>>> {
>>>>> "_id":"7",
>>>>> "_rev":"2-1516ba547bdd21724158bc854f39f66b",
>>>>> "chr":[
>>>>> {
>>>>> "letter":"C",
>>>>> "no":5
>>>>> },
>>>>> {
>>>>> "letter":"T",
>>>>> "no":6
>>>>> }
>>>>> ]
>>>>> },
>>>>> {
>>>>> "_id":"8",
>>>>> "_rev":"2-750078ccc9e74616f33a2537e41b8414",
>>>>> "chr":[
>>>>> {
>>>>> "letter":"C",
>>>>> "no":5
>>>>> },
>>>>> {
>>>>> "letter":"T",
>>>>> "no":6
>>>>> }
>>>>> ]
>>>>> },
>>>>> {
>>>>> "_id":"9",
>>>>> "_rev":"2-3d68352a2d98c56fd322ae674fb7c38a",
>>>>> "chr":[
>>>>> {
>>>>> "letter":"A",
>>>>> "no":5
>>>>> },
>>>>> {
>>>>> "letter":"G",
>>>>> "no":6
>>>>> }
>>>>> ]
>>>>> }
>>>>> ]
>>>>> }
>>>>>
>>>>> How is it possible to write a map function combine with the above
>>> `judge`
>>>>> function or maybe there is better way to do it?
>>>>>
>>>>> P.S. I also asked the same question here (
>> http://stackoverflow.com/questions/27688196/map-function-with-a-helper-function-in-couchdb
>>>>> )
>>>>>
>>>>> Thank you in advance.
>>>>>
>>>>> Mic
>>
Re: map function with a helper function
Posted by Mic <mi...@gmail.com>.
Hi Sebastian,
Thank you for your response. For the below documents I would like only get
documents with the ids 7, 8 and 9, because chr.no = 5 and chr.no = 6
(?key=[5,6]) only contains chr.letter between them which are not the same
and do not have X.
Threfore I thought the judge function would be useful, but maybe in CouchDB
is there a better way to do it.
{
"total_rows":5,
"offset":0,
"rows":[
{
"_id":"10",
"_rev":"3-5288068d2c4ef3e6a9d3f8ff4e3377dd",
"chr":[
{
"letter":"T",
"no":4
},
{
"letter":"A",
"no":5
},
{
"letter":"X",
"no":6
}
]
},
{
"_id":"14",
"_rev":"3-21300d06c31224416b8ff71b71b304d8",
"chr":[
{
"letter":"T",
"no":4
},
{
"letter":"G",
"no":5
},
{
"letter":"G",
"no":6
}
]
},
{
"_id":"7",
"_rev":"2-1516ba547bdd21724158bc854f39f66b",
"chr":[
{
"letter":"C",
"no":5
},
{
"letter":"T",
"no":6
}
]
},
{
"_id":"8",
"_rev":"2-750078ccc9e74616f33a2537e41b8414",
"chr":[
{
"letter":"C",
"no":5
},
{
"letter":"T",
"no":6
}
]
},
{
"_id":"9",
"_rev":"2-3d68352a2d98c56fd322ae674fb7c38a",
"chr":[
{
"letter":"A",
"no":5
},
{
"letter":"G",
"no":6
}
]
}
]
}
Best wishes,
Mic
>
>
On Tue, Jan 6, 2015 at 4:41 AM, Sebastian Rothbucher <
sebastianrothbucher@googlemail.com> wrote:
> Hi Mic,
>
> the general misconception here seems to be that "this" within map refers to
> the design doc, i.e. you'd have to have "chr" w/in the design doc - which
> is not the case in the example you have given.
> I think it would help to explain what you want to achieve with "judge" in
> the first place...
>
> Regards
> Sebastian
>
> On Thu, Jan 1, 2015 at 6:06 AM, Mic <mi...@gmail.com> wrote:
>
> > Hi Sinan,
> > Thank you for the links and your suggestions. However, I did not quite
> > understand your suggestions and I tried this map function which did not
> > work:
> >
> > function(doc) {
> > var judge = function (no1, no2) {
> > var unexpect = "X";
> > var letter1 = unexpect, letter2 = unexpect;
> > for (var i in this.chr) {
> > var chr = this.chr[i];
> > if (chr.no == no1) {
> > letter1 = chr.letter;
> > } else if (chr.no == no2) {
> > letter2 = chr.letter;
> > }
> > }
> > if (letter1 != letter2 && letter1 != unexpect && letter2 !=
> > unexpect) {
> > return true;
> > }
> > return false;
> > };
> >
> >
> > emit(judge(n1, n2), doc);
> > }
> >
> > Could you please explain your ideas a little more?
> >
> > Thank you in advance.
> >
> > Mic
> >
> > On Wed, Dec 31, 2014 at 10:57 PM, Sinan Gabel <si...@gmail.com>
> > wrote:
> >
> > > Hi!
> > >
> > > You may want to take a look at the basics here:
> > > http://docs.couchdb.org/en/latest/couchapp/views/index.html and
> Cloudant
> > > has some interactive samples at:
> > > https://cloudant.com/for-developers/all_docs/
> > >
> > > *Using map*: You may want to emit the letters and use keys to find the
> > > docs.
> > >
> > > *Not using map*: Name each doc something "smart", and use keys to find
> > the
> > > docs.
> > >
> > > Br,
> > > Sinan
> > >
> > > On 31 December 2014 at 13:05, Mic <mi...@gmail.com> wrote:
> > >
> > > > Hi,
> > > > I tried to create a map function which should use the following
> > > conditions:
> > > >
> > > > - e.g. chr.no = 5 and chr.no = 6
> > > > - chr.letter between two objects/dicts in chr are not the same and
> no
> > X
> > > >
> > > > I have the following function but I do not know how to combine it
> with
> > > > `emit`
> > > >
> > > > var judge = function (no1, no2) {
> > > > var unexpect = "X";
> > > > var letter1 = unexpect, letter2 = unexpect;
> > > > for (var i in this.chr) {
> > > > var chr = this.chr[i];
> > > > if (chr.no == no1) {
> > > > letter1 = chr.letter;
> > > > } else if (chr.no == no2) {
> > > > letter2 = chr.letter;
> > > > }
> > > > }
> > > > if (letter1 != letter2 && letter1 != unexpect && letter2 !=
> > > > unexpect) {
> > > > return true;
> > > > }
> > > > return false;
> > > > };
> > > >
> > > >
> > > > CouchDB has the below content:
> > > >
> > > >
> > > > {
> > > > "total_rows":5,
> > > > "offset":0,
> > > > "rows":[
> > > > {
> > > > "_id":"10",
> > > > "_rev":"3-5288068d2c4ef3e6a9d3f8ff4e3377dd",
> > > > "chr":[
> > > > {
> > > > "letter":"T",
> > > > "no":4
> > > > },
> > > > {
> > > > "letter":"A",
> > > > "no":5
> > > > },
> > > > {
> > > > "letter":"X",
> > > > "no":6
> > > > }
> > > > ]
> > > > },
> > > > {
> > > > "_id":"14",
> > > > "_rev":"3-21300d06c31224416b8ff71b71b304d8",
> > > > "chr":[
> > > > {
> > > > "letter":"T",
> > > > "no":4
> > > > },
> > > > {
> > > > "letter":"G",
> > > > "no":5
> > > > },
> > > > {
> > > > "letter":"G",
> > > > "no":6
> > > > }
> > > > ]
> > > > },
> > > > {
> > > > "_id":"7",
> > > > "_rev":"2-1516ba547bdd21724158bc854f39f66b",
> > > > "chr":[
> > > > {
> > > > "letter":"C",
> > > > "no":5
> > > > },
> > > > {
> > > > "letter":"T",
> > > > "no":6
> > > > }
> > > > ]
> > > > },
> > > > {
> > > > "_id":"8",
> > > > "_rev":"2-750078ccc9e74616f33a2537e41b8414",
> > > > "chr":[
> > > > {
> > > > "letter":"C",
> > > > "no":5
> > > > },
> > > > {
> > > > "letter":"T",
> > > > "no":6
> > > > }
> > > > ]
> > > > },
> > > > {
> > > > "_id":"9",
> > > > "_rev":"2-3d68352a2d98c56fd322ae674fb7c38a",
> > > > "chr":[
> > > > {
> > > > "letter":"A",
> > > > "no":5
> > > > },
> > > > {
> > > > "letter":"G",
> > > > "no":6
> > > > }
> > > > ]
> > > > }
> > > > ]
> > > > }
> > > >
> > > > How is it possible to write a map function combine with the above
> > `judge`
> > > > function or maybe there is better way to do it?
> > > >
> > > > P.S. I also asked the same question here (
> > > >
> > > >
> > >
> >
> http://stackoverflow.com/questions/27688196/map-function-with-a-helper-function-in-couchdb
> > > > )
> > > >
> > > > Thank you in advance.
> > > >
> > > > Mic
> > > >
> > >
> >
>
Re: map function with a helper function
Posted by Sebastian Rothbucher <se...@googlemail.com>.
Hi Mic,
the general misconception here seems to be that "this" within map refers to
the design doc, i.e. you'd have to have "chr" w/in the design doc - which
is not the case in the example you have given.
I think it would help to explain what you want to achieve with "judge" in
the first place...
Regards
Sebastian
On Thu, Jan 1, 2015 at 6:06 AM, Mic <mi...@gmail.com> wrote:
> Hi Sinan,
> Thank you for the links and your suggestions. However, I did not quite
> understand your suggestions and I tried this map function which did not
> work:
>
> function(doc) {
> var judge = function (no1, no2) {
> var unexpect = "X";
> var letter1 = unexpect, letter2 = unexpect;
> for (var i in this.chr) {
> var chr = this.chr[i];
> if (chr.no == no1) {
> letter1 = chr.letter;
> } else if (chr.no == no2) {
> letter2 = chr.letter;
> }
> }
> if (letter1 != letter2 && letter1 != unexpect && letter2 !=
> unexpect) {
> return true;
> }
> return false;
> };
>
>
> emit(judge(n1, n2), doc);
> }
>
> Could you please explain your ideas a little more?
>
> Thank you in advance.
>
> Mic
>
> On Wed, Dec 31, 2014 at 10:57 PM, Sinan Gabel <si...@gmail.com>
> wrote:
>
> > Hi!
> >
> > You may want to take a look at the basics here:
> > http://docs.couchdb.org/en/latest/couchapp/views/index.html and Cloudant
> > has some interactive samples at:
> > https://cloudant.com/for-developers/all_docs/
> >
> > *Using map*: You may want to emit the letters and use keys to find the
> > docs.
> >
> > *Not using map*: Name each doc something "smart", and use keys to find
> the
> > docs.
> >
> > Br,
> > Sinan
> >
> > On 31 December 2014 at 13:05, Mic <mi...@gmail.com> wrote:
> >
> > > Hi,
> > > I tried to create a map function which should use the following
> > conditions:
> > >
> > > - e.g. chr.no = 5 and chr.no = 6
> > > - chr.letter between two objects/dicts in chr are not the same and no
> X
> > >
> > > I have the following function but I do not know how to combine it with
> > > `emit`
> > >
> > > var judge = function (no1, no2) {
> > > var unexpect = "X";
> > > var letter1 = unexpect, letter2 = unexpect;
> > > for (var i in this.chr) {
> > > var chr = this.chr[i];
> > > if (chr.no == no1) {
> > > letter1 = chr.letter;
> > > } else if (chr.no == no2) {
> > > letter2 = chr.letter;
> > > }
> > > }
> > > if (letter1 != letter2 && letter1 != unexpect && letter2 !=
> > > unexpect) {
> > > return true;
> > > }
> > > return false;
> > > };
> > >
> > >
> > > CouchDB has the below content:
> > >
> > >
> > > {
> > > "total_rows":5,
> > > "offset":0,
> > > "rows":[
> > > {
> > > "_id":"10",
> > > "_rev":"3-5288068d2c4ef3e6a9d3f8ff4e3377dd",
> > > "chr":[
> > > {
> > > "letter":"T",
> > > "no":4
> > > },
> > > {
> > > "letter":"A",
> > > "no":5
> > > },
> > > {
> > > "letter":"X",
> > > "no":6
> > > }
> > > ]
> > > },
> > > {
> > > "_id":"14",
> > > "_rev":"3-21300d06c31224416b8ff71b71b304d8",
> > > "chr":[
> > > {
> > > "letter":"T",
> > > "no":4
> > > },
> > > {
> > > "letter":"G",
> > > "no":5
> > > },
> > > {
> > > "letter":"G",
> > > "no":6
> > > }
> > > ]
> > > },
> > > {
> > > "_id":"7",
> > > "_rev":"2-1516ba547bdd21724158bc854f39f66b",
> > > "chr":[
> > > {
> > > "letter":"C",
> > > "no":5
> > > },
> > > {
> > > "letter":"T",
> > > "no":6
> > > }
> > > ]
> > > },
> > > {
> > > "_id":"8",
> > > "_rev":"2-750078ccc9e74616f33a2537e41b8414",
> > > "chr":[
> > > {
> > > "letter":"C",
> > > "no":5
> > > },
> > > {
> > > "letter":"T",
> > > "no":6
> > > }
> > > ]
> > > },
> > > {
> > > "_id":"9",
> > > "_rev":"2-3d68352a2d98c56fd322ae674fb7c38a",
> > > "chr":[
> > > {
> > > "letter":"A",
> > > "no":5
> > > },
> > > {
> > > "letter":"G",
> > > "no":6
> > > }
> > > ]
> > > }
> > > ]
> > > }
> > >
> > > How is it possible to write a map function combine with the above
> `judge`
> > > function or maybe there is better way to do it?
> > >
> > > P.S. I also asked the same question here (
> > >
> > >
> >
> http://stackoverflow.com/questions/27688196/map-function-with-a-helper-function-in-couchdb
> > > )
> > >
> > > Thank you in advance.
> > >
> > > Mic
> > >
> >
>