%% change <login>  to your login name

mongosh

show databases

use <login>

show collections     

db.actors.drop()

db.createCollection("actors")

show collections

db.actors.insert({ _id: "trojan", name: "Ivan Trojan" });
db.actors.insert({ _id: 2, name: "Jiri Machacek" });
db.actors.insert({ _id: ObjectId(), name: "Jitka Schneiderova" });
db.actors.insert({ name: "Zdenek Sverak" });

db.actors.find();

% old syntax: db.actors.update({ _id: "geislerova" }, {name: "Anna Geislerova" }, { upsert: true });
db.actors.update({ _id: "geislerova" }, { $set: {name: "Anna Geislerova"} }, { upsert: true });

db.actors.find();

db.actors.find({ _id: "trojan" });

% old syntax: db.actors.update({ _id: "trojan" }, { name: "Ivan Trojan", year: 1964 });
db.actors.update({ _id: "trojan" }, { $set: { name: "Ivan Trojan", year: 1964 }});

db.actors.update(
    { _id: "trojan" },
    {
        $set: { year: 1964, age: 52 },
        $inc: { rating: 1 },
        $push: { movies: { $each: [ "samotari", "medvidek" ] } }
    }
)

db.actors.find( { movies: { $exists: true } } )
db.actors.find( { movies: "medvidek" } )
db.actors.find( { movies: { $in: ["medvidek", "vratnelahve" ] } } )


db.actors.find().sort({ year: 1, name: -1 });

%%%%%%%%%%%%%%%%%%%%%%

db.people.drop()

exit
mongoimport --db <login>  --collection people  --jsonArray --stopOnError < /home/NDBI040/mongodb/simpleData.txt
mongosh
use <login>

show collections

db.people.find({ "salary" : { $lt  : 10.1 }})  

db.people.find({ "salary" : { $lt  : 10.1 }}).explain()

db.people.ensureIndex( {"salary" : 1 } )

db.people.find({ "salary" : { $lt  : 10.1 }}).explain()