| <?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. |
| |
| --> |
| <workflow> |
| <name>main-0013-synchronize-after-merge</name> |
| <name_sync_with_filename>Y</name_sync_with_filename> |
| <description/> |
| <extended_description/> |
| <workflow_version/> |
| <created_user>-</created_user> |
| <created_date>2021/04/29 11:51:40.288</created_date> |
| <modified_user>-</modified_user> |
| <modified_date>2021/04/29 11:51:40.288</modified_date> |
| <parameters> |
| </parameters> |
| <actions> |
| <action> |
| <name>Start</name> |
| <description/> |
| <type>SPECIAL</type> |
| <attributes/> |
| <repeat>N</repeat> |
| <schedulerType>0</schedulerType> |
| <intervalSeconds>0</intervalSeconds> |
| <intervalMinutes>60</intervalMinutes> |
| <hour>12</hour> |
| <minutes>0</minutes> |
| <weekDay>1</weekDay> |
| <DayOfMonth>1</DayOfMonth> |
| <parallel>N</parallel> |
| <xloc>64</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>SQL</name> |
| <description/> |
| <type>SQL</type> |
| <attributes/> |
| <sql/> |
| <useVariableSubstitution>F</useVariableSubstitution> |
| <sqlfromfile>T</sqlfromfile> |
| <sqlfilename>${PROJECT_HOME}/scripts/script2.sql</sqlfilename> |
| <sendOneStatement>F</sendOneStatement> |
| <connection>unit-test-db</connection> |
| <parallel>N</parallel> |
| <xloc>230</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>0013-synchronize-after-merge.hpl</name> |
| <description/> |
| <type>PIPELINE</type> |
| <attributes/> |
| <filename>${PROJECT_HOME}/0013-synchronize-after-merge.hpl</filename> |
| <params_from_previous>N</params_from_previous> |
| <exec_per_row>N</exec_per_row> |
| <clear_rows>N</clear_rows> |
| <clear_files>N</clear_files> |
| <set_logfile>N</set_logfile> |
| <logfile/> |
| <logext/> |
| <add_date>N</add_date> |
| <add_time>N</add_time> |
| <loglevel>Basic</loglevel> |
| <set_append_logfile>N</set_append_logfile> |
| <wait_until_finished>Y</wait_until_finished> |
| <follow_abort_remote>N</follow_abort_remote> |
| <create_parent_folder>N</create_parent_folder> |
| <run_configuration>local</run_configuration> |
| <parameters> |
| <pass_all_parameters>Y</pass_all_parameters> |
| </parameters> |
| <parallel>N</parallel> |
| <xloc>396</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>count rows</name> |
| <description/> |
| <type>EVAL_TABLE_CONTENT</type> |
| <attributes/> |
| <connection>unit-test-db</connection> |
| <schemaname>public</schemaname> |
| <tablename>testtable</tablename> |
| <success_condition>rows_count_equal</success_condition> |
| <limit>5</limit> |
| <is_custom_sql>N</is_custom_sql> |
| <is_usevars>N</is_usevars> |
| <custom_sql/> |
| <add_rows_result>N</add_rows_result> |
| <clear_result_rows>Y</clear_result_rows> |
| <parallel>N</parallel> |
| <xloc>562</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>check changed value</name> |
| <description/> |
| <type>EVAL_TABLE_CONTENT</type> |
| <attributes/> |
| <connection>unit-test-db</connection> |
| <schemaname>public</schemaname> |
| <tablename>testtable</tablename> |
| <success_condition>rows_count_equal</success_condition> |
| <limit>1</limit> |
| <is_custom_sql>Y</is_custom_sql> |
| <is_usevars>N</is_usevars> |
| <custom_sql>select 1 from public.testtable |
| where value = 'e'</custom_sql> |
| <add_rows_result>N</add_rows_result> |
| <clear_result_rows>Y</clear_result_rows> |
| <parallel>N</parallel> |
| <xloc>728</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>check deleted row</name> |
| <description/> |
| <type>EVAL_TABLE_CONTENT</type> |
| <attributes/> |
| <connection>unit-test-db</connection> |
| <schemaname>public</schemaname> |
| <tablename>testtable</tablename> |
| <success_condition>rows_count_equal</success_condition> |
| <limit>0</limit> |
| <is_custom_sql>Y</is_custom_sql> |
| <is_usevars>N</is_usevars> |
| <custom_sql>select 1 from public.testtable |
| where value = 'bb'</custom_sql> |
| <add_rows_result>N</add_rows_result> |
| <clear_result_rows>Y</clear_result_rows> |
| <parallel>N</parallel> |
| <xloc>894</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| </actions> |
| <hops> |
| <hop> |
| <from>Start</from> |
| <to>SQL</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>Y</unconditional> |
| </hop> |
| <hop> |
| <from>SQL</from> |
| <to>0013-synchronize-after-merge.hpl</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| <hop> |
| <from>0013-synchronize-after-merge.hpl</from> |
| <to>count rows</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| <hop> |
| <from>count rows</from> |
| <to>check changed value</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| <hop> |
| <from>check changed value</from> |
| <to>check deleted row</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| </hops> |
| <notepads> |
| </notepads> |
| <attributes/> |
| </workflow> |