/
Week3 Day1: MongoDB Overview
123 lines (41 loc) · 3.18 KB
/
Week3 Day1: MongoDB Overview
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
----------------------------------------------------------------------------SOLUTION 1------------------------------------------------------------------------------------------------------
db.books.insertMany(
[{"_id" : 12 ,"title": "abc", "author_id": 1, "published_date": 2000, "pages" : 54 , "language": "English", "price": 10.99},
{"_id" : 13 , "title": "def", "author_id": 2, "published_date": 2001, "pages" : 44 , "language": "Hindi", "price": 20.99}])
----------------------------------------------------------------------------SOLUTION 2------------------------------------------------------------------------------------------------------
db.publisher.insertMany([{
"id": 12, "pub_name":"abc", "country":"India"},
{"id": 13, "pub_name":"def", "country":"England"}])
----------------------------------------------------------------------------SOLUTION 3------------------------------------------------------------------------------------------------------
db.author.insertMany(
[{"id" : 12 , "author_name" : "abc","age" : 43,"gender" : "Male","email_id" : "abc@gmail.com",
"phoneno" : "987456123" ,"address" : "abcdef"},
{"id" : 13 , "author_name" : "abcd","age" : 33,"gender" : "Female","email_id" : "abcd@gmail.com",
"phoneno" : "987654321" ,"address" : "defabc"}])
----------------------------------------------------------------------------SOLUTION 4------------------------------------------------------------------------------------------------------
db.books.updateOne({ "_id": 77 },{ $set: { "language": "Sanskrit" }})
----------------------------------------------------------------------------SOLUTION 5------------------------------------------------------------------------------------------------------
db.books.updateMany(
{ "publisher_id": 201 },
{ $set: { "published_date": ISODate("2010-10-24") } }
)
----------------------------------------------------------------------------SOLUTION 6------------------------------------------------------------------------------------------------------
db.author.deleteOne(
"{_id": 201})
----------------------------------------------------------------------------SOLUTION 7------------------------------------------------------------------------------------------------------
db.publisher.drop()
----------------------------------------------------------------------------SOLUTION 8------------------------------------------------------------------------------------------------------
db.books.deleteOne(
{"publisher_id": 201})
----------------------------------------------------------------------------SOLUTION 9------------------------------------------------------------------------------------------------------
db.author.update({"_id": 41},
{$rename:{
"email_id" : "mail", "phoneno" : "mobile"
}})
----------------------------------------------------------------------------SOLUTION 10------------------------------------------------------------------------------------------------------
db.publisher.updateOne(
{ _id: 203 },
{$rename:
{ "pub_name": "UniversityPress", "country": "US" }},
{ upsert: true }
)