MongoDB CLI

docker run -d --name testMongoDB \
  -e MONGO_INITDB_ROOT_USERNAME=admin \
  -e MONGO_INITDB_ROOT_PASSWORD=password \
  -p 27017:27017 \
  mongo

docker run -d --name mongodb \
  -p 27017:27017 \
  -v "D:/DatabaseMount/Mongo":/data/db \
  -e MONGO_INITDB_ROOT_USERNAME=admin \
  -e MONGO_INITDB_ROOT_PASSWORD=admin \
  mongo:latest

docker exec -it CONTAINER_ID bash
mongosh

# 列出所有資料庫
show dbs

# 切換/建立資料庫（資料庫不存在時，插入資料後自動建立）
use database

# 刪除目前資料庫
db.dropDatabase()

# 列出所有 collections
show collections

# 建立 collection
db.createCollection("students")

db.auth("admin", "password")

db.help()

db.createUser({
  user: "admin",
  pwd: "password",
  roles: [
    { role: "userAdminAnyDatabase", db: "admin" },
    "readWriteAnyDatabase"
  ]
})

db.createUser({
  user: "user1",
  pwd: "123456",
  roles: [{ role: "readWrite", db: "demo" }]
})

db.grantRolesToUser(
  "demouser",
  [{ role: "readWrite", db: "demo" }]
)

db.students.insertOne({ name: "Spongebob", age: 30, gpa: 3.2 })

{
  "acknowledged": true,
  "insertedId": ObjectId("64fc64cd3d53295f6abd2856")
}

db.students.insertMany([
  { name: "Patrick", age: 38, gpa: 1.5 },
  { name: "Sandy", age: 27, gpa: 4.0 },
  { name: "Gary", age: 18, gpa: 2.5 }
])

db.students.find()

db.students.find({ age: 18 })

# 只回傳 name 欄位（含 _id）
db.students.find({}, { name: true })

# 不含 _id
db.students.find({}, { _id: false, name: true })

# 計數
db.students.find().count()

# 限制筆數
db.students.find().limit(2)

# 排序（1: 升冪, -1: 降冪）
db.students.find().sort({ name: 1 })

db.students.updateOne(filter, update)

db.students.updateOne(
  { name: "Spongebob" },
  { $set: { fullTime: true } }
)

db.students.updateOne(
  { _id: ObjectId("65000e5f94ba2fcc6d4f05df") },
  { $set: { fullTime: false } }
)

db.students.updateOne(
  { name: "Sandy" },
  { $unset: { fullTime: "" } }
)

# 為所有文件新增 fullTime 欄位
db.students.updateMany({}, { $set: { fullTime: false } })

# 僅更新沒有 fullTime 欄位的文件
db.students.updateMany(
  { fullTime: { $exists: false } },
  { $set: { fullTime: true } }
)

db.system.users.update(
  { "user": "user1" },
  { $set: { "user": "admin" } }
)

db.books.find({ rating: { $gt: 7 } })

db.books.find({ rating: { $lt: 8 } })

db.books.find({ rating: { $lte: 8 } })

db.books.find({ $or: [{ rating: 7 }, { rating: 9 }] })

db.books.find({
  $or: [
    { pages: { $lt: 300 } },
    { pages: { $gt: 400 } }
  ]
})

# rating 在 7, 8, 9 之中
db.books.find({ rating: { $in: [7, 8, 9] } })

# rating 不在 7, 8, 9 之中
db.books.find({ rating: { $nin: [7, 8, 9] } })

# genres 陣列包含 "fantasy"
db.books.find({ genres: "fantasy" })

# genres 陣列「只有」["fantasy"]
db.books.find({ genres: ["fantasy"] })

# genres 陣列為 ["fantasy", "magic"]（順序需一致）
db.books.find({ genres: ["fantasy", "magic"] })

# genres 包含 "fantasy" 和 "sci-fi"（順序無關）
db.books.find({ genres: { $all: ["fantasy", "sci-fi"] } })

# reviews 陣列中有 name 為 "Luigi" 的物件
db.books.find({ "reviews.name": "Luigi" })

rs.initiate({
  _id: "rs0",
  members: [{ _id: 0, host: "localhost:27017" }]
})

rs.status()

{
  "set": "rs0",
  "myState": 1,
  "members": [
    {
      "_id": 0,
      "name": "localhost:27017",
      "health": 1,
      "state": 1,
      "stateStr": "PRIMARY"
    }
  ],
  "ok": 1
}

db.order.aggregate([
  { $match: { _id: ObjectId("5968d724592e0a4141ea43e7") } }
])

db.order.aggregate([
  { $match: { _id: ObjectId("5968d724592e0a4141ea43e7") } },
  {
    $lookup: {
      from: "web",
      localField: "webId",
      foreignField: "_id",
      as: "webData"
    }
  }
])

db.users.aggregate([
  {
    $group: {
      _id: null,
      averageAge: { $avg: "$age" }
    }
  }
])

db.users.aggregate([
  {
    $group: {
      _id: "$gender",
      averageAge: { $avg: "$age" }
    }
  }
])

db.users.aggregate([
  {
    $group: {
      _id: "$favoriteFruit",
      count: { $sum: 1 }
    }
  },
  { $sort: { count: -1 } },
  { $limit: 5 }
])