FIND in DB

 db.collection.find({key:value}) - returns a  cursor(reference) (not original document)

db.collection.findOne({key:value}) - returns an original document




db.student.find({name:"abhi"})

[

  {

    _id: ObjectId('67c09443583fb8a7ecfa4214'),

    name: 'abhi',

    age: 21,

    marks: 97

  },

  { _id: ObjectId('67c09722583fb8a7ecfa4216'), name: 'abhi', age: 21 }

]

test> db.student.findOne({age:35})

{ _id: ObjectId('67c09722583fb8a7ecfa4217'), name: 'ash', age: 35 }

test> db.student.find({city:"delhi",marks:7})

[

  {

    _id: ObjectId('67c094a3583fb8a7ecfa4215'),

    name: 'kohli',

    city: 'delhi',

    marks: 7

  }

]

Comments

Post a Comment

Popular posts from this blog

DELETE ROUTE

Image
 INDEX.EJS     </ form >       < form method = "post" action = "/chats/ <%= chat . _id %> ?_method=delete" >         < button > Delete </ button >       </ form > INDEX.JS / DELETE ROUTE   app . delete ( "/chats/:id" , async ( req , res ) => {     let { id } = req . params ;     let deletedChat = await Chat . findByIdAndDelete ( id );     console . log ( deletedChat );     res . redirect ( "/chats" );   })
Read more

CREATE ROUTE

Image
INDEX.JS app . use ( express . urlencoded ({ extended : true })); // NEW ROUTE app . get ( "/chats/new" , ( req , res ) => {   res . render ( "new.ejs" ); }); // POST ROUTE app . post ( "/chats" , ( req , res ) => {   let { from , to , msg } = req . body ;   let newchat = new Chat ({     from : from ,     msg : msg ,     to : to ,     created_at : new Date (),   });   newchat     . save ()     . then (( res ) => {       console . log ( "chat was saved" );     })     . catch (( err ) => {       console . log ( err );     });   res . redirect ( "/chats" ); }); INDEX.EJS <! DOCTYPE html > < html lang = "en" >   < head >     < meta charset = "UTF-8" />     < meta name = "viewport" content = "width=device-width, initial-scale=1.0" />     < t...
Read more

Schema type options

Image
let book2 = new Book ({   title : "Marvel Comics" ,   author : "stan lee" ,   price : 499 ,   category : "comics" , })   . save ()   . then (( res ) => {     console . log ( res );   })   . catch (( err ) => {     console . log ( err );   }); NOW THE CONDITIONS:   title : {     type : String ,     required : true ,     maxlength : 5 ,   },   discount : {     type : Number ,     default : 0 ,   }, HERE WE DIDN'T DEFINE DISCOUNT ,BUT IN THE OUTPUT WE CAN SEE IT, AS IT IS DEFAULT category : {     type : String ,     enum : [ "fiction" , "non-fiction" ],   }, THERE ARE MANY MORE SCHEMA TYPES ,REFER:https://mongoosejs.com/docs/schematypes.html  
Read more