How to save a nested object using typeorm and Nestjs?

Question

I have the following Data entity:

@PrimaryGeneratedColumn() 
id: number 

@Column() 
dataA: string 

@Column() 
dataB: string 

@Column() 
dataC: number

@Column() 
dataD: number

The data object I am trying to save:

const data = {
      dataA: "data 1",
      nestedData: {
        dataB: "data 2",
        dataC: 3
      },
      dataD: 4
      }

I then try to save it as follows:

await this.dataRepository.save(data)

I get an error that says something about dataB and dataC not being a part of Data entity even though it should be. Thanks.

Pete Houston · Accepted Answer · 2022-05-12 21:19:48Z

3

You need to flatten it, write a function to do that before passing object into the Repository.

export function flattenData(data) {
    return {
        dataA: data.dataA,
        dataB: data.nestedData.dataB,
        dataC: data.nestedData.dataC,
        dataD: data.dataD,
    }
}

// then pass into Repository
await this.dataRepository.save(flattenData(data));

answered May 12, 2022 at 21:19

Pete Houston

15.1k6 gold badges51 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

M C · Accepted Answer · 2023-10-14 20:39:11Z

0

There is a 'json' type for the column type: https://typeorm.io/entities#column-types-for-mysql--mariadb

You can then write something like

@Column({ type: 'json' }) ressources: { title: string; ref: string }[];

answered Oct 14, 2023 at 20:39

M C

2861 silver badge7 bronze badges

Collectives™ on Stack Overflow

How to save a nested object using typeorm and Nestjs?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related