Subversion Repositories DevTools

Rev

Rev 2269 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
2267 kivins 1 
 
2 
alter session set current_schema = TSB;
3 
 
4 
alter table ITERATION_PARAMS disable CONSTRAINT R_ITERATION_PARAMS_36198 ;
5 
truncate table ITERATION_PARAMS;
6 
 
7 
alter table TXNSPEC_VALUES DISABLE ALL TRIGGERS;
8 
alter table TXNSPEC_VALUES disable CONSTRAINT R_TXNSPEC_VALUES_36200 ;
9 
truncate table TXNSPEC_VALUES;
10 
 
11 
alter table TRANSACTION_SPECIFICATION DISABLE ALL TRIGGERS;
12 
alter table TRANSACTION_SPECIFICATION disable CONSTRAINT R_TRANSACTION_SPECIFICAT_24283 ;
13 
truncate table TRANSACTION_SPECIFICATION;
14 
 
15 
alter table TEST_SCENARIOS DISABLE ALL TRIGGERS;
16 
alter table TEST_SCENARIOS disable CONSTRAINT R_TEST_SCENARIOS_36202 ;
17 
truncate table TEST_SCENARIOS;
18 
 
19 
truncate table TESTCASES;
20 
 
21 
--MASS txns
22 
-- card issue
23 
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 1 AND UDSUBTYPE = 3;
24 
-- card fee
25 
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 1 AND UDSUBTYPE = 22;
26 
-- card block
27 
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 1 AND UDSUBTYPE = 6;
28 
-- card unblock
29 
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 1 AND UDSUBTYPE = 7;
30 
-- application create
31 
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 2 AND UDSUBTYPE = 1;
32 
-- purse issue
33 
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 3 AND UDSUBTYPE = 1;
34 
-- pass issue
35 
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 3 AND UDSUBTYPE = 2;
36 
-- pass usage
37 
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 3 AND UDSUBTYPE = 85;
38 
-- shift start,end, trp start,end
39 
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 4 AND UDSUBTYPE in (21,22,23,24);
2269 kivins 40 
-- device events
41 
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 6 AND UDSUBTYPE = 3;
42 
-- entry exit counts
43 
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 7 AND UDSUBTYPE = 22;
2267 kivins 44 
 
2269 kivins 45 
 
2267 kivins 46 
-- testcases
47 
Insert into TSB.TESTCASES
48 
   (USECASE_ID, NAME, TESTCASE_ID, CASE_REPEAT, REPEAT_DELAY, BATCH_SIZE)
49 
 Values
50 
   ('mags', '1000 magnetic validations', 'mags', 10, 1, 99);
51 
Insert into TSB.TESTCASES
52 
   (USECASE_ID, NAME, DESCRIPTION, TESTCASE_ID, CASE_REPEAT, REPEAT_DELAY, BATCH_SIZE)
53 
 Values
2269 kivins 54 
   ('AUshift', 'AU shift with sales', 'Same AU and operator each time', 'AUshift', 1, 5, 99);
2267 kivins 55 
Insert into TSB.TESTCASES
56 
   (USECASE_ID, NAME, DESCRIPTION, TESTCASE_ID, CASE_REPEAT, REPEAT_DELAY, BATCH_SIZE)
57 
 Values
