DT
Drizzle Team•14mo ago
Kasper

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

I have 100+ rows I want to insert into an artists table, and at the same time insert each artist's songs into a 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" },
      // ...
    ]
  },
  // ...
]
2 Replies
bloberenober
bloberenober•14mo ago
you'd have to insert to different tables separately, same as how you'd do it with SQL
Kasper
Kasper•14mo ago
I see, that's unfortunate - thanks!
Want results from more Discord servers?
Add your server
More Posts
Drizzle migrations workflow with CICD and multi-dev teamsHi! I'm looking into ORMs to use for my team in a new Node/TS project, and Drizzle has caught my attQuery from table with where clause NOT IN another sub query?For ex: select * from TableA where email not in (select email from TableB); ?how to empty a table (postgres)What's the best way to programatically empty a database table? I'm using ```javascript const emptieusing in nest.jsWhat is the proper way to use in nest.js (or express). Should I create one single instance of db tha"bind message supplies 1 parameters, but prepared statement \"\" requires 0"``` const results = await drizzleDb .select({ count: sql<number>`count(*)` }) .from(calls)POSTGRES_URL_NON_POOLING vs POOLINGI'm setting up postgres and drizzle to try to run some edge function. I'm reading these docs: https