Skip to content

Instantly share code, notes, and snippets.

@patkepa

patkepa/mongodb-cheatsheet.md

Last active October 22, 2020 21:47
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save patkepa/83c48a76267d7b2bcabb74287795885d to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save patkepa/83c48a76267d7b2bcabb74287795885d to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. patkepa revised this gist Oct 22, 2020. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion mongodb-cheatsheet.md
    View file
    Original file line number Diff line number Diff line change
    @@ -270,5 +270,5 @@ show users
    ## Create user

    ```
    db.createUser("user": "username", "pwd": "password", "roles": ["readWrite", "dbAdmin"]})
    db.createUser({"user": "username", "pwd": "password", "roles": ["readWrite", "dbAdmin"]})
    ```
  2. patkepa revised this gist Oct 22, 2020. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion mongodb-cheatsheet.md
    View file
    Original file line number Diff line number Diff line change
    @@ -264,7 +264,7 @@ db.posts.find({ views: { $lte: 7 } })
    ## Show users

    ```
    show user
    show users
    ```

    ## Create user
  3. patkepa revised this gist Oct 22, 2020. 1 changed file with 10 additions and 2 deletions.
    12 changes: 10 additions & 2 deletions mongodb-cheatsheet.md
    View file
    Original file line number Diff line number Diff line change
    @@ -259,8 +259,16 @@ db.posts.find({ views: { $gte: 7 } })
    db.posts.find({ views: { $lt: 7 } })
    db.posts.find({ views: { $lte: 7 } })
    ```
    # Create user
    # User

    ## Show users

    ```
    show user
    ```

    ## Create user

    ```
    db.createUser("user": "username", "pwd": "password", "roles": ["readWrite", "dbAdmin"]})
    ```
    ```
  4. patkepa renamed this gist Oct 22, 2020. 1 changed file with 0 additions and 0 deletions.
    0 mongodb-cheatsheet → mongodb-cheatsheet.md
    View file
    File renamed without changes.
  5. patkepa created this gist Oct 22, 2020.
    266 changes: 266 additions & 0 deletions mongodb-cheatsheet
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,266 @@
    # MongoDB Cheat Sheet

    ## Show All Databases

    ```
    show dbs
    ```

    ## Show Current Database

    ```
    db
    ```

    ## Create Or Switch Database

    ```
    use acme
    ```

    ## Drop

    ```
    db.dropDatabase()
    ```

    ## Create Collection

    ```
    db.createCollection('posts')
    ```

    ## Show Collections

    ```
    show collections
    ```

    ## Insert Row

    ```
    db.posts.insert({
    title: 'Post One',
    body: 'Body of post one',
    category: 'News',
    tags: ['news', 'events'],
    user: {
    name: 'John Doe',
    status: 'author'
    },
    date: Date()
    })
    ```

    ## Insert Multiple Rows

    ```
    db.posts.insertMany([
    {
    title: 'Post Two',
    body: 'Body of post two',
    category: 'Technology',
    date: Date()
    },
    {
    title: 'Post Three',
    body: 'Body of post three',
    category: 'News',
    date: Date()
    },
    {
    title: 'Post Four',
    body: 'Body of post three',
    category: 'Entertainment',
    date: Date()
    }
    ])
    ```

    ## Get All Rows

    ```
    db.posts.find()
    ```

    ## Get All Rows Formatted

    ```
    db.find().pretty()
    ```

    ## Find Rows

    ```
    db.posts.find({ category: 'News' })
    ```

    ## Sort Rows

    ```
    # asc
    db.posts.find().sort({ title: 1 }).pretty()
    # desc
    db.posts.find().sort({ title: -1 }).pretty()
    ```

    ## Count Rows

    ```
    db.posts.find().count()
    db.posts.find({ category: 'news' }).count()
    ```

    ## Limit Rows

    ```
    db.posts.find().limit(2).pretty()
    ```

    ## Chaining

    ```
    db.posts.find().limit(2).sort({ title: 1 }).pretty()
    ```

    ## Foreach

    ```
    db.posts.find().forEach(function(doc) {
    print("Blog Post: " + doc.title)
    })
    ```

    ## Find One Row

    ```
    db.posts.findOne({ category: 'News' })
    ```

    ## Find Specific Fields

    ```
    db.posts.find({ title: 'Post One' }, {
    title: 1,
    author: 1
    })
    ```

    ## Update Row

    ```
    db.posts.update({ title: 'Post Two' },
    {
    title: 'Post Two',
    body: 'New body for post 2',
    date: Date()
    },
    {
    upsert: true
    })
    ```

    ## Update Specific Field

    ```
    db.posts.update({ title: 'Post Two' },
    {
    $set: {
    body: 'Body for post 2',
    category: 'Technology'
    }
    })
    ```

    ## Increment Field (\$inc)

    ```
    db.posts.update({ title: 'Post Two' },
    {
    $inc: {
    likes: 5
    }
    })
    ```

    ## Rename Field

    ```
    db.posts.update({ title: 'Post Two' },
    {
    $rename: {
    likes: 'views'
    }
    })
    ```

    ## Delete Row

    ```
    db.posts.remove({ title: 'Post Four' })
    ```

    ## Sub-Documents

    ```
    db.posts.update({ title: 'Post One' },
    {
    $set: {
    comments: [
    {
    body: 'Comment One',
    user: 'Mary Williams',
    date: Date()
    },
    {
    body: 'Comment Two',
    user: 'Harry White',
    date: Date()
    }
    ]
    }
    })
    ```

    ## Find By Element in Array (\$elemMatch)

    ```
    db.posts.find({
    comments: {
    $elemMatch: {
    user: 'Mary Williams'
    }
    }
    }
    )
    ```

    ## Add Index

    ```
    db.posts.createIndex({ title: 'text' })
    ```

    ## Text Search

    ```
    db.posts.find({
    $text: {
    $search: "\"Post O\""
    }
    })
    ```

    ## Greater & Less Than

    ```
    db.posts.find({ views: { $gt: 2 } })
    db.posts.find({ views: { $gte: 7 } })
    db.posts.find({ views: { $lt: 7 } })
    db.posts.find({ views: { $lte: 7 } })
    ```
    # Create user

    ```
    db.createUser("user": "username", "pwd": "password", "roles": ["readWrite", "dbAdmin"]})
    ```