C:\S2025_JointDB\website\demo\c4333>mongosh
Current Mongosh Log ID: 67fff4ef5fe3e2f474e9b2a7
Connecting to:          mongodb://127.0.0.1:27017/?directConnection=true&serverSelectionTimeoutMS=2000
Using MongoDB:          5.0.5
Using Mongosh:          1.1.8

For mongosh info see: https://docs.mongodb.com/mongodb-shell/

------
   The server generated these startup warnings when booting:
   2025-04-16T12:57:55.037-05:00: Access control is not enabled for the database. Read and write access to data and configuration is unrestricted
------

test> show dbs
MMIM_Ex2   205 kB
RefInt     123 kB
admin      135 kB
config    36.9 kB
local      115 kB
swim       532 kB
tinker     111 kB
toyu       369 kB
test> show dbs
MMIM_Ex2   205 kB
RefInt     123 kB
admin      135 kB
config    98.3 kB
local      115 kB
swim       532 kB
toyu       369 kB
test> use tinker
switched to db tinker
tinker> db.test1.insertOne(
...    {
.....       "StudentId" :1,
.....       "StudentName" : "Joseph Connor"
.....    }
... )
Browserslist: caniuse-lite is outdated. Please run:
  npx browserslist@latest --update-db
  Why you should do it regularly: https://github.com/browserslist/browserslist#browsers-data-updating
{
  acknowledged: true,
  insertedId: ObjectId("67fff77e00a125dc2f626d32")
}
tinker> doc1 = {
...       "StudentId" :1,
...       "StudentName" : "Joseph Connor"
...    }
{ StudentId: 1, StudentName: 'Joseph Connor' }
tinker> doc1
{ StudentId: 1, StudentName: 'Joseph Connor' }
tinker> db.test1.insertOne(doc1)
{
  acknowledged: true,
  insertedId: ObjectId("67fff8d100a125dc2f626d33")
}
tinker> db.test1.find()
[
  {
    _id: ObjectId("67fff77e00a125dc2f626d32"),
    StudentId: 1,
    StudentName: 'Joseph Connor'
  },
  {
    _id: ObjectId("67fff8d100a125dc2f626d33"),
    StudentId: 1,
    StudentName: 'Joseph Connor'
  }
]
tinker> doc1
{ StudentId: 1, StudentName: 'Joseph Connor' }
tinker> if (db.test1.find(doc1).count() == 0) { db.test1.insertOne(doc1) }
{
  acknowledged: true,
  insertedId: ObjectId("67fff9e300a125dc2f626d34")
}
tinker>

tinker> if (db.test1.find(doc1).count() == 0) { db.test1.insertOne(doc1) }

tinker> db.test1.find()
[
  {
    _id: ObjectId("67fff9e300a125dc2f626d34"),
    StudentId: 1,
    StudentName: 'Joseph Connor'
  }
]
tinker> show dbs
MMIM_Ex2  205 kB
RefInt    123 kB
admin     135 kB
config    111 kB
local     115 kB
swim      532 kB
tinker     41 kB
toyu      369 kB
tinker> db.dropDatabase()
{ ok: 1, dropped: 'tinker' }
tinker> show dbs
MMIM_Ex2  205 kB
RefInt    123 kB
admin     135 kB
config    111 kB
local     115 kB
swim      532 kB
toyu      369 kB
tinker>

tinker> // remove tinker

tinker> use tinker
already on db tinker
tinker> db.test1.find()

tinker> doc = {
...       "StudentId" :1,
...       "StudentName" : "Joseph Connor"
... }
{ StudentId: 1, StudentName: 'Joseph Connor' }
tinker> doc
{ StudentId: 1, StudentName: 'Joseph Connor' }
tinker> if (db.test1.find(doc).count() == 0) { db.test1.insertOne(doc) }
{
  acknowledged: true,
  insertedId: ObjectId("67fffaa700a125dc2f626d35")
}
tinker> db.test1.find()
[
  {
    _id: ObjectId("67fffaa700a125dc2f626d35"),
    StudentId: 1,
    StudentName: 'Joseph Connor'
  }
]
tinker> if (db.test1.find(doc).count() == 0) { db.test1.insertOne(doc) }

