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.controller.ControllerRequest;
068: import com.jcorporate.expresso.core.db.DBException;
069: import com.jcorporate.expresso.core.dbobj.DBObject;
070: import com.jcorporate.expresso.core.dbobj.Schema;
071: import com.jcorporate.expresso.core.dbobj.SchemaFactory;
072: import com.jcorporate.expresso.core.dbobj.SecuredDBObject;
073: import com.jcorporate.expresso.core.dbobj.ValidValue;
074: import com.jcorporate.expresso.kernel.util.FastStringBuffer;
075: import com.jcorporate.expresso.services.dbobj.DBOtherMap;
076: import com.jcorporate.expresso.services.dbobj.SchemaList;
077:
078: import java.util.Enumeration;
079: import java.util.Iterator;
080: import java.util.Vector;
081:
082: /**
083: * AppIntegration
084: * Provide a point of integration between different Expresso-based
085: * applications. This facilitates (for example) a Poll being associated
086: * with an eForum discussion, or a HelpDesk ticket being associated
087: * with an eContent resource.
088: *
089: * @author Michael Nash
090: */
091: public class AppIntegration extends SecuredDBObject {
092:
093: /**
094: * Constructor
095: */
096: public AppIntegration() throws DBException {
097: super ();
098: } /* AppIntegration() */
099:
100: /**
101: * Use over (String) constructor. Initializes the object in the context
102: * of the user who's uid belongs to the parameter.
103: *
104: * @param the Uid of the user context
105: * @throws DBException if there's an initialization problem
106: */
107: public AppIntegration(int uid) throws DBException {
108: super (uid);
109: }
110:
111: /**
112: * For using DBObjects within Controllers. Initializes based upon the current
113: * user and the requested db. [Of course this can be modified later]
114: *
115: * @param request - The controller request handed to you by the framework.
116: */
117: public AppIntegration(ControllerRequest request) throws DBException {
118: super (request);
119: }
120:
121: /**
122: * Define the table and fields for this object
123: *
124: * @throws DBException If the fields cannot be set up
125: */
126: public void setupFields() throws DBException {
127: setTargetTable("APPINTEGRATE");
128: setDescription("DBappIntegrate");
129: setCharset("ISO-8859-1");
130: addField("IntegrationId", "auto-inc", 0, false,
131: "integrationKey");
132: addField("FromSchema", "varchar", 128, false, "fromSchema");
133: addField("ToSchema", "varchar", 128, false, "toSchema");
134: addField("FromObj", "varchar", 128, false, "fromObject");
135: addField("ToObj", "varchar", 128, false, "toObject");
136: addField("FromKey", "text", 0, false, "fromKey");
137: addField("ToKey", "text", 0, false, "toKey");
138: addKey("IntegrationId");
139: setReadOnly("IntegrationId");
140: setMultiValued("FromSchema");
141: setMultiValued("ToSchema");
142: setMultiValued("FromObj");
143: setMultiValued("ToObj");
144: } /* setupFields() */
145:
146: public Vector getValidValues(String fieldName) throws DBException {
147: if (fieldName.equals("FromSchema")
148: || fieldName.equals("ToSchema")) {
149: Vector v2 = new Vector(2);
150: v2.addElement(new ValidValue(
151: "com.jcorporate.expresso.core.ExpressoSchema",
152: "General"));
153:
154: SchemaList sl = new SchemaList(
155: SecuredDBObject.SYSTEM_ACCOUNT);
156: sl.setDataContext(getDataContext());
157:
158: SchemaList oneSchema = null;
159:
160: for (Iterator e = sl.searchAndRetrieveList("Descrip")
161: .iterator(); e.hasNext();) {
162: oneSchema = (SchemaList) e.next();
163: v2.addElement(new ValidValue(oneSchema
164: .getField("SchemaClass"), oneSchema
165: .getField("Descrip")));
166: }
167:
168: return v2;
169: } else if (fieldName.equals("FromObj")
170: || fieldName.equals("ToObj")) {
171: SchemaList myList = new SchemaList(
172: SecuredDBObject.SYSTEM_ACCOUNT);
173: myList.setDataContext(getDataContext());
174:
175: SchemaList oneList = null;
176: Vector dbObjList = new Vector(10);
177: dbObjList.addElement(new ValidValue(
178: "com.jcorporate.expresso.core.dbobj.AutoDBObject",
179: "Expresso: Automatic DB Objects"));
180: doSchema("com.jcorporate.expresso.core.ExpressoSchema",
181: "Expresso", dbObjList);
182:
183: /* Get any database objects listed as existing in another */
184:
185: /* database */
186: DBOtherMap otherList = new DBOtherMap();
187: otherList.setDataContext(getDataContext());
188:
189: DBOtherMap oneOther = null;
190:
191: for (Iterator e2 = otherList.searchAndRetrieveList()
192: .iterator(); e2.hasNext();) {
193: oneOther = (DBOtherMap) e2.next();
194: dbObjList.addElement(new ValidValue(oneOther
195: .getField("DBObjName"), oneOther
196: .getField("Descrip")));
197: }
198: /* Now get all of the schemas listed in the database as well */
199: for (Iterator sl = myList.searchAndRetrieveList()
200: .iterator(); sl.hasNext();) {
201: oneList = (SchemaList) sl.next();
202: doSchema(oneList.getField("SchemaClass"), oneList
203: .getField("Descrip"), dbObjList);
204: } /* for each schema list */
205:
206: return dbObjList;
207: }
208:
209: return super .getValidValues(fieldName);
210: } /* getValidValues */
211:
212: /**
213: * @param schemaName
214: * @param schemaDescrip
215: * @param oList
216: * @param DBException
217: */
218: private void doSchema(String schemaName, String schemaDescrip,
219: Vector oList) throws DBException {
220: Schema oneSchema = null;
221: DBObject oneDBObj = null;
222: ValidValue oneVal = null;
223:
224: oneSchema = SchemaFactory.getInstance().getSchema(schemaName);
225: if (oneSchema == null) {
226: throw new DBException("Error instantiating class '"
227: + schemaName);
228: }
229:
230: FastStringBuffer fsb = new FastStringBuffer(128);
231: /* Now add all of the objects in this schema to our list */
232: for (Enumeration e = oneSchema.getMembers(); e
233: .hasMoreElements();) {
234: oneDBObj = (DBObject) e.nextElement();
235: fsb.clear();
236: fsb.append(schemaDescrip);
237: fsb.append(": ");
238: fsb.append(oneDBObj.getMetaData().getDescription());
239: oneVal = new ValidValue(oneDBObj.getClass().getName(), fsb
240: .toString());
241: oList.addElement(oneVal);
242: }
243: } /* doSchema(String, String, Vector) */
244:
245: } /* AppIntegration */
246:
247: /* AppIntegration */
|