code: def test_delete(self, postgres_handler_mock):
      df = pd.DataFrame(
          {
              "id": [1, 2],
              "content": ["this is a test", "this is a test"],
              "metadata": [{"test": "test1"}, {"test": "test2"}],
              "embeddings": [[1.0, 2.0, 3.0], [1.0, 2.0, 3.0]],
          }
      )
      self.set_handler(
          postgres_handler_mock, "pg", tables={"test_table": df}
      )
  
      # create a table
      sql = """
              CREATE TABLE qtest.test_table_6 (
                  SELECT * FROM pg.df
              )
          """
      self.run_sql(sql)
  
      # delete from a table with a metadata filter
      sql = """
              DELETE FROM qtest.test_table_6
              WHERE `metadata.test` = 'test1'
          """
      self.run_sql(sql)
      # check if the data is deleted
      sql = """
              SELECT * FROM qtest.test_table_6
              WHERE `metadata.test` = 'test2'
          """
      ret = self.run_sql(sql)
      assert ret.shape[0] == 1
  
      # delete by id
      sql = """
              DELETE FROM qtest.test_table_6
              WHERE id = 2
          """
      self.run_sql(sql)
      # check if the data is deleted
      sql = """
              SELECT * FROM qtest.test_table_6
              WHERE id = 2
          """
      ret = self.run_sql(sql)
      assert ret.shape[0] == 0
  
      # delete from a table with a search vector filter is not allowed
      sql = """
              DELETE FROM qtest.test_table_6
              WHERE search_vector = [1.0, 2.0, 3.0]
          """
      with pytest.raises(Exception):
          self.run_sql(sql)
  
      # delete from a table without any filters is not allowed
      sql = """
              DELETE FROM qtest.test_table_6
          """
      with pytest.raises(Exception):
          self.run_sql(sql)
  
file_path: mindsdb/tests/handler_tests/test_qdrant_handler.py
imports: from unittest.mock import patch
  import pytest
  import pandas
  from mindsdb_sql import parse_sql
  from tests.unit.executor_test_base import BaseExecutorTest
label_desc: Use image node_id 8 for calling the TestQdrantHandler obj's underlying member method code with example usage: obj.test_delete(postgres_handler_mock) without return types