Danny Freed dannyfreed
dannyfreed
/ messaging_by_user
Created
September 30, 2017 18:16
count active users by received message
This file contains hidden or 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
| db.messages.aggregate( | |
| [ | |
| { | |
| $match: { | |
| timestamp: {$gte: ISODate("2017-09-30T00:00:00.0Z"), $lt: ISODate("2017-10-01T00:00:00.0Z")}, | |
| sentBy: 'human' | |
| } | |
| }, | |
| { | |
| $group : { |
dannyfreed
/ gist:5948c4d1ff0a2919b52f8e7f68b450a7
Created
August 19, 2017 04:09
count dupes in a mongo collection
This file contains hidden or 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
| db.users.aggregate( | |
| {"$group" : { "_id": "$fbid", "count": { "$sum": 1 } } }, | |
| {"$match": {"_id" :{ "$ne" : null } , "count" : {"$gt": 1} } }, | |
| {"$project": {"fbid" : "$_id", "_id" : 0} }, | |
| {"$sort": {"count" : -1} } | |
| ) |
dannyfreed
/ output an aggregate to a new collection
Created
September 28, 2016 03:59
This file contains hidden or 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
| db.journals.aggregate( | |
| [ | |
| { | |
| $group : { | |
| _id : { month: { $month: "$date" }, day: { $dayOfMonth: "$date" }, year: { $year: "$date" } }, | |
| count: { $sum: 1 } | |
| } | |
| }, | |
| {$sort: {_id: -1}}, |
This file contains hidden or 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
| db.journals.aggregate( | |
| [ | |
| { | |
| $group : { | |
| _id : "$fbid", | |
| count: { $sum: 1 } | |
| } | |
| }, | |
| {$sort: {count: -1}} | |
| ] |
dannyfreed
/ group by date and sort mongodb shell
Created
September 8, 2016 01:54
This file contains hidden or 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
| db.journals.aggregate( | |
| [ | |
| { | |
| $group : { | |
| _id : { month: { $month: "$date" }, day: { $dayOfMonth: "$date" }, year: { $year: "$date" } }, | |
| count: { $sum: 1 } | |
| } | |
| }, | |
| {$sort: {_id: -1}} |
This file contains hidden or 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
| db.users.aggregate([ | |
| { $group: { | |
| _id: { fbid: "$fbid" }, | |
| dups: { $addToSet: "$_id" }, | |
| count: { $sum: 1 } | |
| }}, | |
| { $match: { | |
| count: {$gt: 1} | |
| }} | |
| ]).forEach(function(doc) { |