Mongodb1
ASSIGNMENT 1
1] Create a database with the name 'Movie'
> use Movie
switched to db Movie
2] 'Film' Collection.
>db.Film.insert({id:1,title:'Dilwale',r_year:'2015',cat:'comedy',actors:[{fname:'ShahRukh',lname:'Khan'}],director:[{fname:'Rohit',lname:'Shetty'}],r_details:[{place:'Mumbai',date:'18-12-2015',rate:5}]})
WriteResult({ "nInserted" : 1 })
3] 'Actor' Collection.
>db.Actor.insert({id:1111,fname:'ShahRukh',lname:'Khan',address:[{street:'Bandstand',city:'Mumbai',country:'India',pincode:'400050'}],c_details:[{email_id:'kingkhan@aaa.com',phone_no:'9876543210'}],age:'52'})
WriteResult({ "nInserted" : 1 })
QUERIES:
1]
A] Insert atleast one document with Film belonging to two categories.
> db.Film.insert({
... id:1,
... title:'Mission Mangal',
... r_year:'2019',
... cat:['drama','fantasy'],
... actors:[{fname:'Akshay',lname:'Kumar'}],
... director:[{fname:'Jagan',lname:'Shakti'}],
... r_details:[{place:'Mumbai',date:'15/8/2019',rate:'4'}]
... })
WriteResult({ "nInserted" : 1 })
B] Insert at least one document with film that is released at more than one place and on two different dates.
> db.Film.insert({
... id:3,
... title:"ABCD2",
... r_year:"2015",
... cat:"dance",
... actors:[{fname:"Varun",lname:"Dhawan"}],
... director:[{fname:"Remo",lname:"D'souza"}],
... r_details:[{place:["Pune","Mumbai"],date:["12/3/2015","14/3/2015"],rate:"5"}]
... })
WriteResult({ "nInserted" : 1 })
C] Insert at least three documents with the films released in the same year.
> db.Film.insert({ id:3, title:"Bahubali", r_year:"2015", cat:"drama", actors:[{fname:"Prabhas",lname:"Uppalapati"}], director:[{fname:"Rajmaulli",lname:"Garu"}], r_details:[{place:["Pune","Mumbai"],date:["12/3/2015","14/3/2015"],rate:"5"}] })
WriteResult({ "nInserted" : 1 })
> db.Film.insert({ id:5, title:"Bajrangi Bhaijaan", r_year:"2015", cat:"drama", actors:[{fname:"Salman",lname:"Khan"}], director:[{fname:"Kabir",lname:"Khan"}], r_details:[{place:["Pune","Mumbai"],date:["12/3/2015","14/3/2015"],rate:"5"}] })
WriteResult({ "nInserted" : 1 })
D] Insert at least two documents with the films directed by one director.
> db.Film.insert({ id:6, title:"Bahubali2", r_year:"2017", cat:"drama", actors:[{fname:"Prahas",lname:"Uppalapati"}], director:[{fname:"Rajmaulli",lname:"Garu"}], r_details:[{place:["Pune","Mumbai"],date:["12/3/2017","14/4/2017"],rate:"5"}] })
WriteResult({ "nInserted" : 1 })
E] Insert at least two documents with films those are acted by a pair ‘Madhuri Dixit’ and ‘Shahrukh Khan’.
> db.Film.insert({ id:7, title:"Dil to Pagal hai", r_year:"2000", cat:"drama", actors:[{fname:"ShahRukh",lname:"Khan"},{fname:"Madhuri",lname:"Dixit"}], director:[{fname:"Yash",lname:"Chopra"}], r_details:[{place:"Mumbai",date:"12/3/2000",rate:"5"}]})
WriteResult({ "nInserted" : 1 })
1] Insert at least 10 documents in the collection Actor
>db.Actor.insert({id:2222,fname:'Akshay',lname:'Kumar',address:[{street:'Bandra',city:'Mumbai',country:'India',pincode:'400051'}],c_details:[{email_id:'akky@aaa.com',phone_no:'9877643210'}],age:'48'})
WriteResult({ "nInserted" : 1 })
>db.Actor.insert({id:3333,fname:'Prabhas',lname:'Uppalapati',address:[{street:'AAA',city:'Hyderabad',country:'India',pincode:'400565'}],c_details:[{email_id:'darling@aaa.com',phone_no:'9997643210'}],age:'36'})
WriteResult({ "nInserted" : 1 })
2] Display all the documents inserted in both the collections.
FILM
> db.Film.find().pretty()
{
"_id" : ObjectId("5d7327aa01c4f2761a1e451c"),
"id" : 1,
"title" : "Dilwale",
"r_year" : "2015",
"cat" : "comedy",
"actors" : [
{
"fname" : "ShahRukh",
"lname" : "Khan"
}
],
"director" : [
{
"fname" : "Rohit",
"lname" : "Shetty"
}
],
"r_details" : [
{
"place" : "Mumbai",
"date" : "18-12-2015",
"rate" : 5
}
]
}
{
"_id" : ObjectId("5d732c6901c4f2761a1e451f"),
"id" : 2,
"title" : "Mission Mangal",
"r_year" : "2019",
"cat" : [
"drama",
"fantasy"
],
"actors" : [
{
"fname" : "Akshay",
"lname" : "Kumar"
}
],
"director" : [
{
"fname" : "Jagan",
"lname" : "Shakti"
}
],
"r_details" : [
{
"place" : "Mumbai",
"date" : "15/8/2019",
"rate" : "4"
}
]
}
{
"_id" : ObjectId("5d7c7583954b59108a0701e9"),
"id" : 3,
"title" : "ABCD2",
"r_year" : "2015",
"cat" : "dance",
"actors" : [
{
"fname" : "Varun",
"lname" : "Dhawan"
}
],
"director" : [
{
"fname" : "Remo",
"lname" : "D'souza"
}
],
"r_details" : [
{
"place" : [
"Pune",
"Mumbai"
],
"date" : [
"12/3/2015",
"14/3/2015"
],
"rate" : "5"
}
]
}
{
"_id" : ObjectId("5d7c7693954b59108a0701ea"),
"id" : 4,
"title" : "Bahubali",
"r_year" : "2015",
"cat" : "dance",
"actors" : [
{
"fname" : "Prabhas",
"lname" : "Uppalapati"
}
],
"director" : [
{
"fname" : "Rajmaulli",
"lname" : "Garu"
}
],
"r_details" : [
{
"place" : [
"Pune",
"Mumbai"
],
"date" : [
"12/3/2015",
"14/3/2015"
],
"rate" : "5"
}
]
}
{
"_id" : ObjectId("5d7c76ca954b59108a0701eb"),
"id" : 5,
"title" : "Bajrangi Bhaijaan",
"r_year" : "2015",
"cat" : "drama",
"actors" : [
{
"fname" : "Salman",
"lname" : "Khan"
}
],
"director" : [
{
"fname" : "Kabir",
"lname" : "Khan"
}
],
"r_details" : [
{
"place" : [
"Pune",
"Mumbai"
],
"date" : [
"12/3/2015",
"14/3/2015"
],
"rate" : "5"
}
]
}
{
"_id" : ObjectId("5d7c76f3954b59108a0701ec"),
"id" : 6,
"title" : "Bahubali2",
"r_year" : "2017",
"cat" : "drama",
"actors" : [
{
"fname" : "Prabhas",
"lname" : "Uppalapati"
}
],
"director" : [
{
"fname" : "Rajmaulli",
"lname" : "Garu"
}
],
"r_details" : [
{
"place" : [
"Pune",
"Mumbai"
],
"date" : [
"12/3/2017",
"14/4/2017"
],
"rate" : "5"
}
]
}
{
"_id" : ObjectId("5d7c7846954b59108a0701ed"),
"id" : 7,
"title" : "Dil to Pagal hai",
"r_year" : "2000",
"cat" : "drama",
"actors" : [
{
"fname" : "ShahRukh",
"lname" : "Khan"
},
{
"fname" : "Madhuri",
"lname" : "Dixit"
}
],
"director" : [
{
"fname" : "Yash",
"lname" : "Chopra"
}
],
"r_details" : [
{
"place" : "Mumbai",
"date" : "12/3/2000",
"rate" : "5"
}
]
}
ACTOR
> db.Actor.find().pretty()
{
"_id" : ObjectId("5d7c71c1954b59108a0701e7"),
"id" : 1111,
"fname" : "ShahRukh",
"lname" : "Khan",
"address" : [
{
"street" : "Bandstand",
"city" : "Mumbai",
"country" : "India",
"pincode" : "400050"
}
],
"c_details" : [
{
"email_id" : "kingkhan@aaa.com",
"phone_no" : "9876543210"
}
],
"age" : "52"
}
{
"_id" : ObjectId("5d7c79bc954b59108a0701ee"),
"id" : 2222,
"fname" : "Akshay",
"lname" : "Kumar",
"address" : [
{
"street" : "Bandra",
"city" : "Mumbai",
"country" : "India",
"pincode" : "400051"
}
],
"c_details" : [
{
"email_id" : "akky@aaa.com",
"phone_no" : "9877643210"
}
],
"age" : "48"
}
{
"_id" : ObjectId("5d7c7a1f954b59108a0701ef"),
"id" : 3333,
"fname" : "Prabhas",
"lname" : "Uppalapati",
"address" : [
{
"street" : "AAA",
"city" : "Hyderabad",
"country" : "India",
"pincode" : "400565"
}
],
"c_details" : [
{
"email_id" : "darling@aaa.com",
"phone_no" : "9997643210"
}
],
"age" : "36"
}
3] Add a value to the rating of the film whose title starts with ‘T’.
> db.Film.update({title:/^M/},{$inc:{rate:1}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
4] Delete the film "______________".
> db.Film.remove({title:"Bajrangi Bhaijaan"})
WriteResult({ "nRemoved" : 1 })
5] Delete an actor named "_________".
> db.Actor.remove({fname:"Akshay",lname:"Kumar"})
WriteResult({ "nRemoved" : 1 })
6] Delete all actors from an ‘Actor’ collection who have age greater than “_____”
> db.Actor.remove({age:{$gt:50}})
WriteResult({ "nRemoved" : 0 })
7] Update the actor’s address where Actor Id is “ ______”
> db.Actor.update({id:2222},{$set:{"address.street":"AAAS"}})
WriteResult({ "nMatched" : 0, "nUpserted" : 0, "nModified" : 0 })
> db.Actor.update({id:1111},{$set:{"address.street":"AAAS"}})
WriteResult({
"nMatched" : 0,
"nUpserted" : 0,
"nModified" : 0,
"writeError" : {
"code" : 28,
"errmsg" : "Cannot create field 'street' in element {address: [ { street: \"Bandstand\", city: \"Mumbai\", country: \"India\", pincode: \"400050\" } ]}"
}
})
8] Update the genre of the film directed by “___________”.
>db.Film.update({"director.fname":"Rajmaulli","director.lname":"Garu"},{$set:{cat:"fiction"}})
WriteResult({ "nMatched" : 1, "nUpserted" : 0, "nModified" : 1 })
> db.Film.find().pretty()
{
"_id" : ObjectId("5d7327aa01c4f2761a1e451c"),
"id" : 1,
"title" : "Dilwale",
"r_year" : "2015",
"cat" : "comedy",
"actors" : [
{
"fname" : "ShahRukh",
"lname" : "Khan"
}
],
"director" : [
{
"fname" : "Rohit",
"lname" : "Shetty"
}
],
"r_details" : [
{
"place" : "Mumbai",
"date" : "18-12-2015",
"rate" : 5
}
]
}
{
"_id" : ObjectId("5d732c6901c4f2761a1e451f"),
"id" : 2,
"title" : "Mission Mangal",
"r_year" : "2019",
"cat" : [
"drama",
"fantasy"
],
"actors" : [
{
"fname" : "Akshay",
"lname" : "Kumar"
}
],
"director" : [
{
"fname" : "Jagan",
"lname" : "Shakti"
}
],
"r_details" : [
{
"place" : "Mumbai",
"date" : "15/8/2019",
"rate" : "4"
}
]
"rate" : 1
}
{
"_id" : ObjectId("5d7c7583954b59108a0701e9"),
"id" : 3,
"title" : "ABCD2",
"r_year" : "2015",
"cat" : "dance",
"actors" : [
{
"fname" : "Varun",
"lname" : "Dhawan"
}
],
"director" : [
{
"fname" : "Remo",
"lname" : "D'souza"
}
],
"r_details" : [
{
"place" : [
"Pune",
"Mumbai"
],
"date" : [
"12/3/2015",
"14/3/2015"
],
"rate" : "5"
}
]
}
{
"_id" : ObjectId("5d7c7693954b59108a0701ea"),
"id" : 4,
"title" : "Bahubali",
"r_year" : "2015",
"cat" : "fiction",
"actors" : [
{
"fname" : "Prabhas",
"lname" : "Uppalapati"
}
],
"director" : [
{
"fname" : "Rajmaulli",
"lname" : "Garu"
}
],
"r_details" : [
{
"place" : [
"Pune",
"Mumbai"
],
"date" : [
"12/3/2015",
"14/3/2015"
],
"rate" : "5"
}
]
}
{
"_id" : ObjectId("5d7c76f3954b59108a0701ec"),
"id" : 6,
"title" : "Bahubali2",
"r_year" : "2017",
"cat" : "drama",
"actors" : [
{
"fname" : "Prabhas",
"lname" : "Uppalapati"
}
],
"director" : [
{
"fname" : "Rajmaulli",
"lname" : "Garu"
}
],
"r_details" : [
{
"place" : [
"Pune",
"Mumbai"
],
"date" : [
"12/3/2017",
"14/4/2017"
],
"rate" : "5"
}
]
}
{
"_id" : ObjectId("5d7c7846954b59108a0701ed"),
"id" : 7,
"title" : "Dil to Pagal hai",
"r_year" : "2000",
"cat" : "drama",
"actors" : [
{
"fname" : "ShahRukh",
"lname" : "Khan"
},
{
"fname" : "Madhuri",
"lname" : "Dixit"
}
],
"director" : [
{
"fname" : "Yash",
"lname" : "Chopra"
}
],
"r_details" : [
{
"place" : "Mumbai",
"date" : "12/3/2000",
"rate" : "5"
}
]
}
Comments
Post a Comment