Fixing broken test.

Adding test: reporters/test_coverage/test_html_extended_reporter reporters/test_extended_coverage
utPLSQL · jgebal · Apr 3, 2019 · Mar 22, 2019 · Mar 23, 2019 · Mar 24, 2019
commit 858a675c1e867563a9a0b135fd621bab554fb965
diff --git a/.travis/install.sh b/.travis/install.sh
@@ -86,7 +86,7 @@ grant create public database link to $UT3_TESTER_HELPER;
 grant drop public database link to  $UT3_TESTER_HELPER;
 set feedback on
 --Needed for testing coverage outside of main UT3 schema.
-grant create any procedure, drop any procedure, execute any procedure, create any type, drop any type, execute any type, under any type, select any table, update any table, insert any table, delete any table, create any table, drop any table, alter any table, select any dictionary to $UT3_TESTER_HELPER;
+grant create any procedure, drop any procedure, execute any procedure, create any type, drop any type, execute any type, under any type, select any table, update any table, insert any table, delete any table, create any table, drop any table, alter any table, select any dictionary, create any synonym, drop any synonym to $UT3_TESTER_HELPER;
 grant create job to $UT3_TESTER_HELPER;
 exit
 SQL
diff --git a/test/ut3_tester/core/test_ut_test.pkb b/test/ut3_tester/core/test_ut_test.pkb
@@ -404,6 +404,16 @@ create or replace package body test_ut_test is
     ut.expect(l_test.result).to_equal(ut3.ut_utils.gc_error);
   end;
 
+  procedure create_synonym is
+  begin
+   ut3_tester_helper.ut_example_tests.create_synonym;
+  end;
+
+  procedure drop_synonym is
+  begin
+   ut3_tester_helper.ut_example_tests.drop_synonym;
+  end;
+
   procedure owner_name_null is
     --Arrange
     l_test ut3.ut_test := ut3.ut_test(

diff --git a/test/ut3_tester/core/test_ut_test.pks b/test/ut3_tester/core/test_ut_test.pks
@@ -50,9 +50,13 @@ create or replace package test_ut_test is
   --%test(Fails when owner name invalid)
   procedure owner_name_invalid;
 
-  --TODO: FIX that
+
+  procedure create_synonym;
+  procedure drop_synonym;
+
   --%test(Runs test as current schema when owner name null)
-  --%disabled
+  --%beforetest(create_synonym)
+  --%aftertest(drop_synonym)
   procedure owner_name_null;
 
   procedure create_invalid_package;

diff --git a/test/ut3_tester_helper/ut_example_tests.pkb b/test/ut3_tester_helper/ut_example_tests.pkb
@@ -1,6 +1,17 @@
 create or replace package body ut_example_tests
 as
-
+  procedure create_synonym is
+    pragma autonomous_transaction;
+  begin
+    execute immediate 'create or replace synonym ut3_tester.ut_example_tests for ut3_tester_helper.ut_example_tests';
+  end;
+
+  procedure drop_synonym is
+    pragma autonomous_transaction;
+  begin
+    execute immediate 'drop synonym ut3_tester.ut_example_tests';
+  end;
+
   procedure set_g_number_0 as
   begin
     g_number := 0;

diff --git a/test/ut3_tester_helper/ut_example_tests.pks b/test/ut3_tester_helper/ut_example_tests.pks
@@ -1,5 +1,9 @@
 create or replace package ut_example_tests is
   g_number  number;
+
+  procedure create_synonym;
+  procedure drop_synonym;
+
   procedure set_g_number_0;
   procedure add_1_to_g_number;
   procedure failing_procedure;

diff --git a/test/ut3_user/reporters/test_coverage/test_html_extended_reporter.pkb b/test/ut3_user/reporters/test_coverage/test_html_extended_reporter.pkb
@@ -13,7 +13,7 @@ create or replace package body test_html_extended_reporter is
       bulk collect into l_results
       from table(
         ut3.ut.run(
-          a_path => 'ut3.test_dummy_coverage',
+          a_path => 'ut3.test_block_dummy_coverage',
           a_reporter=> ut3.ut_coverage_html_reporter(),
           a_source_files => ut3.ut_varchar2_list( 'test/ut3.dummy_coverage_package_with_an_amazingly_long_name_that_you_would_not_think_of_in_real_life_project_because_its_simply_too_long.pkb' ),
           a_test_files => ut3.ut_varchar2_list( ),

diff --git a/test/ut3_user/reporters/test_coverage/test_html_extended_reporter.pks b/test/ut3_user/reporters/test_coverage/test_html_extended_reporter.pks
@@ -1,7 +1,7 @@
 create or replace package test_html_extended_reporter is
 
   --%suite(ut_html_extended_reporter)
-  --%suitepath(utplsql.test_user.reporters.test_coverage.test_extended_coverage)
+  --%suitepath(utplsql.test_user.reporters.test_extended_coverage)
 
   --%test(reports on a project file mapped to database object in extended profiler coverage)
   procedure report_on_file;

diff --git a/test/ut3_user/reporters/test_extended_coverage.pks b/test/ut3_user/reporters/test_extended_coverage.pks
@@ -1,7 +1,7 @@
 create or replace package test_extended_coverage is
 
   --%suite
-  --%suitepath(utplsql.test_user.reporters.test_coverage)
+  --%suitepath(utplsql.test_user.reporters)
 
   --%beforeall
   procedure setup_dummy_coverage;