docstr: Test that "prohibit_commit" applies only to the given session object,
  not any other session objects that may be used
docstr_tok: ["Test","that","``","prohibit_commit","''","applies","only","to","the","given","session","object",",","not","any","other","session","objects","that","may","be","used"]
code: def test_prohibit_commit_specific_session_only(self):
      """
      Test that "prohibit_commit" applies only to the given session object,
      not any other session objects that may be used
      """
  
      # We _want_ another session. By default this would be the _same_
      # session we already had
      other_session = Session.session_factory()
      assert other_session is not self.session
  
      with prohibit_commit(self.session):
          self.session.execute(text("SELECT 1"))
          with pytest.raises(RuntimeError):
              self.session.commit()
          self.session.rollback()
  
          other_session.execute(text("SELECT 1"))
          other_session.commit()
  
imports: from __future__ import annotations
  import datetime
  import pickle
  from copy import deepcopy
  from unittest import mock
  from unittest.mock import MagicMock
  import pytest
  from kubernetes.client import models
  from sqlalchemy import text
  from sqlalchemy.exc import StatementError
  from airflow import settings
  from airflow.models.dag import DAG
  from airflow.serialization.enums import DagAttributeTypes, Encoding
  from airflow.serialization.serialized_objects import BaseSerialization
  from airflow.settings import Session
  from airflow.utils.sqlalchemy import ExecutorConfigType, ensure_pod_is_valid_after_unpickling, nowait, prohibit_commit, skip_locked, with_row_locks
  from airflow.utils.state import State
  from airflow.utils.timezone import utcnow
label_desc: Use image node_id 8 for calling the TestSqlAlchemyUtils obj's underlying member method code with example usage: obj.test_prohibit_commit_specific_session_only() without return types