Why updateOrCreateMany not delete old data?

[positivedeveloper36]

My code like this :

  public async update(params: any) {
    const data = await Period.findOrFail(params.id)
    data.from = params.from
    data.to = params.to
    data.description = params.description

    await data.save()

    let files = []
    for (let i in params.file_names) {
      files.push({
        fileName: Date.now() + '_' + params.file_names[i],
        fileUri: params.file_uris[i],
      })
    }

    await data.related('files').updateOrCreateMany(files, 'fileUri)
    return { success: true }
  }

This is a one to many relation

The result of files like this :

[
    {
      "fileName": "1662319086345_test1.pdf",
      "fileUri": "https://api.company.com/public-asset/16608261250361321.pdf"
    },
    {
      "fileName": "1123319086235_test2.pdf",
      "fileUri": "https://api.company.com/public-asset/16608261250361222.pdf"
    },
    {
      "fileName": "3453319086123_test3.pdf",
      "fileUri": "https://api.company.com/public-asset/16608261250361452.pdf"
    }
]

If I run the code, it successfully updates the old data, but it doesn't work to delete old data

So, I have 3 data in the table of database. If I remove 1 data and I run the query and I check the table, the data is 3. It should be two

For example I remove "fileName": "1662319086345_test1.pdf". Should the new data to be like this :

[
    {
      "fileName": "1123319086235_test2.pdf",
      "fileUri": "https://api.company.com/public-asset/16608261250361222.pdf"
    },
    {
      "fileName": "3453319086123_test3.pdf",
      "fileUri": "https://api.company.com/public-asset/16608261250361452.pdf"
    }
]

How can I solve this problem?

Please help. Thanks

Note :

I follow this docs : https://docs.adonisjs.com/reference/orm/relations/has-many#updateorcreatemany