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: Convert FilterOperator to an operator that pinecone's query language can undersand
docstr_tok: ["Convert","FilterOperator","to","an","operator","that","pinecone","'s","query","language","can","undersand"]
code: def _get_pinecone_operator(self, operator: FilterOperator) -> str:
      """Convert FilterOperator to an operator that pinecone's query language can undersand"""
      mapping = {
          FilterOperator.EQUAL: "$eq",
          FilterOperator.NOT_EQUAL: "$ne",
          FilterOperator.GREATER_THAN: "$gt",
          FilterOperator.GREATER_THAN_OR_EQUAL: "$gte",
          FilterOperator.LESS_THAN: "$lt",
          FilterOperator.LESS_THAN_OR_EQUAL: "$lte",
          FilterOperator.IN: "$in",
          FilterOperator.NOT_IN: "$nin",
      }
      if operator not in mapping:
          raise Exception(
              f"Operator {operator} is not supported by Pinecone!"
          )
      return mapping[operator]
  
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 4 for calling the PineconeHandler obj's underlying member method code with example usage: obj._get_pinecone_operator(operator) and returns: mapping