marianogonzalez

<set-variable variableName="table" value="PLANET"/>
<db:select config-ref="dbConfig">
 <db:sql>#["SELECT * FROM $(vars.table) WHERE name = :name"]</db:sql>
 <db:input-parameters>
   #[{'name' : payload}]
 </db:input-parameters>
</db:select>

marianogonzalez

<sfdc:query query="dsql:...">
  <repeatable-in-memory-iterable
    initialBufferSize="100"
    bufferSizeIncrement="100"
    maxBufferSize="500" />
</sfdc:query>

marianogonzalez

<sfdc:query query="dsql:...">
  <ee:repeatable-file-store-iterable inMemoryObjects="100"/>
</sfdc:query>

marianogonzalez

<sfdc:query query="dsql:..." />

marianogonzalez

<try transactionalAction="ALWAYS_BEGIN">
  <db:update config-ref="db">
    <db:sql>UPDATE ACCOUNT set BALANCE = BALANCE - :money where ID = :source</db:sql>
    <db:input-parameters>#[{'money' : payload.money, 'source': payload.source}]</db:input-parameters>
  </db:update>

  <db:update config-ref="db">
    <db:sql>UPDATE ACCOUNT set BALANCE = BALANCE + :money where ID = :target</db:sql>
    <db:input-parameters>#[{'money' : payload.money, 'target'': payload.target}]</db:input-parameters>
  </db:update>

marianogonzalez

<db:update config-ref=”db”>
  <db:sql>UPDATE ACCOUNT set BALANCE = BALANCE - :money where ID = :source</db:sql>
  <db:input-parameters>#[{‘money’ : payload.money, ‘source’: payload.source}]</db:input-parameters>
</db:update>

<db:update config-ref=”db”>
  <db:sql>UPDATE ACCOUNT set BALANCE = BALANCE + :money where ID = :target</db:sql>
  <db:input-parameters>#[{‘money’ : payload.money, ‘target’’: payload.target}]</db:input-parameters>
</db:update>

marianogonzalez

<db:execute-script config-ref="dbConfig" file="integration/executescript/bulk-script.sql" />

marianogonzalez

<db:execute-script config-ref="dbConfig">
  <db:sql>
    update PLANET set NAME='Mercury' where POSITION=0;
    update PLANET set NAME='Mercury' where POSITION=4
  </db:sql>
</db:execute-script>

marianogonzalez

<db:execute-ddl config-ref="dbConfig" queryTimeout="10" queryTimeoutUnit="SECONDS">
  <db:sql>
    create TABLE patients (
    PATIENT_ID integer NOT NULL UNIQUE,
    FIRST_NAME varchar(255),
    LAST_NAME varchar(800),
    PHONE varchar(20),
    DATE_OF_BIRTH varchar(20),
    GENDER varchar(1))
  </db:sql>

marianogonzalez

<db:stored-procedure config-ref="dbConfig">
  <db:sql>{ call doubleMyInt(:myInt) }</db:sql>
  <db:in-out-parameters>
    <db:in-out-parameter key="myInt" value="3"/>
  </db:in-out-parameters>
</db:stored-procedure>