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.actions;
29:
30: import java.util.Iterator;
31: import java.util.Set;
32: import org.netbeans.lib.ddl.impl.CreateIndex;
33: import org.netbeans.lib.ddl.impl.DropIndex;
34: import org.netbeans.lib.ddl.impl.Specification;
35: import org.netbeans.modules.db.explorer.dlg.ColumnItem;
36:
37: /**
38: * Factors out logic to work with DDL package so we can unit test it
39: */
40: public class AddToIndexDDL {
41: Specification spec;
42: String schema;
43: String tablename;
44:
45: public AddToIndexDDL(Specification spec, String schema,
46: String tablename) {
47: this .spec = spec;
48: this .schema = schema;
49: this .tablename = tablename;
50: }
51:
52: public boolean execute(String indexName, boolean unique, Set columns)
53: throws Exception {
54: CreateIndex icmd = spec.createCommandCreateIndex(tablename);
55: // Quote the index name in this case because we're recreating an
56: // existing index name
57: icmd.setIndexName(icmd.quote(indexName));
58: icmd.setObjectOwner(schema);
59: icmd.setIndexType(unique ? ColumnItem.UNIQUE : "");
60:
61: Iterator enu = columns.iterator();
62: while (enu.hasNext()) {
63: icmd.specifyColumn((String) enu.next());
64: }
65:
66: DropIndex dicmd = spec.createCommandDropIndex(indexName);
67: dicmd.setObjectOwner(schema);
68: dicmd.setTableName(tablename);
69: dicmd.execute();
70: icmd.execute();
71:
72: return (icmd.wasException() || dicmd.wasException());
73: }
74:
75: }
|