utPLSQL · jgebal · Jul 18, 2018 · Jul 8, 2018 · Jul 9, 2018 · Jul 10, 2018
diff --git a/.travis.yml b/.travis.yml
@@ -86,7 +86,6 @@ install:
 before_script:
   - if [[ ! $TRAVIS_TAG ]]; then bash .travis/install.sh; fi
   - if [[ ! $TRAVIS_TAG ]]; then bash .travis/install_utplsql_release.sh; fi
-  - if [[ ! $TRAVIS_TAG ]]; then bash .travis/create_additional_grants_for_old_tests.sh; fi
   - if [[ ! $TRAVIS_TAG ]]; then bash .travis/run_examples.sh; fi
   - if [[ ! $TRAVIS_TAG ]]; then bash .travis/run_old_tests.sh; fi
 

diff --git a/.travis/create_additional_grants_for_old_tests.sh b/.travis/create_additional_grants_for_old_tests.sh
diff --git a/.travis/install.sh b/.travis/install.sh
@@ -69,3 +69,30 @@ revoke execute on dbms_crypto from $UT3_TESTER;
 grant create job to $UT3_TESTER;
 exit
 SQL
+
+#additional privileges to run tests
+"$SQLCLI" sys/$ORACLE_PWD@//$CONNECTION_STR AS SYSDBA <<-SQL
+set feedback on
+--needed for Mystats script to work
+grant select any dictionary to $UT3_OWNER;
+--Needed for testing a coverage outside ut3_owner.
+grant create any procedure, drop any procedure, execute any procedure to $UT3_OWNER;
+
+exit
+SQL
+
+#Create additional users
+"$SQLCLI" sys/$ORACLE_PWD@//$CONNECTION_STR AS SYSDBA <<-SQL
+set feedback off
+@create_utplsql_owner.sql $UT3_USER $UT3_USER_PASSWORD $UT3_TABLESPACE
+
+exit
+SQL
+
+#Grant UT3 framework to UT3$USER#
+"$SQLCLI" sys/$ORACLE_PWD@//$CONNECTION_STR AS SYSDBA <<-SQL
+set feedback off
+@create_user_grants.sql $UT3_OWNER $UT3_USER
+
+exit
+SQL
diff --git a/development/install.sh b/development/install.sh
@@ -18,7 +18,3 @@ if ! .travis/install_utplsql_release.sh; then
     echo -e ${header}"\nFailed to install utPLSQL from branch ${SELFTESTING_BRANCH} into ${UT3_RELEASE_VERSION_SCHEMA}\n"${header}
     exit 1
 fi
