| <?xml version="1.0" encoding="UTF-8"?> |
| <!-- |
| |
| Licensed to the Apache Software Foundation (ASF) under one or more |
| contributor license agreements. See the NOTICE file distributed with |
| this work for additional information regarding copyright ownership. |
| The ASF licenses this file to You under the Apache License, Version 2.0 |
| (the "License"); you may not use this file except in compliance with |
| the License. You may obtain a copy of the License at |
| |
| http://www.apache.org/licenses/LICENSE-2.0 |
| |
| Unless required by applicable law or agreed to in writing, software |
| distributed under the License is distributed on an "AS IS" BASIS, |
| WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| See the License for the specific language governing permissions and |
| limitations under the License. |
| |
| --> |
| <pipeline> |
| <info> |
| <name>0019-execute-sqlscript-byeachrow</name> |
| <name_sync_with_filename>Y</name_sync_with_filename> |
| <description/> |
| <extended_description/> |
| <pipeline_version/> |
| <pipeline_type>Normal</pipeline_type> |
| <pipeline_status>0</pipeline_status> |
| <parameters> |
| </parameters> |
| <capture_transform_performance>N</capture_transform_performance> |
| <transform_performance_capturing_delay>1000</transform_performance_capturing_delay> |
| <transform_performance_capturing_size_limit>100</transform_performance_capturing_size_limit> |
| <created_user>-</created_user> |
| <created_date>2021/04/30 11:01:28.333</created_date> |
| <modified_user>-</modified_user> |
| <modified_date>2021/04/30 11:01:28.333</modified_date> |
| <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key> |
| <is_key_private>N</is_key_private> |
| </info> |
| <notepads> |
| </notepads> |
| <order> |
| <hop> |
| <from>validate count</from> |
| <to>success</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>validate count</from> |
| <to>failed on count</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>Generate rows</from> |
| <to>Execute SQL script</to> |
| <enabled>Y</enabled> |
| </hop> |
| <hop> |
| <from>Execute SQL script</from> |
| <to>validate count</to> |
| <enabled>Y</enabled> |
| </hop> |
| </order> |
| <transform> |
| <name>Execute SQL script</name> |
| <type>ExecSql</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <connection>unit-test-db</connection> |
| <execute_each_row>Y</execute_each_row> |
| <single_statement>N</single_statement> |
| <replace_variables>N</replace_variables> |
| <quoteString>N</quoteString> |
| <sql>insert into public.testtable (key, value) values ('key1', ?); |
| insert into public.testtable (key, value) values ('key2', ?); |
| delete from public.testtable where value=?;</sql> |
| <set_params>Y</set_params> |
| <insert_field>inserted</insert_field> |
| <update_field>updated</update_field> |
| <delete_field>deleted</delete_field> |
| <read_field>read</read_field> |
| <arguments> |
| <argument> |
| <name>value</name> |
| </argument> |
| </arguments> |
| <attributes/> |
| <GUI> |
| <xloc>384</xloc> |
| <yloc>80</yloc> |
| </GUI> |
| </transform> |
| <transform> |
| <name>Generate rows</name> |
| <type>RowGenerator</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <fields> |
| <field> |
| <length>-1</length> |
| <name>value</name> |
| <precision>-1</precision> |
| <set_empty_string>N</set_empty_string> |
| <type>String</type> |
| <nullif>value</nullif> |
| </field> |
| </fields> |
| <interval_in_ms>5000</interval_in_ms> |
| <last_time_field>FiveSecondsAgo</last_time_field> |
| <never_ending>N</never_ending> |
| <limit>1</limit> |
| <row_time_field>now</row_time_field> |
| <attributes/> |
| <GUI> |
| <xloc>144</xloc> |
| <yloc>80</yloc> |
| </GUI> |
| </transform> |
| <transform> |
| <name>failed on count</name> |
| <type>Abort</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <abort_option>ABORT_WITH_ERROR</abort_option> |
| <always_log_rows>Y</always_log_rows> |
| <row_threshold>0</row_threshold> |
| <attributes/> |
| <GUI> |
| <xloc>640</xloc> |
| <yloc>176</yloc> |
| </GUI> |
| </transform> |
| <transform> |
| <name>success</name> |
| <type>Dummy</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <attributes/> |
| <GUI> |
| <xloc>784</xloc> |
| <yloc>80</yloc> |
| </GUI> |
| </transform> |
| <transform> |
| <name>validate count</name> |
| <type>FilterRows</type> |
| <description/> |
| <distribute>Y</distribute> |
| <custom_distribution/> |
| <copies>1</copies> |
| <partitioning> |
| <method>none</method> |
| <schema_name/> |
| </partitioning> |
| <send_true_to>success</send_true_to> |
| <send_false_to>failed on count</send_false_to> |
| <compare> |
| <condition> |
| <negated>N</negated> |
| <conditions> |
| <condition> |
| <negated>N</negated> |
| <leftvalue>updated</leftvalue> |
| <function>=</function> |
| <rightvalue/> |
| <value> |
| <name>constant</name> |
| <type>Integer</type> |
| <text>0</text> |
| <length>-1</length> |
| <precision>0</precision> |
| <isnull>N</isnull> |
| <mask>####0;-####0</mask> |
| </value> |
| </condition> |
| <condition> |
| <negated>N</negated> |
| <operator>AND</operator> |
| <leftvalue>deleted</leftvalue> |
| <function>=</function> |
| <rightvalue/> |
| <value> |
| <name>constant</name> |
| <type>Integer</type> |
| <text>2</text> |
| <length>-1</length> |
| <precision>0</precision> |
| <isnull>N</isnull> |
| <mask>####0;-####0</mask> |
| </value> |
| </condition> |
| <condition> |
| <negated>N</negated> |
| <operator>AND</operator> |
| <leftvalue>inserted</leftvalue> |
| <function>=</function> |
| <rightvalue/> |
| <value> |
| <name>constant</name> |
| <type>Integer</type> |
| <text>2</text> |
| <length>-1</length> |
| <precision>0</precision> |
| <isnull>N</isnull> |
| <mask>####0;-####0</mask> |
| </value> |
| </condition> |
| <condition> |
| <negated>N</negated> |
| <operator>AND</operator> |
| <leftvalue>read</leftvalue> |
| <function>=</function> |
| <rightvalue/> |
| <value> |
| <name>constant</name> |
| <type>Integer</type> |
| <text>0</text> |
| <length>-1</length> |
| <precision>0</precision> |
| <isnull>N</isnull> |
| <mask>####0;-####0</mask> |
| </value> |
| </condition> |
| </conditions> |
| </condition> |
| </compare> |
| <attributes/> |
| <GUI> |
| <xloc>640</xloc> |
| <yloc>80</yloc> |
| </GUI> |
| </transform> |
| <transform_error_handling> |
| </transform_error_handling> |
| <attributes/> |
| </pipeline> |