Skip to content

Add ability to run tests by part of a name. #1203

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
lwasylow merged 29 commits into from
Apr 23, 2022
Merged

Add ability to run tests by part of a name. #1203

Show file tree
Hide file tree
Changes from 1 commit
Commits
Show all changes
29 commits
Select commit Hold shift + click to select a range
86d4d0a
Initial check-in.
lwasylow Mar 18, 2022
f1f6d71
Tidy up code to make sure we got distinct set of expanded tests.
lwasylow Mar 19, 2022
1454221
Adding extra fields.
lwasylow Mar 23, 2022
ce4df28
Stage 3. Fixing error calls.
lwasylow Mar 29, 2022
273962b
Fixing issue with a non visible tests.
lwasylow Mar 29, 2022
a753e66
Fixing ORA-600
lwasylow Mar 30, 2022
0d8d34d
Cleanup Phase1.
lwasylow Mar 30, 2022
95ddec1
Adding tests.
lwasylow Mar 31, 2022
83dbdaa
Updating documentation.
lwasylow Mar 31, 2022
52c0307
Addresing sonar issues
lwasylow Mar 31, 2022
8f8d257
Extra tests and cleanup of old code.
lwasylow Apr 1, 2022
12be123
Adding extra tests
lwasylow Apr 1, 2022
d5ee6ca
Updating SQL to expand paths and extract suites.
lwasylow Apr 1, 2022
2db8d63
Addressing issue with reconstruct_cache knocking off other levels.
lwasylow Apr 6, 2022
d3396fe
Update tests for random order
lwasylow Apr 7, 2022
02d41a6
Removing a hash function from api into utils package which is more su…
lwasylow Apr 7, 2022
274d80a
Fixing ordering
lwasylow Apr 7, 2022
3937737
Fixing a documentation
lwasylow Apr 7, 2022
9296f38
Fixing indent
lwasylow Apr 7, 2022
6ff7f38
Peer review changes
lwasylow Apr 12, 2022
ee7a98b
Moving a SQL to be more readable.
lwasylow Apr 12, 2022
a53cefa
Apply suggestions from code review
jgebal Apr 13, 2022
011970f
Apply suggestions from code review
jgebal Apr 13, 2022
71e07f9
Merge remote-tracking branch 'origin/develop' into feature/call_tests…
jgebal Apr 15, 2022
221c2de
Address issue of not recognizing a correct nested level of suitepath.
lwasylow Apr 16, 2022
870cfe4
Merge branch 'feature/call_tests_by_part_of_name' of https://github.c…
lwasylow Apr 16, 2022
51439d8
Update documentation
lwasylow Apr 16, 2022
0fc7ff6
Fixing issue where parition by only path caused a duplicate level 1 a…
lwasylow Apr 16, 2022
647b830
Fixed issue with suites getting duplicated when running tests across …
jgebal Apr 17, 2022
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
Prev Previous commit
Next Next commit
Stage 3. Fixing error calls.
  • Loading branch information
@lwasylow
lwasylow committed Mar 29, 2022
commit ce4df285da6cd303fd38df345b0d68389dcaf348
9 changes: 3 additions & 6 deletions source/core/types/ut_path_item.tpb
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -15,30 +15,27 @@ create or replace type body ut_path_item as
See the License for the specific language governing permissions and
limitations under the License.
*/
constructor function ut_path_item(self in out nocopy ut_path_item, schema_name varchar2, object_name varchar2,procedure_name varchar2, originated_path varchar2) return self as result is
constructor function ut_path_item(self in out nocopy ut_path_item, schema_name varchar2, object_name varchar2,procedure_name varchar2) return self as result is
begin
self.schema_name := schema_name;
self.object_name := object_name;
self.procedure_name := procedure_name;
self.originated_path := originated_path;
return;
end;

constructor function ut_path_item(self in out nocopy ut_path_item, schema_name varchar2,suite_path varchar2, originated_path varchar2) return self as result is
constructor function ut_path_item(self in out nocopy ut_path_item, schema_name varchar2,suite_path varchar2) return self as result is
begin
self.schema_name := schema_name;
self.suite_path := suite_path;
self.originated_path := originated_path;
return;
end;

