text: from __future__ import annotations
  
  from contextlib import contextmanager
  from typing import Dict, Iterator, List
  
  from dcp.storage.database.api import DatabaseApi, DatabaseStorageApi
  from dcp.storage.database.utils import get_tmp_sqlite_db_url
  
  
  class SqliteDatabaseApi(DatabaseApi):
      def remove(self, name: str):
          self.execute_sql(f"drop table {name}")
  
      @classmethod
      @contextmanager
      def temp_local_database(cls) -> Iterator[str]:
          db_url = get_tmp_sqlite_db_url("__test_dcp_sqlite")
          yield db_url
  
  
  class SqliteDatabaseStorageApi(DatabaseStorageApi, SqliteDatabaseApi):
      pass
  