tinker> db.test1.find()
[
  {
    _id: ObjectId("67fffaa700a125dc2f626d35"),
    StudentId: 1,
    StudentName: 'Joseph Connor'
  }
]
tinker> use tinker// remove tinker
MongoshInvalidInputError: [COMMON-10001] Invalid database name: tinker//
tinker> show dbs
MMIM_Ex2  205 kB
RefInt    123 kB
admin     135 kB
config    111 kB
local     115 kB
swim      532 kB
tinker     41 kB
toyu      369 kB
tinker> db.dropDatabase()
{ ok: 1, dropped: 'tinker' }
tinker> show dbs
MMIM_Ex2  205 kB
RefInt    123 kB
admin     135 kB
config    111 kB
local     115 kB
swim      532 kB
toyu      369 kB
tinker> // create index

tinker> db.test1.createIndex( { "StudentId": 1 }, { unique: true } )
StudentId_1
tinker> doc = {
...       "StudentId" :1,
...       "StudentName" : "Joseph Connor"
... }
{ StudentId: 1, StudentName: 'Joseph Connor' }
tinker> doc
{ StudentId: 1, StudentName: 'Joseph Connor' }
tinker> db.test1.insertOne(doc)
{
  acknowledged: true,
  insertedId: ObjectId("67fffba200a125dc2f626d36")
}
tinker> db.test1.insertOne(doc)
MongoServerError: E11000 duplicate key error collection: tinker.test1 index: StudentId_1 dup key: { StudentId: 1 }
tinker> db.test1.insertMany([
...    {   "StudentId" :2,
.....       "GPA": 3.72
.....    },
...    {   "StudentId" :3,
.....       "GPA": 1.69
.....    },
...    {
.....       "BCAssetId": "78c22fc6-5dec-11ec-bf63-0242ac130002",
.....       "BCAssetType": "BCAssetTypeMetadata",
.....       "BCAssetName": "BCAssetTypeMetadata: MBSEModel",
.....       "ForBCAssetType": "MBSEModel",
.....       "Version": {
.......          "Version": "1.0",
.......          "Subversion": null,
.......          "StartTime": "2019-01-13T07:23:13+06:00"
.......       }
.....    }
... ])
{
  acknowledged: true,
  insertedIds: {
    '0': ObjectId("67fffc6f00a125dc2f626d38"),
    '1': ObjectId("67fffc6f00a125dc2f626d39"),
    '2': ObjectId("67fffc6f00a125dc2f626d3a")
  }
}
tinker> db.test1.find()
[
  {
    _id: ObjectId("67fffba200a125dc2f626d36"),
    StudentId: 1,
    StudentName: 'Joseph Connor'
  },
  {
    _id: ObjectId("67fffc6f00a125dc2f626d38"),
    StudentId: 2,
    GPA: 3.72
  },
  {
    _id: ObjectId("67fffc6f00a125dc2f626d39"),
    StudentId: 3,
    GPA: 1.69
  },
  {
    _id: ObjectId("67fffc6f00a125dc2f626d3a"),
    BCAssetId: '78c22fc6-5dec-11ec-bf63-0242ac130002',
    BCAssetType: 'BCAssetTypeMetadata',
    BCAssetName: 'BCAssetTypeMetadata: MBSEModel',
    ForBCAssetType: 'MBSEModel',
    Version: {
      Version: '1.0',
      Subversion: null,
      StartTime: '2019-01-13T07:23:13+06:00'
    }
  }
]
tinker> show dbs
MMIM_Ex2  205 kB
RefInt    123 kB
admin     135 kB
config    111 kB
local     115 kB
swim      532 kB
tinker    111 kB
tinker> show dbs
MMIM_Ex2   205 kB
RefInt     123 kB
admin      135 kB
config     111 kB
local      115 kB
swim       532 kB
tinker     111 kB
toyu      73.7 kB
tinker> //Show all students.

