Insert array of objects using TypeORM in typrscript in table

Question

suppose we have a table of fruits and we want to insert multiple record in one query using TypeORM

apple = {
    color: "Green",
    name:  "apple",
    price: 400
}
banana = {
    color: "yellow",
    name:  "banana",
    price: 700
}
fruits = [apple, banana]
repo = repository(fruit_repo)
repo.insert(fruits)

The last line does not work for list how do i insert in one query without a for loop

Akbar30bill · Accepted Answer · 2020-09-06 20:38:06Z

1

It really depends in the modeling of the entities.

Let's say you have an entity holding a relation to another Fruit entity in a many form, you can use cascade: true, and then TypeORM will save the array in a single line, also creating the fruit entities.

Please view TypeORM docs for further information.

edited Sep 6, 2020 at 20:38

Akbar30bill

3623 silver badges11 bronze badges

answered Sep 5, 2020 at 17:15

adamC

2652 silver badges5 bronze badges

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

Collectives™ on Stack Overflow

Insert array of objects using TypeORM in typrscript in table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related