So I have given up my previous question with Buffers and now instead trying to use string. I keep on getting 0 changes when I am submitting a multiple item array, just 1 item and it's fine.

const query = db.$executeRaw(
        `
        update DamFile
        set deletedAt = ?
        where id in (?)
      `,
        DateTime.utc().toString(),
        ids.join(",")
      )

      const result = await db.$transaction([query])

      console.log(result)

Can anyone catch what I am doing wrong? Thanks

You need to use

join

as shown here. This can be imported from:

import { Prisma } from '@prisma/client';

Prisma.join

Thanks for the response. I have tried that, but let me try it again.

Is the datatype of your field

Bytes

?

Yes

Could you share some sample data that you’re passing? I would like to try this out.

Let me know if this is ok or you need more stuff. https://gist.github.com/paulm17/74dfb747794357bc6e8e4ceec807523d

I cannot insert the values you provided using

Buffer

.

This is how I save for that table:

const query = this.prisma.damFile.create({
        data: {
          id: Buffer.from(data.fileId),
          userId: Buffer.from(data.userId),
          parentId: Buffer.from(data.parentId),
          typeId: Buffer.from(data.fileTypeId),
          mimeId: Buffer.from(data.mimeId),
          name: data.filename,
          filename: data.filename,
          filesize: data.size,
          extension: data.extension,
          md5: data.tempFileMd5,
          filterType: data.fileType,
        },
        select: { id: true },
      });

      const result = await this.prisma.$transaction([query]);

Yeah but the data from the gist cannot be saved. I’m getting an error:

Yeah it's because of: https://github.com/prisma/prisma/issues/7097#issuecomment-877130151

Yes it would be great if you could create one here 🙂