INSERT INTO ${tableName} (
<% for(column in columns!) { %>
<% if(column.columnName != pk.columnName || pk.extra != 'auto_increment') { %>
`${column.columnName}`<% if(!columnLP.last) { %>, <% } %>
<% } %>
<% } %>
)
VALUES (
<% for(column in columns!) { %>
<% if(column.columnName != pk.columnName || pk.extra != 'auto_increment') { %>
#{${column.fieldName}}<% if(!columnLP.last) { %>, <% } %>
<% } %>
<% } %>
)
UPDATE ${tableName}
<% for(column in columns!) { %>
<% if(column.columnName != pk.columnName) { %>
`${column.columnName}` = #{${column.fieldName}}<% if(!columnLP.last) { %>, <% } %>
<% } %>
<% } %>
WHERE
${pk.columnName} = #{${pk.fieldName}}
DELETE
FROM
${tableName}
WHERE
${pk.columnName} IN
#{id}