utPLSQL · jgebal · Oct 26, 2017 · Oct 6, 2017 · Oct 6, 2017 · Oct 7, 2017
diff --git a/development/cleanup.sh b/development/cleanup.sh
@@ -15,9 +15,10 @@ drop user ${UT3_USER} cascade;
 begin
   for i in (
     select decode(owner,'PUBLIC','drop public synonym "','drop synonym "'||owner||'"."')|| synonym_name ||'"' drop_orphaned_synonym from dba_synonyms a
-     where not exists (select null from dba_objects b where a.table_name=b.object_name and a.table_owner=b.owner )
-       and a.table_owner <> 'SYS'
+     where not exists (select 1 from dba_objects b where (a.table_name=b.object_name and a.table_owner=b.owner or b.owner='SYS' and a.table_owner=b.object_name) )
+       and a.table_owner not in ('SYS','SYSTEM')
   ) loop
+    dbms_output.put_line(i.drop_orphaned_synonym);
     execute immediate i.drop_orphaned_synonym;
   end loop;
 end;

diff --git a/docs/userguide/annotations.md b/docs/userguide/annotations.md
@@ -214,3 +214,26 @@ When processing the test suite `test_pkg` defined in [Example of annotated test
   rollback to savepoint 'beforeall'
 
 ```
+
+# Annotation cache
+
+utPLSQL needs to scan sources of package specifications to identify and parse annotations.
+To improve framework startup time, specially when dealing with database users owning large amount of packages the framework has build-in persistent cache for annotations.
+
+Cache is checked for staleness and refreshed automatically on every run.
+The initial startup of utPLSQL for a schema will take longer than consecutive executions.
+
+If you're in situation, where your database is controlled via CI/CD server and gets refreshed/wiped before each run of your tests, 
+consider building upfront and creating the snapshot of our database after the cache was refreshed.
+
+To build annotation cache without actually invoking any tests, call `ut_runner.rebuild_annotation_cache(a_object_owner, a_object_type)` sql block for every unit test owner that you want to have annotations cache prebuilt.
+
+Example:
+```sql
+exec ut_runner.rebuild_annotation_cache('HR', 'PACKAGE');
+```
+
+To purge annotations cache call: 
+```sql
+exec ut_runner.purge_cache('HR', 'PACKAGE');
+```
diff --git a/examples/developer_examples/RunExampleTestAnnotationsParsingTimeHugePackage.sql b/examples/developer_examples/RunExampleTestAnnotationsParsingTimeHugePackage.sql
@@ -6,9 +6,9 @@ set echo off
 @@tst_pkg_huge.pks
 
 declare
-  l_suite ut_logical_suite;
+  l_suites ut_suite_items;
 begin
-  l_suite := ut_suite_manager.config_package(a_owner_name => USER,a_object_name => 'TST_PKG_HUGE');
+  l_suites := ut_suite_manager.configure_execution_by_path(ut_varchar2_list(USER||'.TST_PKG_HUGE'));
 end;
 /
 

diff --git a/old_tests/RunAll.sql b/old_tests/RunAll.sql
@@ -18,7 +18,6 @@ spool RunAll.log
 --Global setup
 @@helpers/ut_example_tests.pks
 @@helpers/ut_example_tests.pkb
-@@helpers/check_annotation_parsing.prc
 --@@helpers/cre_tab_ut_test_table.sql
 create table ut$test_table (val varchar2(1));
 @@helpers/ut_transaction_control.pck
@@ -38,19 +37,6 @@ create table ut$test_table (val varchar2(1));
 --Regular coverage excludes the framework
 exec ut_coverage.coverage_start_develop();
 
-@@lib/RunTest.sql ut_annotations/ut_annotations.parse_package_annotations.IgnoreWrappedPackageAndDoesNotRaiseException.sql
-@@lib/RunTest.sql ut_annotations/ut_annotations.parse_package_annotations.ParseAnnotationMixedWithWrongBeforeProcedure.sql
-@@lib/RunTest.sql ut_annotations/ut_annotations.parse_package_annotations.ParseAnnotationNotBeforeProcedure.sql
-@@lib/RunTest.sql ut_annotations/ut_annotations.parse_package_annotations.ParseAnnotationParamsWithBrackets.sql
-@@lib/RunTest.sql ut_annotations/ut_annotations.parse_package_annotations.ParsePackageAndProcedureLevelAnnotations.sql
-@@lib/RunTest.sql ut_annotations/ut_annotations.parse_package_annotations.ParsePackageLevelAnnotation.sql
-@@lib/RunTest.sql ut_annotations/ut_annotations.parse_package_annotations.ParsePackageLevelAnnotationAccessibleBy.sql
-@@lib/RunTest.sql ut_annotations/ut_annotations.parse_package_annotations.ParsePackageLevelAnnotationMultilineDeclare.sql
-@@lib/RunTest.sql ut_annotations/ut_annotations.parse_package_annotations.ParsePackageLevelAnnotationWithKeyValue.sql
-@@lib/RunTest.sql ut_annotations/ut_annotations.parse_package_annotations.ParsePackageLevelAnnotationWithMultilineComment.sql
-@@lib/RunTest.sql ut_annotations/ut_annotations.parse_package_annotations.spaceBeforeAnnotationParams.sql
-@@lib/RunTest.sql ut_annotations/ut_annotations.parse_package_annotations.ParseAnnotationWithWindowsNewline.sql
-@@lib/RunTest.sql ut_annotations/ut_annotations.parse_package_annotations.ParseProcedureAnnotationWithVeryLongName.sql
 @@lib/RunTest.sql ut_expectation_processor/who_called_expectation.parseStackTrace.sql
 @@lib/RunTest.sql ut_expectation_processor/who_called_expectation.parseStackTraceWith0x.sql
 @@ut_expectations/ut.expect.not_to_be_null.sql
@@ -284,7 +270,6 @@ spool off
 --Global cleanup
 --removing objects that should not be part of coverage report
 drop package ut_example_tests;
-drop procedure check_annotation_parsing;
 drop package ut_transaction_control;
 drop table ut$test_table;
 drop type department$;
@@ -341,8 +326,12 @@ begin
     'source/api/ut_runner.pks',
     'source/core/coverage',
     'source/core/types',
-    'source/core/ut_annotations.pkb',
-    'source/core/ut_annotations.pks',
+    'source/core/annotations/ut_annotation_manager.pkb',
+    'source/core/annotations/ut_annotation_manager.pks',
+    'source/core/annotations/ut_annotation_parser.pkb',
+    'source/core/annotations/ut_annotation_parser.pks',
+    'source/core/annotations/ut_annotation_cache_manager.pkb',
+    'source/core/annotations/ut_annotation_cache_manager.pks',
     'source/core/ut_expectation_processor.pkb',
     'source/core/ut_expectation_processor.pks',
     'source/core/ut_file_mapper.pkb',

diff --git a/old_tests/helpers/check_annotation_parsing.prc b/old_tests/helpers/check_annotation_parsing.prc
diff --git a/old_tests/helpers/test_reporters.pks b/old_tests/helpers/test_reporters.pks
@@ -2,6 +2,7 @@ create or replace package test_reporters
 as
   --%suite(A suite for testing different outcomes from reporters)
   --%suitepath(org.utplsql.utplsql.test)
+
   --%beforeall
   procedure beforeall;
 

diff --git a/...ut_annotations.parse_package_annotations.IgnoreWrappedPackageAndDoesNotRaiseException.sql b/...ut_annotations.parse_package_annotations.IgnoreWrappedPackageAndDoesNotRaiseException.sql
diff --git a/...ut_annotations.parse_package_annotations.ParseAnnotationMixedWithWrongBeforeProcedure.sql b/...ut_annotations.parse_package_annotations.ParseAnnotationMixedWithWrongBeforeProcedure.sql
diff --git a/...nnotations/ut_annotations.parse_package_annotations.ParseAnnotationNotBeforeProcedure.sql b/...nnotations/ut_annotations.parse_package_annotations.ParseAnnotationNotBeforeProcedure.sql
diff --git a/...nnotations/ut_annotations.parse_package_annotations.ParseAnnotationParamsWithBrackets.sql b/...nnotations/ut_annotations.parse_package_annotations.ParseAnnotationParamsWithBrackets.sql
diff --git a/...nnotations/ut_annotations.parse_package_annotations.ParseAnnotationWithWindowsNewline.sql b/...nnotations/ut_annotations.parse_package_annotations.ParseAnnotationWithWindowsNewline.sql