INSERT INTO MWCONFIG.ADAPTOR (ID, DESCRIPTION, ASYNCHRONOUS, MODIFIED_BY, TIMESTAMP) VALUES ('dic-30801', 'Dummy IST Conn', 1, CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.CODEX (ID, ALLOW_PARTIAL, XML, MODIFIED_BY, TIMESTAMP) VALUES ('iso-8583-cws', NULL, ' iso-8583-cws ${msg.transmissionDateTime}.${msg.systemsTraceAuditNumber} ${msg.messageType}.${msg.messageType.startsWith("08") ? msg.networkManagementInformationCode?.padLeft(6, "0") : msg.processingCode?.trim().substring(0,6)} ', CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID) VALUES ('dic-30801', 'incoming', 'iso-8583-cws'); INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID) VALUES ('dic-30801', 'outgoing', 'iso-8583-cws'); INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES ('dic-30801', 'maxConnection', '1'); INSERT INTO MWCONFIG.SERVER_PORT (ADAPTOR_ID, PORT, SERVER, GROUP) VALUES ('dic-30801', 30801, 'dummy-server', 'dic'); INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('dummy-res.dic.default-mapping', NULL, '[dic]', CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('dummy-res.dic.default-mapping', 1, '/data', '/data', NULL, NULL), ('dummy-res.dic.default-mapping', 2, '/data/body', '/data/body', NULL, NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('dummy-res.dic.default-mapping', 1, '@', 'copyMessage();', NULL), ('dummy-res.dic.default-mapping', 2, 'messageType', '${msg.messageType.''!value''.substring(0,2).concat("10")}', NULL), ('dummy-res.dic.default-mapping', 2, 'responseCode', '00', NULL); INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('dummy-res.dic.default-transaction-mapping', NULL, '[dic]', CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('dummy-res.dic.default-transaction-mapping', 3, '/data/body', '/data/body', NULL, NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('dummy-res.dic.default-transaction-mapping', 3, 'dateCapture', '${msg.dateLocalTransaction}', NULL), ('dummy-res.dic.default-transaction-mapping', 3, 'reservedPrivate1', 'BTN4PRO100000000000', NULL), ('dummy-res.dic.default-transaction-mapping', 3, 'receivingInstitutionIdentificationCode', '20000000001', NULL); INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('dummy-res.dic.0800.000001', 'SIGN ON', '[dic]', CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('dummy-res.dic.0800.000001', 1, '/data', '/data', 'dummy-res.dic.default-mapping', 1), ('dummy-res.dic.0800.000001', 2, '/data/body', '/data/body', 'dummy-res.dic.default-mapping', 2); INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('dummy-res.dic.0800.000301', 'ECHO TEST', '[dic]', CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('dummy-res.dic.0800.000301', 1, '/data', '/data', 'dummy-res.dic.default-mapping', 1), ('dummy-res.dic.0800.000301', 2, '/data/body', '/data/body', 'dummy-res.dic.default-mapping', 2); INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('dummy-res.dic.0200.022000', NULL, '[dic]', CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('dummy-res.dic.0200.022000', 1, '/data', '/data', 'dummy-res.dic.default-mapping', 1), ('dummy-res.dic.0200.022000', 2, '/data/body', '/data/body', 'dummy-res.dic.default-mapping', 2), ('dummy-res.dic.0200.022000', 3, '/data/body', '/data/body', 'dummy-res.dic.default-transaction-mapping', 3); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('dummy-res.dic.0200.022000', 2, 'responseCode', '00', 10); INSERT INTO MWCONFIG.MAPPING (ID, DESCRIPTION, MODULE, MODIFIED_BY ,TIMESTAMP) VALUES ('dummy-res.dic.0200.940000', NULL, '[dic]', CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('dummy-res.dic.0200.940000', 1, '/data', '/data', 'dummy-res.dic.default-mapping', 1), ('dummy-res.dic.0200.940000', 2, '/data/body', '/data/body', 'dummy-res.dic.default-mapping', 2), ('dummy-res.dic.0200.940000', 3, '/data/body', '/data/body', 'dummy-res.dic.default-transaction-mapping', 3); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('dummy-res.dic.0200.940000', 2, 'responseCode', '00', 10); -- CLIENT TARGET INSERT INTO MWCONFIG.ADAPTOR (ID, DESCRIPTION, ASYNCHRONOUS, MODIFIED_BY, TIMESTAMP) VALUES ('ist-conn', NULL, 1, CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.ADAPTOR_CODEX (ADAPTOR_ID, ID, CODEX_ID) VALUES ('ist-conn', 'incoming', 'iso-8583-cws'), ('ist-conn', 'outgoing', 'iso-8583-cws'); INSERT INTO MWCONFIG.ADAPTOR_PARAM (ADAPTOR_ID, NAME, VALUE) VALUES ('ist-conn', 'echo', '60000'), ('ist-conn', 'needSignOn', 'true'), ('ist-conn', 'timeout', '60000'); INSERT INTO MWCONFIG.CLIENT (ADAPTOR_ID, IDLE_WAIT, TIMEOUT, CLOSE_QUEUE, CONTROL_QUEUE, KEEP_CONN, REUSE_DELAY, NODE) VALUES('ist-conn', 0, 0, NULL, NULL, 1, 0, 'backend-iso'); INSERT INTO MWCONFIG.CLIENT_TARGET (CLIENT_ID, ID, HOST, WEIGHT, SEQ) VALUES ('ist-conn', 'ist-conn', 'DUMMY:30801', 0, 1); INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('ist-conn.SIGN-ON', null, CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('ist-conn.SIGN-ON', 1, '/data', '/data/body', NULL, NULL); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('ist-conn.SIGN-ON', 1, 'systemsTraceAuditNumber', '${counter("ist-conn", 5, 1, "ddMMyy")} ', 10), ('ist-conn.SIGN-ON', 1, 'transmissionDateTime', '${getTimeZoneFormat("MMddHHmmss","GMT")}', 10), ('ist-conn.SIGN-ON', 1, '!mid', '${tar.transmissionDateTime."!value"+"."+tar.systemsTraceAuditNumber."!value"}', 20), ('ist-conn.SIGN-ON', 1, '!destination', '${msg.source}', null), ('ist-conn.SIGN-ON', 1, '!nosignon', 'true', null), ('ist-conn.SIGN-ON', 1, '!reqtimestamp', '${head.reqtimestamp}', null), ('ist-conn.SIGN-ON', 1, '!sid', '${msg.sid}', null), ('ist-conn.SIGN-ON', 1, 'dateLocalTransaction', '${getTimeZoneFormat("MMdd","GMT")}', null), ('ist-conn.SIGN-ON', 1, 'messageType', '0800', null), ('ist-conn.SIGN-ON', 1, 'networkManagementInformationCode', '001', null), ('ist-conn.SIGN-ON', 1, 'timeLocalTransaction', '${getTimeZoneFormat("HHmmss","GMT")}', null); INSERT INTO MWCONFIG.MAPPING (ID, MODULE, MODIFIED_BY, TIMESTAMP) VALUES ('ist-conn.ECHO-TEST', null, CURRENT USER, CURRENT TIMESTAMP); INSERT INTO MWCONFIG.MAPPING_GROUP (MAPPING_ID, ID, SOURCE, TARGET, INCLUDE_MAPPING_ID, INCLUDE_ID) VALUES ('ist-conn.ECHO-TEST', 1, '/data', '/data/body', 'ist-conn.SIGN-ON', '1'); INSERT INTO MWCONFIG.MAPPING_GROUP_LINE (MAPPING_ID, MAPPING_GROUP_ID, NAME, TEXT, SEQ) VALUES ('ist-conn.ECHO-TEST', 1, 'networkManagementInformationCode', '301', null);