-
Notifications
You must be signed in to change notification settings - Fork 187
Expand file tree
/
Copy pathut_assertion.tab
More file actions
147 lines (124 loc) · 4.14 KB
/
ut_assertion.tab
File metadata and controls
147 lines (124 loc) · 4.14 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
-- Modification History:
-- studious:01/20/2002:Assertion for object existance
CREATE TABLE ut_assertion (
id INTEGER ,
NAME VARCHAR2(100), -- MUST corresponds to utAssert2 program name
description VARCHAR2(1000),
/* Rest of columns, V1 compatibility; too generic to be useful. */
use_msg CHAR(1) DEFAULT 'Y',
use_null_ok CHAR(1) DEFAULT 'Y',
use_raise_exc CHAR(1) DEFAULT 'Y',
use_check_this CHAR(1) DEFAULT 'Y',
check_this_label VARCHAR2(100)
DEFAULT 'Check this',
use_check_this_where CHAR(1) DEFAULT 'N',
check_this_where_label VARCHAR2(100)
DEFAULT 'Check this WHERE clause',
use_against_this CHAR(1) DEFAULT 'Y',
against_this_label VARCHAR2(100)
DEFAULT 'Against this',
use_against_this_where CHAR(1) DEFAULT 'N',
against_this_where_label VARCHAR2(100)
DEFAULT 'Against this WHERE clause',
use_check_this_dir CHAR(1) DEFAULT 'N',
check_this_dir_label VARCHAR2(100)
DEFAULT 'Location of "check this" file',
use_against_this_dir CHAR(1) DEFAULT 'N',
against_this_dir_label VARCHAR2(100)
DEFAULT 'Location of "against this" file',
CONSTRAINT ut_assertion_pk PRIMARY KEY (id)
);
CREATE UNIQUE INDEX ut_assertion_idx1 ON
ut_assertion (NAME);
BEGIN
INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (1, 'THIS',
'General Boolean expression evaluation');
INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (2, 'EQ',
'Scalar equality');
INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (3, 'EQTABLE',
'Database table/view equality');
INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (4, 'EQTABCOUNT',
'Database table/view row count comparison');
INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (5, 'EQQUERY',
'Query result set equality');
INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (6, 'EQQUERYVALUE',
'Query return value comparison');
INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (7, 'EQFILE',
'Operating system file equality');
INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (8, 'EQPIPE',
'Database pipe equality');
INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (9, 'EQCOLL',
'Collection equality - direct access');
INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (10, 'EQCOLLAPI',
'Collection equality - API access');
INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (11, 'ISNOTNULL',
'NOTNULL validation');
INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (12, 'ISNULL',
'NULL validation');
INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (13, 'RAISES',
'Raised exception validation');
INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (14, 'FILEEXISTS',
'Confirm that specified file exists');
INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (15, 'EVALUATE',
'General evaluation of specified expression');
-- START username:STUDIOUS Date:01/11/2002 Task_id:42690
-- Description: Checking whether object exists
INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (16, 'OBJEXISTS',
'Confirm that specified Object exists');
INSERT INTO ut_assertion
(id, NAME,
description)
VALUES (17, 'OBJNOTEXISTS',
'Confirm that specified Object does not exist');
-- END username:STUDIOUS Task_id:42690
COMMIT;
END;
/