WebSVN – DevTools – /TxnTestManager/branches/Stockholm/schema/importscenarios.sql


alter session set current_schema = TSB;

alter table ITERATION_PARAMS disable CONSTRAINT R_ITERATION_PARAMS_36198 ;
truncate table ITERATION_PARAMS;

alter table TXNSPEC_VALUES DISABLE ALL TRIGGERS;
alter table TXNSPEC_VALUES disable CONSTRAINT R_TXNSPEC_VALUES_36200 ;
truncate table TXNSPEC_VALUES;

alter table TRANSACTION_SPECIFICATION DISABLE ALL TRIGGERS;
alter table TRANSACTION_SPECIFICATION disable CONSTRAINT R_TRANSACTION_SPECIFICAT_24283 ;
truncate table TRANSACTION_SPECIFICATION;

alter table TEST_SCENARIOS DISABLE ALL TRIGGERS;
alter table TEST_SCENARIOS disable CONSTRAINT R_TEST_SCENARIOS_36202 ;
truncate table TEST_SCENARIOS;

truncate table TESTCASES;

--MASS txns
-- card issue
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 1 AND UDSUBTYPE = 3;
-- card fee
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 1 AND UDSUBTYPE = 22;
-- card block
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 1 AND UDSUBTYPE = 6;
-- card unblock
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 1 AND UDSUBTYPE = 7;
-- application create
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 2 AND UDSUBTYPE = 1;
-- purse issue
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 3 AND UDSUBTYPE = 1;
-- pass issue
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 3 AND UDSUBTYPE = 2;
-- pass usage
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 3 AND UDSUBTYPE = 85;
-- shift start,end, trp start,end
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 4 AND UDSUBTYPE in (21,22,23,24);
-- device events
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 6 AND UDSUBTYPE = 3;
-- entry exit counts
UPDATE TSB.MASS_TXNS SET ENABLED = 'Y' WHERE UDTYPE = 7 AND UDSUBTYPE = 22;


-- testcases
Insert into TSB.TESTCASES
   (USECASE_ID, NAME, TESTCASE_ID, CASE_REPEAT, REPEAT_DELAY, BATCH_SIZE)
 Values
   ('mags', '1000 magnetic validations', 'mags', 10, 1, 99);
Insert into TSB.TESTCASES
   (USECASE_ID, NAME, DESCRIPTION, TESTCASE_ID, CASE_REPEAT, REPEAT_DELAY, BATCH_SIZE)
 Values
   ('AUshift', 'AU shift with sales', 'Same AU and operator each time', 'AUshift', 1, 5, 99);
