// 1. Sélectionner la base de données
use hospital

// 2. Insérer un patient
db.patients.insertOne({
    name: "Max",
    age: 29,
    diseaseSummary: "sum-max-1"
})

// 3. Afficher le patient
db.patients.findOne()

// 4. Insérer son résumé médical
db.diseaseSummaries.insertOne({
    _id: "sum-max-1",
    diseases: ["cold", "fever"]
    
})

// 5. Afficher le patient
db.patients.findOne()

// 6. Récupérer la référence
var dsid = db.patients.findOne().diseaseSummary

// 7. Afficher la référence
print(dsid)

// 8. Retrouver le résumé médical correspondant
db.diseaseSummaries.findOne({
    _id: dsid
})




use hospital
db.patients.insertOne({
    name: "Max",
    age: 29,
    diseaseSummary: {
        diseases: ["cold", "fever"]
    }
})

db.patients.findOne({
    name: "Max"
})

{
    "_id": ObjectId("..."),
    "name": "Max",
    "age": 29,
    "diseaseSummary": {
        "diseases": [
            "cold",
            "fever"
        ]
    }
}

db.patients.findOne(
    { name: "Max" },
    { _id: 0, "diseaseSummary.diseases": 1 }
)

db.patients.find({
    "diseaseSummary.diseases": "cold"
})

{
    name: "Max",
    age: 29,
    diseaseSummary: "sum-max-1"
}


{
    name: "Max",
    age: 29,
    diseaseSummary: {
        diseases: ["cold", "fever"]
    }
}

use carData
db.persones.insertOne({
    name: "Max",
    car: {
        model: "BMW",
        price: 40000
    }
})

db.persones.findOne()
db.persones.find({
    "car.model": "BMW"
})


use carData
db.persones.insertOne({
    name: "Max"
})
db.cars.insertOne({
    _id: "car-max-1",
    model: "BMW",
    price: 40000
})