Source code: org/openscience/nmrshiftdb/om/map/DBUserDBSpectrumMarkMapBuilder.java
1 package org.openscience.nmrshiftdb.om.map;
2
3 import java.util.*;
4 import java.math.*;
5 import org.apache.turbine.services.db.PoolBrokerService;
6 import org.apache.turbine.services.db.TurbineDB;
7 import org.apache.turbine.util.db.map.MapBuilder;
8 import org.apache.turbine.util.db.map.DatabaseMap;
9 import org.apache.turbine.util.db.map.TableMap;
10
11 /**
12 */
13 public class DBUserDBSpectrumMarkMapBuilder implements MapBuilder
14 {
15 /** the name of this class */
16 public static final String CLASS_NAME = "org.openscience.nmrshiftdb.om.map.DBUserDBSpectrumMarkMapBuilder";
17
18 /** item */
19 public static String getTable( )
20 {
21 return "USER_SPECTRUM_MARK";
22 }
23
24
25 /** USER_SPECTRUM_MARK.USER_ID */
26 public static String getDBUserDBSpectrumMark_UserId()
27 {
28 return getTable() + ".USER_ID";
29 }
30
31 /** USER_SPECTRUM_MARK.SPECTRUM_ID */
32 public static String getDBUserDBSpectrumMark_SpectrumId()
33 {
34 return getTable() + ".SPECTRUM_ID";
35 }
36
37 /** USER_SPECTRUM_MARK.MARK */
38 public static String getDBUserDBSpectrumMark_Mark()
39 {
40 return getTable() + ".MARK";
41 }
42
43 /** USER_SPECTRUM_MARK.MARK_DATE */
44 public static String getDBUserDBSpectrumMark_MarkDate()
45 {
46 return getTable() + ".MARK_DATE";
47 }
48
49 /** USER_SPECTRUM_MARK.COMMENT */
50 public static String getDBUserDBSpectrumMark_Comment()
51 {
52 return getTable() + ".COMMENT";
53 }
54
55 /** the database map */
56 private DatabaseMap dbMap = null;
57
58 /**
59 tells us if this DatabaseMapBuilder is built so that we don't have
60 to re-build it every time
61 */
62 public boolean isBuilt()
63 {
64 if ( dbMap != null )
65 return true;
66 return false;
67 }
68
69 /** gets the databasemap this map builder built. */
70 public DatabaseMap getDatabaseMap()
71 {
72 return this.dbMap;
73 }
74 /** the doBuild() method builds the DatabaseMap */
75 public void doBuild() throws Exception
76 {
77 dbMap = TurbineDB.getDatabaseMap("default");
78
79 dbMap.addTable(getTable());
80 TableMap tMap = dbMap.getTable(getTable());
81
82 tMap.setPrimaryKeyMethod("none");
83
84
85
86 tMap.addForeignPrimaryKey ( getDBUserDBSpectrumMark_UserId(), new Integer(0) , "TURBINE_USER" , "USER_ID" );
87
88 tMap.addForeignPrimaryKey ( getDBUserDBSpectrumMark_SpectrumId(), new Integer(0) , "SPECTRUM" , "SPECTRUM_ID" );
89
90 tMap.addColumn ( getDBUserDBSpectrumMark_Mark(), new Integer(0) );
91
92 tMap.addColumn ( getDBUserDBSpectrumMark_MarkDate(), new Date() );
93
94 tMap.addColumn ( getDBUserDBSpectrumMark_Comment(), new String() );
95
96 }
97
98 }