docstr: Deletes a database by name
docstr_tok: ["Deletes","a","database","by","name"]
code: def delete(self, database_name):
      """Deletes a database by name"""
      session = SessionController()
      if not session.database_controller.exists(database_name):
          abort(
              HTTPStatus.NOT_FOUND,
              f"Database with name {database_name} does not exist.",
          )
      try:
          session.database_controller.delete(database_name)
      except Exception as e:
          abort(
              HTTPStatus.BAD_REQUEST,
              f"Cannot delete database {database_name}. "
              + "This is most likely a system database, a permanent integration, or an ML engine with active models. "
              + f"Full error: {e}. "
              + "Please check the name and try again.",
          )
      return "", HTTPStatus.NO_CONTENT
  
imports: from http import HTTPStatus
  from sqlalchemy.exc import NoResultFound
  from typing import Dict
  from flask import request
  from flask_restx import Resource, abort
  from mindsdb.api.http.namespaces.configs.databases import ns_conf
  from mindsdb.api.mysql.mysql_proxy.classes.fake_mysql_proxy import FakeMysqlProxy
  from mindsdb.api.executor.controllers.session_controller import SessionController
  from mindsdb.api.executor.datahub.classes.tables_row import TablesRow
  from mindsdb.api.executor.data_types.response_type import RESPONSE_TYPE
  from mindsdb_sql import parse_sql, ParsingException
  from mindsdb_sql.parser.ast import CreateTable, DropTables
label_desc: Use image node_id 3 for calling the DatabaseResource obj's underlying member method code with example usage: obj.delete(database_name) and returns: str,  HTTPStatus