tinker> use toyu
switched to db toyu
toyu> db.student.find()
[
  {
    _id: ObjectId("63c19f66c1fb90601512c759"),
    stuId: 100000,
    fname: 'Tony',
    lname: 'Hawk',
    major: 'CSCI',
    minor: 'CINF',
    ach: 40,
    advisor: 1011
  },
  {
    _id: ObjectId("63c19f66c1fb90601512c75a"),
    stuId: 100001,
    fname: 'Mary',
    lname: 'Hawk',
    major: 'CSCI',
    minor: 'CINF',
    ach: 35,
    advisor: 1011
  },
  {
    _id: ObjectId("63c19f66c1fb90601512c75b"),
    stuId: 100002,
    fname: 'David',
    lname: 'Hawk',
    major: 'CSCI',
    minor: 'ITEC',
    ach: 66,
    advisor: 1012
  },
  {
    _id: ObjectId("63c19f66c1fb90601512c75c"),
    stuId: 100003,
    fname: 'Catherine',
    lname: 'Lim',
    major: 'ITEC',
    minor: 'CINF',
    ach: 20,
    advisor: null
  },
  {
    _id: ObjectId("63c19f66c1fb90601512c75d"),
    stuId: 100004,
    fname: 'Larry',
    lname: 'Johnson',
    major: 'ITEC',
    minor: null,
    ach: 66,
    advisor: 1017
  },
  {
    _id: ObjectId("63c19f66c1fb90601512c75e"),
    stuId: 100005,
    fname: 'Linda',
    lname: 'Johnson',
    major: 'CINF',
    minor: 'ENGL',
    ach: 13,
    advisor: 1015
  },
  {
    _id: ObjectId("63c19f66c1fb90601512c75f"),
    stuId: 100006,
    fname: 'Lillian',
    lname: 'Johnson',
    major: 'CINF',
    minor: 'ITEC',
    ach: 18,
    advisor: 1016
  },
  {
    _id: ObjectId("63c19f66c1fb90601512c760"),
    stuId: 100007,
    fname: 'Ben',
    lname: 'Zico',
    major: null,
    minor: null,
    ach: 16,
    advisor: null
  },
  {
    _id: ObjectId("63c19f66c1fb90601512c761"),
    stuId: 100008,
    fname: 'Bill',
    lname: 'Ching',
    major: 'ARTS',
    minor: null,
    ach: 90,
    advisor: null
  },
  {
    _id: ObjectId("63c19f66c1fb90601512c762"),
    stuId: 100009,
    fname: 'Linda',
    lname: 'King',
    major: 'ARTS',
    minor: 'CSCI',
    ach: 125,
    advisor: 1018
  },
  {
    _id: ObjectId("63c19f66c1fb90601512c763"),
    stuId: 100111,
    fname: 'Cathy',
    lname: 'Johanson',
    major: null,
    minor: null,
    ach: 0,
    advisor: 1018
  }
]
toyu> db.student.find({},
...    { "_id": 0 }
... )
[
  {
    stuId: 100000,
    fname: 'Tony',
    lname: 'Hawk',
    major: 'CSCI',
    minor: 'CINF',
    ach: 40,
    advisor: 1011
  },
  {
    stuId: 100001,
    fname: 'Mary',
    lname: 'Hawk',
    major: 'CSCI',
    minor: 'CINF',
    ach: 35,
    advisor: 1011
  },
  {
    stuId: 100002,
    fname: 'David',
    lname: 'Hawk',
    major: 'CSCI',
    minor: 'ITEC',
    ach: 66,
    advisor: 1012
  },
  {
    stuId: 100003,
    fname: 'Catherine',
    lname: 'Lim',
    major: 'ITEC',
    minor: 'CINF',
    ach: 20,
    advisor: null
  },
  {
    stuId: 100004,
    fname: 'Larry',
    lname: 'Johnson',
    major: 'ITEC',
    minor: null,
    ach: 66,
    advisor: 1017
  },
  {
    stuId: 100005,
    fname: 'Linda',
    lname: 'Johnson',
    major: 'CINF',
    minor: 'ENGL',
    ach: 13,
    advisor: 1015
  },
  {
    stuId: 100006,
    fname: 'Lillian',
    lname: 'Johnson',
    major: 'CINF',
    minor: 'ITEC',
    ach: 18,
    advisor: 1016
  },
  {
    stuId: 100007,
    fname: 'Ben',
    lname: 'Zico',
    major: null,
    minor: null,
    ach: 16,
    advisor: null
  },
  {
    stuId: 100008,
    fname: 'Bill',
    lname: 'Ching',
    major: 'ARTS',
    minor: null,
    ach: 90,
    advisor: null
  },
  {
    stuId: 100009,
    fname: 'Linda',
    lname: 'King',
    major: 'ARTS',
    minor: 'CSCI',
    ach: 125,
    advisor: 1018
  },
  {
    stuId: 100111,
    fname: 'Cathy',
    lname: 'Johanson',
    major: null,
    minor: null,
    ach: 0,
    advisor: 1018
  }
]
toyu> db.student.find({},
...    { "_id": false }
... )
[
  {
    stuId: 100000,
    fname: 'Tony',
    lname: 'Hawk',
    major: 'CSCI',
    minor: 'CINF',
    ach: 40,
    advisor: 1011
  },
  {
    stuId: 100001,
    fname: 'Mary',
    lname: 'Hawk',
    major: 'CSCI',
    minor: 'CINF',
    ach: 35,
    advisor: 1011
  },
  {
    stuId: 100002,
    fname: 'David',
    lname: 'Hawk',
    major: 'CSCI',
    minor: 'ITEC',
    ach: 66,
    advisor: 1012
  },
  {
    stuId: 100003,
    fname: 'Catherine',
    lname: 'Lim',
    major: 'ITEC',
    minor: 'CINF',
    ach: 20,
    advisor: null
  },
  {
    stuId: 100004,
    fname: 'Larry',
    lname: 'Johnson',
    major: 'ITEC',
    minor: null,
    ach: 66,
    advisor: 1017
  },
  {
    stuId: 100005,
    fname: 'Linda',
    lname: 'Johnson',
    major: 'CINF',
    minor: 'ENGL',
    ach: 13,
    advisor: 1015
  },
  {
    stuId: 100006,
    fname: 'Lillian',
    lname: 'Johnson',
    major: 'CINF',
    minor: 'ITEC',
    ach: 18,
    advisor: 1016
  },
  {
    stuId: 100007,
    fname: 'Ben',
    lname: 'Zico',
    major: null,
    minor: null,
    ach: 16,
    advisor: null
  },
  {
    stuId: 100008,
    fname: 'Bill',
    lname: 'Ching',
    major: 'ARTS',
    minor: null,
    ach: 90,
    advisor: null
  },
  {
    stuId: 100009,
    fname: 'Linda',
    lname: 'King',
    major: 'ARTS',
    minor: 'CSCI',
    ach: 125,
    advisor: 1018
  },
  {
    stuId: 100111,
    fname: 'Cathy',
    lname: 'Johanson',
    major: null,
    minor: null,
    ach: 0,
    advisor: 1018
  }
]
toyu> // Show all information of students majoring in 'CINF'.

