templates.sm.mapper.tpl Maven / Gradle / Ivy
<#if Autos??>
<#list Autos as item>
<#assign info=item?split("#")>
#list>
#if>
insert into ${table}
(<#if Autos??><#list Autos as item><#assign info=item?split("#")>${info[8]}<#if item_has_next>,#if>#list>#if>)
values
(<#if Autos??><#list Autos as item><#assign info=item?split("#")>${r"#{"}${info[0]}}<#if item_has_next>,#if>#list>#if>)
update ${table}
set
<#if Autos??><#list Autos as item><#assign info=item?split("#")>${info[8]}=${r"#{"}${info[0]}}<#if item_has_next>,#if>#list>#if>
where ${oidColumn}=${r"#{"}${Oid}}
delete from ${table} where ${oidColumn}=${r"#{"}${Oid}}
delete from ${table}
WHERE ${oidColumn} in
${r"#{"}item}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy