//Using video database
use video 

show collections

//It will auto-generate unique ObjectId as id. Any json object can be used as parameter.
db.moviesScratch.insertOne({titile: "Hello, World",imbd: "tt212314"})

db.moviesScratch.insertMany([
{titile: "Hello, World",imbd: "tt212314"},
{titile: "Hello, World2",imbd: "tt2123142"}])

// Also we can define the _id as we need
// Below statement will encounter duplicate key error
// So it will stop at 3th record, then the 4th one won't insert into collection
db.moviesScratch.insertMany([
{_id:"tt1" ,titile: "Hello, World",imbd: "tt212314"},
{_id:"tt2" ,titile: "Hello, World2",imbd: "tt2123142"},
{_id:"tt1" ,titile: "Hello, World3",imbd: "tt2123143"},
{_id:"tt3" ,titile: "Hello, World4",imbd: "tt2123144"}])

// Adding second argument to make insert continuing when facing duplicated key error
db.moviesScratch.insertMany([
{_id:"tt1" ,titile: "Hello, World",imbd: "tt212314"},
{_id:"tt2" ,titile: "Hello, World2",imbd: "tt2123142"},
{_id:"tt1" ,titile: "Hello, World3",imbd: "tt2123143"},
{_id:"tt3" ,titile: "Hello, World4",imbd: "tt2123144"}
],
{"ordered": false})

// It will return the records with mpaaRating equals PG-13 and year euqals 2009
db.movies.find({mpaaRating:"PG-13",year:2009})

// To show the result in a strucutre pretty way
db.movies.find({mpaaRating:"PG-13",year:2009}).pretty()

// To return the number of results
db.movies.find({mpaaRating:"PG-13",year:2009}).count()

// Set constrain on nested object
// In this case, key must be inside of ""
db.movies.find({"wind.direction.angle": 20})

// Exactly Match 
db.movies.find({cast:["Jeff", "Tim"]})

// Find the record contains "Jeff" in its cast array
db.movies.find({cast:"Jeff"})

// Asign its exact index in cast array
db.movies.find({cast.0:"Jeff"})

// If there are several mathes, it will only update the first document
db.movies.updateOne({
    title: "The Martian"
},
{
    $set:{
        poster: "Updated Value"
    }
})

// $inc is another updating operator, it will increase the reviwe value by 3
db.movies.updateOne({
    title: "The Martian"
},
{
    $inc:{
        reviews: 3
    }
})

// $push will add item to an array called reviews(nested object)
// If reviews array doesn't exist, it will create one
db.movies.updateOne({
    title: "The Martian"
},
{
    $push:{
        reviews:{
            rating: 4.5,
            data: "2018-9-01"
        }
    }
})

// It will modified all the matched records
db.movies.updateMany()

// fileter was used to select record
// json document is all the contents stored in json object
db.movies.replaceOne(filter, json object)

db.movies.deleteOne(filter)

db.movies.deleteMany(filter)