===Chapter-1=== > db.unicorns.insert({name: 'Aurora', ... gender: 'f', weight: 450}) > db.unicorns.find() { "_id" : ObjectId("526328ee7023ef178f1b6636"), "name" : "Aurora", "gender" : "f", "weight" : 450 } > > db.unicorns.find() { "_id" : ObjectId("526328ee7023ef178f1b6636"), "name" : "Aurora", "gender" : "f", "weight" : 450 } > > > db.system.indexes.find() { "v" : 1, "key" : { "_id" : 1 }, "ns" : "test.nettuts", "name" : "_id_" } { "v" : 1, "key" : { "_id" : 1 }, "ns" : "test.unicorns", "name" : "_id_" } > > > db.unicorns.insert({name: 'Leto', ... gender: 'm', ... home: 'Arrakeen', ... worm: false}) > > > db.unicorns.find() { "_id" : ObjectId("526328ee7023ef178f1b6636"), "name" : "Aurora", "gender" : "f", "weight" : 450 } { "_id" : ObjectId("52632aa17023ef178f1b6637"), "name" : "Leto", "gender" : "m", "home" : "Arrakeen", "worm" : false } > > > > > db.unicorns.remove() > > > db.unicorns.insert({name: 'Horny', ... dob: new Date(1992,2,13,7,47), ... loves: ['carrot','papaya'], ... weight: 600, ... gender: 'm', ... vampires: 63}); > db.unicorns.insert({name: 'Aurora', ... dob: new Date(1991, 0, 24, 13, 0), ... loves: ['carrot', 'grape'], ... weight: 450, ... gender: 'f', ... vampires: 43}); > db.unicorns.insert({name: 'Unicrom', ... dob: new Date(1973, 1, 9, 22, 10), ... loves: ['energon', 'redbull'], ... weight: 984, ... gender: 'm', ... vampires: 182}); > db.unicorns.insert({name: 'Roooooodles', ... dob: new Date(1979, 7, 18, 18, 44), ... loves: ['apple'], ... weight: 575, ... gender: 'm', ... vampires: 99}); > db.unicorns.insert({name: 'Solnara', ... dob: new Date(1985, 6, 4, 2, 1), ... loves:['apple', 'carrot', ... 'chocolate'], ... weight:550, ... gender:'f', ... vampires:80}); > db.unicorns.insert({name:'Ayna', ... dob: new Date(1998, 2, 7, 8, 30), ... loves: ['strawberry', 'lemon'], ... weight: 733, ... gender: 'f', ... vampires: 40}); > db.unicorns.insert({name:'Kenny', ... dob: new Date(1997, 6, 1, 10, 42), ... loves: ['grape', 'lemon'], ... weight: 690, ... gender: 'm', ... vampires: 39}); > db.unicorns.insert({name: 'Raleigh', ... dob: new Date(2005, 4, 3, 0, 57), ... loves: ['apple', 'sugar'], ... weight: 421, ... gender: 'm', ... vampires: 2}); > db.unicorns.insert({name: 'Leia', ... dob: new Date(2001, 9, 8, 14, 53), ... loves: ['apple', 'watermelon'], ... weight: 601, ... gender: 'f', ... vampires: 33}); > db.unicorns.insert({name: 'Pilot', ... dob: new Date(1997, 2, 1, 5, 3), ... loves: ['apple', 'watermelon'], ... weight: 650, ... gender: 'm', ... vampires: 54}); > db.unicorns.insert({name: 'Nimue', ... dob: new Date(1999, 11, 20, 16, 15), ... loves: ['grape', 'carrot'], ... weight: 540, ... gender: 'f'}); > db.unicorns.insert({name: 'Dunx', ... dob: new Date(1976, 6, 18, 18, 18), ... loves: ['grape', 'watermelon'], ... weight: 704, ... gender: 'm', ... vampires: 165}); > > > > > > > db.unicorns.find({gender: 'm', ... weight: {$gt: 700}}) { "_id" : ObjectId("52632b757023ef178f1b663a"), "name" : "Unicrom", "dob" : ISODate("1973-02-10T03:10:00Z"), "loves" : [ "energon", "redbull" ], "weight" : 984, "gender" : "m", "vampires" : 182 } { "_id" : ObjectId("52632b767023ef178f1b6643"), "name" : "Dunx", "dob" : ISODate("1976-07-18T22:18:00Z"), "loves" : [ "grape", "watermelon" ], "weight" : 704, "gender" : "m", "vampires" : 165 } > //or (not quite the same thing, but for > //demonstration purposes) > db.unicorns.find({gender: {$ne: 'f'}, ... weight: {$gte: 701}}) { "_id" : ObjectId("52632b757023ef178f1b663a"), "name" : "Unicrom", "dob" : ISODate("1973-02-10T03:10:00Z"), "loves" : [ "energon", "redbull" ], "weight" : 984, "gender" : "m", "vampires" : 182 } { "_id" : ObjectId("52632b767023ef178f1b6643"), "name" : "Dunx", "dob" : ISODate("1976-07-18T22:18:00Z"), "loves" : [ "grape", "watermelon" ], "weight" : 704, "gender" : "m", "vampires" : 165 } > > > > db.unicorns.find({ ... vampires: {$exists: false}}) { "_id" : ObjectId("52632b757023ef178f1b6642"), "name" : "Nimue", "dob" : ISODate("1999-12-20T21:15:00Z"), "loves" : [ "grape", "carrot" ], "weight" : 540, "gender" : "f" } > > > db.unicorns.find({gender: 'f', ... $or: [{loves: 'apple'}, ... {loves: 'orange'}, ... {weight: {$lt: 500}}]}) { "_id" : ObjectId("52632b757023ef178f1b6639"), "name" : "Aurora", "dob" : ISODate("1991-01-24T18:00:00Z"), "loves" : [ "carrot", "grape" ], "weight" : 450, "gender" : "f", "vampires" : 43 } { "_id" : ObjectId("52632b757023ef178f1b663c"), "name" : "Solnara", "dob" : ISODate("1985-07-04T06:01:00Z"), "loves" : [ "apple", "carrot", "chocolate" ], "weight" : 550, "gender" : "f", "vampires" : 80 } { "_id" : ObjectId("52632b757023ef178f1b6640"), "name" : "Leia", "dob" : ISODate("2001-10-08T18:53:00Z"), "loves" : [ "apple", "watermelon" ], "weight" : 601, "gender" : "f", "vampires" : 33 } > > > > > > db.unicorns.find( {_id: ObjectId("52632b757023ef178f1b6640")}) { "_id" : ObjectId("52632b757023ef178f1b6640"), "name" : "Leia", "dob" : ISODate("2001-10-08T18:53:00Z"), "loves" : [ "apple", "watermelon" ], "weight" : 601, "gender" : "f", "vampires" : 33 } > > > ===Chapter-2=== > db.unicorns.update({name: 'Roooooodles'}, ... {weight: 590}) > > > db.unicorns.remove() > > > db.unicorns.insert({name: 'Horny', ... dob: new Date(1992,2,13,7,47), ... loves: ['carrot','papaya'], ... weight: 600, ... gender: 'm', ... vampires: 63}); > db.unicorns.insert({name: 'Aurora', ... dob: new Date(1991, 0, 24, 13, 0), ... loves: ['carrot', 'grape'], ... weight: 450, ... gender: 'f', ... vampires: 43}); > db.unicorns.insert({name: 'Unicrom', ... dob: new Date(1973, 1, 9, 22, 10), ... loves: ['energon', 'redbull'], ... weight: 984, ... gender: 'm', ... vampires: 182}); > db.unicorns.insert({name: 'Roooooodles', ... dob: new Date(1979, 7, 18, 18, 44), ... loves: ['apple'], ... weight: 575, ... gender: 'm', ... vampires: 99}); > db.unicorns.insert({name: 'Solnara', ... dob: new Date(1985, 6, 4, 2, 1), ... loves:['apple', 'carrot', ... 'chocolate'], ... weight:550, ... gender:'f', ... vampires:80}); > db.unicorns.insert({name:'Ayna', ... dob: new Date(1998, 2, 7, 8, 30), ... loves: ['strawberry', 'lemon'], ... weight: 733, ... gender: 'f', ... vampires: 40}); > db.unicorns.insert({name:'Kenny', ... dob: new Date(1997, 6, 1, 10, 42), ... loves: ['grape', 'lemon'], ... weight: 690, ... gender: 'm', ... vampires: 39}); > db.unicorns.insert({name: 'Raleigh', ... dob: new Date(2005, 4, 3, 0, 57), ... loves: ['apple', 'sugar'], ... weight: 421, ... gender: 'm', ... vampires: 2}); > db.unicorns.insert({name: 'Leia', ... dob: new Date(2001, 9, 8, 14, 53), ... loves: ['apple', 'watermelon'], ... weight: 601, ... gender: 'f', ... vampires: 33}); > db.unicorns.insert({name: 'Pilot', ... dob: new Date(1997, 2, 1, 5, 3), ... loves: ['apple', 'watermelon'], ... weight: 650, ... gender: 'm', ... vampires: 54}); > db.unicorns.insert({name: 'Nimue', ... dob: new Date(1999, 11, 20, 16, 15), ... loves: ['grape', 'carrot'], ... weight: 540, ... gender: 'f'}); > db.unicorns.insert({name: 'Dunx', ... dob: new Date(1976, 6, 18, 18, 18), ... loves: ['grape', 'watermelon'], ... weight: 704, ... gender: 'm', ... vampires: 165}); > > > db.unicorns.find({name: 'Roooooodles'}) { "_id" : ObjectId("52632e567023ef178f1b6647"), "name" : "Roooooodles", "dob" : ISODate("1979-08-18T22:44:00Z"), "loves" : [ "apple" ], "weight" : 575, "gender" : "m", "vampires" : 99 } > > > db.unicorns.update({weight: 590}, {$set: { ... name: 'Roooooodles', ... dob: new Date(1979, 7, 18, 18, 44), ... loves: ['apple'], ... gender: 'm', ... vampires: 99}}) > > > db.unicorns.find({name: 'Roooooodles'}) { "_id" : ObjectId("52632e567023ef178f1b6647"), "name" : "Roooooodles", "dob" : ISODate("1979-08-18T22:44:00Z"), "loves" : [ "apple" ], "weight" : 575, "gender" : "m", "vampires" : 99 } > > > > > > db.unicorns.update({name: 'Roooooodles'}, ... {$set: {weight: 590}}) > > > db.unicorns.update({name: 'Pilot'}, ... {$inc: {vampires: -2}}) > > > db.unicorns.update({name: 'Aurora'}, ... {$push: {loves: 'sugar'}}) > > > db.hits.update({page: 'unicorns'}, ... {$inc: {hits: 1}}); > > > db.hits.find(); > > > db.hits.update({page: 'unicorns'}, ... {$inc: {hits: 1}}, true); > db.hits.find(); { "_id" : ObjectId("52632fb2ffbaa916e910db30"), "hits" : 1, "page" : "unicorns" } > > db.hits.update({page: 'unicorns'}, ... {$inc: {hits: 1}}, true); > db.hits.find(); { "_id" : ObjectId("52632fb2ffbaa916e910db30"), "hits" : 2, "page" : "unicorns" } > > > > > > db.unicorns.update({}, ... {$set: {vaccinated: true }}); > db.unicorns.find({vaccinated: true}); { "_id" : ObjectId("52632e567023ef178f1b6644"), "dob" : ISODate("1992-03-13T12:47:00Z"), "gender" : "m", "loves" : [ "carrot", "papaya" ], "name" : "Horny", "vaccinated" : true, "vampires" : 63, "weight" : 600 } > > > > db.unicorns.update({}, ... {$set: {vaccinated: true }}, ... false, true); > db.unicorns.find({vaccinated: true}); { "_id" : ObjectId("52632e567023ef178f1b6647"), "dob" : ISODate("1979-08-18T22:44:00Z"), "gender" : "m", "loves" : [ "apple" ], "name" : "Roooooodles", "vaccinated" : true, "vampires" : 99, "weight" : 590 } { "_id" : ObjectId("52632e567023ef178f1b6644"), "dob" : ISODate("1992-03-13T12:47:00Z"), "gender" : "m", "loves" : [ "carrot", "papaya" ], "name" : "Horny", "vaccinated" : true, "vampires" : 63, "weight" : 600 } { "_id" : ObjectId("52632e567023ef178f1b6646"), "dob" : ISODate("1973-02-10T03:10:00Z"), "gender" : "m", "loves" : [ "energon", "redbull" ], "name" : "Unicrom", "vaccinated" : true, "vampires" : 182, "weight" : 984 } { "_id" : ObjectId("52632e567023ef178f1b6648"), "dob" : ISODate("1985-07-04T06:01:00Z"), "gender" : "f", "loves" : [ "apple", "carrot", "chocolate" ], "name" : "Solnara", "vaccinated" : true, "vampires" : 80, "weight" : 550 } { "_id" : ObjectId("52632e567023ef178f1b6649"), "dob" : ISODate("1998-03-07T13:30:00Z"), "gender" : "f", "loves" : [ "strawberry", "lemon" ], "name" : "Ayna", "vaccinated" : true, "vampires" : 40, "weight" : 733 } { "_id" : ObjectId("52632e567023ef178f1b664a"), "dob" : ISODate("1997-07-01T14:42:00Z"), "gender" : "m", "loves" : [ "grape", "lemon" ], "name" : "Kenny", "vaccinated" : true, "vampires" : 39, "weight" : 690 } { "_id" : ObjectId("52632e567023ef178f1b664b"), "dob" : ISODate("2005-05-03T04:57:00Z"), "gender" : "m", "loves" : [ "apple", "sugar" ], "name" : "Raleigh", "vaccinated" : true, "vampires" : 2, "weight" : 421 } { "_id" : ObjectId("52632e567023ef178f1b664c"), "dob" : ISODate("2001-10-08T18:53:00Z"), "gender" : "f", "loves" : [ "apple", "watermelon" ], "name" : "Leia", "vaccinated" : true, "vampires" : 33, "weight" : 601 } { "_id" : ObjectId("52632e567023ef178f1b664d"), "dob" : ISODate("1997-03-01T10:03:00Z"), "gender" : "m", "loves" : [ "apple", "watermelon" ], "name" : "Pilot", "vaccinated" : true, "vampires" : 52, "weight" : 650 } { "_id" : ObjectId("52632e567023ef178f1b664e"), "dob" : ISODate("1999-12-20T21:15:00Z"), "gender" : "f", "loves" : [ "grape", "carrot" ], "name" : "Nimue", "vaccinated" : true, "weight" : 540 } { "_id" : ObjectId("52632e577023ef178f1b664f"), "dob" : ISODate("1976-07-18T22:18:00Z"), "gender" : "m", "loves" : [ "grape", "watermelon" ], "name" : "Dunx", "vaccinated" : true, "vampires" : 165, "weight" : 704 } { "_id" : ObjectId("52632e567023ef178f1b6645"), "dob" : ISODate("1991-01-24T18:00:00Z"), "gender" : "f", "loves" : [ "carrot", "grape", "sugar" ], "name" : "Aurora", "vaccinated" : true, "vampires" : 43, "weight" : 450 } > > > > ===Chapter-3=== > > > > > db.unicorns.find(null, {name: 1}); { "_id" : ObjectId("52632e567023ef178f1b6647"), "name" : "Roooooodles" } { "_id" : ObjectId("52632e567023ef178f1b6644"), "name" : "Horny" } { "_id" : ObjectId("52632e567023ef178f1b6646"), "name" : "Unicrom" } { "_id" : ObjectId("52632e567023ef178f1b6648"), "name" : "Solnara" } { "_id" : ObjectId("52632e567023ef178f1b6649"), "name" : "Ayna" } { "_id" : ObjectId("52632e567023ef178f1b664a"), "name" : "Kenny" } { "_id" : ObjectId("52632e567023ef178f1b664b"), "name" : "Raleigh" } { "_id" : ObjectId("52632e567023ef178f1b664c"), "name" : "Leia" } { "_id" : ObjectId("52632e567023ef178f1b664d"), "name" : "Pilot" } { "_id" : ObjectId("52632e567023ef178f1b664e"), "name" : "Nimue" } { "_id" : ObjectId("52632e577023ef178f1b664f"), "name" : "Dunx" } { "_id" : ObjectId("52632e567023ef178f1b6645"), "name" : "Aurora" } > > > > //heaviest unicorns first > db.unicorns.find().sort({weight: -1}) { "_id" : ObjectId("52632e567023ef178f1b6646"), "dob" : ISODate("1973-02-10T03:10:00Z"), "gender" : "m", "loves" : [ "energon", "redbull" ], "name" : "Unicrom", "vaccinated" : true, "vampires" : 182, "weight" : 984 } { "_id" : ObjectId("52632e567023ef178f1b6649"), "dob" : ISODate("1998-03-07T13:30:00Z"), "gender" : "f", "loves" : [ "strawberry", "lemon" ], "name" : "Ayna", "vaccinated" : true, "vampires" : 40, "weight" : 733 } { "_id" : ObjectId("52632e577023ef178f1b664f"), "dob" : ISODate("1976-07-18T22:18:00Z"), "gender" : "m", "loves" : [ "grape", "watermelon" ], "name" : "Dunx", "vaccinated" : true, "vampires" : 165, "weight" : 704 } { "_id" : ObjectId("52632e567023ef178f1b664a"), "dob" : ISODate("1997-07-01T14:42:00Z"), "gender" : "m", "loves" : [ "grape", "lemon" ], "name" : "Kenny", "vaccinated" : true, "vampires" : 39, "weight" : 690 } { "_id" : ObjectId("52632e567023ef178f1b664d"), "dob" : ISODate("1997-03-01T10:03:00Z"), "gender" : "m", "loves" : [ "apple", "watermelon" ], "name" : "Pilot", "vaccinated" : true, "vampires" : 52, "weight" : 650 } { "_id" : ObjectId("52632e567023ef178f1b664c"), "dob" : ISODate("2001-10-08T18:53:00Z"), "gender" : "f", "loves" : [ "apple", "watermelon" ], "name" : "Leia", "vaccinated" : true, "vampires" : 33, "weight" : 601 } { "_id" : ObjectId("52632e567023ef178f1b6644"), "dob" : ISODate("1992-03-13T12:47:00Z"), "gender" : "m", "loves" : [ "carrot", "papaya" ], "name" : "Horny", "vaccinated" : true, "vampires" : 63, "weight" : 600 } { "_id" : ObjectId("52632e567023ef178f1b6647"), "dob" : ISODate("1979-08-18T22:44:00Z"), "gender" : "m", "loves" : [ "apple" ], "name" : "Roooooodles", "vaccinated" : true, "vampires" : 99, "weight" : 590 } { "_id" : ObjectId("52632e567023ef178f1b6648"), "dob" : ISODate("1985-07-04T06:01:00Z"), "gender" : "f", "loves" : [ "apple", "carrot", "chocolate" ], "name" : "Solnara", "vaccinated" : true, "vampires" : 80, "weight" : 550 } { "_id" : ObjectId("52632e567023ef178f1b664e"), "dob" : ISODate("1999-12-20T21:15:00Z"), "gender" : "f", "loves" : [ "grape", "carrot" ], "name" : "Nimue", "vaccinated" : true, "weight" : 540 } { "_id" : ObjectId("52632e567023ef178f1b6645"), "dob" : ISODate("1991-01-24T18:00:00Z"), "gender" : "f", "loves" : [ "carrot", "grape", "sugar" ], "name" : "Aurora", "vaccinated" : true, "vampires" : 43, "weight" : 450 } { "_id" : ObjectId("52632e567023ef178f1b664b"), "dob" : ISODate("2005-05-03T04:57:00Z"), "gender" : "m", "loves" : [ "apple", "sugar" ], "name" : "Raleigh", "vaccinated" : true, "vampires" : 2, "weight" : 421 } > > //by unicorn name then vampire kills: > db.unicorns.find().sort({name: 1, ... vampires: -1}) { "_id" : ObjectId("52632e567023ef178f1b6645"), "dob" : ISODate("1991-01-24T18:00:00Z"), "gender" : "f", "loves" : [ "carrot", "grape", "sugar" ], "name" : "Aurora", "vaccinated" : true, "vampires" : 43, "weight" : 450 } { "_id" : ObjectId("52632e567023ef178f1b6649"), "dob" : ISODate("1998-03-07T13:30:00Z"), "gender" : "f", "loves" : [ "strawberry", "lemon" ], "name" : "Ayna", "vaccinated" : true, "vampires" : 40, "weight" : 733 } { "_id" : ObjectId("52632e577023ef178f1b664f"), "dob" : ISODate("1976-07-18T22:18:00Z"), "gender" : "m", "loves" : [ "grape", "watermelon" ], "name" : "Dunx", "vaccinated" : true, "vampires" : 165, "weight" : 704 } { "_id" : ObjectId("52632e567023ef178f1b6644"), "dob" : ISODate("1992-03-13T12:47:00Z"), "gender" : "m", "loves" : [ "carrot", "papaya" ], "name" : "Horny", "vaccinated" : true, "vampires" : 63, "weight" : 600 } { "_id" : ObjectId("52632e567023ef178f1b664a"), "dob" : ISODate("1997-07-01T14:42:00Z"), "gender" : "m", "loves" : [ "grape", "lemon" ], "name" : "Kenny", "vaccinated" : true, "vampires" : 39, "weight" : 690 } { "_id" : ObjectId("52632e567023ef178f1b664c"), "dob" : ISODate("2001-10-08T18:53:00Z"), "gender" : "f", "loves" : [ "apple", "watermelon" ], "name" : "Leia", "vaccinated" : true, "vampires" : 33, "weight" : 601 } { "_id" : ObjectId("52632e567023ef178f1b664e"), "dob" : ISODate("1999-12-20T21:15:00Z"), "gender" : "f", "loves" : [ "grape", "carrot" ], "name" : "Nimue", "vaccinated" : true, "weight" : 540 } { "_id" : ObjectId("52632e567023ef178f1b664d"), "dob" : ISODate("1997-03-01T10:03:00Z"), "gender" : "m", "loves" : [ "apple", "watermelon" ], "name" : "Pilot", "vaccinated" : true, "vampires" : 52, "weight" : 650 } { "_id" : ObjectId("52632e567023ef178f1b664b"), "dob" : ISODate("2005-05-03T04:57:00Z"), "gender" : "m", "loves" : [ "apple", "sugar" ], "name" : "Raleigh", "vaccinated" : true, "vampires" : 2, "weight" : 421 } { "_id" : ObjectId("52632e567023ef178f1b6647"), "dob" : ISODate("1979-08-18T22:44:00Z"), "gender" : "m", "loves" : [ "apple" ], "name" : "Roooooodles", "vaccinated" : true, "vampires" : 99, "weight" : 590 } { "_id" : ObjectId("52632e567023ef178f1b6648"), "dob" : ISODate("1985-07-04T06:01:00Z"), "gender" : "f", "loves" : [ "apple", "carrot", "chocolate" ], "name" : "Solnara", "vaccinated" : true, "vampires" : 80, "weight" : 550 } { "_id" : ObjectId("52632e567023ef178f1b6646"), "dob" : ISODate("1973-02-10T03:10:00Z"), "gender" : "m", "loves" : [ "energon", "redbull" ], "name" : "Unicrom", "vaccinated" : true, "vampires" : 182, "weight" : 984 } > > > > db.unicorns.find() { "_id" : ObjectId("52632e567023ef178f1b6647"), "dob" : ISODate("1979-08-18T22:44:00Z"), "gender" : "m", "loves" : [ "apple" ], "name" : "Roooooodles", "vaccinated" : true, "vampires" : 99, "weight" : 590 } { "_id" : ObjectId("52632e567023ef178f1b6644"), "dob" : ISODate("1992-03-13T12:47:00Z"), "gender" : "m", "loves" : [ "carrot", "papaya" ], "name" : "Horny", "vaccinated" : true, "vampires" : 63, "weight" : 600 } { "_id" : ObjectId("52632e567023ef178f1b6646"), "dob" : ISODate("1973-02-10T03:10:00Z"), "gender" : "m", "loves" : [ "energon", "redbull" ], "name" : "Unicrom", "vaccinated" : true, "vampires" : 182, "weight" : 984 } { "_id" : ObjectId("52632e567023ef178f1b6648"), "dob" : ISODate("1985-07-04T06:01:00Z"), "gender" : "f", "loves" : [ "apple", "carrot", "chocolate" ], "name" : "Solnara", "vaccinated" : true, "vampires" : 80, "weight" : 550 } { "_id" : ObjectId("52632e567023ef178f1b6649"), "dob" : ISODate("1998-03-07T13:30:00Z"), "gender" : "f", "loves" : [ "strawberry", "lemon" ], "name" : "Ayna", "vaccinated" : true, "vampires" : 40, "weight" : 733 } { "_id" : ObjectId("52632e567023ef178f1b664a"), "dob" : ISODate("1997-07-01T14:42:00Z"), "gender" : "m", "loves" : [ "grape", "lemon" ], "name" : "Kenny", "vaccinated" : true, "vampires" : 39, "weight" : 690 } { "_id" : ObjectId("52632e567023ef178f1b664b"), "dob" : ISODate("2005-05-03T04:57:00Z"), "gender" : "m", "loves" : [ "apple", "sugar" ], "name" : "Raleigh", "vaccinated" : true, "vampires" : 2, "weight" : 421 } { "_id" : ObjectId("52632e567023ef178f1b664c"), "dob" : ISODate("2001-10-08T18:53:00Z"), "gender" : "f", "loves" : [ "apple", "watermelon" ], "name" : "Leia", "vaccinated" : true, "vampires" : 33, "weight" : 601 } { "_id" : ObjectId("52632e567023ef178f1b664d"), "dob" : ISODate("1997-03-01T10:03:00Z"), "gender" : "m", "loves" : [ "apple", "watermelon" ], "name" : "Pilot", "vaccinated" : true, "vampires" : 52, "weight" : 650 } { "_id" : ObjectId("52632e567023ef178f1b664e"), "dob" : ISODate("1999-12-20T21:15:00Z"), "gender" : "f", "loves" : [ "grape", "carrot" ], "name" : "Nimue", "vaccinated" : true, "weight" : 540 } { "_id" : ObjectId("52632e577023ef178f1b664f"), "dob" : ISODate("1976-07-18T22:18:00Z"), "gender" : "m", "loves" : [ "grape", "watermelon" ], "name" : "Dunx", "vaccinated" : true, "vampires" : 165, "weight" : 704 } { "_id" : ObjectId("52632e567023ef178f1b6645"), "dob" : ISODate("1991-01-24T18:00:00Z"), "gender" : "f", "loves" : [ "carrot", "grape", "sugar" ], "name" : "Aurora", "vaccinated" : true, "vampires" : 43, "weight" : 450 } > .sort({weight: -1}) Sat Oct 19 21:23:49.244 SyntaxError: Unexpected token . > .limit(2) Sat Oct 19 21:23:49.246 SyntaxError: Unexpected token . > .skip(1) Sat Oct 19 21:23:51.301 SyntaxError: Unexpected token . > > > db.unicorns.find().sort({weight: -1}).limit(2).skip(1) { "_id" : ObjectId("52632e567023ef178f1b6649"), "dob" : ISODate("1998-03-07T13:30:00Z"), "gender" : "f", "loves" : [ "strawberry", "lemon" ], "name" : "Ayna", "vaccinated" : true, "vampires" : 40, "weight" : 733 } { "_id" : ObjectId("52632e577023ef178f1b664f"), "dob" : ISODate("1976-07-18T22:18:00Z"), "gender" : "m", "loves" : [ "grape", "watermelon" ], "name" : "Dunx", "vaccinated" : true, "vampires" : 165, "weight" : 704 } > > > > > > db.unicorns.count({vampires: {$gt: 50}}) 6 > > db.unicorns.find({vampires: {$gt: 50}}).count() 6 > > > ===Chapter-4=== > > db.employees.insert({_id: ObjectId( ... "4d85c7039ab0fd70a117d730"), ... name: 'Leto'}) > > > > > > db.employees.insert({_id: ObjectId( ... "4d85c7039ab0fd70a117d731"), ... name: 'Duncan', ... manager: ObjectId( ... "4d85c7039ab0fd70a117d730")}); > db.employees.insert({_id: ObjectId( ... "4d85c7039ab0fd70a117d732"), ... name: 'Moneo', ... manager: ObjectId( ... "4d85c7039ab0fd70a117d730")}); > > > db.employees.find({manager: ObjectId( ... "4d85c7039ab0fd70a117d730")}) { "_id" : ObjectId("4d85c7039ab0fd70a117d731"), "name" : "Duncan", "manager" : ObjectId("4d85c7039ab0fd70a117d730") } { "_id" : ObjectId("4d85c7039ab0fd70a117d732"), "name" : "Moneo", "manager" : ObjectId("4d85c7039ab0fd70a117d730") } > > > > db.employees.insert({_id: ObjectId( ... "4d85c7039ab0fd70a117d733"), ... name: 'Siona', ... manager: [ObjectId( ... "4d85c7039ab0fd70a117d730"), ... ObjectId( ... "4d85c7039ab0fd70a117d732")] }) > > > > db.employees.find({manager: ObjectId( ... "4d85c7039ab0fd70a117d730")}) { "_id" : ObjectId("4d85c7039ab0fd70a117d731"), "name" : "Duncan", "manager" : ObjectId("4d85c7039ab0fd70a117d730") } { "_id" : ObjectId("4d85c7039ab0fd70a117d732"), "name" : "Moneo", "manager" : ObjectId("4d85c7039ab0fd70a117d730") } { "_id" : ObjectId("4d85c7039ab0fd70a117d733"), "name" : "Siona", "manager" : [ ObjectId("4d85c7039ab0fd70a117d730"), ObjectId("4d85c7039ab0fd70a117d732") ] } > > > > > db.employees.insert({_id: ObjectId( ... "4d85c7039ab0fd70a117d734"), ... name: 'Ghanima', ... family: {mother: 'Chani', ... father: 'Paul', ... brother: ObjectId( ... "4d85c7039ab0fd70a117d730")}}) > > > > db.employees.find({ ... 'family.mother': 'Chani'}) { "_id" : ObjectId("4d85c7039ab0fd70a117d734"), "name" : "Ghanima", "family" : { "mother" : "Chani", "father" : "Paul", "brother" : ObjectId("4d85c7039ab0fd70a117d730") } } > > > > db.users.insert({name: 'leto', ... email: 'leto@dune.gov', ... account: {allowed_gholas: 5, ... spice_ration: 10}}) > > > >