-
Notifications
You must be signed in to change notification settings - Fork 0
/
10..js
110 lines (94 loc) · 3 KB
/
10..js
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
show dbs
use Asg10
// 1. Create a collection named books.
db.createCollection('Books')
// 2. Insert 5 records with field TITLE,DESCRIPTION, BY, URL, TAGS AND LIKES
db.Books.insertMany(
[
{
title: 'book 1',
description : 'description 1',
by : 'author 1',
url : 'url 1',
tags : ['tag1.1', 'tag1.2'],
likes : 197
},
{
title: 'book 2',
description : 'description 2',
by : 'author 2',
url : 'url 2',
tags : ['tag2.1', 'tag2.2'],
likes : 997
},
{
title: 'book 3',
description : 'description 3',
by : 'author 3',
url : 'url 3',
tags : ['tag3.1', 'tag3.2'],
likes : 397
},
{
title: 'book 4',
description : 'description 4',
by : 'author 4',
url : 'url 4',
tags : ['tag4.1', 'tag4.2'],
likes : 17
},
{
title: 'book 5',
description : 'description 5',
by : 'author 5',
url : 'url 5',
tags : ['tag5.1', 'tag5.2'],
likes : 1970
}
]
)
// 3. Insert 1 more document in collection with additional field of
// user name and comments.
db.Books.insertOne(
{
title: 'mongodb',
description : 'best seller book',
by : 'john',
url : 'mongodb.com',
tags: ['mongosh', 'nosqldb'],
likes: 1200,
user: ['soham', 'adam'],
comments: [['nice', 'helpful'],['must buy']]
}
)
// 4. Display all the documents whose title is 'mongodb',
db.Books.find({title:'mongodb'})
// 5. Display all the documents written by 'john' or whose title is 'mongodb'
db.Books.find( { $or:[ {title:'book 1'}, {by:'john'} ] } )
// 5. Display all the documents written by 'john' and whose title is 'mongodb'
db.Books.find( { $and:[ {title:'mongodb'}, {by:'john'} ]} )
// Display all the documents whose like is greater than 100
db.Books.find( {likes:{$gt:100}} )
// 8. Display all the documents whose like is greater than 100 and whose title is either
// 'mongodb' or written by 'john'.
db.Books.find( {$and:[ {likes: {$gt:100}}, {$or:[ {title: 'book 1'}, {by: 'john'}]} ]} )
// 9. Update the title of 'mongodb' document to 'mongodb overview'
db.Books.updateOne(
{title:'mongodb'},
{$set:{title:'mongodb-edition 2'}}
)
// 10. Delete the document titled 'nosql overview.
db.Books.deleteOne({title: 'book 3'})
// 11. Display exactly two documents written by 'john'.
db.Books.find({by:'john'}).limit(2)
// 13. Display all the books in sorted fashion (ascending by title):
db.Books.find().sort({title:1})
// 14. Insert a document using save method
var docToSave = {
title: 'last',
description:'lasttt',
by: "me",
url: 'last.com',
likes: 3492,
tags : ['lastdoc']
}