cvs commit: jakarta-turbine/conf/torque/templates/sql/base/sapdb columns.vm drop.vm foreignkey.vm index.vm primarykey.vm sequence.vm table.vm tablefk.vm unique.vm

[jvanzyl]

jvanzyl     01/05/26 19:45:07

  Added:       conf/torque/templates/sql/base/sapdb columns.vm drop.vm
                        foreignkey.vm index.vm primarykey.vm sequence.vm
                        table.vm tablefk.vm unique.vm
  Log:
  - sapdb support for torque
  
  Revision  Changes    Path
  1.1                  jakarta-turbine/conf/torque/templates/sql/base/sapdb/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 ( $entry = "$col.Name $type $size $default $nullString," )
      $strings.sub($strings.collapseSpaces($entry)," ,",",")
  #end
  
  
  
  1.1                  jakarta-turbine/conf/torque/templates/sql/base/sapdb/drop.vm
  
  Index: drop.vm
  ===================================================================
  drop table $table.Name cascade constraints;
  #foreach ($col in $table.Columns)
  #if ($col.isAutoIncrement())
  drop sequence ${table.Name}_SEQ;
  #end
  #end
  
  
  
  1.1                  
jakarta-turbine/conf/torque/templates/sql/base/sapdb/foreignkey.vm
  
  Index: foreignkey.vm
  ===================================================================
  #foreach ($fk in $table.ForeignKeys)
  ALTER TABLE $table.Name
      ADD CONSTRAINT ${table.Name}_FK_${velocityCount} FOREIGN KEY 
($fk.LocalColumnNames)
      REFERENCES $fk.ForeignTableName ($fk.ForeignColumnNames)
  ;
  
  #end
  
  
  
  1.1                  jakarta-turbine/conf/torque/templates/sql/base/sapdb/index.vm
  
  Index: index.vm
  ===================================================================
  #foreach ($index in $table.Indices)
  CREATE #if($index.IsUnique)UNIQUE#end INDEX $index.IndexName ON $table.Name 
($index.IndexColumnList);
  #end
  
  
  
  1.1                  
jakarta-turbine/conf/torque/templates/sql/base/sapdb/primarykey.vm
  
  Index: primarykey.vm
  ===================================================================
  ALTER TABLE $table.Name
      ADD CONSTRAINT ${table.Name}_PK 
  PRIMARY KEY ($table.printPrimaryKey());
  
  
  
  1.1                  jakarta-turbine/conf/torque/templates/sql/base/sapdb/sequence.vm
  
  Index: sequence.vm
  ===================================================================
  #if ($table.IdMethod == "sequence")
  CREATE SEQUENCE $table.SequenceName;
  #end
  
  
  
  1.1                  jakarta-turbine/conf/torque/templates/sql/base/sapdb/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 ( $unique = $generator.parse("$basepath/unique.vm", "", "table", $tbl) )
  #if($strings.allEmpty([$unique]))$strings.chop($cols,2)#else$cols#end
  #if($unique.length()>0)$strings.chop($unique,2)#end
  
  );
  
  #set ( $pk = $generator.parse("$basepath/primarykey.vm", "", "table", $tbl) )
  #if($pk.length()>0)$pk#end
  
  #set ( $index = $generator.parse("$basepath/index.vm", "", "table", $tbl) )
  #if($index.length() > 0)$index#end
  
  #set ( $sequence = $generator.parse("$basepath/sequence.vm", "", "table", $tbl) )
  #if ($sequence.length()>0)$sequence#end
  
  
  
  1.1                  jakarta-turbine/conf/torque/templates/sql/base/sapdb/tablefk.vm
  
  Index: tablefk.vm
  ===================================================================
  #set ( $fk = $generator.parse("$basepath/foreignkey.vm", "", "table", $tbl) )
  #if ($fk.length()>0)$fk#end
  
  
  
  
  1.1                  jakarta-turbine/conf/torque/templates/sql/base/sapdb/unique.vm
  
  Index: unique.vm
  ===================================================================
  #foreach ($unique in $table.Unices)
      UNIQUE ($unique.ColumnList),
  #end
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]