-
Notifications
You must be signed in to change notification settings - Fork 0
/
Asgn_10.js
85 lines (55 loc) · 1.82 KB
/
Asgn_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
db.Student.insertOne({
name: "Ninad",
branch: 'CE',
rollno: 31253,
scores: [
{ sub: "DBMS", marks: 90},
{ sub: "Lp1", marks: 97 },
{ sub: "CNS", marks: 86}
]
});
// AGGREGATION
db.Student.aggregate({
$match: { branch: "CE" }
});
db.Student.aggregate([
{
$unwind: "$scores"
},
{
$group: {
_id: "$rollno",
totalMarks: { $sum: "$scores.marks" } //$avg, $min, $max, $first, $last, $push
}
}
]);
db.Student.aggregate([
{$match: {rollno: 31253}},
{$unwind: '$sores'},
]);
//INDEXING
db.Student.createIndex({name: 1});
db.Student.getIndexs();
db.Student.dropIndex({name: 1});
db.Student.createIndex({name: 1, rollno:1});
db.Student.distinct("name");
// db.website.aggregate({$group: {_id:"$name", "total": {$sum:"$amount"}}});
// db.website.aggregate({$group: {_id:"$name", "total": {$avg:"$amount"}}});
// db.website.aggregate({$group:{_id:"$name","total":{$min:"$amount"}}});
// db.website.aggregate({$group:{_id:"$name","total":{$max:"$amount"}}});
// db.website.aggregate({$group:{_id:"$name","total":{$first:"$amount"}}});
// db.website.aggregate({$group:{_id:"$name","total":{$last:"$amount"}}});
// db.website.aggregate({$group:{_id:"$name","total":{$push:"$amount"}}});
// db.website.aggregate({$group:{_id:"$name","total": {$sum:1}}});
// db.website.aggregate({$group:{_id:"$name","total": {$addToSet:"$amount"}}});
// db.createCollection('website1')
// db.website1.insert({'r':1,'name':'harsh'});
// db.website1.createIndex({'name':1})
// db.website1.createIndex({'name':-1})
// db.website.dropIndex({'name':-1})
// db.website1.dropIndex({'name':1})
// db.website1.getIndexes()
// db.website1.find().pretty()
// db.website1.createIndex({'name':1})
// db.website1.getIndexes()
// db.website1.dropIndex({'name':1})