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 NewsletterMapBuilder implements MapBuilder 19 { 20 23 public static final String CLASS_NAME = 24 "org.campware.cream.om.map.NewsletterMapBuilder"; 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("NEWSLETTER"); 63 TableMap tMap = dbMap.getTable("NEWSLETTER"); 64 65 tMap.setPrimaryKeyMethod(TableMap.NATIVE); 66 67 tMap.setPrimaryKeyMethodInfo("NEWSLETTER_SEQ"); 68 69 tMap.addPrimaryKey("NEWSLETTER.NEWSLETTER_ID", new Integer (0)); 70 tMap.addColumn("NEWSLETTER.NEWSLETTER_CODE", ""); 71 tMap.addColumn("NEWSLETTER.STATUS", new Integer (0)); 72 tMap.addColumn("NEWSLETTER.PRIORITY", new Integer (0)); 73 tMap.addColumn("NEWSLETTER.ISSUED_DATE", new Date ()); 74 tMap.addColumn("NEWSLETTER.CLOSED_DATE", new Date ()); 75 tMap.addColumn("NEWSLETTER.SENT_TIME", new Date ()); 76 tMap.addColumn("NEWSLETTER.EMAIL_FORMAT", new Integer (0)); 77 tMap.addForeignKey( 78 "NEWSLETTER.LANGUAGE_ID", new Integer (0) , "LANGUAGE" , 79 "LANGUAGE_ID"); 80 tMap.addForeignKey( 81 "NEWSLETTER.CUSTOMER_CAT_ID", new Integer (0) , "CUSTOMER_CATEGORY" , 82 "CUSTOMER_CAT_ID"); 83 tMap.addColumn("NEWSLETTER.CUSTOMER_TYPE", new Integer (0)); 84 tMap.addForeignKey( 85 "NEWSLETTER.CUST_LANGUAGE_ID", new Integer (0) , "LANGUAGE" , 86 "LANGUAGE_ID"); 87 tMap.addForeignKey( 88 "NEWSLETTER.CUST_COUNTRY_ID", new Integer (0) , "COUNTRY" , 89 "COUNTRY_ID"); 90 tMap.addColumn("NEWSLETTER.REL_DOCUMENT", new Integer (0)); 91 tMap.addColumn("NEWSLETTER.REL_DOC_STATUS", new Integer (0)); 92 tMap.addForeignKey( 93 "NEWSLETTER.REL_PROJECT_ID", new Integer (0) , "PROJECT" , 94 "PROJECT_ID"); 95 tMap.addForeignKey( 96 "NEWSLETTER.REL_PRODUCT_ID", new Integer (0) , "PRODUCT" , 97 "PRODUCT_ID"); 98 tMap.addForeignKey( 99 "NEWSLETTER.PROJECT_ID", new Integer (0) , "PROJECT" , 100 "PROJECT_ID"); 101 tMap.addForeignKey( 102 "NEWSLETTER.PRODUCT_ID", new Integer (0) , "PRODUCT" , 103 "PRODUCT_ID"); 104 tMap.addColumn("NEWSLETTER.SUBJECT", ""); 105 tMap.addColumn("NEWSLETTER.BODY", ""); 106 tMap.addColumn("NEWSLETTER.NOTES", ""); 107 tMap.addColumn("NEWSLETTER.CREATED", new Date ()); 108 tMap.addColumn("NEWSLETTER.MODIFIED", new Date ()); 109 tMap.addColumn("NEWSLETTER.CREATED_BY", ""); 110 tMap.addColumn("NEWSLETTER.MODIFIED_BY", ""); 111 } 112 } 113 | Popular Tags |