<?xml-stylesheet type="text/xsl" href="delivery.xsl"?>
<delivery id="Data from the XYZ System">

   <destparms name="MSSQLParms">
      <descr>Paradevs needed for access to the database</descr>
      <param name="url"
         value="jdbc:microsoft:sqlserver://host.name:1433"/>
      <param name="driver"
         value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
      <param name="username" value="user"/>
      <param name="password" value="password"/>
      <param name="type" value="mssql"/>
      <param name="transact" value="14400"/>
      <param name="maxidle" value="14400"/>
      <procedure call="execute">
         <prefix val="{call "/>
         <suffix val="}"/>
      </procedure>
   </destparms>

   <fieldvaluemap name="dataMap">
      <descr>
      Map the fields for storing into the database.
      </descr>
      <store field="mtype" as="devtype"/>
      <store field="dev_station" as="dev_station" key="yes"/>
      <store field="dev" as="dev" key="yes"/>
      <store field="systimestamp" as="prod_date_time" key="yes"/>
      <store field="subhour" as="subhour" key="yes"/>
      <store field="minflow" as="flowtime"/>
      <store field="mcf" as="mcf_1473"/>
      <store field="dtf" as="energy"/>
      <store field="dp" as="dp"/>
      <store field="rawpress" as="psia_pres"/>
      <store field="temp" as="temperature"/>
      <store field="unc_vol" as="unc_vol"/>
      <store field="intext" as="intext"/>
      <store field="pb_status" as="pb_status"/>
      <store field="datasource" as="data_source"/>
      <store field="seq" as="sequence_num"/>
      <store field="gmtstamp" as="gmt_time"/>
      <store field="offset" as="gmt_offset"/>
   </fieldvaluemap>

   <deliveredby name="dataDeliv">
      <descr>
      Delivery description for storing data to the database.
      </descr>
      <lookup>

         
         <!-- lookup data parameters for this device and do pre-store
              conversions
           -->
         <select sql="select atmospheric_pressure,type,effective_date_time from schema.dev_characteristic where dev_station=? and dev=?  and effective_date_time = (select max(effective_date_time) from schema.dev_characteristic where dev_station = ? and dev=?)">
            <arg><ref field="dev_station"/></arg>
            <arg><ref field="dev"/></arg>
            <arg><ref field="dev_station"/></arg>
            <arg><ref field="dev"/></arg>
         </select>

         <!-- process values from parameter lookup -->
         <set field="dev_type" type="string" from="type"/>
         <set field="atmospheric_pressure" type="float"
		from="atmospheric_pressure"/>
         <set field="rawpress" type="float">
            <ref field="press">
               <add field="atmospheric_pressure"/>
            </ref>
         </set>

         <!-- handle other data conversion/mapping -->
         <set field="isorifice" type="boolean">
            <ref field="dev_type">
               <contains pattern="ORIFICE"/>
               <convert to="string"/>
            </ref>
         </set>
         <set field="unc_vol" type="float">
            <when field="isorifice">
               <eq val="true">
                  <null type="FLOAT"/>
               </eq>
               <else>
                  <ref field="sqrtextn"/>
               </else>
            </when>
         </set>
         <set field="intext" type="float">
            <when field="isorifice">
               <eq val="true">
                  <ref field="sqrtextn"/>
               </eq>
               <else>
                  <ref field="zero"/>
               </else>
            </when>
         </set>
         <set field="dp" type="float">
            <when field="isorifice">
               <eq val="true">
                  <ref field="dp"/>
               </eq>
               <else>
                  <ref field="zero"/>
               </else>
            </when>
         </set>
         <set field="mtype" type="string">
            <when field="isorifice">
               <eq val="true">
                  <ref field="orifice"/>
               </eq>
               <else>
                  <ref field="other"/>
               </else>
            </when>
         </set>
      </lookup>

      <!-- perform the JDBC "insert" -->
      <write/>
   </deliveredby>

   <model report="dataReport">
      <descr>
      Model for storing data to the appropriate destinations
      </descr>
      <deliver
         location="schema.table_name"
         deliveredby="dataDeliv"
         fieldvaluemap="dataMap"
         destparms="MSSQLParms"
         destination="DataStore"
      />
   </model>
</delivery>