1 package org.campware.cream.om.map; 2 3 import java.util.Date ; 4 import java.math.BigDecimal ; 5 6 import org.apache.torque.Torque; 7 import org.apache.torque.TorqueException; 8 import org.apache.torque.map.MapBuilder; 9 import org.apache.torque.map.DatabaseMap; 10 import org.apache.torque.map.TableMap; 11 12 18 public class ServiceMapBuilder implements MapBuilder 19 { 20 23 public static final String CLASS_NAME = 24 "org.campware.cream.om.map.ServiceMapBuilder"; 25 26 27 30 private DatabaseMap dbMap = null; 31 32 38 public boolean isBuilt() 39 { 40 return (dbMap != null); 41 } 42 43 48 public DatabaseMap getDatabaseMap() 49 { 50 return this.dbMap; 51 } 52 53 58 public void doBuild() throws TorqueException 59 { 60 dbMap = Torque.getDatabaseMap("cream"); 61 62 dbMap.addTable("SERVICE"); 63 TableMap tMap = dbMap.getTable("SERVICE"); 64 65 tMap.setPrimaryKeyMethod(TableMap.NATIVE); 66 67 tMap.setPrimaryKeyMethodInfo("SERVICE_SEQ"); 68 69 tMap.addPrimaryKey("SERVICE.SERVICE_ID", new Integer (0)); 70 tMap.addColumn("SERVICE.SERVICE_CODE", ""); 71 tMap.addColumn("SERVICE.STATUS", new Integer (0)); 72 tMap.addColumn("SERVICE.PRIORITY", new Integer (0)); 73 tMap.addColumn("SERVICE.ISSUED_DATE", new Date ()); 74 tMap.addColumn("SERVICE.CLOSED_DATE", new Date ()); 75 tMap.addForeignKey( 76 "SERVICE.CUSTOMER_ID", new Integer (0) , "CUSTOMER" , 77 "CUSTOMER_ID"); 78 tMap.addForeignKey( 79 "SERVICE.RECIPIENT_ID", new Integer (0) , "CUSTOMER" , 80 "CUSTOMER_ID"); 81 tMap.addForeignKey( 82 "SERVICE.PROJECT_ID", new Integer (0) , "PROJECT" , 83 "PROJECT_ID"); 84 tMap.addForeignKey( 85 "SERVICE.SORDER_ID", new Integer (0) , "SORDER" , 86 "SORDER_ID"); 87 tMap.addColumn("SERVICE.INVOICE_CODE", ""); 88 tMap.addColumn("SERVICE.SUBJECT", ""); 89 tMap.addColumn("SERVICE.NOTES", ""); 90 tMap.addColumn("SERVICE.CREATED", new Date ()); 91 tMap.addColumn("SERVICE.MODIFIED", new Date ()); 92 tMap.addColumn("SERVICE.CREATED_BY", ""); 93 tMap.addColumn("SERVICE.MODIFIED_BY", ""); 94 } 95 } 96 | Popular Tags |