test> show dbs
admin   40.00 KiB
config  60.00 KiB
local   40.00 KiB
admin> use uni
switched to db uni
uni> db.createCollection("classes")
{ ok: 1 }
uni> show dbs
admin    40.00 KiB
config  108.00 KiB
local    40.00 KiB
uni       8.00 KiB
uni> db.dropDatabase()
{ ok: 1, dropped: 'uni' }
uni> show dbs
admin    40.00 KiB
config  108.00 KiB
local    40.00 KiB
uni> use uni
already on db uni
uni> db.classes.insertOne({name: "CBD", year:3, semester:1})
{
  acknowledged: true,
  insertedId: ObjectId("65154cc1ab142e5f12a10a14")
}
uni> db.classes.find()
[
  {
    _id: ObjectId("65154cc1ab142e5f12a10a14"),
    name: 'CBD',
    year: 3,
    semester: 1
  }
]
uni> db.classes.insertOne({name: "BD", year:2, semester:1})
{
  acknowledged: true,
  insertedId: ObjectId("65154db5ab142e5f12a10a15")
}
uni> db.classes.find()
[
  {
    _id: ObjectId("65154cc1ab142e5f12a10a14"),
    name: 'CBD',
    year: 3,
    semester: 1
  },
  {
    _id: ObjectId("65154db5ab142e5f12a10a15"),
    name: 'BD',
    year: 2,
    semester: 1
  }
]
uni> db.classes.find().sort("name:1")
[
  {
    _id: ObjectId("65154cc1ab142e5f12a10a14"),
    name: 'CBD',
    year: 3,
    semester: 1
  },
  {
    _id: ObjectId("65154db5ab142e5f12a10a15"),
    name: 'BD',
    year: 2,
    semester: 1
  }
]
uni> db.classes.find().sort({name:1})
[
  {
    _id: ObjectId("65154db5ab142e5f12a10a15"),
    name: 'BD',
    year: 2,
    semester: 1
  },
  {
    _id: ObjectId("65154cc1ab142e5f12a10a14"),
    name: 'CBD',
    year: 3,
    semester: 1
  }
]
uni> db.classes.find().sort({year:-1})
[
  {
    _id: ObjectId("65154cc1ab142e5f12a10a14"),
    name: 'CBD',
    year: 3,
    semester: 1
  },
  {
    _id: ObjectId("65154db5ab142e5f12a10a15"),
    name: 'BD',
    year: 2,
    semester: 1
  }
]
uni> db.classes.find().sort({year:-1}).limit(1)
[
  {
    _id: ObjectId("65154cc1ab142e5f12a10a14"),
    name: 'CBD',
    year: 3,
    semester: 1
  }
]
uni> db.classes.updateOne({name:'BD'},{$set:{semester:2}})
{
  acknowledged: true,
  insertedId: null,
  matchedCount: 1,
  modifiedCount: 1,
  upsertedCount: 0
}
uni> db.classes.find({name:'BD'})
[
  {
    _id: ObjectId("65154db5ab142e5f12a10a15"),
    name: 'BD',
    year: 2,
    semester: 2
  }
]
uni> db.classes.deleteOne({name:'BD'})
{ acknowledged: true, deletedCount: 1 }
uni> db.classes.find()
[
  {
    _id: ObjectId("65154cc1ab142e5f12a10a14"),
    name: 'CBD',
    year: 3,
    semester: 1
  }
]
uni>