code: def test_get_first_record(self):
      statement = "SQL"
      result_sets = [("row1",), ("row2",)]
      self.cur.fetchone.return_value = result_sets[0]
  
      assert result_sets[0] == self.db_hook.get_first(statement)
      self.conn.close.assert_called_once_with()
      self.cur.close.assert_called_once_with()
      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 2 for calling the TestElasticsearchSQLHook obj's underlying member method code with example usage: obj.test_get_first_record() without return types