| <?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-0004-execute-sql-script</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/script1.sql</sqlfilename> |
| <sendOneStatement>F</sendOneStatement> |
| <connection>unit-test-db</connection> |
| <parallel>N</parallel> |
| <xloc>208</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>send as single statement</name> |
| <description/> |
| <type>SQL</type> |
| <attributes/> |
| <sql>drop table if exists t; |
| drop table if exists tt; |
| |
| select 1 as a, 2 as b into t; |
| select 3 as aa, 4 as bb into tt;</sql> |
| <useVariableSubstitution>F</useVariableSubstitution> |
| <sqlfromfile>F</sqlfromfile> |
| <sqlfilename>${PROJECT_HOME}/scripts/script1.sql</sqlfilename> |
| <sendOneStatement>T</sendOneStatement> |
| <connection>unit-test-db</connection> |
| <parallel>N</parallel> |
| <xloc>368</xloc> |
| <yloc>48</yloc> |
| <attributes_hac/> |
| </action> |
| <action> |
| <name>Multiple statements</name> |
| <description/> |
| <type>SQL</type> |
| <attributes/> |
| <sql>drop table if exists t; |
| drop table if exists tt; |
| |
| select 1 as a, 2 as b into t; |
| select 3 as aa, 4 as bb into tt;</sql> |
| <useVariableSubstitution>F</useVariableSubstitution> |
| <sqlfromfile>F</sqlfromfile> |
| <sqlfilename>${PROJECT_HOME}/scripts/script1.sql</sqlfilename> |
| <sendOneStatement>F</sendOneStatement> |
| <connection>unit-test-db</connection> |
| <parallel>N</parallel> |
| <xloc>592</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>send as single statement</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| <hop> |
| <from>send as single statement</from> |
| <to>Multiple statements</to> |
| <enabled>Y</enabled> |
| <evaluation>Y</evaluation> |
| <unconditional>N</unconditional> |
| </hop> |
| </hops> |
| <notepads> |
| </notepads> |
| <attributes/> |
| </workflow> |