How to use onConflictDoUpdate when using multi-row insert?

[TinsFox]

I have a piece of data that I'm not sure if it already exists in the database. I want to insert multiple rows of data. When the id is the same as postId, update other data such as createAt desc.

For the first time, my data is as follows:

const data = [
  {
    id: 1,
    name: 'name1',
    desc: 'this is name',
    createAt: '2023-01-1'
  },
  {
    id: 2,
    name: 'name2',
    desc: 'this is name',
    createAt: '2023-01-1'
  }
]

I will have new data as follows

const newData = [
  {
    id: 1,
    name: 'name1',
    desc: 'this is new desc',
    createAt: '2023-03-1'
  },
  {
    id: 2,
    name: 'name2',
    desc: 'this is new desc',
    createAt: '2023-01-1'
  }
]

ts
  await db
    .insert(post)
    .values(data)
    .onConflictDoUpdate({
      target: post.id,
      set: {
        updatedAt: currentTimeString()
      },
      where: sql`${post.postId} = ??` // 
    })

How should I write to get the row at the time of execution when inserting data in batches?
Thanks everyone!🙏

[Angelelz]

You don't need that where condition for what you're describing.
It should automatically (per row) detect the conflict based on the unique id. Then set the data you want for only that row.
Source

[TinsFox]

Sorry, I seem to have missed important context, I'm using SQLite

[Angelelz]

It should be very similar, just take a look at SQLite docs