K
Kysely•10mo ago
liteyear.

How can I write a query that does multiple insertions at once?

I have an array of Ids that I want to assign to a single id in a "bridging" table for a many to many relationship: ie: singleId: id1 singleId: id2 singleId: id3
3 Replies
Unknown User
Unknown User•10mo ago
Message Not Public
Sign In & Join Server To View
koskimas
koskimas•10mo ago
@liteyear. Which dialect are you using? Most dialects support this: 
db.insertInto('table')
  .values([
    { singleId: id1, otherId: id },
    { singleId: id2, otherId: id },
    { singleId: id3, otherId: id }
  ])
  .execute()
db.insertInto('table')
  .values([
    { singleId: id1, otherId: id },
    { singleId: id2, otherId: id },
    { singleId: id3, otherId: id }
  ])
  .execute()
liteyear.
liteyear.•10mo ago
thanks!!
Want results from more Discord servers?
Add your server
More Posts
How can I write a count query?Do I have to use raw SQL?How to "generate" or "store" a query result type?Hello, I was wondering how can I extract or store the type resulting from a query so that I ca use sMigrations in transaction and self managementHi, I have a questions regarding migrations: - Is it possible to run all migrations in one transactiRunning a function during migrationI am looking to use Kysely with TimescaleDB, which is an extension of Postgres to support timeseriesUpdating JSON object value in columnHello, Im trying to wrap my head around how to update a JSON column were I want to update the value npm downloadsWe just broke 100k weekly downloads on npm!!! #adoption 📈I think the fast growth lately has beenI think the fast growth lately has been due to all the work @Igal has been doing in the social mediaNoice7000 ⭐ in github btw 😻Ad-Hoc select from table not in Kysely typesHey, we are dynamically generating our KyselyDB types using the `kysely-codgen` cli, and want to knoConvert JSON array result into JS arrayHello, I am running an SQL query that returns data in this format since it is a PG JSON array: ``` {