-if ! .travis/create_additional_grants_for_old_tests.sh; then
-    echo -e ${header}"Failed to add grants needed old_tests\n"${header}
-    exit 1
-fi
diff --git a/docs/userguide/coverage.md b/docs/userguide/coverage.md
@@ -230,10 +230,10 @@ C:
       \hr.test_betwnstr.pks
 ``` 
 
-By default, utPLSQL will convert file paths into database objects using the following regular expression `/((\w+)\.)?(\w+)\.(\w{3})$`
+By default, utPLSQL will convert file paths into database objects using the following regular expression `/(((\w|[$#])+)\.)?((\w|[$#])+)\.(\w{3})$`
 - object owner (if it is present) is identified by the expression in the second set of  brackets
-- object name is identified by the expression in the third set of brackets
-- object type is identified by the expression in the fourth set of brackets
+- object name is identified by the expression in the fourth set of brackets
+- object type is identified by the expression in the sixth set of brackets
 
 
 **Note**

diff --git a/old_tests/RunAll.sql b/old_tests/RunAll.sql
@@ -37,94 +37,19 @@ create table ut$test_table (val varchar2(1));
 exec ut_coverage.coverage_start();
 exec ut_coverage.set_develop_mode(true);
 
-@@lib/RunTest.sql ut_expectation_processor/who_called_expectation.parseStackTrace.sql
-@@lib/RunTest.sql ut_expectation_processor/who_called_expectation.parseStackTraceWith0x.sql
-@@lib/RunTest.sql ut_expectations/ut.expect.to_be_false.GivesFailureWhenExpessionIsNotBoolean.sql
-@@lib/RunTest.sql ut_expectations/ut.expect.to_be_false.GivesFailureWhenExpessionIsNull.sql
-@@lib/RunTest.sql ut_expectations/ut.expect.to_be_false.GivesFailureWhenExpessionIsTrue.sql
-@@lib/RunTest.sql ut_expectations/ut.expect.to_be_false.GivesSuccessWhenExpessionIsFalse.sql
-@@lib/RunTest.sql ut_expectations/ut.expect.to_be_like.FailsForUnsupportedDatatype.sql
-@@lib/RunTest.sql ut_expectations/ut.expect.to_be_null.anydata.GivesSuccessWhenAnydataIsNull.sql
-@@lib/RunTest.sql ut_expectations/ut.expect.to_be_null.anydata.GivesSuccessWhenCollectionPassedIsNull.sql
-@@lib/RunTest.sql ut_expectations/ut.expect.to_be_null.anydata.GivesSuccessWhenObjectPassedIsNull.sql
-@@lib/RunTest.sql ut_expectations/ut.expect.to_be_true.GivesFailureWhenExpessionIsFalse.sql
-@@lib/RunTest.sql ut_expectations/ut.expect.to_be_true.GivesFailureWhenExpessionIsNotBoolean.sql
-@@lib/RunTest.sql ut_expectations/ut.expect.to_be_true.GivesFailureWhenExpessionIsNull.sql
-@@lib/RunTest.sql ut_expectations/ut.expect.to_be_true.GivesSuccessWhenExpessionIsTrue.sql
-@@ut_expectations/ut.expect.not_to_equal.GivesFailureForEqualValues.sql
-@@ut_expectations/ut.expect.not_to_equal.GivesSuccessForDifferentValues.sql
-@@lib/RunTest.sql ut_expectations/ut.expect.to_match.FailsForUnsupportedDatatype.sql
-@@lib/RunTest.sql ut_expectations/ut_data_value_object.compare.Gives0WhenComparingIdenticalObjects.sql
 @@lib/RunTest.sql ut_expectations/ut_expectation_processor.nulls_are_equal.raisesExceptionWhenTryingToSetNullValue.sql
 @@lib/RunTest.sql ut_expectations/ut_expectation_processor.stackOnFailedTest.sql
 @@lib/RunTest.sql ut_expectations/ut_expectation_processor.stackOnUtFail.sql
 
-@@ut_matchers/be_between.sql
-@@ut_matchers/be_like.sql
-@@ut_matchers/match.sql
-
-@@lib/RunTest.sql ut_matchers/timestamp_between.sql
-@@lib/RunTest.sql ut_matchers/timestamp_ltz_between.sql
-@@lib/RunTest.sql ut_matchers/timestamp_ltz_not_between.sql
-@@lib/RunTest.sql ut_matchers/timestamp_not_between.sql
-@@lib/RunTest.sql ut_matchers/timestamp_tz_between.sql
-@@lib/RunTest.sql ut_matchers/timestamp_tz_not_between.sql
-
 @@lib/RunTest.sql ut_metadata/ut_metadata.form_name.TrimStandaloneProgramName.sql
 
-@@lib/RunTest.sql ut_output_buffer/get_lines.RecievesALineFromBufferTableAndDeletes.sql
-@@lib/RunTest.sql ut_output_buffer/get_lines.WaitsForMoreDataToAppearForSpecifiedTime.sql
-@@lib/RunTest.sql ut_output_buffer/get_lines.WaitsForTheDataToAppearForSpecifiedTime.sql
-@@lib/RunTest.sql ut_output_buffer/send_line.DoesNotSendLineIfNullTextGiven.sql
-@@lib/RunTest.sql ut_output_buffer/send_line.SendsALineIntoBufferTable.sql
-
 @@lib/RunTest.sql ut_reporters/ut_documentation_reporter.providesCorrectLineFromStacktrace.sql
 @@lib/RunTest.sql ut_reporters/ut_documentation_reporter.reportMultipleWarnings.sql
 @@lib/RunTest.sql ut_reporters/ut_documentation_reporter.reportTestTiming.sql
 @@lib/RunTest.sql ut_reporters/ut_html_reporter.DefaultSchemaCoverage.sql
 @@lib/RunTest.sql ut_reporters/ut_html_reporter.UserOverrideSchemaCoverage.sql
-@@lib/RunTest.sql ut_reporters/ut_teamcity_reporter.ProducesExpectedOutputs.sql
-
-@@lib/RunTest.sql ut/ut.run.AcceptsCoverageFileList.sql
-@@lib/RunTest.sql ut/ut.run.AcceptsCoverageFileListWithSutePaths.sql
-@@lib/RunTest.sql ut/ut.run.AcceptsSutePaths.sql
-@@lib/RunTest.sql ut/ut.run.ExecutesSuccesfullyAnEmptySuite.sql
-@@lib/RunTest.sql ut/ut.run.FailsToExecuteAnInvalidPackageBody.sql
-@@lib/RunTest.sql ut/ut.run.function.AcceptsCoverageFileList.sql
-@@lib/RunTest.sql ut/ut.run.function.AcceptsCoverageFileListWithSutePaths.sql
-@@lib/RunTest.sql ut/ut.run.function.AcceptsSutePaths.sql
-@@lib/RunTest.sql ut/ut.run.function.WithGivenReporter.ExectutesAllInCurrentSchemaUsingReporter.sql
-@@lib/RunTest.sql ut/ut.run.function.WithNoParams.ExecutesAllFromCurrentSchema.sql
-@@lib/RunTest.sql ut/ut.run.function.WithPackageName.ExecutesAllFromGivenPackage.sql
---@@lib/RunTest.sql ut.run/ut.run.function.WithPackageName.ExecutesAllFromGivenPackageOnly.sql --TODO this one doesn't work at the moment
-@@lib/RunTest.sql ut/ut.run.function.WithSchemaName.ExecutesAllFromGivenSchema.sql
-@@lib/RunTest.sql ut/ut.run.function.WithSuitePath.ExecutesAllFromGivenPath.sql
-@@lib/RunTest.sql ut/ut.run.WithGivenReporter.ExectutesAllInCurrentSchemaUsingReporter.sql
-@@lib/RunTest.sql ut/ut.run.WithNoParams.ExecutesAllFromCurrentSchema.sql
-@@lib/RunTest.sql ut/ut.run.WithPackageName.ExecutesAllFromGivenPackage.sql
---@@lib/RunTest.sql ut.run/ut.run.WithPackageName.ExecutesAllFromGivenPackageOnly.sql --TODO this one doesn't work at the moment
-@@lib/RunTest.sql ut/ut.run.WithSchemaName.ExecutesAllFromGivenSchema.sql
-@@lib/RunTest.sql ut/ut.run.WithSuitePath.ExecutesAllFromGivenPath.sql
-@@lib/RunTest.sql ut/ut.version.sql
 
 @@lib/RunTest.sql ut_suite_manager/ut_suite_manager.AllowsDescriptionsWithComma.sql
-@@lib/RunTest.sql ut_suite_manager/ut_suite_manager.configure_execution_by_path.PrepareRunnerForTheSchema.sql
-@@lib/RunTest.sql ut_suite_manager/ut_suite_manager.configure_execution_by_path.PrepareRunnerForTheTopPackageByPath.sql
-@@lib/RunTest.sql ut_suite_manager/ut_suite_manager.configure_execution_by_path.PrepareRunnerForTheTopPackageByPathCurUser.sql
-@@lib/RunTest.sql ut_suite_manager/ut_suite_manager.configure_execution_by_path.PrepareRunnerForTheTop2PackageByPath.sql
-@@lib/RunTest.sql ut_suite_manager/ut_suite_manager.configure_execution_by_path.PrepareRunnerForTheTop2PackageByPathCurUser.sql
-@@lib/RunTest.sql ut_suite_manager/ut_suite_manager.configure_execution_by_path.PrepareRunnerForTheTopPackageWithoutSubsuitesByPath.sql
-@@lib/RunTest.sql ut_suite_manager/ut_suite_manager.configure_execution_by_path.PrepareRunnerForTheTopPackageWithoutSubsuitesByPathCurUser.sql
-@@lib/RunTest.sql ut_suite_manager/ut_suite_manager.configure_execution_by_path.PrepareRunnerForTheTopPackageByName.sql
-@@lib/RunTest.sql ut_suite_manager/ut_suite_manager.configure_execution_by_path.PrepareRunnerForTheTopPackageByNameCurUser.sql
-@@lib/RunTest.sql ut_suite_manager/ut_suite_manager.configure_execution_by_path.PrepareRunnerForTheTop2PackageByName.sql
-@@lib/RunTest.sql ut_suite_manager/ut_suite_manager.configure_execution_by_path.PrepareRunnerForTheTop2PackageByNameCurUser.sql
-@@lib/RunTest.sql ut_suite_manager/ut_suite_manager.configure_execution_by_path.PrepareRunnerForTheTopPackageWithoutSubsuitesByName.sql
-@@lib/RunTest.sql ut_suite_manager/ut_suite_manager.configure_execution_by_path.PrepareRunnerForTheTopPackageWithoutSubsuitesByNameCurUser.sql
-@@lib/RunTest.sql ut_suite_manager/ut_suite_manager.configure_execution_by_path.PrepareRunnerForTheTopPackageProcedureByPath.sql
-@@lib/RunTest.sql ut_suite_manager/ut_suite_manager.configure_execution_by_path.PrepareRunnerForTheTopPackageProcedureByPathCurUser.sql
-@@lib/RunTest.sql ut_suite_manager/ut_suite_manager.configure_execution_by_path.PrepareRunnerForTheTop2PackageProcedureByPath.sql
-@@lib/RunTest.sql ut_suite_manager/ut_suite_manager.configure_execution_by_path.PrepareRunnerForTheTop2PackageProcedureByPathCurUser.sql
 @@lib/RunTest.sql ut_suite_manager/ut_suite_manager.emptySuitePath.sql
 @@lib/RunTest.sql ut_suite_manager/ut_suite_manager.get_schema_ut_packages.IncludesPackagesWithSutePath.sql
 @@lib/RunTest.sql ut_suite_manager/ut_suite_manager.IncludesInvalidPackageBodiesInTheRun.sql

diff --git a/old_tests/ut/ut.run.AcceptsCoverageFileList.sql b/old_tests/ut/ut.run.AcceptsCoverageFileList.sql
diff --git a/old_tests/ut/ut.run.AcceptsCoverageFileListWithSutePaths.sql b/old_tests/ut/ut.run.AcceptsCoverageFileListWithSutePaths.sql
diff --git a/old_tests/ut/ut.run.AcceptsSutePaths.sql b/old_tests/ut/ut.run.AcceptsSutePaths.sql
diff --git a/old_tests/ut/ut.run.ExecutesSuccesfullyAnEmptySuite.sql b/old_tests/ut/ut.run.ExecutesSuccesfullyAnEmptySuite.sql
diff --git a/old_tests/ut/ut.run.FailsToExecuteAnInvalidPackageBody.sql b/old_tests/ut/ut.run.FailsToExecuteAnInvalidPackageBody.sql
diff --git a/old_tests/ut/ut.run.WithGivenReporter.ExectutesAllInCurrentSchemaUsingReporter.sql b/old_tests/ut/ut.run.WithGivenReporter.ExectutesAllInCurrentSchemaUsingReporter.sql
diff --git a/old_tests/ut/ut.run.WithNoParams.ExecutesAllFromCurrentSchema.sql b/old_tests/ut/ut.run.WithNoParams.ExecutesAllFromCurrentSchema.sql