toyu>

toyu> db.student.find({"major": "CINF"},
...     { "_id": 0 }
... )
[
  {
    stuId: 100005,
    fname: 'Linda',
    lname: 'Johnson',
    major: 'CINF',
    minor: 'ENGL',
    ach: 13,
    advisor: 1015
  },
  {
    stuId: 100006,
    fname: 'Lillian',
    lname: 'Johnson',
    major: 'CINF',
    minor: 'ITEC',
    ach: 18,
    advisor: 1016
  }
]
toyu> db.student.find({"major": "CINF"},
...     { "_id": 0, "stuId": 1, "fname": 1, "lname": 1, "major": 1 }
... )
[
  { stuId: 100005, fname: 'Linda', lname: 'Johnson', major: 'CINF' },
  { stuId: 100006, fname: 'Lillian', lname: 'Johnson', major: 'CINF' }
]
toyu> db.student.find({"maj": "CINF"},
...     { "_id": 0, "stuId": 1, "fname": 1, "lname": 1, "major": 1 }
... )

toyu> Show all student names. Return an array of student objects.
Uncaught:
SyntaxError: Missing semicolon. (1:4)

> 1 | Show all student names. Return an array of student objects.
    |     ^
  2 |

toyu> db.student.find({},
...    { "fname": 1, "lname":1, "_id": 0 }
... )
[
  { fname: 'Tony', lname: 'Hawk' },
  { fname: 'Mary', lname: 'Hawk' },
  { fname: 'David', lname: 'Hawk' },
  { fname: 'Catherine', lname: 'Lim' },
  { fname: 'Larry', lname: 'Johnson' },
  { fname: 'Linda', lname: 'Johnson' },
  { fname: 'Lillian', lname: 'Johnson' },
  { fname: 'Ben', lname: 'Zico' },
  { fname: 'Bill', lname: 'Ching' },
  { fname: 'Linda', lname: 'King' },
  { fname: 'Cathy', lname: 'Johanson' }
]
toyu> result = db.student.find({},
...    { "fname": 1, "lname":1, "_id": 0 }
... ).toArray()
[
  { fname: 'Tony', lname: 'Hawk' },
  { fname: 'Mary', lname: 'Hawk' },
  { fname: 'David', lname: 'Hawk' },
  { fname: 'Catherine', lname: 'Lim' },
  { fname: 'Larry', lname: 'Johnson' },
  { fname: 'Linda', lname: 'Johnson' },
  { fname: 'Lillian', lname: 'Johnson' },
  { fname: 'Ben', lname: 'Zico' },
  { fname: 'Bill', lname: 'Ching' },
  { fname: 'Linda', lname: 'King' },
  { fname: 'Cathy', lname: 'Johanson' }
]
toyu>

