myfirstrepo/No SQL CRUD Assignment.txt at master · githubuser-bit/myfirstrepo · GitHub

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
C:\Program Files\MongoDB\Server\3.2\bin>mongo
MongoDB shell version: 3.2.22
connecting to: test
> use patients
switched to db patients
> patientsdb.insertOne({"name":"xyz",disease:[{diseasename:"cold",medicine:"paracetamol"}]})
2020-09-18T10:11:27.932+0530 E QUERY    [thread1] ReferenceError: patientsdb is not defined :
@(shell):1:1

> db.patientData.insertOne({"name":"xyz",disease:[{diseasename:"cold",medicine:"paracetamol"}]})
{
        "acknowledged" : true,
        "insertedId" : ObjectId("5f643b9fd07ee911f8cc5065")
}
> db.patientData.insertOne({"name":"abc",disease:[{diseasename:"fever",medicine:"paracetamol"},{diseasename:"pqr",medicine:"123"}]})
{
        "acknowledged" : true,
        "insertedId" : ObjectId("5f644164d07ee911f8cc5066")
}
> db.patientData.find()
{ "_id" : ObjectId("5f643b9fd07ee911f8cc5065"), "name" : "xyz", "disease" : [ { "diseasename" : "cold", "medicine" : "paracetamol" } ] }
{ "_id" : ObjectId("5f644164d07ee911f8cc5066"), "name" : "abc", "disease" : [ { "diseasename" : "fever", "medicine" : "paracetamol" }, { "diseasename" : "pqr", "medicine" : "123" } ] }
> db.patientData.find().pretty()
{
        "_id" : ObjectId("5f643b9fd07ee911f8cc5065"),
        "name" : "xyz",
        "disease" : [
                {
                        "diseasename" : "cold",
                        "medicine" : "paracetamol"
                }
        ]
}
{
        "_id" : ObjectId("5f644164d07ee911f8cc5066"),
        "name" : "abc",
        "disease" : [
                {
                        "diseasename" : "fever",
                        "medicine" : "paracetamol"
                },
                {
                        "diseasename" : "pqr",
                        "medicine" : "123"
                }
        ]
}
> db.patientData.insertOne({"name":"lmn",disease:[{diseasename:"back pain",medicine:"moov"},{diseasename:"pqr",medicine:"123"}]})
{
        "acknowledged" : true,
        "insertedId" : ObjectId("5f6442a2d07ee911f8cc5067")
}
> db.patientData.find().pretty()
{
        "_id" : ObjectId("5f643b9fd07ee911f8cc5065"),
        "name" : "xyz",
        "disease" : [
                {
                        "diseasename" : "cold",
                        "medicine" : "paracetamol"
                }
        ]
}
{
        "_id" : ObjectId("5f644164d07ee911f8cc5066"),
        "name" : "abc",
        "disease" : [
                {
                        "diseasename" : "fever",
                        "medicine" : "paracetamol"
                },
                {
                        "diseasename" : "pqr",
                        "medicine" : "123"
                }
        ]
}
{
        "_id" : ObjectId("5f6442a2d07ee911f8cc5067"),
        "name" : "lmn",
        "disease" : [
                {
                        "diseasename" : "back pain",
                        "medicine" : "moov"
                },
                {
                        "diseasename" : "pqr",
                        "medicine" : "123"
                }
        ]
}
> db.patientData.findOne({name:"lmn"})
{
        "_id" : ObjectId("5f6442a2d07ee911f8cc5067"),
        "name" : "lmn",
        "disease" : [
                {
                        "diseasename" : "back pain",
                        "medicine" : "moov"
                },
                {
                        "diseasename" : "pqr",
                        "medicine" : "123"
                }
        ]
}
> db.patientData.findOne({},{disease:[{diseasename:"fever"}]})
{
        "_id" : ObjectId("5f643b9fd07ee911f8cc5065"),
        "disease" : [
                {
                        "diseasename" : "cold",
                        "medicine" : "paracetamol"
                }
        ]
}
>