Skip to content

Commit d71a2fd

Browse files
DDieterichDDieterich
committed
Major Updates after Testing
1 parent 17ad7df commit d71a2fd

172 files changed

Lines changed: 1104 additions & 3964 deletions

File tree

Some content is hidden

Large Commits have some content hidden by default. Use the searchbox below for content that may be hidden.

‎builds/OnPrem_EE213/build.sh‎

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -64,8 +64,7 @@ build_type_build 'wtpsav' "${PDB_SYSTEM}"
6464
build_type_build 'wtptst' "${PDB_SYSTEM}"
6565
# Test Application
6666
clear_log_files 'unit_testing'
67-
run_script 'unit_testing' 'setup_for_test.sql' "${PDB_WTP}"
68-
exit
67+
run_script 'unit_testing' 'setup_for_test.sql' "${PDB_SYSTEM}"
6968
#run_script 'unit_testing' 'setup_db_links' "${PDB_WTP}" # Unit Testing Expects NO DB Links
7069
run_script 'unit_testing' 'run_core_test.sql' "${PDB_WTP}"
7170
run_script 'unit_testing' 'run_junit_test.sql' "${PDB_WTP}"

‎wtpgrb/ODBCAPTURE/BUILD_CONF.cldr‎

Lines changed: 69 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,69 @@
1+
2+
--
3+
-- Comprehensive Data Loader script for ODBCAPTURE.BUILD_CONF data
4+
--
5+
-- Command Line Parameters:
6+
-- 1 - SYSTEM/password@TNSALIAS
7+
-- i.e. pass the username and password for the SYSTEM user
8+
-- and the TNSALIAS for the connection to the database.
9+
-- The Data Load installation requires this connection information.
10+
--
11+
12+
prompt
13+
prompt Disable Triggers and Foreign Keys
14+
declare
15+
procedure run_sql (in_sql in varchar2) is begin
16+
dbms_output.put_line(in_sql || ';');
17+
execute immediate in_sql;
18+
exception when others then
19+
dbms_output.put_line('-- ' || SQLERRM || CHR(10));
20+
end run_sql;
21+
begin
22+
for buff in (select owner, trigger_name
23+
from dba_triggers
24+
where table_owner = 'ODBCAPTURE'
25+
and table_name = 'BUILD_CONF'
26+
order by owner, trigger_name)
27+
loop
28+
run_sql('alter trigger "' || buff.owner || '"' ||
29+
'."' || buff.trigger_name || '" DISABLE');
30+
end loop;
31+
for buff in (select constraint_name
32+
from dba_constraints
33+
where constraint_type = 'R'
34+
and owner = 'ODBCAPTURE'
35+
and table_name = 'BUILD_CONF'
36+
order by constraint_name)
37+
loop
38+
run_sql('alter table "ODBCAPTURE"."BUILD_CONF"' ||
39+
' DISABLE constraint "' || buff.constraint_name || '"');
40+
end loop;
41+
for buff in (select owner, index_name
42+
from dba_indexes
43+
where index_type = 'DOMAIN'
44+
and table_owner = 'ODBCAPTURE'
45+
and table_name = 'BUILD_CONF'
46+
order by owner, index_name)
47+
loop
48+
run_sql('alter index "' || buff.owner || '"."' || buff.index_name || '"' ||
49+
' DISABLE');
50+
end loop;
51+
end;
52+
/
53+
54+
-- Additional file extensions
55+
-- .bad - Bad Records
56+
-- .dsc - Discard Records
57+
-- .log - Log File
58+
59+
prompt
60+
prompt sqlldr_control=ODBCAPTURE/BUILD_CONF.ctl
61+
host sqlldr '&1.' control=ODBCAPTURE/BUILD_CONF.ctl data=ODBCAPTURE/BUILD_CONF.csv log=ODBCAPTURE/BUILD_CONF.log silent=HEADER,FEEDBACK
62+
63+
begin
64+
if '&_RC.' != '0' then
65+
raise_application_error(-20000, 'Control file "ODBCAPTURE/BUILD_CONF.ctl" returned error: &_RC.');
66+
end if;
67+
end;
68+
/
69+

‎wtpgrb/ODBCAPTURE/BUILD_CONF.csv‎

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,6 @@
1+
"BUILD_SEQ","BUILD_TYPE","NOTES"
2+
10,"wtpsrc","wtPLSQL Unit Testing Source Code (Core)"
3+
20,"wtpsav","wtPLSQL Persisted Test Results"
4+
30,"wtptst","wtPLSQL Internal Unit Testing"
5+
42,"grbsrc","ODBCapture Source Code Script Generation"
6+
44,"wtpgrb","ODBCapture Data for wtPLSQL"

‎wtpgrb/ODBCAPTURE/BUILD_CONF.ctl‎

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,10 @@
1+
OPTIONS (SKIP=1)
2+
LOAD DATA
3+
INTO TABLE "ODBCAPTURE"."BUILD_CONF"
4+
APPEND
5+
FIELDS CSV WITH EMBEDDED
6+
TRAILING NULLCOLS
7+
(BUILD_SEQ FLOAT EXTERNAL
8+
,BUILD_TYPE CHAR(10)
9+
,NOTES CHAR(1024)
10+
)

