Cheatography
https://cheatography.com
Package annotations--%suite | Package is a test suite | --%suite(description) | A suite with description | --%suitepath(org.my_org.my_project) | Similar to Java package.
Groups suites in namespaces |
Annotations are sinlgle-line comments starting with a % sign.
Needed in package specification only (documentation)Procedure annotations--%test | The procedure is a test | --%test(description) | A test with description | --%beforetest(procedure_name) | Runs the procedure before annotated test | --%aftertest(procedure_name) | Runs the procedure after annotated test | --%beforeall | The procedure to run before first test in suite | --%afterall | The procedure to run after last test in suite | --%beforeeach | The procedure to run before each test | --%aftereach | The procedure to after each test |
Unary matchersbe_empty open l_cursor for select * from dual where 1 = 0;
ut.expect( l_cursor ).to_( be_empty() );
| be_false ut.expect( ( 1 = 0 ) ).to_( be_false() );
| be_not_null ut.expect( to_clob('ABC') ).to_( be_not_null() );
| be_null ut.expect( 1 ).to_( be_null() );
| be_true ut.expect( ( 1 = 1 ) ).to_( be_true() );
|
Common annotations--%disabled | Suite / test will not execute | --%rollback(auto) | | --%rollback(manual) | No savepoint/rollback |
Expectation structureBase expectation block ut.expect( actual_value ).to_( matcher );
| Negated expectation block ut.expect( actual_value ).not_to( matcher );
| Shortcuts to matchers ut.expect( actual_value ).[not_]to_matcher;
|
Equality matcherequal ut.expect( 'a dog' ).to_(
equal( 'a dog' , a_nulls_are_equal => false ) );
a_nulls_are_equal is true by default
| equal with cursors open l_expected for select * from dual;
open l_actual for select * from dual where 1 = 0;
ut.expect( l_expected ).to_(
equal(l_actual, a_exclude=>'column_a,column_b') );
| equal on objects ut.expect( anydata.convertObject(l_expected) ).to_(
equal( anydata.convertObject(l_actual) ) );
| equal on collections ut.expect( anydata.convertCollection(l_expected) ).to_(
equal( anydata.convertCollection(l_actual) ) );
|
| | Non-equality matchersbe_like ut.expect( 'Lorem_impsum' ).to_(
be_like( a_mask => '%rem\_%', a_escape_char => '\' ) ); ut.expect( 'Lorem_impsum' ).to_( be_like( '%rem%sum' ) );a_mask, a_escape_char -> see Oracle like operator | match ut.expect( a_actual => '123-456-ABcd' ).to_(
match( a_pattern => '\d{3}-\d{3}-[a-z]', a_modifiers => 'i' ) ); ut.expect( 'some value' ).to_( match( '^some.*' ) );a_pattern, a_modifiers -> see regexp_like function | be_between ut.expect( 3 ).to_( be_between( 1, 3 ) );
| be_greater_or_equal ut.expect( sysdate ).to_( be_greater_or_equal( sysdate - 1 ) );
| be_greater_than ut.expect( 2 ).to_( be_greater_than( 1 ) );
| be_less_or_equal ut.expect( 3 ).to_( be_less_or_equal( 3 ) );
| be_less_than exec ut.expect( 3 ).to_( be_less_than( 2 ) );
|
ReportingColor output exec ut.run(a_color_console=>true);With sqlclor sqlPlus (Mac, Unix, Windows ANSICON) | XUnit reporter | TeamCity reporter exec ut.run(ut_teamcity_reporter());TeamCity-specific report | Sonar Test reporter exec ut.run(ut_sonar_test_reporter());Sonar-specific XML tests report | Coverage html reporter exec ut.run(ut_coverage_html_reporter());
Produces HTML coverage report
|
Executing testsRun all unit tests in my current schema exec ut.run();
| Run all unit tests in current schema after it was changed to HR alter session set current_schema='HR';
exec ut.run();
| Run all unit tests in specific schema exec ut.run('HR');
| Run all unit tests in specific package of current schema exec ut.run('test_betwnstr');
| Run all unit tests in specific schema.package exec ut.run('hr.test_betwnstr');
| Run one specific test only exec ut.run('hr.test_betwnstr.big_end_position');
| Run several items exec ut.run(ut_varchar2_list(
'hr.test_award_bonus',
'hr.test_betwnstr.big_end_position'));
| exec ut.run(':com.my_org.my_project');
| Run the tests as a select statement select * from table(ut.run());
|
Catching exceptionsprocedure my_code_raises_zero_divisor is
l_my_number number;
begin
l_my_number := 1/0; --should raise
ut.fail('Expected exception but nothing was raised');
exception
when others then
ut.expect( sqlcode ).to_equal( -1476 );
end;
|
|
Created By
www.oraclethoughts.com
Metadata
Favourited By
Comments
No comments yet. Add yours below!
Add a Comment
Related Cheat Sheets
More Cheat Sheets by jgebal