Adonis 5 how to get pivot_column from $extras and inject into preload

Question

I created an extra column on my manyToMany decorator and know how to preload my data based on its value. my question is how can I actually take that value and insert it to it's relevant preloaded data or insert them into a new array on parent model, in other words how can I bring back the extra pivot_column with my record(s) because currently it's in the $extra and not showing up with other properties in api call, Im currently creating a new array and inserting it with a map() but Im very worried about this approach.

thank you

exactly my question! anyone? have you found out the answer? following this thread ... — jsdecena, Oct 14 '22 at 05:47

score 2 · Accepted Answer · answered Oct 14 '22 at 19:32

so assuming we have a products table in manyToMany relation with colors table

export default class Product extends BaseModel {
@manyToMany(() => Color, {
pivotTable: 'color_products',
pivotTimestamps: true,
pivotColumns: ['stock'],
})
public colors: ManyToMany<typeof Color>
}

when we bring back a single instance with product.load() or an array with Product.preload()

there will be and array of colors as a product parameter and pivot_table here color_products data in $extras I asked how can I bring the $extras as a product parameter but that was a mistake and the stock(number) is about the color of product for example a I want to know how many green shirts is in the database, as a result the solution will do just that,bringing stock number with each color object as a product parameter.here is how:

export default class Color extends BaseModel {
@manyToMany(() => Product, {
pivotTable: 'color_products',
pivotTimestamps: true,
pivotColumns: ['stock'],
})
public products: ManyToMany<typeof Product>

@computed()
public get stock() {
  const stock = this.$extras.pivot_stock
  return stock
  }
}

Short version

define a computed method on the related model and return the column from this.$extras:

    @computed()
public get stock() {
  const stock = this.$extras.pivot_stock //my pivot column name was "stock"
  return stock
  }

don't forget you should have allready have this in @manyToMany options inside your model:

pivotColumns: ['stock'],

or bring the pivotColumn from other ways.

oh yeah! I got the computed before but not sure how to load the relationship but you made it! nice! super nice! thanks! — jsdecena, Oct 14 '22 at 23:09

score 0 · Answer 2 · answered Oct 14 '22 at 06:05

0

Not sure why you are making a new array because you can continue the query() instance with map():

      const rewards = await user.related('rewards').query()

      const transformed = rewards.map((reward) => {
        return {...reward.toJSON(), status: reward.$extras.pivot_status}
      })
      
      return response.json({data: transformed})

Though, this is still not good as it is not paginated :( but it works for my case.

answered Oct 14 '22 at 06:05

jsdecena

572
2
7
22

transformed is that new array that I create,but I found a solution – w3bsite Oct 14 '22 at 19:02

score 0 · Answer 3 · answered Oct 14 '22 at 06:14

0

you may need this. Additional pivot columns

answered Oct 14 '22 at 06:14

taco

88
4

thank you but it is not what I needed – w3bsite Oct 14 '22 at 19:03

Adonis 5 how to get pivot_column from $extras and inject into preload

3 Answers3