开发者

How do I do the SQL equivalent of "DISTINCT" in CouchDB?

开发者 https://www.devze.com 2022-12-24 05:13 出处:网络
I have a bunch of 开发者_如何学PythonMP3 metadata in CouchDB. I want to return every album that is in the MP3 metadata, but no duplicates.

I have a bunch of 开发者_如何学PythonMP3 metadata in CouchDB. I want to return every album that is in the MP3 metadata, but no duplicates.

A typical document looks like this:

{
   "_id": "005e16a055ba78589695c583fbcdf7e26064df98",
   "_rev": "2-87aa12c52ee0a406084b09eca6116804",
   "name": "Fifty-Fifty Clown",
   "number": 15,
   "artist": "Cocteau Twins",
   "bitrate": 320,
   "album": "Stars and Topsoil: A Collection (1982-1990)",
   "path": "Cocteau Twins/Stars and Topsoil: A Collection (1982-1990)/15 - Fifty-Fifty Clown.mp3",
   "year": 0,
   "genre": "Shoegaze"
}


I believe your map/reduce would look something like:

function map(doc) {
    emit(doc.album, null);
}

function reduce(key, values) {
    return null;
}

Remember to query with the extra parameter group=true


Have a look at View Cookbook for SQL Jockeys' Get Unique Values section.

0

精彩评论

暂无评论...
验证码 换一张
取 消