## ============================================================================
## Filename : SQLInsertQueryTemplate.vm
## Note(s)  : This template is used to generate SQL insert statement to insert
##            a row into a table.
##
## Copyright (c) 2007-2008 ThinkUI Software Inc. All rights reserved.
## ============================================================================
##
## ****************************************************************************
## The following variables are available in this template.  For more
## information on any of the following variable, please refer to the user guide.
## ****************************************************************************
## $projectName
## $authorName
## $headerText
## $tableName
## $schemaName
## $prjPkgName
## $prjClassPrefix
## $dataClass
## $dataObject
## $date
## $codeGen
## $updatedByTrigger
## $attributes
## $stmtSeparator
##
INSERT INTO ${schemaName.toLowerCase()}.${tableName.toLowerCase()} (#set( $firstItem = 1 )#foreach( $attr in $attributes )
#if ($firstItem == 1) #set( $firstItem = 0 )${codeGen.getColumnName($attr)}
#else
    ,${codeGen.getColumnName($attr)}
#end
#end
) VALUES (#set( $firstItem = 1 )#foreach( $attr in $attributes )
#if ($firstItem == 1) #set( $firstItem = 0 )$codeGen.formatJDBC($dataObject, $attr)
#else
    ,$codeGen.formatJDBC($dataObject, $attr)
#end
#end
)${stmtSeparator}