code: def test_delete(self, postgres_handler_mock):
      df = pd.DataFrame(
          {
              "id": ["id1", "id2", "id3"],
              "content": [
                  "this is a test",
                  "this is a test",
                  "this is a test",
              ],
              "metadata": [
                  {"test": "test1"},
                  {"test": "test2"},
                  {"test": "test3"},
              ],
              "embeddings": [
                  [1.0, 2.0, 3.0],
                  [1.0, 2.0, 3.0],
                  [1.0, 2.0, 3.0],
              ],
          }
      )
  
      self.drop_table("testable")
  
      self.set_handler(
          postgres_handler_mock, "pg", tables={"testable": df}
      )
  
      # create a table
      sql = """
              CREATE TABLE milvus_test.testable (
                  SELECT * FROM pg.df
              )
          """
      self.run_sql(sql)
  
      # delete by id
      sql = """
              DELETE FROM milvus_test.testable
              WHERE id IN ('id1')
          """
      self.run_sql(sql)
  
      # check if the data is deleted
      sql = """
              SELECT * FROM milvus_test.testable
          """
      ret = self.run_sql(sql)
      assert ret.shape[0] == 2
  
      # delete by multiple ids
      sql = """
              DELETE FROM milvus_test.testable
              WHERE id IN ('id2', 'id3')
          """
      self.run_sql(sql)
  
      # check if the data is deleted
      sql = """
              SELECT * FROM milvus_test.testable
          """
      ret = self.run_sql(sql)
      assert ret.shape[0] == 2
  
      # delete from a table without any filters is not allowed
      sql = """
              DELETE FROM milvus_test.testable
          """
      with pytest.raises(Exception):
          self.run_sql(sql)
  
      self.drop_table("testable")
  
file_path: mindsdb/tests/handler_tests/test_milvus_handler.py
imports: import importlib
  from unittest.mock import patch
  import pandas
  import pytest
  from mindsdb_sql import parse_sql
  from ..unit.executor_test_base import BaseExecutorTest
label_desc: Use image node_id 10 for calling the TestMilvusHandler obj's underlying member method code with example usage: obj.test_delete(postgres_handler_mock) without return types