Skip to content

Commit 77031ce

Browse files
jgebaljgebal
committed
Moved tests from examples into tests.
Added basic testing framework for building test scripts. Tests are now atomic. One test per one file. Each test has a description.
1 parent caee789 commit 77031ce

26 files changed

Lines changed: 379 additions & 305 deletions

‎examples/RunAllExamples.sql‎

Lines changed: 2 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -11,13 +11,5 @@ prompt RunExampleTestSuiteWithDBMSOutputReporter
1111
@@RunExampleTestSuiteWithDBMSOutputReporter.sql
1212
prompt RunExampleTestThroughBaseClass
1313
@@RunExampleTestThroughBaseClass.sql
14-
prompt TestPackageName
15-
@@TestPackageName.sql
16-
prompt TestProcedureName
17-
@@TestProcedureName.sql
18-
prompt TestOwnerName
19-
@@TestOwnerName.sql
20-
prompt TestSetupProcedureName
21-
@@TestSetupProcedureName.sql
22-
prompt TestTeardownProcedureName
23-
@@TestTeardownProcedureName.sql
14+
prompt RunExampleTestSuiteWithCompositeReporter
15+
@@RunExampleTestSuiteWithCompositeReporter.sql

‎examples/RunExampleTestSuiteWithCompositeReporter.sql‎

Lines changed: 40 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,40 @@
1+
--Shows how to create a test suite with the default reporter which is dbms_output
2+
--No tables are used for this.
3+
--Suite Management packages are when developed will make this easier.
4+
--Clear Screen
5+
Set Serveroutput On Size Unlimited format truncated
6+
set echo off
7+
--install the example unit test packages
8+
@@ut_exampletest.pks
9+
@@ut_exampletest.pkb
10+
@@ut_exampletest2.pks
11+
@@ut_exampletest2.pkb
12+
13+
PROMPT Runs test report using composite reporter
14+
declare
15+
suite ut_test_suite;
16+
testtoexecute ut_test;
17+
begin
18+
suite := ut_test_suite(a_suite_name => 'Test Suite Name' /*,a_items => ut_test_objects_list()*/);
19+
20+
testtoexecute := ut_test(a_object_name => 'ut_exampletest'
21+
,a_test_procedure => 'ut_exAmpletest'
22+
,a_setup_procedure => 'Setup'
23+
,a_teardown_procedure => 'tEardown');
24+
25+
suite.add_item(testtoexecute);
26+
27+
testtoexecute := ut_test(a_object_name => 'UT_EXAMPLETEST2'
28+
,a_test_procedure => 'UT_EXAMPLETEST'
29+
,a_setup_procedure => 'SETUP'
30+
,a_teardown_procedure => 'TEARDOWN');
31+
32+
suite.add_item(testtoexecute);
33+
34+
-- provide a reporter to process results
35+
suite.execute(ut_composite_reporter(ut_reporters_list(ut_dbms_output_suite_reporter)));
36+
end;
37+
/
38+
39+
drop package ut_exampletest;
40+
drop package ut_exampletest2;

‎examples/TestOwnerName.sql‎

Lines changed: 0 additions & 54 deletions
This file was deleted.

‎examples/TestPackageName.sql‎

Lines changed: 0 additions & 81 deletions
This file was deleted.

‎examples/TestProcedureName.sql‎

Lines changed: 0 additions & 52 deletions
This file was deleted.

‎examples/TestSetupProcedureName.sql‎

Lines changed: 0 additions & 54 deletions
This file was deleted.

‎examples/TestTeardownProcedureName.sql‎

Lines changed: 0 additions & 54 deletions
This file was deleted.

‎tests/RunAll.sql‎

Lines changed: 32 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,32 @@
1+
set echo off
2+
set feedback off
3+
Clear Screen
4+
set serveroutput on size unlimited format truncated
5+
@@lib/RunVars.sql
6+
7+
--Global setup
8+
@@helpers/ut_example_tests.pks
9+
@@helpers/ut_example_tests.pkb
10+
11+
--Tests to invoke
12+
@@lib/RunTest.sql ut_test/ut_test.OwnerNameInvalid.sql
13+
@@lib/RunTest.sql ut_test/ut_test.OwnerNameNull.sql
14+
@@lib/RunTest.sql ut_test/ut_test.PackageInInvalidState.sql
15+
@@lib/RunTest.sql ut_test/ut_test.PackageNameInvalid.sql
16+
@@lib/RunTest.sql ut_test/ut_test.PackageNameNull.sql
17+
@@lib/RunTest.sql ut_test/ut_test.ProcedureNameInvalid.sql
18+
@@lib/RunTest.sql ut_test/ut_test.ProcedureNameNull.sql
19+
@@lib/RunTest.sql ut_test/ut_test.SetupExecutedBeforeTest.sql
20+
@@lib/RunTest.sql ut_test/ut_test.SetupProcedureNameInvalid.sql
21+
@@lib/RunTest.sql ut_test/ut_test.SetupProcedureNameNull.sql
22+
@@lib/RunTest.sql ut_test/ut_test.TeardownExecutedAfterTest.sql
23+
@@lib/RunTest.sql ut_test/ut_test.TeardownProcedureNameInvalid.sql
24+
@@lib/RunTest.sql ut_test/ut_test.TeardownProcedureNameNull.sql
25+
26+
--Global cleanup
27+
drop package ut_example_tests;
28+
29+
--Finally
30+
@@lib/RunSummary
31+
--can be used by CI to check for tests status
32+
exit :failures_count

0 commit comments

Comments
 (0)