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.core.dbobj.tests;
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:
071: /**
072: * A basic DBObject used to verify the functions of the DBObject class
073: *
074: * @author Michael Nash
075: */
076: public class Test1 extends DBObject {
077: /**
078: * @throws DBException upon error
079: * @see com.jcorporate.expresso.core.dbobj.SecuredDBObject#SecuredDBObject
080: */
081: public Test1() throws DBException {
082: super ();
083: } /* Test1() */
084:
085: /**
086: * Creates a new object hooked with a particular DBConnection. Useful
087: * for transactional capabilities
088: *
089: * @param oneConnection a DBConnection obtained from the ConnectionPool
090: * @throws DBException upon error
091: */
092: public Test1(DBConnection oneConnection) throws DBException {
093: super (oneConnection);
094: }
095:
096: /**
097: * Setup fields for the test object. The commented out fields are fields
098: * that are rare and not necessarily supported by most databases.
099: *
100: * @throws DBException upon error
101: * @see com.jcorporate.expresso.core.dbobj.SecuredDBObject#setupFields
102: */
103: public void setupFields() throws DBException {
104: setTargetTable("TEST1");
105: setDescription("Test One");
106: setCharset("ISO-8859-1");
107: addField("TestKey", "int", 0, false, "Test Table Key");
108: addField("BigIntTest", "bigint", 0, true, "Big Int Test");
109: addField("BinaryTest", "binary", 0, true, "Binary Test");
110: addField("BitTest", "bit", 0, true, "Bit Test");
111: addField("BooleanTest", "boolean", 0, true, "Boolean Test");
112: addField("BlobTest", "blob", 0, true, "Blob Test");
113: addField("CharTest", "char", 30, true, "Char Test");
114: addField("ClobTest", "clob", 0, true, "Clob Test");
115: addField("DateTest", "date", 0, true, "Date Test");
116: addField("DecimalTest", "decimal", 0, true, "Decimal Test");
117: addField("DoubleTest", "double", 0, true, "Double Test");
118: addField("FloatTest", "float", 9, 3, true, "Float Test");
119: addField("IntTest", "int", 0, true, "Int Test");
120: addField("NumericTest", "numeric", 0, true, "Numeric Test");
121: addField("RealTest", "real", 9, true, "Real Test");
122: addField("SmallIntTest", "smallint", 0, true, "Smallint Test");
123: addField("TimeTest", "time", 0, true, "Time Test");
124: addField("TimeStampTest", "timestamp", 0, true,
125: "Time Stampt Test");
126: addField("DateTimeTest", "datetime", 0, true, "Date Time Test");
127: addField("TinyIntTest", "tinyint", 0, true, "Tiny Int Test");
128: addField("VarCharTest", "varchar", 30, true, "Varchar Test");
129: addField("TextTest", "text", 0, true, "Text Test");
130: addField("AutoIncTest", "auto-inc", 0, true,
131: "AutoIncrement Test");
132:
133: //expressoToSQL.put("array", "ARRAY");
134: //expressoToSQL.put("blob", "BLOB");
135: //expressoToSQL.put("clob", "CLOB");
136: //expressoToSQL.put("distinct", "DISTINCT");
137: //expressoToSQL.put("int", "INTEGER");
138: //expressoToSQL.put("javaobject", "JAVA_OBJECT");
139: //expressoToSQL.put("longvarbinary", "LONGVARBINARY");
140: //expressoToSQL.put("other", "OTHER");
141: //expressoToSQL.put("ref", "REF");
142: //expressoToSQL.put("struct", "STRUCT");
143: //expressoToSQL.put("varbinary", "VARBINARY");
144: addKey("TestKey");
145: } /* setupFields() */
146:
147: }
|