| <?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-0005-check-table</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>Table exists</name> |
| <description/> |
| <type>TABLE_EXISTS</type> |
| <attributes/> |
| <tablename>testtable</tablename> |
| <schemaname>public</schemaname> |
| <connection>unit-test-db</connection> |
| <parallel>N</parallel> |
| <xloc>472</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>Evaluate rows number in a table</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>676</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>Columns exist in a table</name> |
| <description/> |
| <type>COLUMNS_EXIST</type> |
| <attributes/> |
| <tablename>testtable</tablename> |
| <schemaname>public</schemaname> |
| <connection>unit-test-db</connection> |
| <fields> |
| <field> |
| <name>key</name> |
| </field> |
| </fields> |
| <parallel>N</parallel> |
| <xloc>880</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>Check DB connections</name> |
| <description/> |
| <type>CHECK_DB_CONNECTIONS</type> |
| <attributes/> |
| <connections> |
| <connection> |
| <name>unit-test-db</name> |
| <waitfor>0</waitfor> |
| <waittime>millisecond</waittime> |
| </connection> |
| </connections> |
| <parallel>N</parallel> |
| <xloc>192</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>Truncate tables</name> |
| <description/> |
| <type>TRUNCATE_TABLES</type> |
| <attributes/> |
| <connection>unit-test-db</connection> |
| <arg_from_previous>N</arg_from_previous> |
| <fields> |
| <field> |
| <name>testtable</name> |
| <schemaname/> |
| </field> |
| </fields> |
| <parallel>N</parallel> |
| <xloc>1084</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>336</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| </actions> |
| <hops> |
| <hop> |
| <from>Table exists</from> |
| <to>Evaluate rows number in a table</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| <hop> |
| <from>Evaluate rows number in a table</from> |
| <to>Columns exist in a table</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| <hop> |
| <from>Start</from> |
| <to>Check DB connections</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>Y</unconditional> |
| </hop> |
| <hop> |
| <from>Columns exist in a table</from> |
| <to>Truncate tables</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| <hop> |
| <from>Check DB connections</from> |
| <to>SQL</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| <hop> |
| <from>SQL</from> |
| <to>Table exists</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| </hops> |
| <notepads> |
| </notepads> |
| <attributes/> |
| </workflow> |