Querying mongodb in node js

Question

I have a sign up button which inserts data in mongo db collection only if the data is unique otherwise the user should stay on the same page. For implementing the same , I am doing upsert:true. This is my code for node js

var mongoClient=require('mongodb').MongoClient;
var url='mongodb://localhost:27017/test';
app.post('/newuser', function(req, res) {
    username=req.body.username;
    password=req.body.password;

mongoClient.connect(url,function(err,db){
    //console.log("connected")
    db.collection('users',function(err,collection){
        collection.update({username:username, password:password},{upsert:true},function(err,result){
            res.send(result.insertedCount);
        });
    })
})
});

And the code for the frontend is

$.ajax({
    type:'POST',
    url:'/newuser',
    data:{
        username:username,
        password:password
    },
    success:function(result){
        console.log(result);
        if(result===1){

        that.setState({
            isLoggedin:true
        })
    }else{
        alert("not inserted");
    }
    }
})
return false;

}

Every time I run the server, the success function doesn't get executed.What is wrong with the code? Thanks.

Open Console (Ctrl+Shift+J) > Network tools Now make hit .. it will show the request.. click on the request and check response is browser is receiving data or their is some error. — Atul Sharma
– Atul Sharma, Commented Jul 11, 2017 at 13:33

Ankit Balyan · Accepted Answer · 2017-07-11 18:22:58Z

1

use, you need to specify $set in your update query.

collection.update(
  {},
  {$set: { username, password }},
  {upsert:true},
  function(err,result){
      res.send(result);
  }

EDIT: send result object, check based on nModified, n values of result object to get the number of records updated and modified.

edited Jul 11, 2017 at 18:22

answered Jul 11, 2017 at 17:53

Ankit Balyan

1,32919 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Querying mongodb in node js

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related