Added/Updated tests\functional\trigger\database\test_connect_02.py: Added 'SQL_SCHEMA_PREFIX' to be substituted in expected_* on FB 6.x

pavel-zotov · pavel-zotov · commit 83f106c86d7a · 2025-07-13T17:22:11.000+03:00
diff --git a/tests/functional/trigger/database/test_connect_02.py b/tests/functional/trigger/database/test_connect_02.py
@@ -27,12 +27,15 @@
 @pytest.mark.version('>=3.0')
 def test_1(act: Action, tmp_worker: User, tmp_hacker: User):
 
+    SQL_SCHEMA_PREFIX = '' if act.is_version('<6') else '"PUBLIC".'
+    TEST_EXC_NAME = 'EXC_CONNECT' if act.is_version('<6') else f'{SQL_SCHEMA_PREFIX}"EXC_CONNECT"'
+    TEST_TRG_NAME = "'TRG_CONNECT'" if act.is_version('<6') else f'{SQL_SCHEMA_PREFIX}"TRG_CONNECT"'
     expected_stdout = f"""
         Statement failed, SQLSTATE = HY000
         exception 1
-        -EXC_CONNECT
+        -{TEST_EXC_NAME}
         -Exception in ON CONNECT trigger for {tmp_hacker.name}
-        -At trigger 'TRG_CONNECT'
+        -At trigger {TEST_TRG_NAME}
 
         ID                              1
         AUDIT_WHO                       {tmp_worker.name}
