Wasp•3w ago

Does datePaid in the DB get popuplated with the payment date OOTB with opensaas?

Is the functionality to update the datePaid in the DB already build into opensaas or does it need to be added? If its already set up, what format is datePaid in?

3 Replies

kapa.ai•3w ago

Hi @fred-123. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base. :wave: ---------------------- Based on the knowledge sources provided, I don't have enough specific information to definitively answer whether the datePaid field in the database gets populated automatically out-of-the-box with OpenSaaS, or what format it uses if it does. However, I can provide some relevant information based on what is available: 1. In one of the Discord conversations, there's a code snippet that suggests updating the datePaid field when a payment is processed:

await context.entities.User.updateMany({
  where: {
    stripeId: userStripeId,
  },
  data: {
    hasPaid: true,
    datePaid: new Date(),
  },
});

await context.entities.User.updateMany({
  where: {
    stripeId: userStripeId,
  },
  data: {
    hasPaid: true,
    datePaid: new Date(),
  },
});

This code sets the datePaid to a new Date() object, which typically represents the current date and time when the code is executed Discord support thread: Payment for Credits / Credit Balance System. 2. The OpenSaaS template seems to be built on top of Wasp, which uses Prisma for database operations. Prisma typically stores dates in ISO 8601 format when using DateTime fields. 3. It's not clear from the provided information whether this functionality is automatically included in OpenSaaS or if it needs to be added manually. To get a definitive answer, you might want to: 1. Check the OpenSaaS documentation for any mentions of datePaid field handling. 2. Examine the database schema to see if there's a datePaid field defined and what type it is. 3. Look through the payment processing code in the OpenSaaS template to see if and how datePaid is being updated. If you can't find this information in the existing codebase or documentation, you may need to implement this functionality yourself or reach out to the OpenSaaS maintainers for more specific guidance. ---------------------- Note: you can ask me a follow up question by @ mentioning me again :speech_balloon: ---------------------- Sorry @fred-123, I seem to be having a bit of trouble. Don't worry though, I've pinged my support and they will try to fix me up! :technologist: Perhaps try again in 15mins?

Vinny (@Wasp)•3w ago

Did that answer your question @fred-123 ?

fred-123OP•2w ago

Yes thank you!

Gaming

Programming

Does datePaid in the DB get popuplated with the payment date OOTB with opensaas?

Did you find this page helpful?