class_docstr: This handler handles connection and execution of the Pinecone statements.
class_docstr_tok: ["This","handler","handles","connection","and","execution","of","the","Pinecone","statements","."]
docstr: Get the list of indexes in the pinecone database.
docstr_tok: ["Get","the","list","of","indexes","in","the","pinecone","database","."]
code: def get_tables(self) -> HandlerResponse:
      """Get the list of indexes in the pinecone database."""
      indexes = pinecone.list_indexes()
      indexes_names = pd.DataFrame(
          columns=["index_name"],
          data=[index for index in indexes],
      )
      return Response(
          resp_type=RESPONSE_TYPE.TABLE, data_frame=indexes_names
      )
  
imports: from collections import OrderedDict
  from typing import List, Optional
  import pinecone
  import pandas
  import ast
  from mindsdb.integrations.libs.const import HANDLER_CONNECTION_ARG_TYPE
  from mindsdb.integrations.libs.response import RESPONSE_TYPE
  from mindsdb.integrations.libs.response import HandlerResponse
  from mindsdb.integrations.libs.response import HandlerResponse
  from mindsdb.integrations.libs.response import HandlerStatusResponse
  from mindsdb.integrations.libs.vectordatabase_handler import FilterCondition, FilterOperator, TableField, VectorStoreHandler
  from mindsdb.utilities import log
label_desc: Use image node_id 10 for calling the PineconeHandler obj's underlying member method code with example usage: obj.get_tables() and returns: Response