KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > jcorporate > expresso > core > dbobj > tests > Test1


1 /* ====================================================================
2  * The Jcorporate Apache Style Software License, Version 1.2 05-07-2002
3  *
4  * Copyright (c) 1995-2002 Jcorporate Ltd. All rights reserved.
5  *
6  * Redistribution and use in source and binary forms, with or without
7  * modification, are permitted provided that the following conditions
8  * are met:
9  *
10  * 1. Redistributions of source code must retain the above copyright
11  * notice, this list of conditions and the following disclaimer.
12  *
13  * 2. Redistributions in binary form must reproduce the above copyright
14  * notice, this list of conditions and the following disclaimer in
15  * the documentation and/or other materials provided with the
16  * distribution.
17  *
18  * 3. The end-user documentation included with the redistribution,
19  * if any, must include the following acknowledgment:
20  * "This product includes software developed by Jcorporate Ltd.
21  * (http://www.jcorporate.com/)."
22  * Alternately, this acknowledgment may appear in the software itself,
23  * if and wherever such third-party acknowledgments normally appear.
24  *
25  * 4. "Jcorporate" and product names such as "Expresso" must
26  * not be used to endorse or promote products derived from this
27  * software without prior written permission. For written permission,
28  * please contact info@jcorporate.com.
29  *
30  * 5. Products derived from this software may not be called "Expresso",
31  * or other Jcorporate product names; nor may "Expresso" or other
32  * Jcorporate product names appear in their name, without prior
33  * written permission of Jcorporate Ltd.
34  *
35  * 6. No product derived from this software may compete in the same
36  * market space, i.e. framework, without prior written permission
37  * of Jcorporate Ltd. For written permission, please contact
38  * partners@jcorporate.com.
39  *
40  * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED
41  * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES
42  * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
43  * DISCLAIMED. IN NO EVENT SHALL JCORPORATE LTD OR ITS CONTRIBUTORS
44  * BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
45  * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED
46  * TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF
47  * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
48  * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
49  * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT
50  * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
51  * SUCH DAMAGE.
52  * ====================================================================
53  *
54  * This software consists of voluntary contributions made by many
55  * individuals on behalf of the Jcorporate Ltd. Contributions back
56  * to the project(s) are encouraged when you make modifications.
57  * Please send them to support@jcorporate.com. For more information
58  * on Jcorporate Ltd. and its products, please see
59  * <http://www.jcorporate.com/>.
60  *
61  * Portions of this software are based upon other open source
62  * products and are subject to their respective licenses.
63  */
64
65 package com.jcorporate.expresso.core.dbobj.tests;
66
67 import com.jcorporate.expresso.core.db.DBConnection;
68 import com.jcorporate.expresso.core.db.DBException;
69 import com.jcorporate.expresso.core.dbobj.DBObject;
70
71
72 /**
73  * A basic DBObject used to verify the functions of the DBObject class
74  *
75  * @author Michael Nash
76  */
77 public class Test1
78         extends DBObject {
79     /**
80      * @throws DBException upon error
81      * @see com.jcorporate.expresso.core.dbobj.SecuredDBObject#SecuredDBObject
82      */
83     public Test1()
84             throws DBException {
85         super();
86     } /* Test1() */
87
88     /**
89      * Creates a new object hooked with a particular DBConnection. Useful
90      * for transactional capabilities
91      *
92      * @param oneConnection a DBConnection obtained from the ConnectionPool
93      * @throws DBException upon error
94      */
95     public Test1(DBConnection oneConnection) throws DBException {
96         super(oneConnection);
97     }
98
99
100     /**
101      * Setup fields for the test object. The commented out fields are fields
102      * that are rare and not necessarily supported by most databases.
103      *
104      * @throws DBException upon error
105      * @see com.jcorporate.expresso.core.dbobj.SecuredDBObject#setupFields
106      */
107     public void setupFields()
108             throws DBException {
109         setTargetTable("TEST1");
110         setDescription("Test One");
111         setCharset("ISO-8859-1");
112         addField("TestKey", "int", 0, false, "Test Table Key");
113         addField("BigIntTest", "bigint", 0, true, "Big Int Test");
114         addField("BinaryTest", "binary", 0, true, "Binary Test");
115         addField("BitTest", "bit", 0, true, "Bit Test");
116         addField("BooleanTest", "boolean", 0, true, "Boolean Test");
117         addField("BlobTest", "blob", 0, true, "Blob Test");
118         addField("CharTest", "char", 30, true, "Char Test");
119         addField("ClobTest", "clob", 0, true, "Clob Test");
120         addField("DateTest", "date", 0, true, "Date Test");
121         addField("DecimalTest", "decimal", 0, true, "Decimal Test");
122         addField("DoubleTest", "double", 0, true, "Double Test");
123         addField("FloatTest", "float", 9, 3, true, "Float Test");
124         addField("IntTest", "int", 0, true, "Int Test");
125         addField("NumericTest", "numeric", 0, true, "Numeric Test");
126         addField("RealTest", "real", 9, true, "Real Test");
127         addField("SmallIntTest", "smallint", 0, true, "Smallint Test");
128         addField("TimeTest", "time", 0, true, "Time Test");
129         addField("TimeStampTest", "timestamp", 0, true, "Time Stampt Test");
130         addField("DateTimeTest", "datetime", 0, true, "Date Time Test");
131         addField("TinyIntTest", "tinyint", 0, true, "Tiny Int Test");
132         addField("VarCharTest", "varchar", 30, true, "Varchar Test");
133         addField("TextTest", "text", 0, true, "Text Test");
134         addField("AutoIncTest", "auto-inc", 0, true, "AutoIncrement Test");
135
136         //expressoToSQL.put("array", "ARRAY");
137 //expressoToSQL.put("blob", "BLOB");
138 //expressoToSQL.put("clob", "CLOB");
139 //expressoToSQL.put("distinct", "DISTINCT");
140 //expressoToSQL.put("int", "INTEGER");
141 //expressoToSQL.put("javaobject", "JAVA_OBJECT");
142 //expressoToSQL.put("longvarbinary", "LONGVARBINARY");
143 //expressoToSQL.put("other", "OTHER");
144 //expressoToSQL.put("ref", "REF");
145 //expressoToSQL.put("struct", "STRUCT");
146 //expressoToSQL.put("varbinary", "VARBINARY");
147 addKey("TestKey");
148     } /* setupFields() */
149
150
151 }
152
Popular Tags