8000 Merge pull request #868 from utPLSQL/release/v3.1.5 · utPLSQL/utPLSQL@c92ed1b · GitHub
[go: up one dir, main page]
Skip to content

Commit c92ed1b

Browse files
jgebaljgebal
authored
Merge pull request #868 from utPLSQL/release/v3.1.5
Release/v3.1.5
2 parents abd2f37 + fef7ed7 commit c92ed1b

30 files changed

+240
-79
lines changed

‎.travis/push_release_version.sh

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -9,6 +9,7 @@ if [ "${TRAVIS_REPO_SLUG}" = "${UTPLSQL_REPO}" ] && [ "$TRAVIS_PULL_REQUEST" ==
99
git add sonar-project.properties
1010
git add VERSION
1111
git add source/*
12+
git add docs/*
1213
git commit -m 'Updated project version after build [skip ci]'
1314
echo "Pushing to origin"
1415
git push --quiet origin HEAD:${CURRENT_BRANCH}

‎VERSION

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1 +1 @@
1-
v3.1.4
1+
v3.1.5

‎docs/about/authors.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.4.2223--develop-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.5.2707-blue.svg)
22

33
### utPLSQL v3 Major Contributors
44

‎docs/about/license.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.4.2223--develop-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.5.2707-blue.svg)
22

33
# Version Information
44

‎docs/about/project-details.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.4.2223--develop-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.5.2707-blue.svg)
22

33
# utPLSQL Project Details
44

‎docs/about/support.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.4.2223--develop-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.5.2707-blue.svg)
22

33
# How to get support
44

‎docs/index.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.4.2223--develop-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.5.2707-blue.svg)
22

33
# Introduction to utPLSQL
44

‎docs/userguide/advanced_data_comparison.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.4.2223--develop-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.5.2707-blue.svg)
22

33
# Advanced data comparison
44

‎docs/userguide/annotations.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.4.2223--develop-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.5.2707-blue.svg)
22

33
# Annotations
44

‎docs/userguide/best-practices.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.4.2223--develop-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.5.2707-blue.svg)
22

33
# Best Practices
44

‎docs/userguide/coverage.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.4.2223--develop-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.5.2707-blue.svg)
22

33
# Coverage
44
utPLSQL comes with a built-in coverage reporting engine. The code coverage reporting is based on the DBMS_PROFILER package provided with Oracle database.

‎docs/userguide/exception-reporting.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.4.2223--develop-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.5.2707-blue.svg)
22

33
# Exception handling and reporting
44

‎docs/userguide/expectations.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.4.2223--develop-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.5.2707-blue.svg)
22

33
# Expectation concepts
44
Validation of the code under test (the tested logic of procedure/function etc.) is performed by comparing the actual data against the expected data.

‎docs/userguide/getting-started.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.4.2223--develop-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.5.2707-blue.svg)
22

33
# Getting started with TDD and utPLSQL
44

‎docs/userguide/install.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.4.2223--develop-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.5.2707-blue.svg)
22

33
# Downloading latest version of utPLSQL
44

‎docs/userguide/querying_suites.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.4.2223--develop-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.5.2707-blue.svg)
22

33
# Qyerying for test suites
44

‎docs/userguide/reporters.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.4.2223--develop-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.5.2707-blue.svg)
22

33
utPLSQL provides the following reporting formats.
44

‎docs/userguide/running-unit-tests.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.4.2223--develop-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.5.2707-blue.svg)
22

33
# Running tests
44

‎docs/userguide/upgrade.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
![version](https://img.shields.io/badge/version-v3.1.4.2223--develop-blue.svg)
1+
![version](https://img.shields.io/badge/version-v3.1.5.2707-blue.svg)
22

33
# Upgrading from version 2
44

‎sonar-project.properties

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
sonar.projectKey=utPLSQL
33
# this is the name and version displayed in the SonarQube UI. Was mandatory prior to SonarQube 6.1.
44
sonar.projectName=utPLSQL
5-
sonar.projectVersion=v3.1.4
5+
sonar.projectVersion=v3.1.5
66

77
# Path is relative to the sonar-project.properties file. Replace "\" by "/" on Windows.
88
# Since SonarQube 4.2, this property is optional if sonar.modules is set.
@@ -19,6 +19,7 @@ sonar.projectDescription=PL/SQL Unit Testing Framework
1919
sonar.plsql.file.suffixes=sql,tab,pkb,tpb
2020
sonar.language=plsql
2121

22+
2223
sonar.exclusions=create_synonyms_and_grants_for_public.sql, create_user_grants.sql, create_user_synonyms.sql, create_utplsql_owner.sql, define_ut3_owner_param.sql, install.sql, install_above_12_1.sql, install_component.sql, install_headless.sql, uninstall.sql, uninstall_all.sql, uninstall_coverage_tables.sql
2324

2425
sonar.pullrequest.provider=github

‎source/core/ut_utils.pks

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -21,7 +21,7 @@ create or replace package ut_utils authid definer is
2121
*
2222
*/
2323

24-
gc_version constant varchar2(50) := 'v3.1.4.2692';
24+
gc_version constant varchar2(50) := 'v3.1.5.2707';
2525

2626
subtype t_executable_type is varchar2(30);
2727
gc_before_all constant t_executable_type := 'beforeall';

‎source/create_synonyms_and_grants_for_public.sql

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -107,6 +107,8 @@ grant select, insert, delete, update on &&ut3_owner..dbmspcc_units to public;
107107
grant execute on &&ut3_owner..ut_matcher_options to public;
108108
grant execute on &&ut3_owner..ut_matcher_options_items to public;
109109
grant execute on &&ut3_owner..ut_run_info to public;
110+
grant execute on &&ut3_owner..ut_cursor_column_tab to public;
111+
grant execute on &&ut3_owner..ut_cursor_details to public;
110112

111113
prompt Creating synonyms for UTPLSQL objects in &&ut3_owner schema to PUBLIC
112114

@@ -167,3 +169,5 @@ create public synonym dbmspcc_blocks for &&ut3_owner..dbmspcc_blocks;
167169
create public synonym dbmspcc_runs for &&ut3_owner..dbmspcc_runs;
168170
create public synonym dbmspcc_units for &&ut3_owner..dbmspcc_units;
169171
create public synonym ut_run_info for &&ut3_owner..ut_run_info;
172+
create public synonym ut_cursor_column_tab for &&ut3_owner..ut_cursor_column_tab;
173+
create public synonym ut_cursor_details for &&ut3_owner..ut_cursor_details;

‎source/create_user_grants.sql

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -126,4 +126,5 @@ grant select, insert, delete, update on &&ut3_owner..dbmspcc_units to &ut3_user;
126126
grant execute on &&ut3_owner..ut_matcher_options to &ut3_user;
127127
grant execute on &&ut3_owner..ut_matcher_options_items to &ut3_user;
128128
grant execute on &&ut3_owner..ut_run_info to &ut3_user;
129-
129+
grant execute on &&ut3_owner..ut_cursor_column_tab to &ut3_user;
130+
grant execute on &&ut3_owner..ut_cursor_details to &ut3_user;

‎source/create_user_synonyms.sql

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -109,3 +109,5 @@ create or replace synonym &ut3_user..dbmspcc_blocks for &&ut3_owner..dbmspcc_blo
109109
create or replace synonym &ut3_user..dbmspcc_runs for &&ut3_owner..dbmspcc_runs;
110110
create or replace synonym &ut3_user..dbmspcc_units for &&ut3_owner..dbmspcc_units;
111111
create or replace synonym &ut3_user..ut_run_info for &&ut3_owner..ut_run_info;
112+
create or replace synonym &ut3_user..ut_cursor_column_tab for &&ut3_owner..ut_cursor_column_tab;
113+
create or replace synonym &ut3_user..ut_cursor_details for &&ut3_owner..ut_cursor_details;

‎test/core/min_grant_user/test_min_grant_user.pkb

Lines changed: 60 additions & 15 deletions
Original file line numberDiff line numberDiff line change
@@ -1,15 +1,60 @@
1-
create or replace package body test_min_grant_user is
2-
3-
procedure test_join_by_cursor is
4-
l_results clob;
5-
begin
6-
execute immediate 'begin ut3$user#.test_cursor_grants.run(); end;';
7-
l_results := core.get_dbms_output_as_clob();
8-
--Assert
9-
ut.expect( l_results ).to_be_like( '%execute join by test [% sec]' ||
10-
'%1 tests, 0 failed, 0 errored, 0 disabled, 0 warning(s)%' );
11-
12-
end;
13-
14-
end;
15-
/
1+
create or replace package body test_min_grant_user is
2+
3+
procedure test_join_by_cursor is
4+
l_results clob;
5+
begin
6+
execute immediate 'begin ut3$user#.test_cursor_grants.run_test_join_by_cursor(); end;';
7+
l_results := core.get_dbms_output_as_clob();
8+
--Assert
9+
ut.expect( l_results ).to_be_like( '%execute join by test [% sec]' ||
10+
'%1 tests, 0 failed, 0 errored, 0 disabled, 0 warning(s)%' );
11+
12+
end;
13+
14+
procedure test_equal_cursor is
15+
l_results clob;
16+
begin
17+
execute immediate 'begin ut3$user#.test_cursor_grants.run_test_equal_cursor(); end;';
18+
l_results := core.get_dbms_output_as_clob();
19+
--Assert
20+
ut.expect( l_results ).to_be_like( '%execute equal test [% sec]' ||
21+
'%1 tests, 0 failed, 0 errored, 0 disabled, 0 warning(s)%' );
22+
23+
end;
24+
25+
procedure test_not_empty_cursor is
26+
l_results clob;
27+
begin
28+
execute immediate 'begin ut3$user#.test_cursor_grants.run_test_not_empty_cursor(); end;';
29+
l_results := core.get_dbms_output_as_clob();
30+
--Assert
31+
ut.expect( l_results ).to_be_like( '%execute not_empty test [% sec]' ||
32+
'%1 tests, 0 failed, 0 errored, 0 disabled, 0 warning(s)%' );
33+
34+
end;
35+
36+
37+
procedure test_have_count_cursor is
38+
l_results clob;
39+
begin
40+
execute immediate 'begin ut3$user#.test_cursor_grants.run_test_have_count_cursor(); end;';
41+
l_results := core.get_dbms_output_as_clob();
42+
--Assert
43+
ut.expect( l_results ).to_be_like( '%execute have_count test [% sec]' ||
44+
'%1 tests, 0 failed, 0 errored, 0 disabled, 0 warning(s)%' );
45+
46+
end;
47+
48+
procedure test_empty_cursor is
49+
l_results clob;
50+
begin
51+
execute immediate 'begin ut3$user#.test_cursor_grants.run_test_empty_cursor(); end;';
52+
l_results := core.get_dbms_output_as_clob();
53+
--Assert
54+
ut.expect( l_results ).to_be_like( '%execute empty test [% sec]' ||
55+
'%1 tests, 0 failed, 0 errored, 0 disabled, 0 warning(s)%' );
56+
57+
end;
58+
59+
end;
60+
/

‎test/core/min_grant_user/test_min_grant_user.pks

Lines changed: 22 additions & 10 deletions
Original file line numberDiff line numberDiff line change
@@ -1,10 +1,22 @@
1-
create or replace package test_min_grant_user is
2-
3-
--%suite(minimum grant user tests)
4-
--%suitepath(utplsql.core)
5-
6-
--%test(execute join by test)
7-
procedure test_join_by_cursor;
8-
9-
end;
10-
/
1+
create or replace package test_min_grant_user is
2+
3+
--%suite(minimum grant user tests)
4+
--%suitepath(utplsql.core)
5+
6+
--%test(execute join by test)
7+
procedure test_join_by_cursor;
8+
9+
--%test(execute equal test)
10+
procedure test_equal_cursor;
11+
12+
--%test(execute not_empty test)
13+
procedure test_not_empty_cursor;
14+
15+
--%test(execute have_count test)
16+
procedure test_have_count_cursor;
17+
18+
--%test(execute empty test)
19+
procedure test_empty_cursor;
20+
21+
end;
22+
/

‎test/helpers/test_dummy_object.tps

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -13,4 +13,7 @@ create or replace type test_dummy_object as object (
1313
"name" varchar2(30),
1414
"Value" varchar2(30)
1515
)
16-
/
16+
/
17+
18+
19+
grant execute on test_dummy_object to ut3$user#;

‎test/helpers/test_dummy_object_list.tps

Lines changed: 2 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -1,2 +1,4 @@
11
create or replace type test_dummy_object_list as table of test_dummy_object
22
/
3+
4+
grant execute on test_dummy_object_list to ut3$user#;

0 commit comments

Comments
 (0)
0