Skip to content

Instantly share code, notes, and snippets.

Mariano Gonzalez marianogonzalez

Block or report user

Report or block marianogonzalez

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View dynamicquery.xml
<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>
View paging3.xml
<sfdc:query query="dsql:...">
<repeatable-in-memory-iterable
initialBufferSize="100"
bufferSizeIncrement="100"
maxBufferSize="500" />
</sfdc:query>
View paging2.xml
<sfdc:query query="dsql:...">
<ee:repeatable-file-store-iterable inMemoryObjects="100"/>
</sfdc:query>
View tx2.xml
<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>
View tx.xml
<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>
View script2.xml
<db:execute-script config-ref="dbConfig" file="integration/executescript/bulk-script.sql" />
View script1.xml
<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>
View ddl.xml
<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>
View sp3.xml
<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>
You can’t perform that action at this time.