jvanzyl 01/11/11 21:27:26
Added: src/templates/sql/base/cloudscape columns.vm drop.vm
foreignkey.vm index.vm primarykey.vm table.vm
tablefk.vm unique.vm
Log:
- templates for cloudscape support
Revision Changes Path
1.1
jakarta-turbine-torque/src/templates/sql/base/cloudscape/columns.vm
Index: columns.vm
===================================================================
#foreach ($col in $table.Columns)
#set ( $type = $dbprops.get($col.Type) )
#set ( $size = $col.printSize() )
#set ( $default = $col.DefaultSetting )
#set ( $nullString = $strings.select($col.isNotNull(),
$dbprops.get("NOTNULL"),"") )
#set ( $autoIncrement = $strings.select($col.isAutoIncrement(),
$dbprops.get("AUTOINCREMENT"),"") )
#set ( $entry = "$col.Name $type $size $autoIncrement," )
$strings.sub($strings.collapseSpaces($entry)," ,",",")
#end
1.1 jakarta-turbine-torque/src/templates/sql/base/cloudscape/drop.vm
Index: drop.vm
===================================================================
drop table if exists $table.Name;
1.1
jakarta-turbine-torque/src/templates/sql/base/cloudscape/foreignkey.vm
Index: foreignkey.vm
===================================================================
#foreach ($fk in $table.ForeignKeys)
FOREIGN KEY ($fk.LocalColumnNames) REFERENCES $fk.ForeignTableName
($fk.ForeignColumnNames),
#end
1.1
jakarta-turbine-torque/src/templates/sql/base/cloudscape/index.vm
Index: index.vm
===================================================================
#foreach ($index in $table.Indices)
CREATE #if($index.Unique)UNIQUE#end INDEX $index.Name ON $table.Name
($index.ColumnList);
#end
1.1
jakarta-turbine-torque/src/templates/sql/base/cloudscape/primarykey.vm
Index: primarykey.vm
===================================================================
PRIMARY KEY($table.printPrimaryKey()),
1.1
jakarta-turbine-torque/src/templates/sql/base/cloudscape/table.vm
Index: table.vm
===================================================================
-----------------------------------------------------------------------------
-- $table.Name
-----------------------------------------------------------------------------
##$generator.parse("$basepath/drop.vm", "", "table", $tbl)
CREATE TABLE $table.Name
(
#set ( $cols = $generator.parse("$basepath/columns.vm", "", "table", $tbl) )
#set ( $pk = $generator.parse("$basepath/primarykey.vm", "", "table", $tbl) )
##set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
#set ( $unique = $generator.parse("$basepath/unique.vm", "", "table", $tbl) )
#set ( $index = $generator.parse("$basepath/index.vm", "", "table", $tbl) )
#if($strings.allEmpty([$pk,$unique]))$strings.chop($cols,1)#else$cols#end
#if($strings.allEmpty([$unique]) && $pk.length()>0)$strings.chop($pk,2)#else$pk#end
##if($strings.allEmpty([$unique,$index]) && $fk.length()
>0)$strings.chop($fk,2)#else$fk#end
#if($unique.length()>0)$strings.chop($unique,2)#else$unique#end
);
#if($index.length() > 0)$strings.chop($index,1)#end
1.1
jakarta-turbine-torque/src/templates/sql/base/cloudscape/tablefk.vm
<<Binary file>>
1.1
jakarta-turbine-torque/src/templates/sql/base/cloudscape/unique.vm
Index: unique.vm
===================================================================
#foreach ($unique in $table.Unices)
UNIQUE ($unique.ColumnList),
#end
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
