ipreparedcomponent_sql_preparelater.xaction

<?xml version="1.0" encoding="UTF-8"?>
<action-sequence> 
  <title>IPreparedComponent Available Test</title>
  <version>1</version>
  <logging-level>DEBUG</logging-level>
  <documentation> 
    <author>Will Gorman</author>  
    <description>This tests the SQLBaseComponent's implementation of the IPreparedComponent interface, verifying that we can gain access to the component</description>  
    <help/>  
    <result-type>rule</result-type>
    <icon/> 
  </documentation>

	<inputs/>
	<outputs>
		<prepared_component>
			<type>prepared_component</type>
		</prepared_component>
                <second_prepared_component>
                        <type>prepared_component</type>
                </second_prepared_component>
	</outputs>
  <resources/>
  
  <actions>

      <!-- create a prepared_component -->

    <action-definition>
      <component-name>SQLLookupRule</component-name>
      <action-type>Get Component</action-type>
      <action-inputs/>
      <action-outputs>
        <prepared_component/>
      </action-outputs>
      <component-definition>
        <jndi>SampleData</jndi>
        <query><![CDATA[SELECT COUNT(*) FROM QUADRANT_ACTUALS WHERE REGION='Western' AND DEPARTMENT='Sales' ]]></query>
      </component-definition>
    </action-definition>

    <action-definition>
      <component-name>SQLLookupRule</component-name>
      <action-type>Get Second Component</action-type>
      <action-inputs>
         <prepared_component/>
      </action-inputs>
      <action-outputs>
        <prepared_component mapping="second_prepared_component"/>
      </action-outputs>
      <component-definition>
        <REGION>Western</REGION>
        <query><![CDATA[SELECT COUNT(*) FROM QUADRANT_ACTUALS WHERE REGION={PREPARE:REGION} AND DEPARTMENT={PREPARELATER:DEPARTMENT}]]></query>
      </component-definition>
    </action-definition>

  </actions> 
</action-sequence>