‎wtpgrb/ODBCAPTURE/BUILD_PATH.cldr‎

Lines changed: 69 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,69 @@
1+
2+
--
3+
-- Comprehensive Data Loader script for ODBCAPTURE.BUILD_PATH data
4+
--
5+
-- Command Line Parameters:
6+
-- 1 - SYSTEM/password@TNSALIAS
7+
-- i.e. pass the username and password for the SYSTEM user
8+
-- and the TNSALIAS for the connection to the database.
9+
-- The Data Load installation requires this connection information.
10+
--
11+
12+
prompt
13+
prompt Disable Triggers and Foreign Keys
14+
declare
15+
procedure run_sql (in_sql in varchar2) is begin
16+
dbms_output.put_line(in_sql || ';');
17+
execute immediate in_sql;
18+
exception when others then
19+
dbms_output.put_line('-- ' || SQLERRM || CHR(10));
20+
end run_sql;
21+
begin
22+
for buff in (select owner, trigger_name
23+
from dba_triggers
24+
where table_owner = 'ODBCAPTURE'
25+
and table_name = 'BUILD_PATH'
26+
order by owner, trigger_name)
27+
loop
28+
run_sql('alter trigger "' || buff.owner || '"' ||
29+
'."' || buff.trigger_name || '" DISABLE');
30+
end loop;
31+
for buff in (select constraint_name
32+
from dba_constraints
33+
where constraint_type = 'R'
34+
and owner = 'ODBCAPTURE'
35+
and table_name = 'BUILD_PATH'
36+
order by constraint_name)
37+
loop
38+
run_sql('alter table "ODBCAPTURE"."BUILD_PATH"' ||
39+
' DISABLE constraint "' || buff.constraint_name || '"');
40+
end loop;
41+
for buff in (select owner, index_name
42+
from dba_indexes
43+
where index_type = 'DOMAIN'
44+
and table_owner = 'ODBCAPTURE'
45+
and table_name = 'BUILD_PATH'
46+
order by owner, index_name)
47+
loop
48+
run_sql('alter index "' || buff.owner || '"."' || buff.index_name || '"' ||
49+
' DISABLE');
50+
end loop;
51+
end;
52+
/
53+
54+
-- Additional file extensions
55+
-- .bad - Bad Records
56+
-- .dsc - Discard Records
57+
-- .log - Log File
58+
59+
prompt
60+
prompt sqlldr_control=ODBCAPTURE/BUILD_PATH.ctl
61+
host sqlldr '&1.' control=ODBCAPTURE/BUILD_PATH.ctl data=ODBCAPTURE/BUILD_PATH.csv log=ODBCAPTURE/BUILD_PATH.log silent=HEADER,FEEDBACK
62+
63+
begin
64+
if '&_RC.' != '0' then
65+
raise_application_error(-20000, 'Control file "ODBCAPTURE/BUILD_PATH.ctl" returned error: &_RC.');
66+
end if;
67+
end;
68+
/
69+

‎wtpgrb/ODBCAPTURE/BUILD_PATH.csv‎

Lines changed: 6 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,6 @@
1+
"PARENT_BUILD_SEQ","BUILD_SEQ"
2+
-95,10
3+
10,20
4+
20,30
5+
30,42
6+
42,44

‎wtpgrb/ODBCAPTURE/BUILD_PATH.ctl‎

Lines changed: 9 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,9 @@
1+
OPTIONS (SKIP=1)
2+
LOAD DATA
3+
INTO TABLE "ODBCAPTURE"."BUILD_PATH"
4+
APPEND
5+
FIELDS CSV WITH EMBEDDED
6+
TRAILING NULLCOLS
7+
(PARENT_BUILD_SEQ FLOAT EXTERNAL
8+
,BUILD_SEQ FLOAT EXTERNAL
9+
)

wtpgrb/ODBCAPTURE/DLOAD_CONF.cdl renamed to wtpgrb/ODBCAPTURE/DLOAD_CONF.cldr

Lines changed: 13 additions & 3 deletions
Original file line numberDiff line numberDiff line change
@@ -1,6 +1,6 @@
11

22
--
3-
-- Consolidated Data Load script for ODBCAPTURE.DLOAD_CONF data
3+
-- Comprehensive Data Loader script for ODBCAPTURE.DLOAD_CONF data
44
--
55
-- Command Line Parameters:
66
-- 1 - SYSTEM/password@TNSALIAS
@@ -33,15 +33,25 @@ begin
3333
where constraint_type = 'R'
3434
and owner = 'ODBCAPTURE'
3535
and table_name = 'DLOAD_CONF'
36-
order by owner, constraint_name)
36+
order by constraint_name)
3737
loop
3838
run_sql('alter table "ODBCAPTURE"."DLOAD_CONF"' ||
3939
' DISABLE constraint "' || buff.constraint_name || '"');
4040
end loop;
41+
for buff in (select owner, index_name
42+
from dba_indexes
43+
where index_type = 'DOMAIN'
44+
and table_owner = 'ODBCAPTURE'
45+
and table_name = 'DLOAD_CONF'
46+
order by owner, index_name)
47+
loop
48+
run_sql('alter index "' || buff.owner || '"."' || buff.index_name || '"' ||
49+
' DISABLE');
50+
end loop;
4151
end;
4252
/
4353

