| <?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-0006-insert-update-delete</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>0006-insert.hpl</name> |
| <description/> |
| <type>PIPELINE</type> |
| <attributes/> |
| <filename>${PROJECT_HOME}/0006-insert.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>256</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>check 5 records</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>880</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>0006-update.hpl</name> |
| <description/> |
| <type>PIPELINE</type> |
| <attributes/> |
| <filename>${PROJECT_HOME}/0006-update.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>1008</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>check new value</name> |
| <description/> |
| <type>EVAL_TABLE_CONTENT</type> |
| <attributes/> |
| <connection>unit-test-db</connection> |
| <schemaname/> |
| <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 * from public.testtable |
| where value = 'aa'</custom_sql> |
| <add_rows_result>N</add_rows_result> |
| <clear_result_rows>Y</clear_result_rows> |
| <parallel>N</parallel> |
| <xloc>1328</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>0006-insert-table-output-no-field-definition.hpl</name> |
| <description/> |
| <type>PIPELINE</type> |
| <attributes/> |
| <filename>${PROJECT_HOME}/0006-insert-table-output-no-field-definition.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>464</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>0006-insert-table-output.hpl</name> |
| <description/> |
| <type>PIPELINE</type> |
| <attributes/> |
| <filename>${PROJECT_HOME}/0006-insert-table-output.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>720</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/script1.sql</sqlfilename> |
| <sendOneStatement>F</sendOneStatement> |
| <connection>unit-test-db</connection> |
| <parallel>N</parallel> |
| <xloc>160</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>0006-insert-update-update</name> |
| <description/> |
| <type>PIPELINE</type> |
| <attributes/> |
| <filename>${PROJECT_HOME}/0006-insert-update-update.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>1168</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>0006-delete</name> |
| <description/> |
| <type>PIPELINE</type> |
| <attributes/> |
| <filename>${PROJECT_HOME}/0006-delete.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>1440</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>check deleted</name> |
| <description/> |
| <type>EVAL_TABLE_CONTENT</type> |
| <attributes/> |
| <connection>unit-test-db</connection> |
| <schemaname/> |
| <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 * from public.testtable |
| where key = '10'</custom_sql> |
| <add_rows_result>N</add_rows_result> |
| <clear_result_rows>Y</clear_result_rows> |
| <parallel>N</parallel> |
| <xloc>1568</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| </actions> |
| <hops> |
| <hop> |
| <from>check 5 records</from> |
| <to>0006-update.hpl</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| <hop> |
| <from>0006-insert.hpl</from> |
| <to>0006-insert-table-output-no-field-definition.hpl</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| <hop> |
| <from>0006-insert-table-output-no-field-definition.hpl</from> |
| <to>0006-insert-table-output.hpl</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| <hop> |
| <from>0006-insert-table-output.hpl</from> |
| <to>check 5 records</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| <hop> |
| <from>Start</from> |
| <to>SQL</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>Y</unconditional> |
| </hop> |
| <hop> |
| <from>SQL</from> |
| <to>0006-insert.hpl</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| <hop> |
| <from>0006-update.hpl</from> |
| <to>0006-insert-update-update</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| <hop> |
| <from>0006-insert-update-update</from> |
| <to>check new value</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| <hop> |
| <from>check new value</from> |
| <to>0006-delete</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| <hop> |
| <from>0006-delete</from> |
| <to>check deleted</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| </hops> |
| <notepads> |
| </notepads> |
| <attributes/> |
| </workflow> |