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.services.test;
066:
067: import com.jcorporate.expresso.core.db.DBException;
068: import com.jcorporate.expresso.core.dbobj.DBObject;
069: import com.jcorporate.expresso.core.dbobj.Schema;
070: import com.jcorporate.expresso.core.dbobj.SecuredDBObject;
071: import com.jcorporate.expresso.core.utility.DBTool;
072: import com.jcorporate.expresso.kernel.InstallLog;
073: import com.jcorporate.expresso.services.dbobj.SchemaList;
074: import org.apache.log4j.Logger;
075:
076: import java.util.Enumeration;
077: import java.util.Vector;
078:
079: /**
080: * Given a series of schema class names, this class will perform a "dbcreate"
081: * The big difference between this and other versions is that this will work
082: * on a blank database.
083: *
084: * @author Michael Rimov
085: */
086: public class SchemaCreator {
087: static Logger log = Logger.getLogger(SchemaCreator.class);
088: static String dataContext = null;;
089:
090: /**
091: * Default Constructor
092: */
093: public SchemaCreator() {
094: }
095:
096: public String getDataContext() {
097: return dataContext;
098: }
099:
100: public void setDataContext(String newValue) {
101: dataContext = newValue;
102: }
103:
104: private static String getMyContext() {
105: if (dataContext == null) {
106: return TestSystemInitializer.getTestContext();
107: } else {
108: return dataContext;
109: }
110: }
111:
112: /**
113: * Iterates through all the tables. If they all exist, then we assume
114: * the schema is properly set up.
115: *
116: * @param oneSchema an instantiated Schema object to check to see if it is installed
117: * or not.
118: * @return false if there is an error on getting DBobject.count() on the
119: * database table.
120: * @throws DBException upon database communication error
121: */
122: public static boolean schemaExists(Schema oneSchema)
123: throws DBException {
124: DBObject oneMember;
125:
126: for (Enumeration e = oneSchema.getMembers(); e
127: .hasMoreElements();) {
128: oneMember = (DBObject) e.nextElement();
129: oneMember.setDataContext(getMyContext());
130: if (log.isDebugEnabled()) {
131: log.debug("Checking table "
132: + oneMember.getJDBCMetaData().getTargetTable());
133: }
134:
135: try {
136: oneMember.count();
137: if (log.isDebugEnabled()) {
138: log.debug("Table "
139: + oneMember.getJDBCMetaData()
140: .getTargetTable() + " exists");
141: }
142: } catch (Throwable de) {
143:
144: //Table didn't exist or there's a problem with the connection
145: return false;
146: }
147: }
148:
149: SchemaList sl = new SchemaList(SecuredDBObject.SYSTEM_ACCOUNT);
150: sl.setDataContext(dataContext);
151: sl.setField(SchemaList.FLD_SCHEMA_CLASS, oneSchema.getClass()
152: .getName());
153: if (!sl.find()) {
154: return false;
155: }
156:
157: return true;
158: }
159:
160: /**
161: * @param oneSchema
162: * @param installLog
163: * @return
164: */
165: public static synchronized boolean ensureSchemaExists(
166: Schema oneSchema, InstallLog installLog) throws DBException {
167: Vector toCreate = new Vector();
168:
169: if (!schemaExists(oneSchema)) {
170: toCreate.add(oneSchema);
171: } else {
172:
173: //Nothing to create.
174: return true;
175: }
176:
177: DBTool.createTables(installLog, toCreate, getMyContext());
178:
179: for (Enumeration e = toCreate.elements(); e.hasMoreElements();) {
180: Schema s = (Schema) e.nextElement();
181:
182: if (!s.getClass().getName().equals(
183: "com.jcorporate.expresso.core.ExpressoSchema")) {
184: SchemaList sl = new SchemaList(
185: SecuredDBObject.SYSTEM_ACCOUNT);
186: sl.setDataContext(getMyContext());
187: sl.setField("SchemaClass", s.getClass().getName());
188:
189: if (!sl.find()) {
190: sl.setField("Descrip", s.getDefaultDescription());
191: sl.setField("ComponentCode", s
192: .getDefaultComponentCode());
193: sl.add();
194: } else {
195: log
196: .info("Schema Class "
197: + s.getClass().getName()
198: + " already is listed as a registered schema");
199: }
200: }
201: }
202:
203: DBTool.setupSecurity(installLog, toCreate, getMyContext());
204: DBTool.populateTables(installLog, toCreate, getMyContext());
205: DBTool.setupConfig(installLog, toCreate, getMyContext());
206: DBTool.otherSetups(installLog, toCreate, getMyContext());
207:
208: if (!oneSchema.getClass().getName().equals(
209: "com.jcorporate.expresso.core.ExpressoSchema")) {
210: SchemaList sl = new SchemaList(
211: SecuredDBObject.SYSTEM_ACCOUNT);
212: sl.setDataContext(getMyContext());
213: sl.setField("SchemaClass", oneSchema.getClass().getName());
214:
215: if (!sl.find()) {
216: sl.setField("Descrip", oneSchema
217: .getDefaultDescription());
218: sl.setField("ComponentCode", oneSchema
219: .getDefaultComponentCode());
220: sl.add();
221: }
222: }
223:
224: return false;
225: }
226:
227: }
|