mssql insert image

 def insert(self, file_id, file_path):

    img = Image.open(file_path)

    w = int(img.width / 2)

    h = int(img.height / 2)

    img_resize = img.resize((w, h))

    img_resize.save('./temp.png')

    with open('./temp.png', 'rb') as fh:

        bindata = fh.read()

        buf = '0x' + binascii.hexlify(bindata).decode('ascii')

        query = f"INSERT INTO {self.tablename}(FILE_ID, FILE_DATA) VALUES ({file_id}, {buf})"

    self.cursor.execute(query)

    self.conn.commit()