//Insert Movie  data
db.movies.insertMany([
{
title: 'Fight Club',
writer: 'Chuck Palahniuk',
year: 1999,
actors: [
'Brad Pitt',
'Edward Norton'
]
},
{
title: 'Pulp Fiction',
writer: 'Quentin Tarantino',
year: 1994,
actors: [
'John Travolta',
'Uma Thurman'
]
},
{
title: 'Inglorious Basterds',
writer: 'Quentin Tarantino',
year: 2009,
actors: [
'Brad Pitt',
'Diane Kruger',
'Eli Roth'
]
},
{
title: 'The Hobbit: An Unexpected Journey',
writer: 'J.R.R.Tolkein',
year: 2012,
franchise: 'The Hobbit'
},
{
title: 'The Hobbit: The Desolation of Smaug',
writer: 'J.R.R.Tolkein',
year: 2013,
franchise: 'The Hobbit'
},
{
title: 'The Hobbit: The Battle of the Five Armies',
writer: 'J.R.R.Tolkein',
year: 2012,
franchise: 'The Hobbit',
synopsis: 'Bilbo and Company are forced to engage in a war against an array of combatants and keep the Lonely Mountain from falling into the hands of a rising darkness.'
},
{
title: 'Pee Wee Hermans Big Adventure'
},
{
title: 'Avatar'
}
]);




//Query|Find
//1. Get all movies




db.movies.find().pretty();

//2.Get all movies with writer set to "Quentin Tarantino"




db.movies.find({ writer: 'Quentin Tarantino' }).pretty();

//3. Get all movies where actors include "Brad Pitt"






db.movies.find({ actors: 'Brad Pitt' }).pretty();

//4. Get all movies with franchise set to "The Hobbit"






db.movies.find({ franchise: 'The Hobbit' }).pretty();

//5.Get all movies released in the 90s





db.movies.find({ year: { $gte: 1990, $lte: 1999 } }).pretty();

//6.Get all movies released before the year 2000 or after 2010










db.movies.find({ $or: [{ year: { $lt: 2000 } }, { year: { $gt: 2010 } }] }).pretty();

//Update movies 
//1.add a synopsis to "The Hobbit: An Unexpected Journey" : "A reluctant hobbit, Bilbo Baggins, sets out to the Lonely Mountain with a spirited group of dwarves to reclaim their mountain home - and the gold within it - from the dragon Smaug."





db.movies.update({ title: 'The Hobbit: An Unexpected Journey' }, { $set: { synopsis: "A reluctant hobbit, Bilbo Baggins, sets out to the Lonely Mountain with a spirited group of dwarves to reclaim their mountain home - and the gold within it - from the dragon Smaug." } });

//2.add a synopsis to "The Hobbit: The Desolation of Smaug" : "The dwarves, along with Bilbo Baggins and Gandalf the Grey, continue their quest to reclaim Erebor, their homeland, from Smaug. Bilbo Baggins is in possession of a mysterious and magical ring."





db.movies.update({ title: 'The Hobbit: The Desolation of Smaug' }, { $set: { synopsis: "The dwarves, along with Bilbo Baggins and Gandalf the Grey, continue their quest to reclaim Erebor, their homeland, from Smaug. Bilbo Baggins is in possession of a mysterious and magical ring." } });

//3.add an actor named "Samuel L. Jackson" to the movie "Pulp Fiction"



db.movies.update({ title: 'Pulp Fiction' }, { $push: { actors: 'Samuel L. Jackson' } });






//Text Search
//1.find all movies that have a synopsis that contains the word "Bilbo"
db.movies.find({ synopsis: /Bilbo/g }).pretty();

//2.find all movies that have a synopsis that contains the word "Gandalf"
db.movies.find({ synopsis: /Gandalf/g }).pretty();

//3.find all movies that have a synopsis that contains the word "Bilbo" and not the word "Gandalf"
db.movies.find({ $and: [{ synopsis: /Bilbo/g }, { synopsis: { $not: /Gandalf/g } }] }).pretty();

//4.find all movies that have a synopsis that contains the word "dwarves" or "hobbit"
db.movies.find({ synopsis: /(dwarves|hobbit)/g }).pretty();

//5.find all movies that have a synopsis that contains the word "gold" and "dragon"
db.movies.find({ synopsis: /(gold.*dragon|dragon.*gold)/g }).pretty();

db.movies.find({ $and: [{ synopsis: /gold/g }, { synopsis: /dragon/g }] }).pretty();