JSON 1
{ "_id" : ObjectId("6101b787ad5377c81a8c451f"), "acnh" : { "name" : "Coach", "type" : "Bull", "birthday" : "29 de Abril-Touro", "nitialPhrase" : "LET'S GO TEAM! WOOOOOOOOO!", "skill" : "eating quickly", "goal" : "fisherman", "favoriteSong" : "Mr.K.K" }, "personality" : { "personality" : "jock", "interests" : "great interest in sports and bodybuilding", "relationship" : " get along with peppy, cranky and sisterly villagers" }, "house" : "A gym for athletic contests" }
JSON 2
{ "_id" : ObjectId("6101b8fcad5377c81a8c4563"), "acnh" : { "name" : "Cyd", "type" : "Elephant", "birthday" : "June 9th (Gemini)", "nitialPhrase" : "Y'know, I do believe I recognize a few of these folks from back in the day! Gahaha!", "skill" : "guitar playing", "goal" : "rock star", "favoriteSong" : "K.K.metal" }, "personality" : { "personality" : "cranky", "interests" : "great interest in sports and bodybuilding", "relationship" : "get along with jock, snooty and other cranky villagers, and occasionally lazy and normal villagers" }, "house" : "punk/metal theme" }
JSON 3
{ "_id" : ObjectId("6101b9b2ad5377c81a8c458b"), "acnh" : { "name" : "Drago", "type" : "Alligator", "birthday" : "February 12th (Aquarius)", "nitialPhrase" : "This might sound kind of weird, but I really love the smell of dirt, burrrn.", "skill" : "blowing bubbles", "goal" : "pilot", "favoriteSong" : "imperial K.K." }, "personality" : { "personality" : "lazy", "interests" : "a love of food and relaxing", "relationship" : "get along well with other villagers" }, "house" : "many furniture pieces from the Imperial set" }
JSON 4
{ "_id" : ObjectId("6101bb92ad5377c81a8c45e7"), "acnh" : { "name" : "Mira", "type" : "rabbit", "birthday" : "July 6th (Cancer)", "nitialPhrase" : "You can wear it and show me how to make it look good! Thanks for the delivery! Cottontail!", "skill" : "telling jokes", "goal" : "make up artist", "favoriteSong" : "go K.k. rider" }, "personality" : { "personality" : "sisterly", "interests" : "care deeply about her appearance", "relationship" : "get along with jock villagers who share her love of sports, lazy villagers for how laid-back they are, and peppy villagers." }, "house" : "A futuristic space" }
JSON 5
{ "_id" : ObjectId("6101bcc3ad5377c81a8c4623"), "acnh" : { "name" : "Gruff", "type" : "goat", "birthday" : "August 29th (Virgo)", "nitialPhrase" : "How about this weather, huh? It's like the sun's taken a...shine...to us! You get it? Bleh eh eh!", "skill" : "staying up late", "goal" : "musician", "favoriteSong" : "K.K. Rockabilly" }, "personality" : { "personality" : "cranky", "interests" : "often challenge the player to various competitions", "relationship" : "get along with jock, snooty and other cranky villagers, and occasionally lazy and normal villagers as well" }, "house" : "Gruff owns four different kinds of guitars, a piano, a jukebox, and a bass, which gives his house a rather musical appearance" }
JSON 6
{ "_id" : ObjectId("6101bde3ad5377c81a8c4659"), "acnh" : { "name" : "Croque", "type" : "frog", "birthday" : "July 18th (Cancer)", "nitialPhrase" : "Hey, you smell that fresh air? Yeah, you should savor that for as long as possible. No, I mean it. I had tacos for lunch. So enjoy the fresh air while you can.", "skill" : "staying up late", "goal" : "achitect", "favoriteSong" : "K.K. Folk" }, "personality" : { "personality" : "cranky", "interests" : "enjoy spreading rumors about other villagers.", "relationship" : "get along with jock, snooty and other cranky villagers, and occasionally lazy and normal villagers as well" }, "house" : "looks much like an autumnal forest" }
db.getCollection('consultas').update(
{
"personality.personality":"crancky"
},
{ $set:
{
"opinion":"good friend"
}
},
{
"multi":true
}
)
db.getCollection('consultas').remove({'acnh.goal':'make up artist'});
db.getCollection('consultas').find({},("acnh.birthday":1,"_id":0))
db.getCollection('consultas').find({ "personality.relationship" : /.along with jock./})
db.getCollection('consultas').find({$or:[{"personality.personality":/.cra./}]})
db.getCollection('consultas').find({"personality.personality":"cranky", "villagers":{$gte:3}})
db.getCollection('consultas').find().skip(2)
db.getCollection('consultas').find({}).limit(2)
db.getCollection('consultas').find().sort({"acnh.name":1})
