self.negated();

self.not_to( ut_contain(a_expected));

self.not_to( ut_contain(a_expected));

procedure collection_not_to_contain is

l_actual ut3_tester_helper.test_dummy_object_list;

l_expected ut3_tester_helper.test_dummy_object_list;

begin

--Arrange

select ut3_tester_helper.test_dummy_object( rownum, 'Something2 '||rownum, rownum+100)

bulk collect into l_actual

from dual connect by level <=4;

select ut3_tester_helper.test_dummy_object( rownum, 'Something '||rownum, rownum)

bulk collect into l_expected

from dual connect by level <=2

order by rownum desc;

--Act

ut3_develop.ut.expect(anydata.convertCollection(l_actual)).not_to_contain(anydata.convertCollection(l_expected));

ut.expect(ut3_tester_helper.main_helper.get_failed_expectations_num).to_equal(0);

end;

--%test( Success when anydata collection not contains data from another anydata collection)

procedure collection_not_to_contain;

procedure cursor_not_to_contain2

as

l_actual sys_refcursor;

l_expected sys_refcursor;

begin

open l_expected for select 'TEST' username, -600 user_id from dual;

open l_actual for select username, user_id from all_users

union all

select 'TEST1' username, -601 user_id from dual;

--Act

ut3_develop.ut.expect(l_actual).not_to(ut3_develop.contain(l_expected));

--Assert

ut.expect(ut3_tester_helper.main_helper.get_failed_expectations_num).to_equal(0);

end;

procedure cursor_not_to_contain_fail2 is

l_actual sys_refcursor;

l_expected sys_refcursor;

l_expected_message varchar2(32767);

l_actual_message varchar2(32767);

begin

--Arrange

open l_expected for select 'TEST' username, -600 user_id from dual;

open l_actual for select username, user_id from all_users

union all

select 'TEST' username, -600 user_id from dual;

--Act

ut3_develop.ut.expect(l_actual).not_to(ut3_develop.contain(l_expected));

--Assert

l_expected_message := q'[%Actual: (refcursor [ count = % ])%

%Data-types:%

%<USERNAME>VARCHAR2</USERNAME><USER_ID>NUMBER</USER_ID>%

%Data:%

%was expected not to contain:(refcursor [ count = 1 ])%

%Data-types:%

%<USERNAME>CHAR</USERNAME><USER_ID>NUMBER</USER_ID>%

%Data:%

%<ROW><USERNAME>TEST</USERNAME><USER_ID>-600</USER_ID></ROW>%]';

l_actual_message := ut3_tester_helper.main_helper.get_failed_expectations(1);

--Assert

ut.expect(l_actual_message).to_be_like(l_expected_message);

end;

procedure cursor_not_to_contain_joinby2 is

l_actual sys_refcursor;

l_expected sys_refcursor;

begin

--Arrange

open l_actual for select username,rownum * 10 user_id from all_users where rownum < 5;

open l_expected for select username||to_char(rownum) username ,rownum user_id from all_users where rownum < 5;

--Act

ut3_develop.ut.expect(l_actual).not_to(ut3_develop.contain(l_expected).join_by('USER_ID'));

--Assert

ut.expect(ut3_tester_helper.main_helper.get_failed_expectations_num).to_equal(0);

end;

procedure not_con_join_incl_cols_as_lst2 is

l_actual sys_refcursor;

l_expected sys_refcursor;

begin

--Arrange

open l_actual for select rownum as rn, 'b' as "A_Column", 'c' as A_COLUMN, 'x' SOME_COL, 'd' "Some_Col" from dual a connect by level < 10;

open l_expected for select rownum * 20 rn, 'a' as "A_Column", 'd' as A_COLUMN, 'x' SOME_COL, 'c' "Some_Col" from dual a connect by level < 4;

--Act

ut3_develop.ut.expect(l_actual).not_to(ut3_develop.contain(l_expected).include(ut3_develop.ut_varchar2_list('RN','//A_Column','SOME_COL')).join_by('RN'));

--Assert

ut.expect(ut3_tester_helper.main_helper.get_failed_expectations_num).to_equal(0);

end;

procedure not_con_join_excl_cols_as_lst2 is

l_actual sys_refcursor;

l_expected sys_refcursor;

begin

--Arrange

open l_actual for select rownum as rn, 'a' as "A_Column", 'c' as A_COLUMN, 'y' SOME_COL, 'd' "Some_Col" from dual a connect by level < 10;

open l_expected for select rownum * 20 as rn, 'a' as "A_Column", 'd' as A_COLUMN, 'x' SOME_COL, 'c' "Some_Col" from dual a connect by level < 4;

--Act

ut3_develop.ut.expect(l_actual).not_to(ut3_develop.contain(l_expected).exclude(ut3_develop.ut_varchar2_list('//Some_Col','A_COLUMN')).join_by('RN'));

--Assert

ut.expect(ut3_tester_helper.main_helper.get_failed_expectations_num).to_equal(0);

end;

procedure to_not_contain_fails_1245 is

c1 sys_refcursor;

c2 sys_refcursor;

begin

open c1 for select 'a' as letter from dual union all select 'b' from dual;

open c2 for select 'c' as letter from dual;

ut3_develop.ut.expect(c1).not_to(ut3_develop.contain(c2));

ut.expect(ut3_tester_helper.main_helper.get_failed_expectations_num).to_equal(0);

end;

--%test( Cursor not_to[contain] data from another cursor)

procedure cursor_not_to_contain2;

--%test( Cursor fail not_to[contain] data from another cursor)

procedure cursor_not_to_contain_fail2;

--%test( Cursor not_to[contain] data from another cursor with joinby clause)

procedure cursor_not_to_contain_joinby2;

--%test(Cursor not_to[contain] data with of columns to include and join by value)

procedure not_con_join_incl_cols_as_lst2;

--%test(Cursor not_to[contain] data with of columns to exclude and join by value)

procedure not_con_join_excl_cols_as_lst2;

--%test(Cursor using not_to[contain] fails #1245)

procedure to_not_contain_fails_1245;