Skip to main content

SQL-Level Operations

db:select — Select Query​

Builds and executes a SELECT query.

Syntax​

XML
<db:select var_result="users" type="assoc">
    <db:fields>
        <db:field>firstname</db:field>
        <db:field>lastname</db:field>
    </db:fields>
    <db:table>contacts</db:table>
    <db:is field="type">user</db:is>
</db:select>

Joins​

Use <db:join> with <db:inner> or <db:left>.

XML
<db:join>
    <db:inner table="accounts" field1="accounts.id" field2="contacts.account"/>
</db:join>

db:insert / db:update / db:delete​

Structured Write operations.

Transactions​

Wrap write operations in db:transaction for atomicity.

XML
<db:transaction>
    <!-- multiple write operations -->
</db:transaction>