Question 89687 in PostgreSQL Question posted in
The official documentation can be found here.

How create and add relation to two entities at same time – Postgresql

I am have two entites, Coupon and discount, each coupon can have many discounts,and each discount can have only one discount. I need two create new discount and coupon from one request,request body look like this

 "title": "someTitle",
  "description": "someDesc",
  "deadline": "someDeadline",
  "image": "someImg",
  "rules": "someRules",
  "company":"15",
  "category":"1",
  "discounts": [
    {
      "discount":"ad",
      "price":"awd"
    }
]

after this request, I need create new discount from provided array discounts,create new coupon ,and connect it
coupon.entity.ts
discount.entity.ts

coupon.service.ts

after this I am getting error
error

Tags:

2

Answers


  1. 0

    One tip I could give is to try and look up on how to create a transaction where you create first the discount lines, then you create the coupon with the discounts created.
    Finnaly you commit the transaction.

    Login or Signup to reply.
  2. 0

    You can do it by creating the discount first, and then adding it to the coupon entity. You can do this using an API route by first getting the discount data from the request, then making a new discount entity from it like so:

    createDiscount(req, res, { table: 'discount' }).then(async discountData => { const couponData = await createCoupon(req, res, { table: 'coupon', discountId: discountData.id }); return couponData; });```
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search