| #set ($db = $table.Database) |
| #if ($db.Package) |
| #set ($package = $db.Package) |
| #else |
| #set ($package = $targetPackage) |
| #end |
| package ${package}; |
| |
| #if ($table.BaseClass == "") |
| #set ($extendsBaseClass = "" ) |
| #else |
| #set ($extendsBaseClass = "extends $table.BaseClass" ) |
| #end |
| |
| import java.util.*; |
| import java.math.*; |
| import org.apache.turbine.om.*; |
| import org.apache.turbine.om.peer.BasePeer; |
| import org.apache.turbine.util.db.Criteria; |
| #if ($addSaveMethod) |
| import org.apache.turbine.util.ObjectUtils; |
| #end |
| import org.apache.turbine.util.StringUtils; |
| import org.apache.turbine.util.ParameterParser; |
| import org.apache.turbine.util.Log; |
| import org.apache.turbine.util.db.pool.DBConnection; |
| #if (!$complexObjectModel) |
| import org.apache.turbine.services.db.TurbineDB; |
| #end |
| |
| /** |
| #if ($addTimeStamp) |
| * This class was autogenerated by Torque on: |
| * |
| * [$now] |
| * |
| #end |
| * You should not use this class directly. It should not even be |
| * extended all references should be to $table.JavaName |
| */ |
| public abstract class $basePrefix$table.JavaName $extendsBaseClass |
| implements Retrievable |
| { |
| #if (!$table.isAlias()) |
| #foreach ($col in $table.Columns) |
| #set ( $cjtype = $col.JavaNative ) |
| #set ( $clo=$col.Name.toLowerCase() ) |
| #set ($defVal = "") |
| #if ($col.DefaultValue && !$col.DefaultValue.equalsIgnoreCase("NULL") ) |
| #set ( $quote = '' ) |
| #if ( $cjtype == "String" ) |
| #set ( $quote = '"' ) |
| #end |
| #set ( $defaultValue = $col.DefaultValue ) |
| #if ( $cjtype == "boolean" ) |
| #if ( $defaultValue == "1" || $defaultValue == "Y" ) |
| #set ( $defaultValue = "true" ) |
| #elseif ( $defaultValue == "0" || $defaultValue == "N" ) |
| #set ( $defaultValue = "false" ) |
| #end |
| #end |
| #if ($cjtype == "BigDecimal") |
| #set ($defVal = "= new BigDecimal($defaultValue)") |
| #else |
| #set ($defVal = "=$quote$defaultValue$quote") |
| #end |
| #end |
| /** the value for the $clo field */ |
| private $cjtype $clo$defVal; |
| #end |
| |
| |
| #foreach ($col in $table.Columns) |
| #set ( $cfc=$col.JavaName ) |
| #set ( $clo=$col.Name.toLowerCase() ) |
| #set ( $cjtype = $col.JavaNative ) |
| /** |
| * Get the $cfc |
| * @return $cjtype |
| */ |
| public $cjtype get${cfc}() |
| { |
| return $clo; |
| } |
| |
| #set ( $throwsClause = "" ) |
| #if ($complexObjectModel) |
| #if ($col.isForeignKey()) |
| #set ( $throwsClause = "throws Exception" ) |
| #end |
| #if ( $col.Referrers.size() > 0 ) |
| #if ($throwsClause == "") |
| #set ( $throwsClause = "throws Exception" ) |
| #end |
| #end |
| #end |
| |
| /** |
| * Set the value of $cfc |
| */ |
| public void set${cfc}($cjtype v ) $throwsClause |
| { |
| #if ($complexObjectModel) |
| #if ($col.isForeignKey()) |
| #set ( $tmp = $col.RelatedTableName ) |
| #set ( $tblFK = $table.Database.getTable($tmp) ) |
| #set ( $colFK = $tblFK.getColumn($col.RelatedColumnName) ) |
| #if ($col.isMultipleFK()) |
| #set ( $varName = $strings.concat(["a", $tblFK.JavaName, "RelatedBy", $col.JavaName]) ) |
| #elseif ($tmp.equals($table.Name)) |
| #set ( $varName = $strings.concat(["a", $tblFK.JavaName, "RelatedBy", $col.JavaName]) ) |
| #else |
| #set ( $varName = $strings.concat(["a", $tblFK.JavaName]) ) |
| #end |
| $varName = null; |
| #end |
| |
| #foreach ($fk in $col.Referrers) |
| #set ( $fkColName = $fk.ForeignLocalMapping.get($col.Name) ) |
| #set ( $tblFK = $fk.Table ) |
| #if ( !($tblFK.Name.equals($table.Name)) ) |
| |
| #set ( $colFK = $tblFK.getColumn($fkColName) ) |
| |
| #if ($colFK.isMultipleFK()) |
| #set ( $collName = $strings.concat(["coll", $tblFK.JavaName, "sRelatedBy", $colFK.JavaName]) ) |
| #else |
| #set ( $collName = $strings.concat(["coll", $tblFK.JavaName, "s"]) ) |
| #end |
| |
| // update associated $tblFK.JavaName |
| if ($collName != null ) |
| { |
| for (int i=0; i<${collName}.size(); i++) |
| { |
| ((${tblFK.JavaName})${collName}.get(i)) |
| .set${colFK.JavaName}(v); |
| } |
| } |
| #end |
| #end |
| #end |
| |
| #if ($addSaveMethod) |
| |
| #if ( ($cjtype == "int") || ($cjtype == "long") || ($cjtype == "boolean") |
| || ($cjtype == "short") || ($cjtype == "float") || ($cjtype == "double") |
| || ($cjtype == "char") || ($cjtype == "byte") ) |
| if (this.$clo != v) |
| { |
| #else |
| if ( !ObjectUtils.equals(this.$clo, v) ) |
| { |
| #end |
| #if ( ($cjtype == "NumberKey") |
| || ($cjtype == "StringKey") |
| || ($cjtype == "DateKey") ) |
| if (this.$clo == null) |
| { |
| this.$clo = new $cjtype(v); |
| } |
| else |
| { |
| this.${clo}.setValue(v); |
| } |
| #else |
| this.$clo = v; |
| #end |
| setModified(true); |
| } |
| #else |
| this.$clo = v; |
| #end |
| } |
| |
| ##if ($complexObjectModel) |
| #if ($col.isPrimaryKey() || $col.isForeignKey()) |
| /** |
| * Set the value of $cfc as a string. |
| */ |
| public void set${cfc}(String v ) $throwsClause |
| { |
| set${cfc}(new ${cjtype}(v)); |
| } |
| #end |
| ##end |
| |
| #end |
| #end |
| |
| ##association code |
| |
| #if ($complexObjectModel) |
| #foreach ($fk in $table.ForeignKeys) |
| |
| #set ( $tmp = $fk.ForeignTableName ) |
| #set ( $tblFK = $table.Database.getTable($tmp) ) |
| #set ( $className = $tblFK.JavaName ) |
| |
| #set ( $relCol = "" ) |
| #foreach ($columnName in $fk.LocalColumns) |
| #set ( $column = $table.getColumn($columnName) ) |
| #if ($column.isMultipleFK()) |
| #set ( $relCol = $strings.concat([$relCol, $column.JavaName]) ) |
| #elseif ($tmp.equals($table.Name)) |
| #set ( $relCol = $strings.concat([$relCol, $column.JavaName]) ) |
| #end |
| #end |
| |
| #if ($relCol != "") |
| #set ( $relCol = $strings.concat(["RelatedBy", $relCol]) ) |
| #end |
| |
| #set ( $pVarName = $strings.concat([$className, $relCol]) ) |
| #set ( $varName = $strings.concat(["a", $pVarName]) ) |
| |
| private $className $varName; |
| |
| /** |
| * Declares an association between this object and a $className object |
| * |
| * @param $className v |
| */ |
| public void set${pVarName}($className v) throws Exception |
| { |
| #foreach ($columnName in $fk.LocalColumns) |
| #set ( $column = $table.getColumn($columnName) ) |
| #set ( $colFKName = $fk.LocalForeignMapping.get($columnName) ) |
| #set ( $colFK = $tblFK.getColumn($colFKName) ) |
| set${column.JavaName}(v.get${colFK.JavaName}()); |
| #end |
| $varName = v; |
| } |
| |
| #set ( $and = "" ) |
| #set ( $comma = "" ) |
| #set ( $conditional = "" ) |
| #set ( $arglist = "" ) |
| #foreach ($columnName in $fk.LocalColumns) |
| #set ( $column = $table.getColumn($columnName) ) |
| #set ( $cjtype = $column.JavaNative ) |
| #set ( $clo=$column.Name.toLowerCase() ) |
| #if ($cjtype == "int") |
| #set ( $conditional = $strings.concat([$conditional, $and, "this.", $clo, ">0"]) ) |
| #elseif ($cjtype == "long") |
| #set ( $conditional = $strings.concat([$conditional, $and, "this.", $clo, ">0"]) ) |
| #elseif ($cjtype == "short") |
| #set ( $conditional = $strings.concat([$conditional, $and, "this.", $clo, ">0"]) ) |
| #else |
| #set ( $conditional = $strings.concat([$conditional, $and, "!ObjectUtils.equals(this.", $clo, ", null)"]) ) |
| #end |
| #set ( $arglist = $strings.concat([$arglist, $comma, "this.", $clo]) ) |
| #set ( $and = " && " ) |
| #set ( $comma = ", " ) |
| #end |
| #set ( $pCollName = $strings.concat([$table.JavaName, "s", $relCol]) ) |
| |
| public $className get${pVarName}() throws Exception |
| { |
| if ( $varName==null && ($conditional) ) |
| { |
| $varName = ${className}Peer.retrieveByPK($arglist); |
| // The following can be used instead of the line above to |
| // guarantee the related object contains a reference |
| // to this object, but this level of coupling |
| // may be undesirable in many circumstances. |
| // As it can lead to a db query with many results that may |
| // never be used. |
| // $className obj = ${className}Peer.retrieveByPK($arglist); |
| // obj.add${pCollName}(this); |
| } |
| return $varName; |
| } |
| |
| |
| /** |
| * Provides convenient way to set a relationship based on a |
| * ObjectKey. e.g. |
| * <code>bar.setFooKey(foo.getPrimaryKey())</code> |
| * |
| #if ($fk.LocalColumns.size() > 1) |
| * Note: It is important that the xml schema used to create this class |
| * maintains consistency in the order of related columns between |
| * $table.Name and ${tblFK.Name}. |
| * If for some reason this is impossible, this method should be |
| * overridden in <code>$table.JavaName</code>. |
| #end |
| */ |
| public void set${pVarName}Key(ObjectKey key) throws Exception |
| { |
| #if ($fk.LocalColumns.size() > 1) |
| SimpleKey[] keys = (SimpleKey[])key.getValue(); |
| #set ($i = 0) |
| #foreach ($colName in $fk.LocalColumns) |
| #set ($col = $table.getColumn($colName) ) |
| set${col.JavaName}(($col.JavaNative)keys[$i]); |
| #set ( $i = $i + 1 ) |
| #end |
| #else |
| #set ($colName = $fk.LocalColumns.get(0)) |
| #set ($col = $table.getColumn($colName) ) |
| set${col.JavaName}(($col.JavaNative)key); |
| #end |
| } |
| |
| #end ## end of foreach loop over foreign keys |
| |
| ## |
| ## setup foreign key associations |
| ## |
| #foreach ($fk in $table.Referrers) |
| #set ( $tblFK = $fk.Table ) |
| #if ( !($tblFK.Name.equals($table.Name)) ) |
| #set ( $className = $tblFK.JavaName ) |
| #set ( $relatedByCol = "" ) |
| #foreach ($columnName in $fk.LocalColumns) |
| #set ( $column = $tblFK.getColumn($columnName) ) |
| #if ($column.isMultipleFK()) |
| #set ($relatedByCol=$strings.concat([$relatedByCol,$column.JavaName])) |
| #end |
| #end |
| |
| #if ($relatedByCol == "") |
| #set ( $suffix = "" ) |
| #set ( $relCol = $strings.concat([$className, "s"]) ) |
| #set ( $relColMs = $className ) |
| #else |
| #set ( $suffix = $strings.concat(["RelatedBy", $relatedByCol]) ) |
| #set ( $relCol=$strings.concat([$className,"sRelatedBy",$relatedByCol])) |
| #set ( $relColMs=$strings.concat([$className,"RelatedBy",$relatedByCol])) |
| #end |
| #set ( $collName = $strings.concat(["coll", $relCol]) ) |
| |
| /** |
| * Collection to store aggregation of $collName |
| */ |
| protected Vector $collName; |
| /** |
| * Temporary storage of $collName to save a possible db hit in |
| * the event objects are add to the collection, but the |
| * complete collection is never requested. |
| */ |
| // private Vector temp$collName; |
| |
| protected void init${relCol}() |
| { |
| if ($collName == null) |
| $collName = new Vector(); |
| } |
| |
| /** |
| * Method called to associate a $tblFK.JavaName object to this object |
| * through the $className foreign key attribute |
| * |
| * @param $className l |
| */ |
| public void add${relColMs}($className l) throws Exception |
| { |
| /* |
| if ($collName == null) |
| { |
| if (temp$collName == null) |
| { |
| temp$collName = new Vector(); |
| } |
| temp${collName}.add(l); |
| } |
| else |
| { |
| ${collName}.add(l); |
| } |
| */ |
| get${relCol}().add(l); |
| l.set${table.JavaName}${suffix}(($table.JavaName)this); |
| } |
| |
| /** |
| * The criteria used to select the current contents of $collName |
| */ |
| private Criteria last${relCol}Criteria = null; |
| |
| /** |
| * If this collection has already been initialized, returns |
| * the collection. Otherwise returns the results of |
| * get${relCol}(new Criteria()) |
| */ |
| public Vector get${relCol}() throws Exception |
| { |
| if ($collName == null) |
| { |
| $collName = get${relCol}(new Criteria(10)); |
| } |
| return $collName; |
| } |
| |
| /** |
| * If this collection has already been initialized with |
| * an identical criteria, it returns the collection. |
| * Otherwise if this $table.JavaName has previously |
| * been saved, it will retrieve related ${relCol} from storage. |
| * If this $table.JavaName is new, it will return |
| * an empty collection or the current collection, the criteria |
| * is ignored on a new object. |
| */ |
| public Vector get${relCol}(Criteria criteria) throws Exception |
| { |
| if ($collName == null) |
| { |
| if ( isNew() ) |
| { |
| $collName = new Vector(); |
| } |
| else |
| { |
| #foreach ($columnName in $fk.ForeignColumns) |
| #set ( $column = $table.getColumn($columnName) ) |
| #set ( $colFKName = $fk.ForeignLocalMapping.get($columnName) ) |
| #set ( $colFK = $tblFK.getColumn($colFKName) ) |
| criteria.add(${className}Peer.${colFK.Name.toUpperCase()}, get${column.JavaName}() ); |
| #end |
| $collName = ${className}Peer.doSelect(criteria); |
| } |
| /* |
| if (temp$collName != null) |
| { |
| for (int i=0; i<temp${collName}.size(); i++) |
| { |
| ${collName}.add(temp${collName}.get(i)); |
| } |
| temp$collName = null; |
| } |
| */ |
| } |
| else |
| { |
| // criteria has no effect for a new object |
| if ( !isNew() ) |
| { |
| // the following code is to determine if a new query is |
| // called for. If the criteria is the same as the last |
| // one, just return the collection. |
| #foreach ($columnName in $fk.ForeignColumns) |
| #set ( $column = $table.getColumn($columnName) ) |
| #set ( $colFKName = $fk.ForeignLocalMapping.get($columnName) ) |
| #set ( $colFK = $tblFK.getColumn($colFKName) ) |
| criteria.add(${className}Peer.${colFK.Name.toUpperCase()}, get${column.JavaName}() ); |
| #end |
| if ( !last${relCol}Criteria.equals(criteria) ) |
| { |
| $collName = ${className}Peer.doSelect(criteria); |
| } |
| } |
| } |
| last${relCol}Criteria = criteria; |
| |
| return $collName; |
| } |
| #set ( $countFK = 0 ) |
| #foreach ($dummyFK in $tblFK.ForeignKeys) |
| #set ( $countFK = $countFK + 1 ) |
| #end |
| |
| ## ------------------------------------------------------------ |
| ## |
| |
| #if ($countFK >= 1) |
| #set ( $lastTable = "" ) |
| #foreach ($fk2 in $tblFK.ForeignKeys) |
| |
| ## Add join methods if the fk2 table is not this table or |
| ## the fk2 table references this table multiple times. |
| |
| #set ( $doJoinGet = true ) |
| #if ( $fk2.ForeignTableName.equals($table.Name) ) |
| #set ( $doJoinGet = false ) |
| #end |
| |
| #foreach ($columnName in $fk2.LocalColumns) |
| #set ( $column = $tblFK.getColumn($columnName) ) |
| #if ($column.isMultipleFK()) |
| #set ( $doJoinGet = true ) |
| #end |
| #end |
| |
| #set ( $tblFK2 = $table.Database.getTable($fk2.ForeignTableName) ) |
| #set ( $relatedByCol2 = "" ) |
| #foreach ($columnName in $fk2.LocalColumns) |
| #set ( $column = $tblFK.getColumn($columnName) ) |
| #if ($column.isMultipleFK()) |
| #set($relatedByCol2=$strings.concat([$relatedByCol2,$column.JavaName])) |
| #end |
| #end |
| |
| #set ( $fkClassName = $tblFK2.JavaName ) |
| ## do not generate code for self-referencing fk's, it would be |
| ## good to do, but it is just not implemented yet. |
| #if ($className == $fkClassName) |
| #set ( $doJoinGet = false ) |
| #end |
| |
| #if ($relatedByCol2 == "") |
| #set ( $relCol2 = $fkClassName ) |
| #else |
| #set ($relCol2=$strings.concat([$fkClassName,"RelatedBy",$relatedByCol2])) |
| #end |
| |
| #if ( $relatedByCol == "") |
| #else |
| #if ( $relatedByCol.equals($relatedByCol2) ) |
| #set ( $doJoinGet = false ) |
| #end |
| #end |
| |
| #if ($doJoinGet) |
| |
| /** |
| * If this collection has already been initialized with |
| * an identical criteria, it returns the collection. |
| * Otherwise if this $table.JavaName is new, it will return |
| * an empty collection; or if this $table.JavaName has previously |
| * been saved, it will retrieve related ${relCol} from storage. |
| */ |
| protected Vector get${relCol}Join${relCol2}(Criteria criteria) |
| throws Exception |
| { |
| if ($collName == null) |
| { |
| if ( isNew() ) |
| { |
| $collName = new Vector(); |
| } |
| else |
| { |
| #foreach ($columnName in $fk.ForeignColumns) |
| #set ( $column = $table.getColumn($columnName) ) |
| #set ( $colFKName = $fk.ForeignLocalMapping.get($columnName) ) |
| #set ( $colFK = $tblFK.getColumn($colFKName) ) |
| criteria.add(${className}Peer.${colFK.Name.toUpperCase()}, get${column.JavaName}() ); |
| #end |
| $collName = ${className}Peer.doSelectJoin${relCol2}(criteria); |
| } |
| |
| #* /* |
| if (temp$collName != null) |
| { |
| for (int i=0; i<temp${collName}.size(); i++) |
| { |
| ${collName}.add(temp${collName}.get(i)); |
| } |
| temp$collName = null; |
| } |
| */ *# |
| } |
| else |
| { |
| // the following code is to determine if a new query is |
| // called for. If the criteria is the same as the last |
| // one, just return the collection. |
| boolean newCriteria = true; |
| #foreach ($columnName in $fk.ForeignColumns) |
| #set ( $column = $table.getColumn($columnName) ) |
| #set ( $colFKName = $fk.ForeignLocalMapping.get($columnName) ) |
| #set ( $colFK = $tblFK.getColumn($colFKName) ) |
| criteria.add(${className}Peer.${colFK.Name.toUpperCase()}, get${column.JavaName}() ); |
| #end |
| if ( !last${relCol}Criteria.equals(criteria) ) |
| { |
| $collName = ${className}Peer.doSelectJoin${relCol2}(criteria); |
| } |
| } |
| last${relCol}Criteria = criteria; |
| |
| return $collName; |
| } |
| #end #end #end #end |
| |
| ## =========================================================== |
| #* |
| #if ($countFK > 2) |
| |
| /** |
| * If this collection has already been initialized with |
| * an identical criteria, it returns the collection. |
| * Otherwise if this $table.JavaName is new, it will return |
| * an empty collection; or if this $table.JavaName has previously |
| * been saved, it will retrieve related ${relCol} from storage. |
| */ |
| protected Vector get${relCol}JoinAllExcept${table.JavaName}(Criteria criteria) |
| throws Exception |
| { |
| if ($collName == null) |
| { |
| if ( isNew() ) |
| { |
| $collName = new Vector(); |
| } |
| else |
| { |
| #foreach ($columnName in $fk.ForeignColumns) |
| #set ( $column = $table.getColumn($columnName) ) |
| #set ( $colFKName = $fk.ForeignLocalMapping.get($columnName) ) |
| #set ( $colFK = $tblFK.getColumn($colFKName) ) |
| criteria.add(${className}Peer.${colFK.Name.toUpperCase()}, get${column.JavaName}() ); |
| #end |
| $collName = ${className}Peer.doSelectJoinAllExcept${table.JavaName}${suffix}(criteria); |
| } |
| /* |
| if (temp$collName != null) |
| { |
| for (int i=0; i<temp${collName}.size(); i++) |
| { |
| ${collName}.add(temp${collName}.get(i)); |
| } |
| temp$collName = null; |
| } |
| */ |
| } |
| else |
| { |
| // the following code is to determine if a new query is |
| // called for. If the criteria is the same as the last |
| // one, just return the collection. |
| boolean newCriteria = true; |
| #foreach ($columnName in $fk.ForeignColumns) |
| #set ( $column = $table.getColumn($columnName) ) |
| #set ( $colFKName = $fk.ForeignLocalMapping.get($columnName) ) |
| #set ( $colFK = $tblFK.getColumn($colFKName) ) |
| criteria.add(${className}Peer.${colFK.Name.toUpperCase()}, get${column.JavaName}() ); |
| #end |
| if ( !last${relCol}Criteria.equals(criteria) ) |
| { |
| $collName = ${className}Peer.doSelectJoinAllExcept${table.JavaName}${suffix}(criteria); |
| } |
| } |
| last${relCol}Criteria = criteria; |
| |
| return $collName; |
| } |
| |
| #end |
| |
| *# |
| ## ------------------------------------------------------------ |
| |
| |
| #end ## ends foreach over table.Referrers |
| |
| #end ##ends the if(complexObjectModel) |
| |
| ## |
| ## getByName code |
| ## |
| #if (!$table.isAlias() && $addGetByNameMethod) |
| private static Vector fieldNames_ = null; |
| |
| /** |
| * Generate a list of field names. |
| */ |
| public static synchronized List getFieldNames() |
| { |
| if (fieldNames_ == null) |
| { |
| fieldNames_ = new Vector(); |
| #foreach ($col in $table.Columns) |
| fieldNames_.add("${col.JavaName}"); |
| #end |
| } |
| return fieldNames_; |
| } |
| |
| /** |
| * Retrieves a field from the object by name passed in |
| * as a String. |
| */ |
| public Object getByName(String name) |
| { |
| #foreach ($col in $table.Columns) |
| #set ( $cfc = $col.JavaName ) |
| #set ( $cjtype = $col.JavaNative ) |
| if (name.equals("${col.JavaName}")) |
| { |
| #if ($cjtype == "int") |
| return new Integer(get${cfc}()); |
| #elseif ($cjtype == "long") |
| return new Long(get${cfc}()); |
| #elseif ($cjtype == "float") |
| return new Float(get${cfc}()); |
| #elseif ($cjtype == "double") |
| return new Double(get${cfc}()); |
| #elseif ($cjtype == "boolean") |
| return new Boolean(get${cfc}()); |
| #elseif ($cjtype == "short") |
| return new Short(get${cfc}()); |
| #elseif ($cjtype == "byte") |
| return new Byte(get${cfc}()); |
| #elseif ($cjtype == "char") |
| return new Character(get${cfc}()); |
| #else |
| return get${cfc}(); |
| #end |
| } |
| #end |
| return null; |
| } |
| /** |
| * Retrieves a field from the object by name passed in |
| * as a String. The String must be one of the static |
| * Strings defined in this Class' Peer. |
| */ |
| public Object getByPeerName(String name) |
| { |
| #foreach ($col in $table.Columns) |
| #set ( $cfc = $col.JavaName ) |
| #set ( $cup=$col.Name.toUpperCase() ) |
| #set ( $cjtype = $col.JavaNative ) |
| if (name.equals(${table.JavaName}Peer.$cup )) |
| { |
| #if ($cjtype == "int") |
| return new Integer(get${cfc}()); |
| #elseif ($cjtype == "long") |
| return new Long(get${cfc}()); |
| #elseif ($cjtype == "float") |
| return new Float(get${cfc}()); |
| #elseif ($cjtype == "double") |
| return new Double(get${cfc}()); |
| #elseif ($cjtype == "boolean") |
| return new Boolean(get${cfc}()); |
| #elseif ($cjtype == "short") |
| return new Short(get${cfc}()); |
| #elseif ($cjtype == "byte") |
| return new Byte(get${cfc}()); |
| #elseif ($cjtype == "char") |
| return new Character(get${cfc}()); |
| #else |
| return get${cfc}(); |
| #end |
| } |
| #end |
| return null; |
| } |
| |
| /** |
| * Retrieves a field from the object by Position as specified |
| * in the xml schema. Zero-based. |
| */ |
| public Object getByPosition(int pos) |
| { |
| #set ($i = 0) |
| #foreach ($col in $table.Columns) |
| #set ( $cfc = $col.JavaName ) |
| #set ( $cjtype = $col.JavaNative ) |
| if ( pos == $i ) |
| { |
| #if ($cjtype == "int") |
| return new Integer(get${cfc}()); |
| #elseif ($cjtype == "long") |
| return new Long(get${cfc}()); |
| #elseif ($cjtype == "float") |
| return new Float(get${cfc}()); |
| #elseif ($cjtype == "double") |
| return new Double(get${cfc}()); |
| #elseif ($cjtype == "boolean") |
| return new Boolean(get${cfc}()); |
| #elseif ($cjtype == "short") |
| return new Short(get${cfc}()); |
| #elseif ($cjtype == "byte") |
| return new Byte(get${cfc}()); |
| #elseif ($cjtype == "char") |
| return new Character(get${cfc}()); |
| #else |
| return get${cfc}(); |
| #end |
| } |
| #set ($i = $i + 1) |
| #end |
| return null; |
| } |
| |
| #end ## ends the if(addGetByNameMethod) |
| |
| |
| #if (!$table.isAlias() && $addSaveMethod) |
| /** |
| * Stores the object in the database. If the object is new, |
| * it inserts it; otherwise an update is performed. |
| */ |
| public void save() throws Exception |
| { |
| #if ($complexObjectModel) |
| save(${table.JavaName}Peer.getMapBuilder() |
| .getDatabaseMap().getName()); |
| #else |
| if (isModified()) |
| { |
| if (isNew()) |
| { |
| ${table.JavaName}Peer.doInsert(($table.JavaName)this); |
| setNew(false); |
| } |
| else |
| { |
| ${table.JavaName}Peer.doUpdate(($table.JavaName)this); |
| } |
| } |
| #end |
| } |
| |
| /** |
| * Stores the object in the database. If the object is new, |
| * it inserts it; otherwise an update is performed. |
| */ |
| public void save(String dbName) throws Exception |
| { |
| DBConnection dbCon = null; |
| #if ($complexObjectModel) |
| try |
| { |
| dbCon = BasePeer.beginTransaction(dbName); |
| save(dbCon); |
| } |
| catch(Exception e) |
| { |
| BasePeer.rollBackTransaction(dbCon); |
| throw e; |
| } |
| BasePeer.commitTransaction(dbCon); |
| |
| #else |
| |
| if (isModified()) |
| { |
| try |
| { |
| dbCon = TurbineDB.getConnection( dbName ); |
| if (isNew()) |
| { |
| ${table.JavaName}Peer |
| .doInsert(($table.JavaName)this, dbCon); |
| setNew(false); |
| } |
| else |
| { |
| ${table.JavaName}Peer |
| .doUpdate(($table.JavaName)this, dbCon); |
| } |
| } |
| finally |
| { |
| TurbineDB.releaseConnection(dbCon); |
| } |
| } |
| |
| #end |
| } |
| |
| #if ($complexObjectModel) |
| // flag to prevent endless save loop, if this object is referenced |
| // by another object which falls in this transaction. |
| private boolean alreadyInSave = false; |
| #end |
| /** |
| * Stores the object in the database. If the object is new, |
| * it inserts it; otherwise an update is performed. This method |
| * is meant to be used as part of a transaction, otherwise use |
| * the save() method and the connection details will be handled |
| * internally |
| */ |
| public void save(DBConnection dbCon) throws Exception |
| { |
| #if ($complexObjectModel) |
| if (!alreadyInSave) |
| { |
| alreadyInSave = true; |
| #end |
| if (isModified()) |
| { |
| if (isNew()) |
| { |
| ${table.JavaName}Peer.doInsert(($table.JavaName)this, dbCon); |
| setNew(false); |
| } |
| else |
| { |
| ${table.JavaName}Peer.doUpdate(($table.JavaName)this, dbCon); |
| } |
| } |
| |
| #if ($complexObjectModel) |
| #foreach ($fk in $table.Referrers) |
| #set ( $tblFK = $fk.Table ) |
| #if ( !($tblFK.Name.equals($table.Name)) ) |
| #set ( $className = $tblFK.JavaName ) |
| #set ( $relCol = "" ) |
| #foreach ($columnName in $fk.LocalColumns) |
| #set ( $column = $tblFK.getColumn($columnName) ) |
| #if ($column.isMultipleFK()) |
| #set ( $relCol = $strings.concat([$relCol, $column.JavaName]) ) |
| #end |
| #end |
| |
| #if ($relCol == "") |
| #set ( $relCol = $strings.concat([$className, "s"]) ) |
| #else |
| #set ( $relCol = $strings.concat([$className, "sRelatedBy", $relCol]) ) |
| #end |
| #set ( $collName = $strings.concat(["coll", $relCol]) ) |
| |
| if ($collName != null ) |
| { |
| for (int i=0; i<${collName}.size(); i++) |
| { |
| ((${className})${collName}.get(i)).save(dbCon); |
| } |
| } |
| #end |
| #end |
| #end |
| #if ($complexObjectModel) |
| alreadyInSave = false; |
| } |
| #end |
| } |
| #end |
| |
| ## PrimaryKey methods |
| #if (!$table.isAlias()) |
| |
| #set ( $throwsClause = "" ) |
| #set ( $argList = "" ) |
| #set ( $argList2 = "" ) |
| #set ( $comma = "" ) |
| #foreach ($col in $table.PrimaryKeys) |
| #if ($complexObjectModel) |
| #if ( $col.isForeignKey() || ($col.Referrers.size() > 0) ) |
| #set ( $throwsClause = "throws Exception" ) |
| #end |
| #end |
| |
| #set ( $clo=$col.Name.toLowerCase() ) |
| #set ( $cjtype = $col.JavaNative ) |
| #set ($argList = "${argList}$comma $cjtype $clo") |
| #set ($argList2 = "${argList2}$comma String $clo") |
| |
| #set ( $comma = "," ) |
| #end |
| |
| #if ($table.PrimaryKeys.size() == 1) |
| |
| #set ($col = $table.PrimaryKeys.get(0) ) |
| #set ( $clo=$col.Name.toLowerCase() ) |
| #set ( $cjtype= $col.JavaNative ) |
| /** |
| * Set the PrimaryKey using ObjectKey. |
| * |
| * @param ObjectKey $clo |
| */ |
| public void setPrimaryKey(ObjectKey $clo) |
| $throwsClause { |
| set${col.JavaName}(($cjtype)$clo); |
| } |
| |
| /** |
| * Set the PrimaryKey using a String. |
| */ |
| public void setPrimaryKey(String key) $throwsClause |
| { |
| set${col.JavaName}(new ${cjtype}(key) ); |
| } |
| |
| #elseif ($table.PrimaryKeys.size() > 1) |
| |
| private final SimpleKey[] pks = new SimpleKey[$table.PrimaryKeys.size()]; |
| private final ComboKey comboPK = new ComboKey(pks); |
| /** |
| * Set the PrimaryKey with an ObjectKey |
| */ |
| public void setPrimaryKey(ObjectKey key) throws Exception |
| { |
| SimpleKey[] keys = (SimpleKey[])key.getValue(); |
| #set ($i = 0) |
| #foreach ($pk in $table.PrimaryKeys) |
| set${pk.JavaName}(($pk.JavaNative)keys[$i]); |
| #set ( $i = $i + 1 ) |
| #end |
| } |
| |
| /** |
| * Set the PrimaryKey using SimpleKeys. |
| * |
| #foreach ($col in $table.PrimaryKeys) |
| #set ( $clo=$col.Name.toLowerCase() ) |
| #set ( $cjtype= $col.JavaNative ) |
| * @param $cjtype $clo |
| #end |
| */ |
| public void setPrimaryKey($argList) |
| $throwsClause { |
| #foreach ($col in $table.PrimaryKeys) |
| set${col.JavaName}($col.Name.toLowerCase()); |
| #end |
| } |
| |
| /** |
| * Set the PrimaryKey with Strings. |
| * |
| #foreach ($col in $table.PrimaryKeys) |
| #set ( $clo=$col.Name.toLowerCase() ) |
| * @param String $clo |
| #end |
| */ |
| public void setPrimaryKey($argList2) |
| $throwsClause { |
| #foreach ($col in $table.PrimaryKeys) |
| set${col.JavaName}(new ${col.JavaNative}($col.Name.toLowerCase())); |
| #end |
| } |
| |
| /** |
| * Set the PrimaryKey using a String. |
| */ |
| public void setPrimaryKey(String key) throws Exception |
| { |
| int prevPos = 0; |
| |
| #set ($int = "int ") |
| #foreach ($col in $table.PrimaryKeys) |
| ${int}colonPos = key.indexOf(':', prevPos); |
| set${col.JavaName}( new ${col.JavaNative}(key.substring(prevPos, colonPos)) ); |
| prevPos = colonPos + 1; |
| #set ($int = "") |
| #end |
| } |
| |
| #end |
| |
| |
| /** |
| * returns an id that differentiates this object from others |
| * of its class. |
| */ |
| public ObjectKey getPrimaryKey() |
| { |
| #if ($table.PrimaryKeys.size() == 1) |
| return get${table.PrimaryKeys.get(0).JavaName}(); |
| #elseif ($table.PrimaryKeys.size() > 1) |
| #set ($i = 0) |
| #foreach ($pk in $table.PrimaryKeys) |
| pks[$i] = get${pk.JavaName}(); |
| #set ($i = $i +1) |
| #end |
| return comboPK; |
| #else |
| return getPrimaryKey(); |
| #end |
| } |
| |
| #end ##ends if(!$table.isAlias()) |
| |
| /** |
| * get an id that differentiates this object from others |
| * of its class. |
| */ |
| public String getQueryKey() |
| { |
| if (getPrimaryKey() == null) |
| { |
| return ""; |
| } |
| else |
| { |
| return getPrimaryKey().toString(); |
| } |
| } |
| |
| /** |
| * set an id that differentiates this object from others |
| * of its class. |
| */ |
| public void setQueryKey(String key) |
| throws Exception |
| { |
| setPrimaryKey(key); |
| } |
| |
| #if (!$table.isAlias()) |
| /** |
| * Makes a copy of this object. |
| * It creates a new object filling in the simple attributes. |
| #if ($complexObjectModel) |
| * It then fills all the association collections and sets the |
| * related objects to isNew=true. |
| #end |
| */ |
| #if ($table.ChildrenColumn || $table.isAbstract()) |
| public $table.JavaName copyInto($table.JavaName copyObj) throws Exception |
| { |
| #else |
| public $table.JavaName copy() throws Exception |
| { |
| $table.JavaName copyObj = new ${table.JavaName}(); |
| #end |
| #foreach ($col in $table.Columns) |
| copyObj.set${col.JavaName}($col.Name.toLowerCase()); |
| #end |
| |
| #if ($complexObjectModel) |
| |
| #set ( $list = "List " ) |
| #foreach ($fk in $table.Referrers) |
| #set ( $tblFK = $fk.Table ) |
| #if ( !($tblFK.Name.equals($table.Name)) ) |
| #set ( $className = $tblFK.JavaName ) |
| #set ( $relCol = "" ) |
| #foreach ($columnName in $fk.LocalColumns) |
| #set ( $column = $tblFK.getColumn($columnName) ) |
| #if ($column.isMultipleFK()) |
| #set ( $relCol = $strings.concat([$relCol, $column.JavaName]) ) |
| #end |
| #end |
| |
| #if ($relCol == "") |
| #set ( $pCollName = $strings.concat([$className, "s"]) ) |
| #else |
| #set ( $pCollName = $strings.concat([$className, "sRelatedBy", $relCol]) ) |
| #end |
| |
| ${list}v = copyObj.get${pCollName}(); |
| for (int i=0; i<v.size(); i++) |
| { |
| ((Persistent)v.get(i)).setNew(true); |
| } |
| #set ( $list = "" ) |
| #end |
| #end |
| #end |
| |
| #foreach ($col in $table.Columns) |
| #if ($col.isPrimaryKey()) |
| #set ( $pkid = "null" ) |
| #set ( $cjtype = $col.JavaNative ) |
| copyObj.set${col.JavaName}((${cjtype})${pkid}); |
| #end |
| #end |
| return copyObj; |
| } |
| #end |
| } |
| |