44-
-- NOTE: Additional file extensions for SQL*Loader include
54+
-- Additional file extensions
4555
-- .bad - Bad Records
4656
-- .dsc - Discard Records
4757
-- .log - Log File

‎wtpgrb/ODBCAPTURE/DLOAD_CONF.csv‎

Lines changed: 10 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -1,8 +1,10 @@
1-
"USERNAME","TABLE_NAME","INSTALL_TYPE","BEFORE_SELECT_SQL","WHERE_CLAUSE","ORDER_BY_COLUMNS","AFTER_ORDER_BY_SQL","NOTES"
2-
"ODBCAPTURE","DLOAD_CONF","wtpgrb",,"install_type in ('wtpsrc','wtptst','wtpgrb','wtpsav')","USERNAME, TABLE_NAME, INSTALL_TYPE",,
3-
"ODBCAPTURE","OBJECT_CONF","wtpgrb",,"install_type in ('wtpsrc','wtptst','wtpgrb','wtpsav')","USERNAME, INSTALL_OTYPE, INSTALL_TYPE",,
4-
"ODBCAPTURE","ROLE_CONF","wtpgrb",,"install_type in ('wtpsrc','wtptst','wtpgrb','wtpsav')","ROLENAME, INSTALL_TYPE",,
5-
"ODBCAPTURE","SCHEMA_CONF","wtpgrb",,"install_type in ('wtpsrc','wtptst','wtpgrb','wtpsav')","USERNAME",,
6-
"ODBCAPTURE","TYPE_CONF","wtpgrb",,"install_type in ('wtpsrc','wtptst','wtpgrb','wtpsav')","INSTALL_TYPE",,
7-
"WTP","HOOKS","wtpsrc",,,"HOOK_NAME, SEQ",,
8-
"WTP","WT_SELF_TEST","wtptst",,,"ID",,
1+
"USERNAME","TABLE_NAME","BUILD_TYPE","ORDER_BY_COLUMNS","LOADING_METHOD","BEFORE_SELECT_SQL","COLUMNS_REMOVED","WHERE_CLAUSE","AFTER_ORDER_BY_SQL","NOTES"
2+
"ODBCAPTURE","BUILD_CONF","wtpgrb","BUILD_SEQ",,,,"build_type not in ('sys','pub')",,
3+
"ODBCAPTURE","BUILD_PATH","wtpgrb","PARENT_BUILD_SEQ, BUILD_SEQ",,,,"build_seq in (select build_seq from build_conf where build_type not in ('sys','pub'))",,
4+
"ODBCAPTURE","DLOAD_CONF","wtpgrb","USERNAME, TABLE_NAME, BUILD_TYPE",,,,,,
5+
"ODBCAPTURE","OBJECT_CONF","wtpgrb","USERNAME, ELEMENT_NAME, BUILD_TYPE",,,,,,
6+
"ODBCAPTURE","ROLE_CONF","wtpgrb","ROLENAME, BUILD_TYPE",,,,"build_type not in ('sys','pub')",,
7+
"ODBCAPTURE","SCHEMA_CONF","wtpgrb","USERNAME",,,,"build_type not in ('sys','pub')",,
8+
"ODBCAPTURE","TSPACE_CONF","wtpgrb","USERNAME, TSPACE_NAME",,,,,,
9+
"WTP","HOOKS","wtpsrc","HOOK_NAME, SEQ",,,,,,
10+
"WTP","WT_SELF_TEST","wtptst","ID",,,,,,

‎wtpgrb/ODBCAPTURE/DLOAD_CONF.ctl‎

Lines changed: 7 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -1,14 +1,17 @@
11
OPTIONS (SKIP=1)
22
LOAD DATA
3-
APPEND INTO TABLE "ODBCAPTURE"."DLOAD_CONF"
3+
INTO TABLE "ODBCAPTURE"."DLOAD_CONF"
4+
APPEND
45
FIELDS CSV WITH EMBEDDED
56
TRAILING NULLCOLS
67
(USERNAME CHAR(128)
78
,TABLE_NAME CHAR(128)
8-
,INSTALL_TYPE CHAR(10)
9+
,BUILD_TYPE CHAR(10)
10+
,ORDER_BY_COLUMNS CHAR(4000)
11+
,LOADING_METHOD CHAR(50)
912
,BEFORE_SELECT_SQL CHAR(4000)
13+
,COLUMNS_REMOVED CHAR(4000)
1014
,WHERE_CLAUSE CHAR(4000)
11-
,ORDER_BY_COLUMNS CHAR(4000)
1215
,AFTER_ORDER_BY_SQL CHAR(4000)
13-
,NOTES CHAR(1024)
16+
,NOTES CHAR(4000)
1417
)

0 commit comments

Comments
 (0)