Data Model for Coupons storing and redeeming

Working with Data
, ,
#1

Hello guys,
The title may be cloudy but here the scenario:

  • Coupons are pre-saved
  • Coupons are unique
  • 1 coupon is only for 1 user
    Here is the code for redeeming:
...
withTransaction(async (session) => {
...
 const coupon = await this.storage.coupons
        .findOneAndUpdate(
          {
            referralId: { $exists: false },
          },
          { $set: { referralId: referralDoc.id } },
          { session, new: true },
        )
        .lean();

      if (!coupon || !coupon.referralId) {
        throw newError(ErrorCode.INVALID_REQUEST);
      }

      return { code: coupon.code, ok: true };
})

My problem: I am not sure whether that coupon does not conflict if there are many requests? What is the better approach if I dont want to use retry?
Thank you all for reading. I’m looking forward to your question and response.

#2

Hey guys, actually MongoDB Transaction handles it for me, so there will be no problem, right?

#4

Hi @Thanh_An_Nguy_n,

Welcome to the MongoDB Community forums :sparkles:

Can you provide more details regarding your goals and your issues? For example:

  • Coupons are unique, but you’re worried about conflict. What conflict is this precisely?
  • What does pre-saved mean in your case?
  • Can you post some example documents?
  • Can you post a detailed description of the workflow from start to finish, and where do you foresee an issue?
  • Are you experiencing difficulty with the code you have shared above?

What MongoDB Transaction has handled for you. Can you please provide more details to better understand the issue you are facing?

Best,
Kushagra