Created
December 12, 2014 00:27
-
-
Save acdcjunior/f8c9a6df7f3f41d600c4 to your computer and use it in GitHub Desktop.
PouchDB/CouchDB Map/Reduce GROUP BY Example
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html> | |
| <head> | |
| <script src="//cdn.jsdelivr.net/pouchdb/3.2.0/pouchdb.min.js"></script> | |
| <script src="pouchdbMapReduceGroupByExample.js"></script> | |
| </head> | |
| <body> | |
| </body> | |
| </html> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| var db = new PouchDB('groupByTest'); | |
| //db.destroy(); | |
| db.bulkDocs([ | |
| {"_id": "1", "title": "Rambo", "year": 2008, "genre": "Action"}, | |
| {"_id": "2", "title": "Forrest Gump", "year": 1994, "genre": "Drama"}, | |
| {"_id": "3", "title": "Gladiator", "year": 2000, "genre": "Action"}, | |
| {"_id": "4", "title": "The Mask", "year": 1994, "genre": "Comedy"} | |
| ]).then(function () { | |
| var map = function(doc) { | |
| emit(doc.genre, 1); | |
| }; | |
| var reduce = function(keys, values, rereduce) { | |
| return sum(values); | |
| }; | |
| // if you are just summing (like the reduce function above is), it is better to use the build-in sum | |
| reduce = "_sum"; | |
| db.query({map: map, reduce: reduce}, {reduce: true, group: true, group_level: 1}, function(err, response) { | |
| console.log(JSON.stringify(response.rows)); | |
| /* The result: | |
| [ | |
| {"key":"Action", "value":2}, | |
| {"key":"Comedy", "value":1}, | |
| {"key":"Drama", "value":1} | |
| ] | |
| */ | |
| }); | |
| }); |
cannot find name "sum" I GOT this error how to solve
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
As seen in http://acdcjunior.github.io/querying-couchdb-pouchdb-map-reduce-group-by-example.html