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.DBException;
068: import com.jcorporate.expresso.core.dbobj.DBIndex;
069: import com.jcorporate.expresso.services.test.ExpressoTestCase;
070: import junit.framework.Test;
071: import junit.framework.TestSuite;
072:
073: /**
074: * Test to make sure that index sql is getting created properyl
075: *
076: * @author Michael Rimov
077: * @version $Revision: 1.2 $ $Date: 2004/11/17 20:48:22 $
078: */
079: public class DBIndexTest extends ExpressoTestCase {
080: static final String[] tests = {
081: "CREATE UNIQUE INDEX index1 ON table1(field1);",
082: "CREATE INDEX index2 ON table2(fieldA,fieldB);" };
083:
084: public DBIndexTest(String testName) throws Exception {
085: super (testName);
086: }
087:
088: public static void main(String[] args) throws Exception {
089:
090: //Set the system properties we need
091: junit.textui.TestRunner.run(suite());
092: }
093:
094: /**
095: * Define the suite of tests that verify each function of the cache
096: *
097: * @return an appropriate Test Suite to be run.
098: * @throws Exception if there's an error constructing the class
099: */
100: public static Test suite() throws Exception {
101: return new TestSuite(DBIndexTest.class);
102: } /* suite() */
103:
104: public void testUniqueIndex() throws Exception {
105:
106: //Basic create sequences
107: DBIndex dbi = new DBIndex();
108: dbi.setTableName("table1");
109: dbi.setIndexName("index1");
110: dbi.setFieldNames("field1");
111: dbi.setUnique(true);
112:
113: String result = dbi.constructSQL();
114: assertTrue("First DBIndex Test", result.equals(tests[0]));
115: }
116:
117: public void testNonUniqueIndex() throws Exception {
118:
119: //Created using constructor
120: DBIndex dbi = new DBIndex("index2", "table2", "fieldA,fieldB",
121: false);
122: String result = dbi.constructSQL();
123: assertTrue("Second DBIndex Test", result.equals(tests[1]));
124: }
125:
126: public void testBadInputs() {
127:
128: //Finally feed bad inputs
129: DBIndex dbi = new DBIndex(null, null, null, false);
130:
131: try {
132: String result = dbi.constructSQL();
133: fail("Created bad SQL given bad inputs");
134: } catch (DBException e) {
135:
136: //Passed
137: } catch (NullPointerException e) {
138: e.printStackTrace();
139: fail("Caught NULL Pointer Exception should have been handled");
140: }
141: }
142: }
|