Cp3 Creating and Manipulating Documents

Inserting New Documents

 

Learn Data Modeling

 

 How does the value fo _id get assigned to a document.

it is automatically generated as an ObjectId type value.

You can select a non ObjectId type value when inserting a new document, as long as that value is unique to this collection.

Inserting New Documents - insert() and errors

In this lesson we used the following commands:

mongoimport --uri="mongodb+srv://<username>:<password>@<cluster>.mongodb.net/sample_supplies" sales.json

mongoimport --uri="mongodb+srv://m001-student:m001-mongodb-basics@Sandbox.mongodb.net/sample_supplies" sales.json

Step one : Connect to the Atlas cluster

mongo "mongodb+srv://<username>:<password>@<cluster>.mongodb.net/admin"

Step two: navigate to the database that we need:

use sample_training

Step three, get a random document from the collection:

db.inspections.findOne();

Step four, copy this random document, and try to insert in into the collection:

db.inspections.insert({ "_id" : ObjectId("56d61033a378eccde8a8354f"), "id" : "10021-2015-ENFO", "certificate_number" : 9278806, "business_name" : "ATLIXCO DELI GROCERY INC.", "date" : "Feb 20 2015", "result" : "No Violation Issued", "sector" : "Cigarette Retail Dealer - 127", "address" : { "city" : "RIDGEWOOD", "zip" : 11385, "street" : "MENAHAN ST", "number" : 1712 } })

db.inspections.insert({ "id" : "10021-2015-ENFO", "certificate_number" : 9278806, "business_name" : "ATLIXCO DELI GROCERY INC.", "date" : "Feb 20 2015", "result" : "No Violation Issued", "sector" : "Cigarette Retail Dealer - 127", "address" : { "city" : "RIDGEWOOD", "zip" : 11385, "street" : "MENAHAN ST", "number" : 1712 } }) db.inspections.find({"id" : "10021-2015-ENFO", "certificate_number" : 9278806}).pretty()

-------------------------------------------------------------------------------------------------

ep: 

C:\Users\psmax>mongosh "mongodb+srv://sandbox.gnors.mongodb.net/myFirstDatabase" --apiVersion 1 --username m001-student
Enter password: *******************
Current Mongosh Log ID: 6242741bf6d6a70ca0c97b21
Connecting to:          mongodb+srv://sandbox.gnors.mongodb.net/myFirstDatabase?appName=mongosh+1.3.1
Using MongoDB:          5.0.6 (API Version 1)
Using Mongosh:          1.3.1

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

Warning: Found ~/.mongorc.js, but not ~/.mongoshrc.js. ~/.mongorc.js will not be loaded.
  You may want to copy or rename ~/.mongorc.js to ~/.mongoshrc.js.
Atlas atlas-nxi8gd-shard-0 [primary] myFirstDatabase> show dbs
sample_airbnb       56.4 MB
sample_analytics    9.58 MB
sample_geospatial   1.46 MB
sample_guides         41 kB
sample_mflix        50.1 MB
sample_restaurants  6.97 MB
sample_supplies     1.18 MB
sample_training     58.2 MB
sample_weatherdata   2.9 MB
admin                385 kB
local               8.65 GB
Atlas atlas-nxi8gd-shard-0 [primary] myFirstDatabase> use sample_
use sample_airbnb       use sample_analytics    use sample_geospatial   use sample_guides       use sample_mflix        use sample_restaurants  use sample_supplies     use sample_training
use sample_weatherdata

Atlas atlas-nxi8gd-shard-0 [primary] myFirstDatabase> use sample_training
switched to db sample_training
Atlas atlas-nxi8gd-shard-0 [primary] sample_training>

Atlas atlas-nxi8gd-shard-0 [primary] sample_training> db.inspections.findOne()
{
  _id: ObjectId("56d61033a378eccde8a8354f"),
  id: '10021-2015-ENFO',
  certificate_number: 9278806,
  business_name: 'ATLIXCO DELI GROCERY INC.',
  date: 'Feb 20 2015',
  result: 'No Violation Issued',
  sector: 'Cigarette Retail Dealer - 127',
  address: { city: 'RIDGEWOOD', zip: 11385, street: 'MENAHAN ST', number: 1712 }
}
Atlas atlas-nxi8gd-shard-0 [primary] sample_training>

