How to insert many rows with one-to-many relationships

I have 100+ rows I want to insert into an

artists

artists

artists

artists table, and at the same time insert each artist's songs into a

songs

songs

songs

songs table. Each song would be linked to the artist ID, but the artist ID would be generated by the query itself. Any way to accomplish this with Drizzle?

Basically, I have data like this I want to insert:

[
  {
    artist: "example",
    songs: [
      { title: "A" },
      // ...
    ]
  },
  // ...
]

[
  {
    artist: "example",
    songs: [
      { title: "A" },
      // ...
    ]
  },
  // ...
]

[
  {
    artist: "example",
    songs: [
      { title: "A" },
      // ...
    ]
  },
  // ...
]

[
  {
    artist: "example",
    songs: [
      { title: "A" },
      // ...
    ]
  },
  // ...
]

How to insert many rows with one-to-many relationships

Similar Threads

Similar Threads

Similar Threads