I'm working with Node.js and MongoDB, I used this line:db.collection('users').insertOne({"name":"john", "password":"connor"}) to insert a new document, and now I'd like to get the password from it.
I tried with: var users_array = db.collection('users').find({name:"john"},{password:true, _id:false}).toArray() and I get an array that looks like this: [{"password":"connor"}]
Any way to get that value and save it in a string or something similar?
There is nothing special about the array returned. You access properties the same way you always do in JavaScript:
var password = result[0].password;
If you use findOne instead of find you will just get the object directly, without the array, so then you can just use:
var password = result.password;
Side note: You should never store passwords in a way where someone (including yourself) could look inside the database and figure out a password. That means no plaintext and no encrypted passwords. They should be hashed with a random salt, and not by a fast hashing algorithm. Use pbkdf2 or bcrypt.
find or findOne? If you're using findOne then it indicates that there were no results. Are you sure you still have a user named "john"?var pass = db.collection('users').findOne({name:"john"},{password:true, _id:false}).password;And yes, I'm sure there is an user named like that, Shell finds the value using the same query (replacing db.collection('users') for db.users )
var pwString = yourArray[0].passwordfindOne()asvar password = db.collection('users').findOne({name:"john"},{password:true, _id:false}).password