Skip to content

Commit f06bd0a

Browse files
jgebaljgebal
committed
Split uninstall script into smaller, independent pieces.
Added `uninstall_all` to remove all objects created by install. Added calls to `uninstall_all` into deployment to validate the uninstall process completeness.
1 parent 1373583 commit f06bd0a

6 files changed

Lines changed: 474 additions & 357 deletions

File tree

‎.travis/install.sh‎

Lines changed: 31 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -11,6 +11,37 @@ alter session set plsql_warnings = 'ENABLE:ALL', 'DISABLE:(5004,5018,6000,6001,6
1111
@install_headless.sql $UT3_OWNER $UT3_OWNER_PASSWORD
1212
SQL
1313

14+
#uninstall core of utplsql
15+
"$SQLCLI" sys/$ORACLE_PWD@//$CONNECTION_STR AS SYSDBA <<-SQL
16+
set feedback off
17+
set verify off
18+
19+
@uninstall_all.sql $UT3_OWNER
20+
declare
21+
v_leftover_objects_count integer;
22+
begin
23+
select sum(cnt)
24+
into v_leftover_objects_count
25+
from (select count(1) cnt from dba_objects where owner = '$UT3_OWNER'
26+
union all
27+
select count(1) cnt from dba_synonyms where table_owner = '$UT3_OWNER'
28+
);
29+
if v_leftover_objects_count > 0 then
30+
raise_application_error(-20000, 'Not all objects were successfully uninstalled - leftover objects count='||v_leftover_objects_count);
31+
end if;
32+
end;
33+
/
34+
SQL
35+
36+
#reinstall core of utplsql
37+
"$SQLCLI" sys/$ORACLE_PWD@//$CONNECTION_STR AS SYSDBA <<-SQL
38+
set feedback off
39+
set verify off
40+
41+
alter session set plsql_warnings = 'ENABLE:ALL', 'DISABLE:(5004,5018,6000,6001,6003,6009,6010,7206)';
42+
@install.sql $UT3_OWNER
43+
SQL
44+
1445
#additional privileges to run scripted tests
1546
"$SQLCLI" sys/$ORACLE_PWD@//$CONNECTION_STR AS SYSDBA <<-SQL
1647
set feedback on

0 commit comments

Comments
 (0)