Adding global setup

utPLSQL · jgebal · Apr 3, 2019 · Mar 22, 2019 · Mar 23, 2019 · Mar 24, 2019
commit 30d27fedef6428c1a7d17752f2f82a3e54ef46b4
diff --git a/test/install_and_run_tests.sh b/test/install_and_run_tests.sh
@@ -27,4 +27,5 @@ time utPLSQL-cli/bin/utplsql run ${UT3_TESTER_HELPER}/${UT3_TESTER_HELPER_PASSWO
 -f=ut_junit_reporter          -o=junit_test_results.xml \
 -f=ut_tfs_junit_reporter      -o=tfs_test_results.xml \
 -f=ut_documentation_reporter  -o=test_results.log -s \
-scc
+-scc \
+-q
diff --git a/test/install_ut3_user_tests.sql b/test/install_ut3_user_tests.sql
@@ -5,6 +5,7 @@ whenever oserror exit failure rollback
 alter session set plsql_optimize_level=0;

 prompt Install user tests
+@@ut3_user/test_user.pks
 @@ut3_user/expectations/unary/test_expect_not_to_be_null.pks
 @@ut3_user/expectations/unary/test_expect_to_be_null.pks
 @@ut3_user/expectations/unary/test_expect_to_be_empty.pks
@@ -42,7 +43,7 @@ set define on
 @@install_below_12_2.sql 'ut3_user/reporters/test_coverage/test_html_proftab_reporter.pks'
 set define off

-
+@@ut3_user/test_user.pkb
 @@ut3_user/expectations/unary/test_expect_not_to_be_null.pkb
 @@ut3_user/expectations/unary/test_expect_to_be_null.pkb
 @@ut3_user/expectations/unary/test_expect_to_be_empty.pkb

diff --git a/test/ut3_tester/core.pkb b/test/ut3_tester/core.pkb
@@ -5,7 +5,7 @@ create or replace package body core is
    ut3.ut_coverage.set_develop_mode(true);
    --improve performance of test execution by disabling all compiler optimizations
    ut3_tester_helper.main_helper.execute_autonomous('ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL=0');
-    dbms_output.enable(null);
+    --dbms_output.enable(null);
  end;

 end;

diff --git a/test/ut3_tester_helper/main_helper.pkb b/test/ut3_tester_helper/main_helper.pkb
@@ -154,5 +154,9 @@ create or replace package body main_helper is
     ut3.ut_utils.append_to_list(a_list,a_items);
  end;

+  procedure output_null is
+  begin
+    dbms_output.enable(null);
+  end;
 end;
 /
diff --git a/test/ut3_tester_helper/main_helper.pks b/test/ut3_tester_helper/main_helper.pks
@@ -45,5 +45,7 @@ create or replace package main_helper is

  procedure append_to_list(a_list in out nocopy ut3.ut_varchar2_rows, a_items ut3.ut_varchar2_rows);

+  procedure output_null;
+
 end;
 /
diff --git a/test/ut3_user/test_user.pkb b/test/ut3_user/test_user.pkb
@@ -0,0 +1,12 @@
+create or replace package body test_user is
+
+   procedure global_setup is
+  begin
+    ut3.ut_coverage.set_develop_mode(true);
+    --improve performance of test execution by disabling all compiler optimizations
+    ut3_tester_helper.main_helper.execute_autonomous('ALTER SESSION SET PLSQL_OPTIMIZE_LEVEL=0');
+    --dbms_output.enable(null);
+  end;
+
+end;
+/
diff --git a/test/ut3_user/test_user.pks b/test/ut3_user/test_user.pks
@@ -0,0 +1,10 @@
+create or replace package test_user is
+
+  --%suite
+  --%suitepath(utplsql)
+
+  --%beforeall
+  procedure global_setup;
+
+end;
+/