toyu> // May not always work as toArray() returns a promise,

toyu> // which may not be ready for use.

toyu> result.forEach((x,i) => console.log('student #' + String(i) + ': ' + x["fname"] + ' ' + x["lname"]))
student #0: Tony Hawk
student #1: Mary Hawk
student #2: David Hawk
student #3: Catherine Lim
student #4: Larry Johnson
student #5: Linda Johnson
student #6: Lillian Johnson
student #7: Ben Zico
student #8: Bill Ching
student #9: Linda King
student #10: Cathy Johanson

toyu> result = db.student.find({},
...    { "fname": 1, "lname":1, "_id": 0 }
... ).toArray()
[
  { fname: 'Tony', lname: 'Hawk' },
  { fname: 'Mary', lname: 'Hawk' },
  { fname: 'David', lname: 'Hawk' },
  { fname: 'Catherine', lname: 'Lim' },
  { fname: 'Larry', lname: 'Johnson' },
  { fname: 'Linda', lname: 'Johnson' },
  { fname: 'Lillian', lname: 'Johnson' },
  { fname: 'Ben', lname: 'Zico' },
  { fname: 'Bill', lname: 'Ching' },
  { fname: 'Linda', lname: 'King' },
  { fname: 'Cathy', lname: 'Johanson' }
]
toyu> // May not always work as toArray() returns a promise,

toyu> // which may not be ready for use.

toyu> result.forEach((x,i) => console.log('student #' + String(i) + ': ' + x["fname"] + ' ' + x["lname"]))
student #0: Tony Hawk
student #1: Mary Hawk
student #2: David Hawk
student #3: Catherine Lim
student #4: Larry Johnson
student #5: Linda Johnson
student #6: Lillian Johnson
student #7: Ben Zico
student #8: Bill Ching
student #9: Linda King
student #10: Cathy Johanson

toyu> result.forEach((x,i) => console.log('student #' + String(i+1) + ': ' + x["fname"] + ' ' + x["lname"]))
student #1: Tony Hawk
student #2: Mary Hawk
student #3: David Hawk
student #4: Catherine Lim
student #5: Larry Johnson
student #6: Linda Johnson
student #7: Lillian Johnson
student #8: Ben Zico
student #9: Bill Ching
student #10: Linda King
student #11: Cathy Johanson

toyu> db.student.find(
...    { "major": "CSCI", "ach" : {$gte: 40} },
...    { "fname": 1, "lname":1, "ach":1, "_id": 0 }
... )
[
  { fname: 'Tony', lname: 'Hawk', ach: 40 },
  { fname: 'David', lname: 'Hawk', ach: 66 }
]
toyu> db.student.find(
...    { "major": "CSCI", "ach" : {$gte: 40} },
...    { "fname": 1, "lname":1, "ach":1, "major":1,  "_id": 0 }
... )
[
  { fname: 'Tony', lname: 'Hawk', major: 'CSCI', ach: 40 },
  { fname: 'David', lname: 'Hawk', major: 'CSCI', ach: 66 }
]
toyu>