documentation/mongodb.txt at main · safi-siddiqui-github/documentation · 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
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
Mongo DB Documentation

NoSQL Database [Not Only Structured Query Language]
Data is store a document as key-value pairs
Data looks like JSON, but its BSON [Binary JavaScript Object Notation]

Document is a group of key-value pairs to represent an object
Collection is a group of one or more documents
Database group of collections

Login:
    mongodb://user:pass@localhost:27017, need to login using credentials

Commands:
    db.runCommand(
        {
            hello: 1
        }
    )
        -- check db is working

    cls
        -- clear screen

    show dbs
        -- show all databases, with some data

    use db_one
        -- create and use a database

    db.createUser({
        user: "dbUser",
        pwd: "dbPass",
        roles: [{ role: "readWrite", db: "db_one" }]
    })
        -- assign user to database

    db.getUsers()

    show collections

    db.createCollection("users")
        -- create collection

    db.dropDatabase("myDB")
        -- drop database

    db.users.insertOne({
        name: "safi",
        email: "safisiddiqui.work@gmail.com",
        age: 25,
        emailVerified: false,
        emailVerifiedAt: null,
        createdAt: new Date(),
    })

    db.users.insertMany([
        {
            name: "safi",
            email: "safisiddiqui.work@gmail.com",
            age: 25,
            emailVerified: false,
            emailVerifiedAt: null,
            createdAt: new Date(),
        },
        {
            name: "sami",
            email: "samisiddiqui.private@gmail.com",
            age: 22,
            emailVerified: false,
            emailVerifiedAt: null,
            createdAt: new Date(),
        },
    ])

    db.users.find()

    db.users.find({
        name: "safi"
    })

    db.users.find(
        { age: { $lt: 23 } },
        { _id: false, name: 1, email: 1, age:true}
    )
    -- {filter}, {projection}

    db.users.find().sort({age: -1})
    -- 1 for alpba, -1 for reverse

    db.users.find().sort({age: -1}).limit(1)
    -- get the most aged

    db.users.find({
        age: {
            $exists: true
        }
    })

    db.users.find({
        name: {
            $ne: "safi"
            // not equal operator
        }
    })

    db.users.find({
        age: {
            $gte: 22,
            // greater or equal equal operator
            $lte: 25,
            // range
        }
    })

    db.users.find({
        name: {
            $in: ['safi','sami'],
            // in operator
            $nin: ['john','jack'],
        }
    })

    db.users.find({
        // and opertor
        // $and, $or, $nor (all conditions false), $not
        $and: [
            {
                age: {
                    $gt: 20
                }
            },
            {
                name: "safi"
            }
        ]
    })

    db.users.updateOne(
        { name: "safi" },
        { $set: { age: 25 } }
    )

    db.users.updateOne(
        { name: "safi" },
        { $unset: { age: null } }
    )

    db.users.deleteOne({
        name: "safi"
    })

    db.users.deleteMany({})