constructor function ut_path_item(self in out nocopy ut_path_item, schema_name varchar2, object_name varchar2,procedure_name varchar2,suite_path varchar2, originated_path varchar2) return self as result is
constructor function ut_path_item(self in out nocopy ut_path_item, schema_name varchar2, object_name varchar2,procedure_name varchar2,suite_path varchar2) return self as result is
begin
self.schema_name := schema_name;
self.object_name := object_name;
self.procedure_name := procedure_name;
self.suite_path := suite_path;
self.originated_path := originated_path;
return;
end;
end;
Expand Down
7 changes: 3 additions & 4 deletions source/core/types/ut_path_item.tps
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -19,9 +19,8 @@ create or replace type ut_path_item as object (
object_name varchar2(250),
procedure_name varchar2(250),
suite_path varchar2(4000),
originated_path varchar2(4000),
constructor function ut_path_item(self in out nocopy ut_path_item, schema_name varchar2, object_name varchar2,procedure_name varchar2, originated_path varchar2) return self as result,
constructor function ut_path_item(self in out nocopy ut_path_item, schema_name varchar2, suite_path varchar2, originated_path varchar2) return self as result,
constructor function ut_path_item(self in out nocopy ut_path_item, schema_name varchar2, object_name varchar2,procedure_name varchar2,suite_path varchar2, originated_path varchar2) return self as result
constructor function ut_path_item(self in out nocopy ut_path_item, schema_name varchar2, object_name varchar2,procedure_name varchar2) return self as result,
constructor function ut_path_item(self in out nocopy ut_path_item, schema_name varchar2, suite_path varchar2) return self as result,
constructor function ut_path_item(self in out nocopy ut_path_item, schema_name varchar2, object_name varchar2,procedure_name varchar2,suite_path varchar2) return self as result
)
/
25 changes: 13 additions & 12 deletions source/core/ut_suite_cache_manager.pkb
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -278,14 +278,12 @@ create or replace package body ut_suite_cache_manager is
l_results.extend;
if a_paths(i) like '%:%' then
l_path_item := ut_path_item(schema_name => upper(regexp_substr(a_paths(i),'^[^.:]+')),
suite_path => ltrim(regexp_substr(a_paths(i),'[.:].*$'),':'),
originated_path => a_paths(i));
suite_path => ltrim(regexp_substr(a_paths(i),'[.:].*$'),':'));
l_results(l_results.last) := l_path_item;
else
l_path_item := ut_path_item(schema_name => regexp_substr(a_paths(i), c_package_path_regex, subexpression => 1),
object_name => regexp_substr(a_paths(i), c_package_path_regex, subexpression => 3),
procedure_name => regexp_substr(a_paths(i), c_package_path_regex, subexpression => 5),
originated_path => a_paths(i));
procedure_name => regexp_substr(a_paths(i), c_package_path_regex, subexpression => 5));
l_results(l_results.last) := l_path_item;
end if;
end loop;
Expand Down Expand Up @@ -359,42 +357,45 @@ create or replace package body ut_suite_cache_manager is

function expand_paths(a_schema_paths ut_path_items) return ut_path_items is
l_schema_paths ut_path_items:= ut_path_items();
begin
begin
with paths_to_expand as (
select /*+ no_parallel */ min(path) as suite_path,sp.schema_name as schema_name,nvl(sp.object_name,c.object_name) as object_name,
sp.procedure_name as procedure_name,sp.originated_path
sp.procedure_name as procedure_name
from table(a_schema_paths) sp left outer join ut_suite_cache c
on ( c.object_owner = upper(sp.schema_name)
and c.object_name like replace(upper(sp.object_name),'*','%')
and c.name like nvl(replace(upper(sp.procedure_name),'*','%'), c.name))
where sp.suite_path is null
and sp.object_name is not null
group by sp.schema_name,nvl(sp.object_name,c.object_name),sp.procedure_name,sp.originated_path
group by sp.schema_name,nvl(sp.object_name,c.object_name),sp.procedure_name
union all
select /*+ no_parallel */ c.path as suite_path,sp.schema_name,sp.object_name,sp.procedure_name as procedure_name,sp.originated_path
select /*+ no_parallel */ c.path as suite_path,sp.schema_name,sp.object_name,sp.procedure_name as procedure_name
from
table(a_schema_paths) sp left outer join ut_suite_cache c on
( c.object_owner = upper(sp.schema_name)
and sp.suite_path is not null
and instr(sp.suite_path,'*') > 0)
where c.path like replace(sp.suite_path,'*','%')
union all
select /*+ no_parallel */ sp.suite_path as suite_path,sp.schema_name,sp.object_name,sp.procedure_name as procedure_name,sp.originated_path
select /*+ no_parallel */ sp.suite_path as suite_path,sp.schema_name,sp.object_name,sp.procedure_name as procedure_name
from table(a_schema_paths) sp
where sp.suite_path is not null
and instr(sp.suite_path,'*') = 0
union all
select /*+ no_parallel */ sp.suite_path as suite_path,sp.schema_name,sp.object_name,sp.procedure_name as procedure_name,sp.originated_path
select /*+ no_parallel */ sp.suite_path as suite_path,sp.schema_name,sp.object_name,sp.procedure_name as procedure_name
from table(a_schema_paths) sp
where sp.suite_path is null and sp.object_name is null
)
select ut_path_item(schema_name,object_name,procedure_name,suite_path,originated_path)
select ut_path_item(schema_name,object_name,procedure_name,suite_path)
bulk collect into l_schema_paths
from
(select schema_name,object_name,procedure_name,suite_path,originated_path,
(select schema_name,object_name,procedure_name,suite_path,
row_number() over ( partition by schema_name,object_name,procedure_name,suite_path order by 1) r_num
from paths_to_expand)
where r_num = 1 ;



return l_schema_paths;
end;

Expand Down
Loading