Koray PEKER
Menu
  • Anasayfa
  • Kütüphane
  • Kategoriler
    • Java
    • Spring
    • Tasarım Şablonları
    • Git
    • Maven
    • ORM Çatıları
    • VCS
    • SDLC
    • DevOps
    • Algoritma
    • Eğitim
    • Diğer
  • Hakkımda
Menu

MongoDB Cheat Sheet

11 Nisan 202011 Nisan 2020 tarihinde yayımlandı
SQL Terms/Concepts MongoDB Terms/Concepts
database database
table collection
row document
column field
index index
table joins embedded documents and linking

Show All Databases

Java
1
show dbs

Show Current Database

Java
1
db

Create Or Switch Database

Java
1
use user

Display help on DB methods

Java
1
db.help()

Drop Database

Java
1
db.dropDatabase()

Create Collection

Java
1
db.createCollection('user')

Show Collections

Java
1
show collections

Display help on Collection

Java
1
db.collection.help();

Drop Collection

Java
1
db.user.drop()

Insert Row

Java
1
2
3
4
5
db.user.insertOne({
  name: 'koray',
  surname: 'peker',
  yearOfBirth: 1987
})

Insert Multiple Rows

Java
1
2
3
4
5
6
7
8
9
10
11
db.user.insertMany([
  {
    name: 'koray', surname: 'peker', yearOfBirth: 1987
  },
  {
    name: 'koray2', surname: 'peker', yearOfBirth: 1992
  },
  {
    name: 'koray3', surname: 'peker', yearOfBirth: 2021
  }
])

Get All Rows

Java
1
db.user.find()

Get All Rows Formatted

Java
1
db.user.find().pretty()

Find Rows

Java
1
db.user.find({name : "koray"})

Sort Rows

Java
1
2
# asc
db.user.find().sort({yearOfBirth:1})
Java
1
2
# desc
db.user.find().sort({yearOfBirth:-1})

Count Rows

Java
1
2
db.user.find().count()
db.user.find({name:"koray"}).count()

Limit Rows

Java
1
db.user.find().limit(2)

Chaining

Java
1
db.user.find().limit(2).sort({ yearOfBirth: 1 })

Foreach

Java
1
2
3
db.user.find().forEach(function(doc) {
  print("User Name: " + doc.name)
})

Find One Row

Java
1
db.user.findOne({name:"koray"})

Find Specific Fields

Java
1
2
db.user.find({}, { yearOfBirth: 1, surname: 1 })
db.user.find({"name":"koray"}, {name:true, surname:true, _id:false})

Find With Comparison Operators

Java
1
2
3
4
5
6
7
8
db.user.find({yearOfBirth: {$eq: 1987}})
db.user.find({yearOfBirth: {$lt: 1987}})
db.user.find({yearOfBirth: {$lte: 1987}})
db.user.find({yearOfBirth: {$gt: 1987}})
db.user.find({yearOfBirth: {$gte: 1987}})
db.user.find({yearOfBirth: {$ne: 1987}})
db.user.find({yearOfBirth: {$in: [1987, 1988]}})
db.user.find({yearOfBirth: {$nin: [1987, 1988]}})

Find With Logical Operators

Java
1
2
3
4
db.user.find( { $or: [{yearOfBirth: {$lte: 1987}}, {yearOfBirth: {$eq: 1988}}]})
db.user.find( { $and: [{yearOfBirth: {$eq: 1987}}, {name: {$eq: "koray"}}]})
db.user.find( {$not: {yearOfBirth: {$eq: 1992} }})
db.user.find( { $nor: [{yearOfBirth: {$lte: 1987}}, {yearOfBirth: {$eq: 1988}}]})

Find With Element Operators

Java
1
db.user.find( {name: {$exists: true }})

Update Row

Java
1
2
3
4
5
6
7
8
9
10
11
db.user.update({ name: "koray" },
{
  name "koray",
  surname: "peker",
  yearOfBirth:1988
},
{
  upsert: true
})
 
db.user.updateOne({ name: "koray" }, { $set: { yearOfBirth: 1987 } })

Update Multiple Rows

Java
1
db.user.updateMany({}, { $set: { yearOfBirth: 1987 } })

Update Specific Field

Java
1
2
3
4
5
6
db.user.update({ name: "koray" },
{
  $set: {
    yearOfBirth:1988
  }
})

Increment Field ($inc)

Java
1
2
3
4
5
6
db.posts.update({ name: "koray" },
{
  $inc: {
    yearOfBirth: 5
  }
})

Rename Field

Java
1
2
3
4
5
6
db.posts.update({ name: "koray" },
{
  $rename: {
    yearOfBirth: "age"
  }
})

Delete Row

Java
1
2
3
db.user.remove({ name: "koray" })
db.user.deleteOne({ name: "koray" })
db.user.deleteMany({ yearOfBirth: { $gt: 2000 } })

Create An Index

Java
1
db.user.createIndex({ name: 1 })

Create a Unique Index

Java
1
db.user.createIndex( {name:1},{unique:true} )

Create a Index On Multiple Fields (Compound Index)

Java
1
db.user.createIndex({name:1, surname:-1})

Show All Indexes In a Collection

Java
1
db.user.getIndexes()

Drop an Index

Java
1
db.user.dropIndex({name:-1})

Show Index Statistics

Java
1
db.user.stats()

Kaynaklar

  • https://docs.mongodb.com/manual/reference/operator/query/
  • https://info-mongodb-com.s3.amazonaws.com/ReferenceCards15-PDF.pdf
  • https://docs.mongodb.com/manual/
  • https://docs.mongodb.com/manual/reference/method/js-collection/
  • https://gist.github.com/aponxi/4380516

1 yorum yapıldı “MongoDB Cheat Sheet”

  1. Can dedi ki:
    13 Nisan 2020, 00:07

    Mongodb cluster kurulumunda config tanımlanırken cluster nodelarını config file a direk yazabilirmiyiz.
    Ve sonrasınsa sistem reboot olsabile doğrudan rs.initiate() olmasını sağlayabilirmiyiz?

    Teşekkür ederim

    Cevapla

Bir cevap yazın Cevabı iptal et

E-posta hesabınız yayımlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir

POPÜLER YAZILAR

  • CI (Continuous integration) ve CD (Continuous Delivery/Deployment)
  • Bir Yazılımcının Sırt Çantası
  • NullPointerException’dan Kaçış
  • Project : Lombok
  • JAR, WAR, EAR Üçlemesi
  • İlk işime veda :(
  • REST Mimarisi ve RESTful Servisler
  • Mutable ve Immutable nedir ?
  • Yük Testi ve SoapUI
  • Versiyon Kontrol Sistemleri (VCS)

Ara

Son Yazılar

  • Apache Kafka
  • Postman API’ları Görselleştirme
  • MongoDB Cheat Sheet
  • Splunk 101 – Giriş
  • Yük Testi ve SoapUI
  • Modern Veri Tabanları
  • Senior Stajyer ?!
  • API Dokümantasyon Önemi ve Swagger
  • Kod Tekrarı(Code Duplication) ve DRY
  • Yapılacaklar : Kitap OKU

TAKİP ET

Koray PEKER
©2021 Koray PEKER