Insert into TSB.TESTCASES
   (USECASE_ID, NAME, DESCRIPTION, TESTCASE_ID, CASE_REPEAT, REPEAT_DELAY, BATCH_SIZE)
 Values
   ('lotsoftags', 'Mix of smartcard and magnetic validations', 'Small repeat period means continuous generation.
Intended for high volume generation OF validations.  Proportion of smartcard to magentic validations can be varied.
Same Device is used every time. Test case assumes cards and pass have been issued via AUshift test case.', 'lotsoftags', 1, 1, 99);
Insert into TSB.TESTCASES
   (USECASE_ID, NAME, TESTCASE_ID, CASE_REPEAT, REPEAT_DELAY, BATCH_SIZE)
 Values
   ('busshift', 'bus shift with sales', 'busshift', 1, 1, 99);
Insert into TSB.TESTCASES
   (USECASE_ID, NAME, DESCRIPTION, TESTCASE_ID, CASE_REPEAT, REPEAT_DELAY, BATCH_SIZE)
 Values
   ('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);
Insert into TSB.TESTCASES
   (USECASE_ID, NAME, TESTCASE_ID, CASE_REPEAT, REPEAT_DELAY, BATCH_SIZE)
 Values
   ('hcpshift', 'Handheld (Customer Equipment) shift with sales', 'hcpshift', 1, 1, 99);



-- test scenarios
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (1, 'AUshift', 'AUshift', 1, 'SLS', 25, 'start shift', 1, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (2, 'AUshift', 'AUshift', 2, 'SLS', 25, 'sell cards', 2, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (3, 'AUshift', 'AUshift', 3, 'SLS', 25, 'end shift', 1, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, DESCRIPTION, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (17, 'EntryExits', 'Assumes there are 1000 GAKS in the sequence', 'EntryExits', 2, 'SLS', 25, 'entry exit record for all 1000 GAKS', 1000, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, DESCRIPTION, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (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.
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);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (6, 'busshift', 'busshift', 1, 'SLS', 25, 'start shift', 1, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, DESCRIPTION, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (7, 'busshift', 'This step will sell a pass and the immediately validate that pass.
', 'busshift', 3, 'SLS', 25, 'sell cards', 2, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (8, 'busshift', 'busshift', 8, 'SLS', 25, 'end shift', 1, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (12, 'busshift', 'busshift', 2, 'SLS', 25, 'start first trip', 1, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (13, 'busshift', 'busshift', 4, 'SLS', 25, 'end first trip', 1, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (14, 'busshift', 'busshift', 5, 'SLS', 25, 'start second trip', 1, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, DESCRIPTION, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (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.
', 'busshift', 6, 'SLS', 25, 'validate passes', 2, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (16, 'busshift', 'busshift', 7, 'SLS', 25, 'end second trip', 1, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (4, 'lotsoftags', 'lotsoftags', 1, 'SLS', 25, 'bulk pass use', 1, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (19, 'lotsoftags', 'lotsoftags', 2, 'SLS', 25, 'bulk magnetic ticket  use', 1, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (20, 'lotsoftags', 'lotsoftags', 3, 'SLS', 25, 'mixed smartcard and magnetic tags', 1, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (5, 'mags', 'mags', 1, 'SLS', 25, 'magnetic validations', 100, 1000);

Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (26, 'hcpshift', 'hcpshift', 1, 'SLS', 25, 'start shift', 1, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, DESCRIPTION, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (27, 'hcpshift', 'This step will sell a pass and the immediately validate that pass.
', 'hcpshift', 3, 'SLS', 25, 'sell cards', 2, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (28, 'hcpshift', 'hcpshift', 8, 'SLS', 25, 'end shift', 1, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (32, 'hcpshift', 'hcpshift', 2, 'SLS', 25, 'start first trip', 1, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (33, 'hcpshift', 'hcpshift', 4, 'SLS', 25, 'end first trip', 1, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (34, 'hcpshift', 'hcpshift', 5, 'SLS', 25, 'start second trip', 1, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, DESCRIPTION, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (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.
', 'hcpshift', 6, 'SLS', 25, 'validate passes', 2, 1000);
Insert into TSB.TEST_SCENARIOS
   (TESTSCENARIO_NO, TESTCASE_ID, USECASE, TESTCASE_SEQNO, PROJECT_CODE, ITERATION, NAME, REPEAT_COUNT, BATCH_SIZE)
 Values
   (36, 'hcpshift', 'hcpshift', 7, 'SLS', 25, 'end second trip', 1, 1000);

   
--transaction specification
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (116, 1, 4, 21, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (112, 2, 1, 3, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (111, 2, 2, 1, 'SLS', 25, 2);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (113, 2, 3, 1, 'SLS', 25, 3);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (110, 2, 1, 22, 'SLS', 25, 4);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (114, 2, 3, 2, 'SLS', 25, 5);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (117, 3, 4, 22, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (102, 4, 3, 85, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (115, 5, 3, 85, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (126, 6, 4, 21, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (124, 7, 3, 2, 'SLS', 25, 2);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (125, 7, 3, 85, 'SLS', 25, 3);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (131, 8, 4, 22, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (127, 12, 4, 23, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (129, 13, 4, 24, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (132, 14, 4, 23, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (134, 15, 3, 85, 'SLS', 25, 2);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (133, 16, 4, 24, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (140, 17, 7, 22, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (141, 18, 3, 85, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (142, 18, 3, 85, 'SLS', 25, 2);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (103, 19, 3, 85, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (104, 20, 3, 85, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (101, 20, 3, 85, 'SLS', 25, 2);

Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (146, 26, 4, 21, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (144, 27, 3, 2, 'SLS', 25, 2);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (145, 27, 3, 85, 'SLS', 25, 3);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (151, 28, 4, 22, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (147, 32, 4, 23, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (149, 33, 4, 24, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (152, 34, 4, 23, 'SLS', 25, 1);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (154, 35, 3, 85, 'SLS', 25, 2);
Insert into TSB.TRANSACTION_SPECIFICATION
   (TXNSPEC_NO, TESTSCENARIO_NO, UDTYPE, UDSUBTYPE, PROJECT_CODE, ITERATION, SEQ_NO)
 Values
   (153, 36, 4, 24, 'SLS', 25, 1);




-- txnspec_values
@@txnvalues.sql

  
--iteration parameters

@@iterationparams.sql



COMMIT;

alter table ITERATION_PARAMS enable CONSTRAINT R_ITERATION_PARAMS_36198 ;

alter table TXNSPEC_VALUES ENABLE ALL TRIGGERS;
alter table TXNSPEC_VALUES enable CONSTRAINT R_TXNSPEC_VALUES_36200 ;

alter table TRANSACTION_SPECIFICATION ENABLE ALL TRIGGERS;
alter table TRANSACTION_SPECIFICATION enable CONSTRAINT R_TRANSACTION_SPECIFICAT_24283 ;

alter table TEST_SCENARIOS ENABLE ALL TRIGGERS;
alter table TEST_SCENARIOS enable CONSTRAINT R_TEST_SCENARIOS_36202 ;

alter table TESTCASES ENABLE ALL TRIGGERS;


CREATE OR REPLACE TRIGGER TSB.NOTFORDISPLAY
AFTER UPDATE
OF FIELDVALUE
ON TSB.TXNSPEC_VALUES
REFERENCING NEW AS NEW OLD AS OLD
DECLARE
tmpVar NUMBER;

BEGIN
   
   update txnspec_values
   set displayable = 'N'
   where fieldname in ('formatVersion','txnMac', 'keyVersion', 'applicationProviderId', 'applicationSerialNumber', 'udType', 'udSubtype', 
   'currencyIndicatorFinDetails','processedDate','cardIssuerId','productIssuerId','routeLineId','numberOfPassengers',
   'applicationPassengerType','applicationPersonaliseCat','passEndDateTime', 'staffId', 'operatorShiftNumber','shiftStartTime',
   'udsn', 'txnDateTime')
   and  displayable = 'Y';
   
END NOTFORDISPLAY;
/
Subversion Repositories DevTools

(root)/TxnTestManager/branches/Stockholm/schema/importscenarios.sql – Rev 2273
