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 PrintSubscriptionMapBuilder implements MapBuilder 19 { 20 23 public static final String CLASS_NAME = 24 "org.campware.cream.om.map.PrintSubscriptionMapBuilder"; 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("PRINT_SUBSCRIPTION"); 63 TableMap tMap = dbMap.getTable("PRINT_SUBSCRIPTION"); 64 65 tMap.setPrimaryKeyMethod(TableMap.NATIVE); 66 67 tMap.setPrimaryKeyMethodInfo("PRINT_SUBSCRIPTION_SEQ"); 68 69 tMap.addPrimaryKey("PRINT_SUBSCRIPTION.PRINT_SUBS_ID", new Integer (0)); 70 tMap.addColumn("PRINT_SUBSCRIPTION.PRINT_SUBS_CODE", ""); 71 tMap.addColumn("PRINT_SUBSCRIPTION.STATUS", new Integer (0)); 72 tMap.addColumn("PRINT_SUBSCRIPTION.PRIORITY", new Integer (0)); 73 tMap.addColumn("PRINT_SUBSCRIPTION.ISSUED_DATE", new Date ()); 74 tMap.addColumn("PRINT_SUBSCRIPTION.CLOSED_DATE", new Date ()); 75 tMap.addForeignKey( 76 "PRINT_SUBSCRIPTION.SORDER_ID", new Integer (0) , "SORDER" , 77 "SORDER_ID"); 78 tMap.addForeignKey( 79 "PRINT_SUBSCRIPTION.CUSTOMER_ID", new Integer (0) , "CUSTOMER" , 80 "CUSTOMER_ID"); 81 tMap.addForeignKey( 82 "PRINT_SUBSCRIPTION.RECIPIENT_ID", new Integer (0) , "CUSTOMER" , 83 "CUSTOMER_ID"); 84 tMap.addForeignKey( 85 "PRINT_SUBSCRIPTION.CARRIER_ID", new Integer (0) , "CARRIER" , 86 "CARRIER_ID"); 87 tMap.addForeignKey( 88 "PRINT_SUBSCRIPTION.PROJECT_ID", new Integer (0) , "PROJECT" , 89 "PROJECT_ID"); 90 tMap.addForeignKey( 91 "PRINT_SUBSCRIPTION.PRODUCT_ID", new Integer (0) , "PRODUCT" , 92 "PRODUCT_ID"); 93 tMap.addColumn("PRINT_SUBSCRIPTION.QUANTITY", new Integer (0)); 94 tMap.addColumn("PRINT_SUBSCRIPTION.START_DATE", new Date ()); 95 tMap.addColumn("PRINT_SUBSCRIPTION.END_DATE", new Date ()); 96 tMap.addColumn("PRINT_SUBSCRIPTION.SUBJECT", ""); 97 tMap.addColumn("PRINT_SUBSCRIPTION.NOTES", ""); 98 tMap.addColumn("PRINT_SUBSCRIPTION.CREATED", new Date ()); 99 tMap.addColumn("PRINT_SUBSCRIPTION.MODIFIED", new Date ()); 100 tMap.addColumn("PRINT_SUBSCRIPTION.CREATED_BY", ""); 101 tMap.addColumn("PRINT_SUBSCRIPTION.MODIFIED_BY", ""); 102 } 103 } 104 | Popular Tags |