Dynamic Batch w/Turso

I am creating an array of queries by using

.map()

.map()

.map()

.map(). However TS + Drizzle is not happy with this when using it with

.batch()

.batch()

.batch()

.batch(). Has anybody found a workaround for this? Using v0.29.3. The queries are valid SQL queries.

I'm currently using the Turso Client on it's own to accomplish this.

albyzyx•4/2/24, 1:44 AM

Hey did you find a solution for this?

Llordbinbash I am creating an array of queries by using `.map()`. However TS + Drizzle is not...

The Safe Fire!•4/2/24, 3:03 AM

i am not sure about this specific issue, but you can insert list of values in a single insert query (which you dont need the batch here)

The Safe Fire!•4/2/24, 3:06 AM

for example:

await drizzleClient.insert(favourites).values(["1","2"].map((n) => ({ advertiserId: n }))
// or
await drizzleClient.insert(favourites).values([{ advertiserId: "1" }, { advertiserId: "2" }])

await drizzleClient.insert(favourites).values(["1","2"].map((n) => ({ advertiserId: n }))
// or
await drizzleClient.insert(favourites).values([{ advertiserId: "1" }, { advertiserId: "2" }])

Dynamic Batch w/Turso

Similar Threads

Similar Threads

Similar Threads