integration-tests/mdi/0010-database-lookup-parent.hpl

<?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>0010-database-lookup-parent</name>
    <name_sync_with_filename>Y</name_sync_with_filename>
    <description/>
    <extended_description/>
    <pipeline_version/>
    <pipeline_type>Normal</pipeline_type>
    <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/05/25 12:27:40.781</created_date>
    <modified_user>-</modified_user>
    <modified_date>2021/05/25 12:27:40.781</modified_date>
    <key_for_session_key>H4sIAAAAAAAAAAMAAAAAAAAAAAA=</key_for_session_key>
    <is_key_private>N</is_key_private>
  </info>
  <notepads>
  </notepads>
  <order>
    <hop>
      <from>metadata</from>
      <to>ETL metadata injection</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>keys</from>
      <to>ETL metadata injection</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>returns</from>
      <to>ETL metadata injection</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>ETL metadata injection</from>
      <to>myUuid &lt;&gt; '-'</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>myUuid &lt;&gt; '-'</from>
      <to>count</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>count</from>
      <to>count &lt;&gt; 100</to>
      <enabled>Y</enabled>
    </hop>
    <hop>
      <from>count &lt;&gt; 100</from>
      <to>Abort</to>
      <enabled>Y</enabled>
    </hop>
  </order>
  <transform>
    <name>Abort</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>
    <message>Incorrect number of values retrieved</message>
    <row_threshold>0</row_threshold>
    <attributes/>
    <GUI>
      <xloc>768</xloc>
      <yloc>128</yloc>
    </GUI>
  </transform>
  <transform>
    <name>ETL metadata injection</name>
    <type>MetaInject</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <filename>${PROJECT_HOME}/0010-database-lookup-child.hpl</filename>
    <source_transform>OUTPUT</source_transform>
    <source_output_fields>
      <source_output_field>
        <source_output_field_name>id</source_output_field_name>
        <source_output_field_type>Integer</source_output_field_type>
        <source_output_field_length>-1</source_output_field_length>
        <source_output_field_precision>-1</source_output_field_precision>
      </source_output_field>
      <source_output_field>
        <source_output_field_name>myUuid</source_output_field_name>
        <source_output_field_type>String</source_output_field_type>
        <source_output_field_length>-1</source_output_field_length>
        <source_output_field_precision>-1</source_output_field_precision>
      </source_output_field>
    </source_output_fields>
    <target_file/>
    <no_execution>N</no_execution>
    <stream_source_transform/>
    <stream_target_transform/>
    <mappings>
      <mapping>
        <target_transform_name>myUuid</target_transform_name>
        <target_attribute_key>return_default_type</target_attribute_key>
        <target_detail>Y</target_detail>
        <source_transform>returns</source_transform>
        <source_field>defaultType</source_field>
      </mapping>
      <mapping>
        <target_transform_name>myUuid</target_transform_name>
        <target_attribute_key>table</target_attribute_key>
        <target_detail>N</target_detail>
        <source_transform>metadata</source_transform>
        <source_field>table</source_field>
      </mapping>
      <mapping>
        <target_transform_name>myUuid</target_transform_name>
        <target_attribute_key>key_table_field</target_attribute_key>
        <target_detail>Y</target_detail>
        <source_transform>keys</source_transform>
        <source_field>tableField</source_field>
      </mapping>
      <mapping>
        <target_transform_name>myUuid</target_transform_name>
        <target_attribute_key>connection</target_attribute_key>
        <target_detail>N</target_detail>
        <source_transform>metadata</source_transform>
        <source_field>connection</source_field>
      </mapping>
      <mapping>
        <target_transform_name>myUuid</target_transform_name>
        <target_attribute_key>return_rename</target_attribute_key>
        <target_detail>Y</target_detail>
        <source_transform>returns</source_transform>
        <source_field>rename</source_field>
      </mapping>
      <mapping>
        <target_transform_name>myUuid</target_transform_name>
        <target_attribute_key>key_condition</target_attribute_key>
        <target_detail>Y</target_detail>
        <source_transform>keys</source_transform>
        <source_field>Comparator</source_field>
      </mapping>
      <mapping>
        <target_transform_name>myUuid</target_transform_name>
        <target_attribute_key>cache_size</target_attribute_key>
        <target_detail>N</target_detail>
        <source_transform>metadata</source_transform>
        <source_field>cacheSize</source_field>
      </mapping>
      <mapping>
        <target_transform_name>myUuid</target_transform_name>
        <target_attribute_key>return_table_field</target_attribute_key>
        <target_detail>Y</target_detail>
        <source_transform>returns</source_transform>
        <source_field>tableField</source_field>
      </mapping>
      <mapping>
        <target_transform_name>myUuid</target_transform_name>
        <target_attribute_key>cache</target_attribute_key>
        <target_detail>N</target_detail>
        <source_transform>metadata</source_transform>
        <source_field>cache?</source_field>
      </mapping>
      <mapping>
        <target_transform_name>myUuid</target_transform_name>
        <target_attribute_key>cache_load_all</target_attribute_key>
        <target_detail>N</target_detail>
        <source_transform>metadata</source_transform>
        <source_field>loadAll?</source_field>
      </mapping>
      <mapping>
        <target_transform_name>myUuid</target_transform_name>
        <target_attribute_key>return_default_value</target_attribute_key>
        <target_detail>Y</target_detail>
        <source_transform>returns</source_transform>
        <source_field>defaultValue</source_field>
      </mapping>
      <mapping>
        <target_transform_name>myUuid</target_transform_name>
        <target_attribute_key>key_input_field1</target_attribute_key>
        <target_detail>Y</target_detail>
        <source_transform>keys</source_transform>
        <source_field>inputField</source_field>
      </mapping>
    </mappings>
    <attributes/>
    <GUI>
      <xloc>288</xloc>
      <yloc>128</yloc>
    </GUI>
  </transform>
  <transform>
    <name>count</name>
    <type>GroupBy</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <all_rows>N</all_rows>
    <ignore_aggregate>N</ignore_aggregate>
    <field_ignore/>
    <directory>${java.io.tmpdir}</directory>
    <prefix>grp</prefix>
    <add_linenr>N</add_linenr>
    <linenr_fieldname/>
    <give_back_row>N</give_back_row>
    <group>
      </group>
    <fields>
      <field>
        <aggregate>count</aggregate>
        <subject/>
        <type>COUNT_ANY</type>
        <valuefield/>
      </field>
    </fields>
    <attributes/>
    <GUI>
      <xloc>544</xloc>
      <yloc>128</yloc>
    </GUI>
  </transform>
  <transform>
    <name>count &lt;&gt; 100</name>
    <type>FilterRows</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <send_true_to/>
    <send_false_to/>
    <compare>
      <condition>
        <negated>N</negated>
        <leftvalue>count</leftvalue>
        <function>&lt;></function>
        <rightvalue/>
        <value>
          <name>constant</name>
          <type>Integer</type>
          <text>100</text>
          <length>-1</length>
          <precision>0</precision>
          <isnull>N</isnull>
          <mask>#</mask>
        </value>
      </condition>
    </compare>
    <attributes/>
    <GUI>
      <xloc>656</xloc>
      <yloc>128</yloc>
    </GUI>
  </transform>
  <transform>
    <name>keys</name>
    <type>DataGrid</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <fields>
      <field>
        <name>tableField</name>
        <type/>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <set_empty_string>N</set_empty_string>
      </field>
      <field>
        <name>Comparator</name>
        <type/>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <set_empty_string>N</set_empty_string>
      </field>
      <field>
        <name>inputField</name>
        <type/>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <set_empty_string>N</set_empty_string>
      </field>
    </fields>
    <data>
      <line>
        <item>id</item>
        <item>=</item>
        <item>id</item>
      </line>
    </data>
    <attributes/>
    <GUI>
      <xloc>128</xloc>
      <yloc>224</yloc>
    </GUI>
  </transform>
  <transform>
    <name>metadata</name>
    <type>DataGrid</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <fields>
      <field>
        <name>cache?</name>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <set_empty_string>N</set_empty_string>
      </field>
      <field>
        <name>cacheSize</name>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <set_empty_string>N</set_empty_string>
      </field>
      <field>
        <name>connection</name>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <set_empty_string>N</set_empty_string>
      </field>
      <field>
        <name>loadAll?</name>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <set_empty_string>N</set_empty_string>
      </field>
      <field>
        <name>table</name>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <set_empty_string>N</set_empty_string>
      </field>
    </fields>
    <data>
      <line>
        <item>Y</item>
        <item>12345</item>
        <item>h2</item>
        <item>Y</item>
        <item>dblu_uuid</item>
      </line>
    </data>
    <attributes/>
    <GUI>
      <xloc>128</xloc>
      <yloc>128</yloc>
    </GUI>
  </transform>
  <transform>
    <name>myUuid &lt;&gt; '-'</name>
    <type>FilterRows</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <send_true_to/>
    <send_false_to/>
    <compare>
      <condition>
        <negated>N</negated>
        <leftvalue>myUuid</leftvalue>
        <function>&lt;></function>
        <rightvalue/>
        <value>
          <name>constant</name>
          <type>String</type>
          <text>-</text>
          <length>-1</length>
          <precision>-1</precision>
          <isnull>N</isnull>
          <mask/>
        </value>
      </condition>
    </compare>
    <attributes/>
    <GUI>
      <xloc>432</xloc>
      <yloc>128</yloc>
    </GUI>
  </transform>
  <transform>
    <name>returns</name>
    <type>DataGrid</type>
    <description/>
    <distribute>Y</distribute>
    <custom_distribution/>
    <copies>1</copies>
    <partitioning>
      <method>none</method>
      <schema_name/>
    </partitioning>
    <fields>
      <field>
        <name>tableField</name>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <set_empty_string>N</set_empty_string>
      </field>
      <field>
        <name>rename</name>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <set_empty_string>N</set_empty_string>
      </field>
      <field>
        <name>defaultValue</name>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <set_empty_string>N</set_empty_string>
      </field>
      <field>
        <name>defaultType</name>
        <type>String</type>
        <format/>
        <currency/>
        <decimal/>
        <group/>
        <length>-1</length>
        <precision>-1</precision>
        <set_empty_string>N</set_empty_string>
      </field>
    </fields>
    <data>
      <line>
        <item>uuid</item>
        <item>myUuid</item>
        <item>-</item>
        <item>String</item>
      </line>
    </data>
    <attributes/>
    <GUI>
      <xloc>128</xloc>
      <yloc>304</yloc>
    </GUI>
  </transform>
  <transform_error_handling>
  </transform_error_handling>
  <attributes/>
</pipeline>