{"class_fqid":"com-snaplogic-pipeline_8","snode_id":"59ba55e895526e056285729f","instance_id":"70dbb0cc-e0ea-406f-b42b-037386f411ea","instance_version":39,"link_map":{"link104":{"src_view_id":"output101","dst_view_id":"input101","src_id":"4efaf7f2-1382-4afa-827c-818341934c18","dst_id":"2bccfd1f-e3e7-42bf-a0b2-8f055f27fd19","isGoto":false},"link102":{"src_view_id":"output0","dst_view_id":"input101","src_id":"d64f7a86-ea5e-4981-8e0b-4179a04b2bd3","dst_id":"9e86ea1f-a116-4647-bfbd-267ba910793b","isGoto":false},"link103":{"src_view_id":"output0","dst_view_id":"inputRows","src_id":"a64d0385-8080-4098-a5ae-518368ee876a","dst_id":"4efaf7f2-1382-4afa-827c-818341934c18","isGoto":false},"link100":{"src_view_id":"output0","dst_view_id":"input101","src_id":"fb02159a-e04c-4354-9f95-963f98c05b85","dst_id":"a64d0385-8080-4098-a5ae-518368ee876a","isGoto":false},"link101":{"src_view_id":"output0","dst_view_id":"input0","src_id":"9e86ea1f-a116-4647-bfbd-267ba910793b","dst_id":"fb02159a-e04c-4354-9f95-963f98c05b85","isGoto":false}},"link_serial":105,"property_map":{"info":{"notes":{"value":null},"label":{"value":"MySql Stored Procedute Multiple Statements"},"purpose":{"value":null},"pipeline_doc_uri":{"value":null},"author":{"value":"vspridhvi@snaplogic.com"}},"input":{},"settings":{"param_table":{"value":[]},"imports":{"value":[]}},"error":{"error_behavior":{"value":"none"},"a64d0385-8080-4098-a5ae-518368ee876a_error0":{"label":{"value":"MySQL Stored Procedure - error0"},"view_type":{"value":"document"}}},"output":{"a64d0385-8080-4098-a5ae-518368ee876a_output1":{"label":{"value":"MySQL Stored Procedure - Result Set Output View"},"view_type":{"value":"document"}},"9e86ea1f-a116-4647-bfbd-267ba910793b_output1":{"label":{"value":"MySQL Stored Procedure - Result Set Output View"},"view_type":{"value":"document"}},"2bccfd1f-e3e7-42bf-a0b2-8f055f27fd19_outputRows":{"label":{"value":"SQL Server - Select - rows"},"view_type":{"value":"document"}}}},"render_map":{"pan_x_num":0,"default_snaplex":"5710216095526e484d534a97","scale_ratio":1,"detail_map":{"a64d0385-8080-4098-a5ae-518368ee876a":{"grid_x_int":5,"grid_y_int":2,"rot_tail_int":0,"error":{"error0":{"dx_int":0,"rot_int":0,"dy_int":-1}},"output":{"output1":{"dx_int":0,"rot_int":0,"dy_int":1}},"rot_int":0},"2bccfd1f-e3e7-42bf-a0b2-8f055f27fd19":{"grid_x_int":7,"rot_int":0,"grid_y_int":2,"rot_tail_int":0},"4efaf7f2-1382-4afa-827c-818341934c18":{"grid_x_int":6,"rot_int":0,"grid_y_int":2,"rot_tail_int":0},"fb02159a-e04c-4354-9f95-963f98c05b85":{"grid_x_int":4,"rot_int":0,"grid_y_int":2,"rot_tail_int":0},"9e86ea1f-a116-4647-bfbd-267ba910793b":{"grid_x_int":3,"rot_int":0,"grid_y_int":2,"rot_tail_int":0,"output":{"output1":{"dx_int":0,"rot_int":0,"dy_int":1}}},"d64f7a86-ea5e-4981-8e0b-4179a04b2bd3":{"grid_x_int":2,"rot_int":0,"grid_y_int":2,"rot_tail_int":0,"input":{}}},"pan_y_num":0},"snap_map":{"a64d0385-8080-4098-a5ae-518368ee876a":{"class_fqid":"com-snaplogic-snaps-mysql-storedprocedure_1-c439","class_id":"com-snaplogic-snaps-mysql-storedprocedure","class_version":1,"instance_fqid":"a64d0385-8080-4098-a5ae-518368ee876a_7","instance_id":"a64d0385-8080-4098-a5ae-518368ee876a","instance_version":7,"property_map":{"info":{"notes":{"value":null},"label":{"value":"MySQL Stored Procedure"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"MySQL mysqlqatest auto commit ON (do not modify)"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-mysqldatabaseaccount"},"ref_id":{"expression":false,"value":"690627a0-8a5e-46ac-83e4-8ca9588365d4"}}}},"settings":{"parameterValues":{"value":[{"parameterValue":{"expression":true,"value":"$empno1"}},{"parameterValue":{"expression":true,"value":"$empno2"}},{"parameterValue":{"expression":true,"value":"$ename1"}},{"parameterValue":{"expression":true,"value":"$ename2"}}]},"passThrough":{"value":false},"schemaName":{"expression":false,"value":null},"executable_during_suggest":{"value":true},"storedProcedureName":{"expression":false,"value":"`enron`.`Multiple_Statements`"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"Output Parameter OutputView"}},"output1":{"view_type":{"value":"document"},"label":{"value":"Result Set Output View"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"continue"}},"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"c439"},"2bccfd1f-e3e7-42bf-a0b2-8f055f27fd19":{"class_fqid":"com-snaplogic-snaps-sqlserver-select_3-c439","class_id":"com-snaplogic-snaps-sqlserver-select","class_version":3,"instance_fqid":"2bccfd1f-e3e7-42bf-a0b2-8f055f27fd19_3","instance_id":"2bccfd1f-e3e7-42bf-a0b2-8f055f27fd19","instance_version":3,"property_map":{"info":{"notes":{"value":null},"label":{"value":"SQL Server - Select"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"SQL Server 2016 - Auto Commit - TRUE"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-sqlserverdatabaseaccount"},"ref_id":{"expression":false,"value":"4d6cc9e9-a18a-4d75-9aa9-f033a2e81e34"}}}},"input":{"input101":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"autoCommit":{"value":"False"},"orderBy":{"value":[]},"limitRows":{"expression":false,"value":null},"passThrough":{"value":true},"tableName":{"expression":false,"value":"SP_mysql_SqlServer"},"ignoreEmptyResult":{"value":false},"outputFields":{"value":[]},"whereClause":{"expression":false,"value":null},"schemaName":{"expression":false,"value":null},"limitOffset":{"expression":false,"value":null}},"error":{"error0":{"label":{"value":"error0"},"view_type":{"value":"document"}},"error_behavior":{"value":"fail"}},"output":{"outputRows":{"label":{"value":"rows"},"view_type":{"value":"document"}}}},"class_build_tag":"c439"},"4efaf7f2-1382-4afa-827c-818341934c18":{"class_fqid":"com-snaplogic-snaps-sqlserver-insert_1-c439","class_id":"com-snaplogic-snaps-sqlserver-insert","class_version":1,"instance_fqid":"4efaf7f2-1382-4afa-827c-818341934c18_4","instance_id":"4efaf7f2-1382-4afa-827c-818341934c18","instance_version":4,"property_map":{"info":{"notes":{"value":null},"label":{"value":"SQL Server - Insert"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"ref_id":{"expression":false,"value":"4d6cc9e9-a18a-4d75-9aa9-f033a2e81e34"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-sqlserverdatabaseaccount"},"label":{"expression":false,"value":"SQL Server 2016 - Auto Commit - TRUE"}}}},"settings":{"schemaName":{"expression":false,"value":null},"createTable":{"value":true},"tableName":{"expression":false,"value":"SP_mysql_SqlServer"},"executable_during_suggest":{"value":true}},"output":{"output101":{"view_type":{"value":"document"},"label":{"value":"output0"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"input":{"inputRows":{"view_type":{"value":"document"},"label":{"value":"rows"}}}},"class_build_tag":"c439"},"fb02159a-e04c-4354-9f95-963f98c05b85":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-c439","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"fb02159a-e04c-4354-9f95-963f98c05b85_7","instance_id":"fb02159a-e04c-4354-9f95-963f98c05b85","instance_version":7,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper"}},"view_serial":100,"input":{"input0":{"view_type":{"value":"document"},"label":{"value":"input0"}}},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"transformations":{"value":{"mappingTable":{"value":[{"targetPath":{"value":"$empno1"},"expression":{"expression":true,"value":"501"}},{"targetPath":{"value":"$empno2"},"expression":{"expression":true,"value":"502"}},{"targetPath":{"value":"$ename1"},"expression":{"expression":false,"value":"snaplogic1"}},{"targetPath":{"value":"$ename2"},"expression":{"expression":false,"value":"snaplogic2"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"c439"},"9e86ea1f-a116-4647-bfbd-267ba910793b":{"class_fqid":"com-snaplogic-snaps-mysql-storedprocedure_1-c439","class_id":"com-snaplogic-snaps-mysql-storedprocedure","class_version":1,"instance_fqid":"9e86ea1f-a116-4647-bfbd-267ba910793b_2","instance_id":"9e86ea1f-a116-4647-bfbd-267ba910793b","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"MySQL Stored Procedure"}},"view_serial":101,"account":{"account_ref":{"expression":false,"value":{"label":{"expression":false,"value":"MySQL mysqlqatest auto commit ON (do not modify)"},"ref_class_id":{"value":"com-snaplogic-snap-api-sql-accounts-mysqldatabaseaccount"},"ref_id":{"expression":false,"value":"690627a0-8a5e-46ac-83e4-8ca9588365d4"}}}},"settings":{"parameterValues":{"value":[{"parameterValue":{"expression":true,"value":"$empno1"}},{"parameterValue":{"expression":true,"value":"$empno2"}}]},"passThrough":{"value":false},"schemaName":{"expression":false,"value":null},"executable_during_suggest":{"value":true},"storedProcedureName":{"expression":false,"value":"`enron`.`SP_Emp_Delete`"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"Output Parameter OutputView"}},"output1":{"view_type":{"value":"document"},"label":{"value":"Result Set Output View"}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"input":{"input101":{"label":{"value":"input0"},"view_type":{"value":"document"}}}},"class_build_tag":"c439"},"d64f7a86-ea5e-4981-8e0b-4179a04b2bd3":{"class_fqid":"com-snaplogic-snaps-transform-datatransform_4-c439","class_id":"com-snaplogic-snaps-transform-datatransform","class_version":4,"instance_fqid":"d64f7a86-ea5e-4981-8e0b-4179a04b2bd3_2","instance_id":"d64f7a86-ea5e-4981-8e0b-4179a04b2bd3","instance_version":2,"property_map":{"info":{"notes":{"value":null},"label":{"value":"Mapper"}},"view_serial":100,"input":{},"settings":{"nullSafeAccess":{"value":false},"passThrough":{"value":false},"transformations":{"value":{"mappingTable":{"value":[{"targetPath":{"value":"$empno1"},"expression":{"expression":true,"value":"501"}},{"targetPath":{"value":"$empno2"},"expression":{"expression":true,"value":"502"}}]},"mappingRoot":{"value":"$"}}}},"error":{"error0":{"view_type":{"value":"document"},"label":{"value":"error0"}},"error_behavior":{"value":"fail"}},"output":{"output0":{"view_type":{"value":"document"},"label":{"value":"output0"}}}},"class_build_tag":"c439"}},"path_id":"/QA/projects/diagnostic","path_snode":"540e8026ec77034feacff4eb"}