Ana Paula Gomes anapaulagomes
anapaulagomes
/ gist:377caf9fd44554a3c5a7
Created
September 15, 2015 15:12
Atualiza vários registros de um campo com base em uma consulta
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.collection.update({'base.classe': 'turist'}, {$set: {'base.classe': 'turista'}}, {multi: true}) |
anapaulagomes
/ gist:25a147c273af7ad0c4e7
Created
September 8, 2015 03:44
Calcula a média de um atributo de um vetor excluindo um atributo desejado - MongoDB
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.grades.aggregate([ | |
| { $unwind : "$scores" }, | |
| { $project : { type : "$scores.type" , score: "$scores.score", class_id: "$class_id"} }, | |
| { $match : { type : { $ne : "atributo_que_quer_excluir" } } }, | |
| { $group: | |
| { | |
| _id: '$class_id', | |
| media: {$avg: '$score'} | |
| } |
anapaulagomes
/ gist:7083e1d292e6c9d47308
Created
September 8, 2015 02:58
Agrupa de acordo com parâmetros de busca e soma de acordo com um parâmetro da coleção - MongoDB
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.checkins.aggregate([ | |
| { $match : | |
| { | |
| nome: 'AKB48劇場 (AKB48 Theater)', | |
| classe: 'turista' } | |
| }, | |
| {$group: | |
| { | |
| _id: '$horario', | |
| checkins: {$sum: 1}} |
anapaulagomes
/ gist:e6ce97efad0b2cb49fc6
Last active
November 22, 2016 18:53
Count unique records according to parameters - MongoDB
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.checkins.distinct('name', {city: 'london', class: 'resident'}).length; |
anapaulagomes
/ gist:b5d6c5b6d06584c9a774
Created
September 8, 2015 02:55
Cria um vetor com os atributos encontrados e soma-os - MongoDB
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
| var pipeline = [ | |
| { $group: { | |
| _id:{'members': '$member.name'}, | |
| events:{$addToSet: '$event.name'}, | |
| number_events:{$sum:1}} | |
| }, | |
| {$sort: {number_events:-1} } | |
| ] | |
| db.rsvps.aggregate(pipeline) |
anapaulagomes
/ gist:138958fceb012c9616cb
Last active
December 19, 2016 16:59
Group array attributes, sum then and order from the biggest to the smallest - MongoDB
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
| var pipeline = [{$unwind: '$comments'}, {$group: {_id: '$comments.author', numberOf: {$sum: 1}}}, {$sort: {numberOf:-1}}] | |
| db.posts.aggregate(pipeline) |
anapaulagomes
/ gist:18be9028e92b5033c0b4
Last active
December 29, 2020 15:37
Agrupa e calcula a média com aggregate - MongoDB
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.zips.aggregate([ | |
| { | |
| $match: { | |
| $and : [ | |
| { $or: [ { state: 'XX' }, { state: 'YY' } ] }, { pop: {$gte: 25000}} | |
| ]} | |
| }, | |
| { | |
| $group: | |
| { |
NewerOlder