8 replies

Smarter way to update while creating

In prisma, I can do something like this:

await prisma.blogs.createMany(
  data: blogs.map(b => ({
    name: 'asdf',
    text: 'asdfasdfs',
    users: { connect: b.userIdsToConnectTo }
  })
})

await prisma.blogs.createMany(
  data: blogs.map(b => ({
    name: 'asdf',
    text: 'asdfasdfs',
    users: { connect: b.userIdsToConnectTo }
  })
})

is there a smarter way to do this in drizzle? currently im doing this:

await tx.insert(blogs).values(blogs)

await Promise.all(updates.map(async (update) =>
  tx
    .update(users)
    .set({ blogId: update.newBlogId })
    .where(inArray(users.id, update.userIdsToConnectTo))
    .execute()
));

await tx.insert(blogs).values(blogs)

await Promise.all(updates.map(async (update) =>
  tx
    .update(users)
    .set({ blogId: update.newBlogId })
    .where(inArray(users.id, update.userIdsToConnectTo))
    .execute()
));

this is extremely slow to do the promise.all here. it would be much more efficient to just do this upon creation of the

blogs

blogs

if i could just do a create many and name one trip to the db. at the very least i'd like to be able to do 2 trips (one for the creation of all the new blogs and one for the user updates)

Drizzle Team•3y ago•

8 replies

jakeleventhal

Smarter way to update while creating

In prisma, I can do something like this:

await prisma.blogs.createMany(
  data: blogs.map(b => ({
    name: 'asdf',
    text: 'asdfasdfs',
    users: { connect: b.userIdsToConnectTo }
  })
})

await prisma.blogs.createMany(
  data: blogs.map(b => ({
    name: 'asdf',
    text: 'asdfasdfs',
    users: { connect: b.userIdsToConnectTo }
  })
})

is there a smarter way to do this in drizzle? currently im doing this:

await tx.insert(blogs).values(blogs)

await Promise.all(updates.map(async (update) =>
  tx
    .update(users)
    .set({ blogId: update.newBlogId })
    .where(inArray(users.id, update.userIdsToConnectTo))
    .execute()
));

await tx.insert(blogs).values(blogs)

await Promise.all(updates.map(async (update) =>
  tx
    .update(users)
    .set({ blogId: update.newBlogId })
    .where(inArray(users.id, update.userIdsToConnectTo))
    .execute()
));

this is extremely slow to do the promise.all here. it would be much more efficient to just do this upon creation of the

blogs

blogs

if i could just do a create many and name one trip to the db. at the very least i'd like to be able to do 2 trips (one for the creation of all the new blogs and one for the user updates)

Smarter way to update while creating

Similar Threads

Smarter way to update while creating

Similar Threads

Similar Threads

Similar Threads