code: def test_get_conn_purity(self, mock_connect):
      purity = {
          "new": oracledb.PURITY_NEW,
          "self": oracledb.PURITY_SELF,
          "default": oracledb.PURITY_DEFAULT,
      }
      first = True
      for pur in purity:
          self.connection.extra = json.dumps({"purity": pur})
          self.db_hook.get_conn()
          if first:
              assert mock_connect.call_count == 1
              first = False
          args, kwargs = mock_connect.call_args
          assert args == ()
          assert kwargs["purity"] == purity.get(pur)
  
imports: from __future__ import annotations
  import json
  from datetime import datetime
  from unittest import mock
  import numpy
  import oracledb
  import pytest
  from airflow.models import Connection
  from airflow.providers.oracle.hooks.oracle import OracleHook
label_desc: Use image node_id 8 for calling the TestOracleHookConn obj's underlying member method code with example usage: obj.test_get_conn_purity(mock_connect) without return types