How to use Mongo's findOneAndUpdate. #4258

Activity

1. flovilmart commented on Oct 23, 2017

   

   flovilmart

   on Oct 23, 2017

   Contributor

   More actions

   you could use it via cloudCode, and maintain your own connection to mongoDB and run those operations atomically.

   Note that many operations are already atomic (like increment, addUnique etc...)
2. flovilmart

   closed this as completedon Oct 23, 2017
3. majidhassan commented on Oct 26, 2017

   

   majidhassan

   on Oct 26, 2017

   Author

   More actions

   Hey @flovilmart,

   I already run my own connection from cloud code. My question was, whether there's a "parse" way to do it, or whether I have to implement it using the NodeJS Mongo client.

   Also, regarding increment and other functions, I've tried them, and - unlike findOneAndUpdate - they don't force a write lock on the collection / document when I tried them.
4. oallouch commented on Jan 21, 2018

   

   oallouch

   on Jan 21, 2018

   Contributor

   More actions

   same question here
   I guess I'll go the mongo-driver-way.

   👍React with 👍1Reacted by Samuel Denis-D'Ortun
5. yomybaby commented on Feb 6, 2018

   

   yomybaby

   on Feb 6, 2018

   Last edited by yomybaby

   Contributor

   More actions

   On the mongodb, findOneAndUpdate of adapter uses findAndModify of mongoDB collection. (code)

   findAndModify method is also atomically update. (docs)

   So I use this way on cloud code :

   Parse.Cloud.define('borrowBookFromLibrary', function(request, response) {
     const { amount, bookId } = request.params;
     
     const {
       AppCache
     } = require('parse-server/lib/cache'); // this refrenese only in cloud cloud
     const app = AppCache.get(process.env.APP_ID);
     
     if(!amount || amount <= 0 || ! bookId) { // some validation
       response.error('invalid');
     }
     const schema = { // you don't have to write all specifics here, but have to have fields object.
       fields: {
       }
     };
     
     const query = {
       objectId: bookId,
       available: {
         $gte: amount
       }
     };
   
     const update = {
       available: {
         "__op": "Increment",
         "amount": amount * -1
       },
       history: {
         "__op": "Add",
         "objects": [{
           by: 'James',
           requestDate: new Date()
         }]
       }
     };
     
     app.databaseController.adapter.findOneAndUpdate(
       'BookLibrary',
       schema,
       query,
       update
     ).then((result) => {
       if (result) {
         response.success({ success: true });
       } else {
         response.error({ error: true })
       }
     });
   });

   👍React with 👍2Reacted by Olivier Allouch and Manuel

   ❤️React with ❤️1Reacted by Olivier Allouch

   🚀React with 🚀1Reacted by Mohamed Farouk