db.inspections.insert({ "_id" : ObjectId("56d61033a378eccde8a8354f"), "id" : "10021-2015-ENFO", "certificate_number" : 9278806, "business_name" : "ATLIXCO DELI GROCERY INC.", "date" : "Feb 20 2015", "result" : "No Violation Issued", "sector" : "Cigarette Retail Dealer - 127", "address" : { "city" : "RIDGEWOOD", "zip" : 11385, "street" : "MENAHAN ST", "number" : 1712 } })

db.inspections.insert({ "id" : "10021-2015-ENFO", "certificate_number" : 9278806, "business_name" : "ATLIXCO DELI GROCERY INC.", "date" : "Feb 20 2015", "result" : "No Violation Issued", "sector" : "Cigarette Retail Dealer - 127", "address" : { "city" : "RIDGEWOOD", "zip" : 11385, "street" : "MENAHAN ST", "number" : 1712 } }) db.inspections.find({"id" : "10021-2015-ENFO", "certificate_number" : 9278806}).pretty()

 

 

Select all true statements from the following list:

MongoDB can store duplicate documents in the same collection,as long as their _id values are different.

If a document is inserted without a provided _id value,then the _id field and value will be automatically generated for the inserted document before insertion.

Inserting New Documents - insert() order

Insert three test documents:

db.inspections.insert([ { "test": 1 }, { "test": 2 }, { "test": 3 } ])

db.inspections.insert([{ "_id": 1, "test": 1 },{ "_id": 1, "test": 2 }, { "_id": 3, "test": 3 }])

Find the documents with _id: 1

db.inspections.find({ "_id": 1 })

Insert multiple documents specifying the _id values, and using the "ordered": false option.

db.inspections.insert([{ "_id": 1, "test": 1 },{ "_id": 1, "test": 2 }, { "_id": 3, "test": 3 }],{ "ordered": false })

Insert multiple documents with _id: 1 with the default "ordered": true setting

db.inspection.insert([{ "_id": 1, "test": 1 },{ "_id": 3, "test": 3 }])

View collections in the active db

show collections

Switch the active db to training

use training

View all available databases

show dbs

Atlas atlas-nxi8gd-shard-0 [primary] training> db.pets.insert([{ "pet": "cat" }, { "pet": "dog" }, { "pet": "fish" }])
{
  acknowledged: true,
  insertedIds: {
    '0': ObjectId("6242c3abb17c23387790a625"),
    '1': ObjectId("6242c3abb17c23387790a626"),
    '2': ObjectId("6242c3abb17c23387790a627")
  }
}
Atlas atlas-nxi8gd-shard-0 [primary] training> db.pets.insert([{ "_id": 1, "pet": "cat" },
...                 { "_id": 1, "pet": "dog" },
...                 { "_id": 3, "pet": "fish" },
...                 { "_id": 4, "pet": "snake" }], { "ordered": true })
Uncaught:
MongoBulkWriteError: E11000 duplicate key error collection: training.pets index: _id_ dup key: { _id: 1 }
Result: BulkWriteResult {
  result: {
    ok: 1,
    writeErrors: [
      WriteError {
        err: {
          index: 1,
          code: 11000,
          errmsg: 'E11000 duplicate key error collection: training.pets index: _id_ dup key: { _id: 1 }',
          errInfo: undefined,
          op: { _id: 1, pet: 'dog' }
        }
      }
    ],
    writeConcernErrors: [],
    insertedIds: [
      { index: 0, _id: 1 },
      { index: 1, _id: 1 },
      { index: 2, _id: 3 },
      { index: 3, _id: 4 }
    ],
    nInserted: 1,
    nUpserted: 0,
    nMatched: 0,
    nModified: 0,
    nRemoved: 0,
    upserted: [],
    opTime: { ts: Timestamp({ t: 1648542650, i: 9 }), t: Long("121") }
  }
}
Atlas atlas-nxi8gd-shard-0 [primary] training>