code: def test_get_pandas_df(self):
      statement = "SQL"
      column = "col"
      result_sets = [("row1",), ("row2",)]
      self.cur.description = [(column,)]
      self.cur.fetchall.return_value = result_sets
      df = self.db_hook.get_pandas_df(statement)
  
      assert column == df.columns[0]
  
      assert result_sets[0][0] == df.values.tolist()[0][0]
      assert result_sets[1][0] == df.values.tolist()[1][0]
  
      self.cur.execute.assert_called_once_with(statement)
  
imports: from __future__ import annotations
  from unittest import mock
  import pytest
  from elasticsearch import Elasticsearch
  from airflow.exceptions import AirflowProviderDeprecationWarning
  from airflow.models import Connection
  from airflow.providers.elasticsearch.hooks.elasticsearch import ElasticsearchHook, ElasticsearchPythonHook, ElasticsearchSQLHook
label_desc: Use image node_id 4 for calling the TestElasticsearchSQLHook obj's underlying member method code with example usage: obj.test_get_pandas_df() without return types