Skip to content

Instantly share code, notes, and snippets.

View ahachete's full-sized avatar

Álvaro Hernández Tortosa ahachete

62 followers · 1 following
View GitHub Profile
@ahachete
ahachete / Stampede-GithubQuery-MongoDB-D
Created November 30, 2016 11:15
db.events.aggregate(
[
{ $match: { "payload.action": { $exists: true } } },
{ $group: { _id: "$payload.action", total: { $sum: 1 } } },
{ $sort: { total: 1 } }
],
{ allowDiskUse: true, cursor: { batchSize: 100000000 } }
);
@ahachete
ahachete / Stampede-GithubQuery-MongoDB-C
Created November 30, 2016 11:13
db.events.aggregate(
[
{ $group: { _id: "$type", total: { $sum: 1 } } },
{ $sort: { total: -1 } }
],
{ allowDiskUse: true, cursor: { batchSize: 100000000 } }
);
@ahachete
ahachete / Stampede-GithubQuery-MongoDB-B
Created November 30, 2016 11:06
db.events.aggregate(
[
{ $group: { _id: "$type", total: { $sum: 1 } } },
{ $sort: { total: 1 } }
],
{ allowDiskUse: true, cursor: { batchSize: 100000000 } }
);
@ahachete
ahachete / Stampede-GithubQuery-MongoDB-A
Created November 30, 2016 11:04
db.events.aggregate(
[
{ $match: {
$and: [ { type: "IssuesEvent"} , { "payload.action" : "opened" } ] }
},
{ $group: { _id: "$repo.name", total: { $sum: 1 } } },
{ $sort: { total: -1 } }
],
{ allowDiskUse: true, cursor: { batchSize: 100000000 } }
);