MongoDB Exercise 02
1. Create a Database called customers.
test> use customers
switched to db customers
customers>
2. Create a collection called customerdetails..
customers> db.createCollection("customerdetails")
{ ok: 1 }
customers>
3. Insert all documents into the collection named customerdetails.
customers> db.customerdetails.insertMany([ { "name": "John", "age": "25", "gender": "Male", "city": "New York" }, { "name": "Emily", "age": "22", "gender": "Female", "city": "London" }, { "name": "Daniel", "age": "28", "gender": "Male", "city": "Sydney" }, { "name": "Sophia", "age": "24", "gender": "Female", "city": "Paris" }, { "name": "William", "age": "26", "gender": "Male", "city": "Chicago" }, { "name": "Olivia", "age": "23", "gender": "Female", "city": "Los Angeles" }, { "name": "Benjamin", "age": "27", "gender": "Male", "city": "Toronto" }, { "name": "Mila", "age": "29", "gender": "Female", "city": "Berlin" }, { "name": "James", "age": "30", "gender": "Male", "city": "Tokyo" }])
{
acknowledged: true,
insertedIds: {
'0': ObjectId("654ca6a8f41d0bb8c74d2fb1"),
'1': ObjectId("654ca6a8f41d0bb8c74d2fb2"),
'2': ObjectId("654ca6a8f41d0bb8c74d2fb3"),
'3': ObjectId("654ca6a8f41d0bb8c74d2fb4"),
'4': ObjectId("654ca6a8f41d0bb8c74d2fb5"),
'5': ObjectId("654ca6a8f41d0bb8c74d2fb6"),
'6': ObjectId("654ca6a8f41d0bb8c74d2fb7"),
'7': ObjectId("654ca6a8f41d0bb8c74d2fb8"),
'8': ObjectId("654ca6a8f41d0bb8c74d2fb9")
}
}
customers>
4. Retrieve all documents from the collection and sort the results by the “age” field in ascending order.
customers> db.customerdetails.find().sort({ "age": 1 }).pretty()
[
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb2"),
name: 'Emily',
age: '22',
gender: 'Female',
city: 'London'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb6"),
name: 'Olivia',
age: '23',
gender: 'Female',
city: 'Los Angeles'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb4"),
name: 'Sophia',
age: '24',
gender: 'Female',
city: 'Paris'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb1"),
name: 'John',
age: '25',
gender: 'Male',
city: 'New York'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb5"),
name: 'William',
age: '26',
gender: 'Male',
city: 'Chicago'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb7"),
name: 'Benjamin',
age: '27',
gender: 'Male',
city: 'Toronto'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb3"),
name: 'Daniel',
age: '28',
gender: 'Male',
city: 'Sydney'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb8"),
name: 'Mila',
age: '29',
gender: 'Female',
city: 'Berlin'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb9"),
name: 'James',
age: '30',
gender: 'Male',
city: 'Tokyo'
}
]
customers>
**5. Count the number of females. **
customers> db.customerdetails.countDocuments({ "gender": "Female" })
4
customers>
6.Insert one document into the customerdetails collection.
customers>
db.customerdetails.insertOne({ "name": "Mariyamma", "age": "24", "gender": "Female", "city": "Srilanka" }) { acknowledged: true, insertedId: ObjectId("654cb000f41d0bb8c74d2fba") }
customers>
7. Update city=SriLanka to John.
customers>
db.customerdetails.update({"name": "John"},{ $set: {"city": "Srilanka"}}) DeprecationWarning: Collection.update() is deprecated. Use updateOne, updateMany, or bulkWrite. { acknowledged: true, insertedId: null, matchedCount: 1, modifiedCount: 1, upsertedCount: 0 }
customers>
8. Remove the customer from Tokyo.
customers>
db.customerdetails.remove({ "city":"Tokyo" }) DeprecationWarning: Collection.remove() is deprecated. Use deleteOne, deleteMany, findOneAndDelete, or bulkWrite. { acknowledged: true, deletedCount: 1 }
customers>
**9. Find customers not from Los Angeles. **
customers> db.customerdetails.find({"city": {$ne: "Los Angeles" } })
[
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb1"),
name: 'John',
age: '25',
gender: 'Male',
city: 'Srilanka'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb2"),
name: 'Emily',
age: '22',
gender: 'Female',
city: 'London'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb3"),
name: 'Daniel',
age: '28',
gender: 'Male',
city: 'Sydney'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb4"),
name: 'Sophia',
age: '24',
gender: 'Female',
city: 'Paris'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb5"),
name: 'William',
age: '26',
gender: 'Male',
city: 'Chicago'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb7"),
name: 'Benjamin',
age: '27',
gender: 'Male',
city: 'Toronto'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb8"),
name: 'Mila',
age: '29',
gender: 'Female',
city: 'Berlin'
},
{
_id: ObjectId("654cb000f41d0bb8c74d2fba"),
name: 'Mariyamma',
age: '24',
gender: 'Female',
city: 'Srilanka'
}
]
customers>
10.Find the customers who are older than age 25.
customers>
db.customerdetails.find({ "age": {$gt:("25")} })
[
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb3"),
name: 'Daniel',
age: '28',
gender: 'Male',
city: 'Sydney'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb5"),
name: 'William',
age: '26',
gender: 'Male',
city: 'Chicago'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb7"),
name: 'Benjamin',
age: '27',
gender: 'Male',
city: 'Toronto'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb8"),
name: 'Mila',
age: '29',
gender: 'Female',
city: 'Berlin'
}
]
customers>
11.Retrieve the males who are less than 25.
customers>
db.customerdetails.find({ "age": {$lt:("25")},"gender":"Male" })
[
{
_id: ObjectId("654cb000f41d0bb8c74d2fba"),
name: 'ariyamma',
age: '24',
gender: 'Female',
city: 'Srilanka'
}
]
customers>
**12.Update Francis age to 35, if Francis is not available upsert. **
customers>
db.customerdetails.update({"name":"Francis"},{ $set: {"age":"35"}},{ upsert: true })
DeprecationWarning: Collection.update() is deprecated. Use updateOne, updateMany, or bulkWrite.
{
acknowledged: true,
insertedId: ObjectId("654ceed0937b2d69715cfcba"),
matchedCount: 0,
modifiedCount: 0,
upsertedCount: 1
}
customers>
13.Retrieve males who are younger than 30 and older than25.
customers> db.customerdetails.find({ "age": {$lt:("30"),$gt:("25")},"gender":"Male" })
[
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb3"),
name: 'Daniel',
age: '28',
gender: 'Male',
city: 'Sydney'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb5"),
name: 'William',
age: '26',
gender: 'Male',
city: 'Chicago'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb7"),
name: 'Benjamin',
age: '27',
gender: 'Male',
city: 'Toronto'
}
]
customers>
14.Find a customer who is lesser than or equal to 23.
customers>
db.customerdetails.find({ "age": {$lte:("23")} })
[
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb2"),
name: 'Emily',
age: '22',
gender: 'Female',
city: 'London'
},
{
_id: ObjectId("654ca6a8f41d0bb8c74d2fb6"),
name: 'Olivia',
age: '23',
gender: 'Female',
city: 'Los Angeles'
}
]
customers>