Promises and async not working...

[jonataseridani]

Hi All,

I'm using version 1.0 on a project and I have a route that starts a PROMISE whenever a request is made.

new Promise(async (_) => {
...
...
await db.get(collection).find(filter).assign(obj).write(function(err) {
        if(err) throw err;
      }).then((result) => {
          console.log('Updated');
          console.log(result);
        }
      });
...
...
.catch(err => {
	console.error(err);
})

RESULT shows the updated obj, but when checking the data, if for example 6 requests were sent at the same time, only 2 or 3 were actually updated.

It seems that one PROMISE overwrites the other. While the promise A has the update for X, the promise B only has the update for Y and the last to write it, will set the final value.

How can I get it updated from all PROMISES?

Thanks ;)

[jonataseridani]

Hi All,

I got it by fixed using a file lock:

const { Mutex } = require('async-mutex');

const release = await this.mutex.acquire();

try {
    // Read the current state of the database
    await db.read();
    await db.get(collection)  // Access the collection
    .find(filter)  // Find the item based on the filter
    .assign(data)  // Assign the new data
    .write(function(err) { // Write the changes asynchronously
      if(err) throw err; console.log(err);
    }).then((r) => {
      if(debug == true) this._debug(r); //Optional DEBUG
    });
  } catch (err) {
    console.error("Error writing data:", err);
  } finally {
    release();  // Release the lock
  }