class_docstr: This handler handles connection and execution of the Solr SQL statements.
docstr: Get a list with all of the tables in Aerospike
docstr_tok: ["Get","a","list","with","all","of","the","tables","in","Aerospike"]
code: def get_tables(self) -> Response:
      """
      Get a list with all of the tables in Aerospike
      """
      need_to_close = self.is_connected is False
      connection = self.connect()
  
      data_lst = []
      request = "sets"
  
      try:
          for node, (err, res) in list(
              connection.info_all(request).items()
          ):
              if res:
                  entries = [
                      entry.strip()
                      for entry in res.strip().split(";")
                      if entry.strip()
                  ]
                  for entry in entries:
                      data = [
                          d
                          for d in entry.split("=")
                          if ":set" in d or ":objects" in d
                      ]
                      ele = [None, None, None]
                      for d in data:
                          if ":set" in d:
                              ele[0] = d.split(":")[0]
                          if ":objects" in d:
                              ele[1] = d.split(":")[0]
                          if d[0] or d[1]:
                              ele[2] = request
                      data_lst.append(ele)
  
          response = Response(
              RESPONSE_TYPE.TABLE,
              pd.DataFrame(
                  data_lst,
                  columns=["table_schema", "table_name", "table_type"],
              ),
          )
      except Exception as e:
          response = Response(RESPONSE_TYPE.ERROR, error_message=str(e))
  
      if need_to_close is True:
          self.disconnect()
  
      return response
  
imports: from typing import Optional
  from collections import OrderedDict
  import pandas
  import aerospike
  import re
  import duckdb
  from mindsdb_sql import parse_sql
  from mindsdb_sql.parser.ast.base import ASTNode
  from mindsdb.integrations.libs.base import DatabaseHandler
  from mindsdb.integrations.libs.response import HandlerStatusResponse, HandlerResponse, RESPONSE_TYPE
  from mindsdb.integrations.libs.const import HANDLER_CONNECTION_ARG_TYPE
label_desc: Use image node_id 9 for calling the AerospikeHandler obj's underlying member method code with example usage: obj.get_tables() and returns: response