#foreach ($column in $columns) #end select#foreach($column in $columns) $column.columnName#if($velocityCount != $columns.size()),#end#end from ${tableName} #foreach($column in $columns) and $column.columnName = #{$column.attrname} #end where ${primaryKey.columnName} = #{${primaryKey.attrname}} insert into ${tableName} #foreach($column in $columns) #if($column.columnName != $primaryKey.columnName || $primaryKey.extra != 'auto_increment') $column.columnName, #end #end #foreach($column in $columns) #if($column.columnName != $primaryKey.columnName || $primaryKey.extra != 'auto_increment') #{$column.attrname}, #end #end update ${tableName} #foreach($column in $columns) #if($column.columnName != $primaryKey.columnName) $column.columnName = #{$column.attrname}, #end #end where ${primaryKey.columnName} = #{${primaryKey.attrname}} delete from ${tableName} where ${primaryKey.columnName} = #{${primaryKey.attrname}} delete from ${tableName} where ${primaryKey.columnName} in #{${primaryKey.attrname}}