001: /* ====================================================================
002: * The Jcorporate Apache Style Software License, Version 1.2 05-07-2002
003: *
004: * Copyright (c) 1995-2002 Jcorporate Ltd. All rights reserved.
005: *
006: * Redistribution and use in source and binary forms, with or without
007: * modification, are permitted provided that the following conditions
008: * are met:
009: *
010: * 1. Redistributions of source code must retain the above copyright
011: * notice, this list of conditions and the following disclaimer.
012: *
013: * 2. Redistributions in binary form must reproduce the above copyright
014: * notice, this list of conditions and the following disclaimer in
015: * the documentation and/or other materials provided with the
016: * distribution.
017: *
018: * 3. The end-user documentation included with the redistribution,
019: * if any, must include the following acknowledgment:
020: * "This product includes software developed by Jcorporate Ltd.
021: * (http://www.jcorporate.com/)."
022: * Alternately, this acknowledgment may appear in the software itself,
023: * if and wherever such third-party acknowledgments normally appear.
024: *
025: * 4. "Jcorporate" and product names such as "Expresso" must
026: * not be used to endorse or promote products derived from this
027: * software without prior written permission. For written permission,
028: * please contact info@jcorporate.com.
029: *
030: * 5. Products derived from this software may not be called "Expresso",
031: * or other Jcorporate product names; nor may "Expresso" or other
032: * Jcorporate product names appear in their name, without prior
033: * written permission of Jcorporate Ltd.
034: *
035: * 6. No product derived from this software may compete in the same
036: * market space, i.e. framework, without prior written permission
037: * of Jcorporate Ltd. For written permission, please contact
038: * partners@jcorporate.com.
039: *
040: * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
041: * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
042: * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
043: * DISCLAIMED. IN NO EVENT SHALL JCORPORATE LTD OR ITS CONTRIBUTORS
044: * BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
045: * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED
046: * TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
047: * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
048: * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
049: * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
050: * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
051: * SUCH DAMAGE.
052: * ====================================================================
053: *
054: * This software consists of voluntary contributions made by many
055: * individuals on behalf of the Jcorporate Ltd. Contributions back
056: * to the project(s) are encouraged when you make modifications.
057: * Please send them to support@jcorporate.com. For more information
058: * on Jcorporate Ltd. and its products, please see
059: * <http://www.jcorporate.com/>.
060: *
061: * Portions of this software are based upon other open source
062: * products and are subject to their respective licenses.
063: */
064:
065: package com.jcorporate.expresso.ext.dbobj;
066:
067: import com.jcorporate.expresso.core.db.DBConnection;
068: import com.jcorporate.expresso.core.db.DBException;
069: import com.jcorporate.expresso.core.dbobj.DBObject;
070: import com.jcorporate.expresso.core.dbobj.SecuredDBObject;
071: import com.jcorporate.expresso.core.misc.DateTime;
072:
073: /**
074: * The AuditLog is a table that is written to by AuditedSecuredDBObjects and
075: * HistAuditSecuredDBObjects.
076: *
077: * @author Adam Rossi, PlatinumSolutions
078: */
079: public class AuditLog extends SecuredDBObject {
080:
081: /**
082: * Constructor
083: * Create a new object of this type with no connection
084: * yet allocated.
085: */
086: public AuditLog() throws DBException {
087: super ();
088: } /* AUDIT() */
089:
090: /**
091: * Constructor
092: *
093: * @param theConnection Database connection to
094: * communicate with the database
095: * @throws DBException If the new object cannot be
096: * created
097: */
098: public AuditLog(DBConnection theConnection) throws DBException {
099: super (theConnection);
100: } /* AUDIT(DBConnection) */
101:
102: /**
103: * Define the fields for this object
104: */
105: protected synchronized void setupFields() throws DBException {
106: setTargetTable("AUDITLOG");
107:
108: setDescription("Audit Log");
109:
110: addField("AUDITLOG_ID", "auto-inc", 0, false, "AuditLog ID");
111: // Field AUDITLOG_ID reverse-engineered from DB type: NUMBER
112: addField("AUDITLOG_CODE", "char", 5, false, "AuditLog Code");
113: // Field AUDITLOG_CODE reverse-engineered from DB type: CHAR
114: addField("EXPUID", "integer", 0, false, "EXP ID");
115: // Field EXPUID reverse-engineered from DB type: NUMBER
116: addField("AUDITLOG_DATE", "datetime", 0, false, "AuditLog Date");
117: // Field AUDITLOG_DATE reverse-engineered from DB type: DATE
118: addField("AUDITLOG_DES", "varchar", 250, true,
119: "AuditLog Description");
120:
121: addKey("AUDITLOG_ID");
122: setMultiValued("AUDITLOG_CODE");
123: setLookupObject("AUDITLOG_CODE",
124: "com.jcorporate.expresso.ext.dbobj.AuditLogL");
125: this .setReadOnly("AUDITLOG_ID");
126: this .setReadOnly("AUDITLOG_CODE");
127: this .setReadOnly("EXPUID");
128: this .setReadOnly("AUDITLOG_DATE");
129: this .setReadOnly("AUDITLOG_DES");
130:
131: } /* setupFields() */
132:
133: /**
134: * Add method overriden to always insert current date.
135: */
136:
137: public synchronized void add() throws DBException {
138: setField("AUDITLOG_DATE", DateTime.getDateTimeForDB(this
139: .getDataContext()));
140: super .add();
141: }
142:
143: /**
144: * Standard method to create a new copy of this
145: * particular database object
146: *
147: * @return DBObject A newly created instance of this object
148: * @throws DBException If the new object cannot be created
149: */
150: public DBObject getThisDBObj() throws DBException {
151: return new AuditLog();
152: } /* getThisDBObj() */
153: } /* AUDIT */
|