01: /*
02: * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
03: *
04: * Copyright 1997-2007 Sun Microsystems, Inc. All rights reserved.
05: *
06: * The contents of this file are subject to the terms of either the GNU
07: * General Public License Version 2 only ("GPL") or the Common
08: * Development and Distribution License("CDDL") (collectively, the
09: * "License"). You may not use this file except in compliance with the
10: * License. You can obtain a copy of the License at
11: * http://www.netbeans.org/cddl-gplv2.html
12: * or nbbuild/licenses/CDDL-GPL-2-CP. See the License for the
13: * specific language governing permissions and limitations under the
14: * License. When distributing the software, include this License Header
15: * Notice in each file and include the License file at
16: * nbbuild/licenses/CDDL-GPL-2-CP. Sun designates this
17: * particular file as subject to the "Classpath" exception as provided
18: * by Sun in the GPL Version 2 section of the License file that
19: * accompanied this code. If applicable, add the following below the
20: * License Header, with the fields enclosed by brackets [] replaced by
21: * your own identifying information:
22: * "Portions Copyrighted [year] [name of copyright owner]"
23: *
24: * Contributor(s):
25: *
26: * Portions Copyrighted 2007 Sun Microsystems, Inc.
27: */
28: package org.netbeans.modules.db.explorer.infos;
29:
30: import java.sql.Types;
31: import org.netbeans.modules.db.util.DBTestBase;
32: import org.netbeans.modules.db.util.InfoHelper;
33:
34: /**
35: * @author <href="mailto:david@vancouvering.com">David Van Couvering</href>
36: */
37: public class DDLHelperTest extends DBTestBase {
38: InfoHelper helper;
39:
40: public DDLHelperTest(String name) {
41: super (name);
42: }
43:
44: public void testDeleteIndex() throws Exception {
45: String tablename = "testIndexDelete";
46: String colname = "indexcol";
47: String indexname = "indexcol_idx";
48:
49: createBasicTable(tablename, "id");
50: addBasicColumn(tablename, colname, Types.INTEGER, 0);
51:
52: // Create an index
53: createSimpleIndex(tablename, indexname, colname);
54:
55: DDLHelper.deleteIndex(spec, SCHEMA, fixIdentifier(tablename),
56: fixIdentifier(indexname));
57:
58: assertFalse(indexExists(tablename, indexname));
59: }
60:
61: public void testDeleteTable() throws Exception {
62: String tablename = "testDeleteTable";
63:
64: createBasicTable(tablename, "id");
65: assertTrue(tableExists(tablename));
66:
67: DDLHelper.deleteTable(spec, SCHEMA, fixIdentifier(tablename));
68:
69: assertFalse(tableExists(tablename));
70: }
71:
72: public void testDeleteView() throws Exception {
73: String tablename = "testDeleteViewTable";
74: String viewname = "testDeleteView";
75:
76: createBasicTable(tablename, "id");
77:
78: createView(viewname, "SELECT * FROM " + tablename);
79: assertTrue(viewExists(viewname));
80:
81: DDLHelper.deleteView(spec, SCHEMA, fixIdentifier(viewname));
82:
83: assertFalse(viewExists(viewname));
84: }
85:
86: }
|