2269 kivins 58 
   ('lotsoftags', 'Mix of smartcard and magnetic validations', 'Small repeat period means continuous generation.
59 
Intended for high volume generation OF validations.  Proportion of smartcard to magentic validations can be varied.
60 
Same Device is used every time. Test case assumes cards and pass have been issued via AUshift test case.', 'lotsoftags', 1, 1, 99);
2267 kivins 61 
Insert into TSB.TESTCASES
62 
   (USECASE_ID, NAME, TESTCASE_ID, CASE_REPEAT, REPEAT_DELAY, BATCH_SIZE)
63 
 Values
64 
   ('busshift', 'bus shift with sales', 'busshift', 1, 1, 99);
2269 kivins 65 
Insert into TSB.TESTCASES
66 
   (USECASE_ID, NAME, DESCRIPTION, TESTCASE_ID, CASE_REPEAT, REPEAT_DELAY, BATCH_SIZE)
67 
 Values
68 
   ('EntryExits', 'Passenger count at gates', 'Once per hour to simulate a real GAK though we don''t enforce the on-the-hour rule that as a real GAK should.', 'EntryExits', 1, 3600, 99);
69 
Insert into TSB.TESTCASES
70 
   (USECASE_ID, NAME, TESTCASE_ID, CASE_REPEAT, REPEAT_DELAY, BATCH_SIZE)
71 
 Values
72 
   ('hcpshift', 'Handheld (Customer Equipment) shift with sales', 'hcpshift', 1, 1, 99);
2267 kivins 73 
 
74 
 
75 
 
76 
-- test scenarios
77 
Insert into TSB.TEST_SCENARIOS
78 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
79 
 Values
2269 kivins 80 
   (1, 'AUshift', 'AUshift', 1, 'SLS', 25, 'start shift', 1, 1000);
2267 kivins 81 
Insert into TSB.TEST_SCENARIOS
82 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
83 
 Values
2269 kivins 84 
   (2, 'AUshift', 'AUshift', 2, 'SLS', 25, 'sell cards', 2, 1000);
2267 kivins 85 
Insert into TSB.TEST_SCENARIOS
86 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
87 
 Values
88 
   (3, 'AUshift', 'AUshift', 3, 'SLS', 25, 'end shift', 1, 1000);
89 
Insert into TSB.TEST_SCENARIOS
2269 kivins 90 
   (TESTSCENARIO_NO, TESTCASE_ID, DESCRIPTION, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
91 
 Values
92 
   (17, 'EntryExits', 'Assumes there are 1000 GAKS in the sequence', 'EntryExits', 2, 'SLS', 25, 'entry exit record for all 1000 GAKS', 1000, 1000);
93 
Insert into TSB.TEST_SCENARIOS
94 
   (TESTSCENARIO_NO, TESTCASE_ID, DESCRIPTION, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
95 
 Values
96 
   (18, 'EntryExits', 'Assumption here is that if the repeat count is 25000 ten we get 50 tags per GAK which matches the PatronIn count for the Entry Exit event.
97 
This means 50,000 txns per hour or 1 miilion over 20 hours.', 'EntryExits', 1, 'SLS', 25, '50 tags per GAK for 1000 GAKS', 1, 1000);
98 
Insert into TSB.TEST_SCENARIOS
2267 kivins 99 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
100 
 Values
2269 kivins 101 
   (6, 'busshift', 'busshift', 1, 'SLS', 25, 'start shift', 1, 1000);
2267 kivins 102 
Insert into TSB.TEST_SCENARIOS
2269 kivins 103 
   (TESTSCENARIO_NO, TESTCASE_ID, DESCRIPTION, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
104 
 Values
105 
   (7, 'busshift', 'This step will sell a pass and the immediately validate that pass.
106 
', 'busshift', 3, 'SLS', 25, 'sell cards', 2, 1000);
107 
Insert into TSB.TEST_SCENARIOS
2267 kivins 108 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
109 
 Values
2269 kivins 110 
   (8, 'busshift', 'busshift', 8, 'SLS', 25, 'end shift', 1, 1000);
111 
Insert into TSB.TEST_SCENARIOS
112 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
113 
 Values
114 
   (12, 'busshift', 'busshift', 2, 'SLS', 25, 'start first trip', 1, 1000);
115 
Insert into TSB.TEST_SCENARIOS
116 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
117 
 Values
118 
   (13, 'busshift', 'busshift', 4, 'SLS', 25, 'end first trip', 1, 1000);
119 
Insert into TSB.TEST_SCENARIOS
120 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
121 
 Values
122 
   (14, 'busshift', 'busshift', 5, 'SLS', 25, 'start second trip', 1, 1000);
123 
Insert into TSB.TEST_SCENARIOS
124 
   (TESTSCENARIO_NO, TESTCASE_ID, DESCRIPTION, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
125 
 Values
126 
   (15, 'busshift', 'validate a card using the same card sequence as bulk validation at the GAK rather than the pass sold on the first trip.
127 
', 'busshift', 6, 'SLS', 25, 'validate passes', 2, 1000);
128 
Insert into TSB.TEST_SCENARIOS
129 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
130 
 Values
131 
   (16, 'busshift', 'busshift', 7, 'SLS', 25, 'end second trip', 1, 1000);
132 
Insert into TSB.TEST_SCENARIOS
133 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
134 
 Values
135 
   (4, 'lotsoftags', 'lotsoftags', 1, 'SLS', 25, 'bulk pass use', 1, 1000);
136 
Insert into TSB.TEST_SCENARIOS
137 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
138 
 Values
139 
   (19, 'lotsoftags', 'lotsoftags', 2, 'SLS', 25, 'bulk magnetic ticket  use', 1, 1000);
140 
Insert into TSB.TEST_SCENARIOS
141 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
142 
 Values
143 
   (20, 'lotsoftags', 'lotsoftags', 3, 'SLS', 25, 'mixed smartcard and magnetic tags', 1, 1000);
144 
Insert into TSB.TEST_SCENARIOS
145 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
146 
 Values
2267 kivins 147 
   (5, 'mags', 'mags', 1, 'SLS', 25, 'magnetic validations', 100, 1000);
2269 kivins 148 
 
2267 kivins 149 
Insert into TSB.TEST_SCENARIOS
150 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
151 
 Values
2269 kivins 152 
   (26, 'hcpshift', 'hcpshift', 1, 'SLS', 25, 'start shift', 1, 1000);
2267 kivins 153 
Insert into TSB.TEST_SCENARIOS
2269 kivins 154 
   (TESTSCENARIO_NO, TESTCASE_ID, DESCRIPTION, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
155 
 Values
156 
   (27, 'hcpshift', 'This step will sell a pass and the immediately validate that pass.
157 
', 'hcpshift', 3, 'SLS', 25, 'sell cards', 2, 1000);
158 
Insert into TSB.TEST_SCENARIOS
2267 kivins 159 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
160 
 Values
2269 kivins 161 
   (28, 'hcpshift', 'hcpshift', 8, 'SLS', 25, 'end shift', 1, 1000);
2267 kivins 162 
Insert into TSB.TEST_SCENARIOS
163 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
164 
 Values
2269 kivins 165 
   (32, 'hcpshift', 'hcpshift', 2, 'SLS', 25, 'start first trip', 1, 1000);
166 
Insert into TSB.TEST_SCENARIOS
167 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
168 
 Values
169 
   (33, 'hcpshift', 'hcpshift', 4, 'SLS', 25, 'end first trip', 1, 1000);
170 
Insert into TSB.TEST_SCENARIOS
171 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
172 
 Values
173 
   (34, 'hcpshift', 'hcpshift', 5, 'SLS', 25, 'start second trip', 1, 1000);
174 
Insert into TSB.TEST_SCENARIOS
175 
   (TESTSCENARIO_NO, TESTCASE_ID, DESCRIPTION, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
176 
 Values
177 
   (35, 'hcpshift', 'validate a card using the same card sequence as bulk validation at the GAK rather than the pass sold on the first trip.
178 
', 'hcpshift', 6, 'SLS', 25, 'validate passes', 2, 1000);
179 
Insert into TSB.TEST_SCENARIOS
180 
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
181 
 Values
182 
   (36, 'hcpshift', 'hcpshift', 7, 'SLS', 25, 'end second trip', 1, 1000);
183 
 
2267 kivins 184 
 
185 
--transaction specification
186 
Insert into TSB.TRANSACTION_SPECIFICATION
187 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
188 
 Values
2269 kivins 189 
   (116, 1, 4, 21, 'SLS', 25, 1);
190 
Insert into TSB.TRANSACTION_SPECIFICATION
191 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
192 
 Values
2267 kivins 193 
   (112, 2, 1, 3, 'SLS', 25, 1);
194 
Insert into TSB.TRANSACTION_SPECIFICATION
195 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
196 
 Values
197 
   (111, 2, 2, 1, 'SLS', 25, 2);
198 
Insert into TSB.TRANSACTION_SPECIFICATION
199 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
200 
 Values
201 
   (113, 2, 3, 1, 'SLS', 25, 3);
202 
Insert into TSB.TRANSACTION_SPECIFICATION
203 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
204 
 Values
2269 kivins 205 
   (110, 2, 1, 22, 'SLS', 25, 4);
2267 kivins 206 
Insert into TSB.TRANSACTION_SPECIFICATION
207 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
208 
 Values
209 
   (114, 2, 3, 2, 'SLS', 25, 5);
210 
Insert into TSB.TRANSACTION_SPECIFICATION
211 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
212 
 Values
2269 kivins 213 
   (117, 3, 4, 22, 'SLS', 25, 1);
2267 kivins 214 
Insert into TSB.TRANSACTION_SPECIFICATION
215 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
216 
 Values
2269 kivins 217 
   (102, 4, 3, 85, 'SLS', 25, 1);
2267 kivins 218 
Insert into TSB.TRANSACTION_SPECIFICATION
219 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
220 
 Values
2269 kivins 221 
   (115, 5, 3, 85, 'SLS', 25, 1);
2267 kivins 222 
Insert into TSB.TRANSACTION_SPECIFICATION
223 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
224 
 Values
2269 kivins 225 
   (126, 6, 4, 21, 'SLS', 25, 1);
2267 kivins 226 
Insert into TSB.TRANSACTION_SPECIFICATION
227 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
228 
 Values
2269 kivins 229 
   (124, 7, 3, 2, 'SLS', 25, 2);
2267 kivins 230 
Insert into TSB.TRANSACTION_SPECIFICATION
231 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
232 
 Values
2269 kivins 233 
   (125, 7, 3, 85, 'SLS', 25, 3);
2267 kivins 234 
Insert into TSB.TRANSACTION_SPECIFICATION
235 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
236 
 Values
2269 kivins 237 
   (131, 8, 4, 22, 'SLS', 25, 1);
2267 kivins 238 
Insert into TSB.TRANSACTION_SPECIFICATION
239 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
240 
 Values
2269 kivins 241 
   (127, 12, 4, 23, 'SLS', 25, 1);
2267 kivins 242 
Insert into TSB.TRANSACTION_SPECIFICATION
243 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
244 
 Values
2269 kivins 245 
   (129, 13, 4, 24, 'SLS', 25, 1);
2267 kivins 246 
Insert into TSB.TRANSACTION_SPECIFICATION
247 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
248 
 Values
2269 kivins 249 
   (132, 14, 4, 23, 'SLS', 25, 1);
2267 kivins 250 
Insert into TSB.TRANSACTION_SPECIFICATION
251 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
252 
 Values
2269 kivins 253 
   (134, 15, 3, 85, 'SLS', 25, 2);
2267 kivins 254 
Insert into TSB.TRANSACTION_SPECIFICATION
255 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
256 
 Values
2269 kivins 257 
   (133, 16, 4, 24, 'SLS', 25, 1);
2267 kivins 258 
Insert into TSB.TRANSACTION_SPECIFICATION
259 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
260 
 Values
2269 kivins 261 
   (140, 17, 7, 22, 'SLS', 25, 1);
2267 kivins 262 
Insert into TSB.TRANSACTION_SPECIFICATION
263 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
264 
 Values
2269 kivins 265 
   (141, 18, 3, 85, 'SLS', 25, 1);
266 
Insert into TSB.TRANSACTION_SPECIFICATION
267 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
2267 kivins 268 
 Values
2269 kivins 269 
   (142, 18, 3, 85, 'SLS', 25, 2);
270 
Insert into TSB.TRANSACTION_SPECIFICATION
271 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
2267 kivins 272 
 Values
2269 kivins 273 
   (103, 19, 3, 85, 'SLS', 25, 1);
274 
Insert into TSB.TRANSACTION_SPECIFICATION
275 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
2267 kivins 276 
 Values
2269 kivins 277 
   (104, 20, 3, 85, 'SLS', 25, 1);
278 
Insert into TSB.TRANSACTION_SPECIFICATION
279 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
2267 kivins 280 
 Values
2269 kivins 281 
   (101, 20, 3, 85, 'SLS', 25, 2);
2267 kivins 282 
 
2269 kivins 283 
Insert into TSB.TRANSACTION_SPECIFICATION
284 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
2267 kivins 285 
 Values
2269 kivins 286 
   (146, 26, 4, 21, 'SLS', 25, 1);
287 
Insert into TSB.TRANSACTION_SPECIFICATION
288 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
2267 kivins 289 
 Values
2269 kivins 290 
   (144, 27, 3, 2, 'SLS', 25, 2);
291 
Insert into TSB.TRANSACTION_SPECIFICATION
292 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
2267 kivins 293 
 Values
2269 kivins 294 
   (145, 27, 3, 85, 'SLS', 25, 3);
295 
Insert into TSB.TRANSACTION_SPECIFICATION
296 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
2267 kivins 297 
 Values
2269 kivins 298 
   (151, 28, 4, 22, 'SLS', 25, 1);
299 
Insert into TSB.TRANSACTION_SPECIFICATION
300 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
2267 kivins 301 
 Values
2269 kivins 302 
   (147, 32, 4, 23, 'SLS', 25, 1);
303 
Insert into TSB.TRANSACTION_SPECIFICATION
304 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
2267 kivins 305 
 Values
2269 kivins 306 
   (149, 33, 4, 24, 'SLS', 25, 1);
307 
Insert into TSB.TRANSACTION_SPECIFICATION
308 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
2267 kivins 309 
 Values
2269 kivins 310 
   (152, 34, 4, 23, 'SLS', 25, 1);
311 
Insert into TSB.TRANSACTION_SPECIFICATION
312 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
2267 kivins 313 
 Values
2269 kivins 314 
   (154, 35, 3, 85, 'SLS', 25, 2);
315 
Insert into TSB.TRANSACTION_SPECIFICATION
316 
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
2267 kivins 317 
 Values
2269 kivins 318 
   (153, 36, 4, 24, 'SLS', 25, 1);
2267 kivins 319 
 
320 
 
2269 kivins 321 
 
322 
 
323 
-- txnspec_values
2273 kivins 324 
@@txnvalues.sql
2269 kivins 325 
 
2267 kivins 326 
 
327 
--iteration parameters
328 
 
2273 kivins 329 
@@iterationparams.sql
2267 kivins 330 
 
2269 kivins 331 
 
332 
 
2267 kivins 333 
COMMIT;
334 
 
335 
alter table ITERATION_PARAMS enable CONSTRAINT R_ITERATION_PARAMS_36198 ;
336 
 
337 
alter table TXNSPEC_VALUES ENABLE ALL TRIGGERS;
338 
alter table TXNSPEC_VALUES enable CONSTRAINT R_TXNSPEC_VALUES_36200 ;
339 
 
340 
alter table TRANSACTION_SPECIFICATION ENABLE ALL TRIGGERS;
341 
alter table TRANSACTION_SPECIFICATION enable CONSTRAINT R_TRANSACTION_SPECIFICAT_24283 ;
342 
 
343 
alter table TEST_SCENARIOS ENABLE ALL TRIGGERS;
344 
alter table TEST_SCENARIOS enable CONSTRAINT R_TEST_SCENARIOS_36202 ;
345 
 
346 
alter table TESTCASES ENABLE ALL TRIGGERS;
347 
 
348 
 
349 
CREATE OR REPLACE TRIGGER TSB.NOTFORDISPLAY
350 
AFTER UPDATE
351 
OF FIELDVALUE
352 
ON TSB.TXNSPEC_VALUES
353 
REFERENCING NEW AS NEW OLD AS OLD
354 
DECLARE
355 
tmpVar NUMBER;
356 
 
357 
BEGIN
358 
 
359 
   update txnspec_values
360 
   set displayable = 'N'
361 
   where fieldname in ('formatVersion','txnMac', 'keyVersion', 'applicationProviderId', 'applicationSerialNumber', 'udType', 'udSubtype',
362 
   'currencyIndicatorFinDetails','processedDate','cardIssuerId','productIssuerId','routeLineId','numberOfPassengers',
2269 kivins 363 
   'applicationPassengerType','applicationPersonaliseCat','passEndDateTime', 'staffId', 'operatorShiftNumber','shiftStartTime',
364 
   'udsn', 'txnDateTime')
2267 kivins 365 
   and  displayable = 'Y';
366 
 
367 
END NOTFORDISPLAY;
368 
/