001: /*
002: * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
003: *
004: * Copyright 1997-2007 Sun Microsystems, Inc. All rights reserved.
005: *
006: * The contents of this file are subject to the terms of either the GNU
007: * General Public License Version 2 only ("GPL") or the Common
008: * Development and Distribution License("CDDL") (collectively, the
009: * "License"). You may not use this file except in compliance with the
010: * License. You can obtain a copy of the License at
011: * http://www.netbeans.org/cddl-gplv2.html
012: * or nbbuild/licenses/CDDL-GPL-2-CP. See the License for the
013: * specific language governing permissions and limitations under the
014: * License. When distributing the software, include this License Header
015: * Notice in each file and include the License file at
016: * nbbuild/licenses/CDDL-GPL-2-CP. Sun designates this
017: * particular file as subject to the "Classpath" exception as provided
018: * by Sun in the GPL Version 2 section of the License file that
019: * accompanied this code. If applicable, add the following below the
020: * License Header, with the fields enclosed by brackets [] replaced by
021: * your own identifying information:
022: * "Portions Copyrighted [year] [name of copyright owner]"
023: *
024: * Contributor(s):
025: *
026: * The Original Software is NetBeans. The Initial Developer of the Original
027: * Software is Sun Microsystems, Inc. Portions Copyright 1997-2006 Sun
028: * Microsystems, Inc. All Rights Reserved.
029: *
030: * If you wish your version of this file to be governed by only the CDDL
031: * or only the GPL Version 2, indicate your decision by adding
032: * "[Contributor] elects to include this software in this distribution
033: * under the [CDDL or GPL Version 2] license." If you do not indicate a
034: * single choice of license, a recipient has the option to distribute
035: * your version of this file under either the CDDL, the GPL Version 2 or
036: * to extend the choice of license to its licensees as provided above.
037: * However, if you add GPL Version 2 code and therefore, elected the GPL
038: * Version 2 license, then the option applies only if the new code is
039: * made subject to such option by the copyright holder.
040: */
041:
042: package org.netbeans.modules.db.explorer.actions;
043:
044: import java.sql.*;
045: import java.text.MessageFormat;
046: import java.util.*;
047: import org.netbeans.modules.db.explorer.DbUtilities;
048:
049: import org.openide.*;
050: import org.openide.nodes.*;
051:
052: import org.netbeans.lib.ddl.*;
053: import org.netbeans.lib.ddl.impl.*;
054: import org.netbeans.lib.ddl.adaptors.*;
055: import org.netbeans.modules.db.explorer.*;
056: import org.netbeans.modules.db.explorer.dlg.*;
057: import org.netbeans.modules.db.explorer.nodes.*;
058: import org.netbeans.modules.db.explorer.infos.*;
059:
060: public class AddIndexAction extends DatabaseAction {
061: public void performAction(Node[] activatedNodes) {
062: Node node;
063: if (activatedNodes != null && activatedNodes.length > 0)
064: node = activatedNodes[0];
065: else
066: return;
067:
068: try {
069: DatabaseNodeInfo info = (DatabaseNodeInfo) node
070: .getCookie(DatabaseNodeInfo.class);
071: IndexListNodeInfo nfo = (IndexListNodeInfo) info
072: .getParent(nodename);
073:
074: String tablename = (String) nfo.get(DatabaseNode.TABLE);
075: String columnname = (String) nfo.get(DatabaseNode.COLUMN);
076:
077: Specification spec = (Specification) nfo.getSpecification();
078: String index = (String) nfo.get(DatabaseNode.INDEX);
079: DriverSpecification drvSpec = info.getDriverSpecification();
080:
081: // List columns not present in current index
082: Vector cols = new Vector(5);
083:
084: drvSpec.getColumns(tablename, "%");
085: ResultSet rs = drvSpec.getResultSet();
086: HashMap rset = new HashMap();
087: while (rs.next()) {
088: rset = drvSpec.getRow();
089: cols.add((String) rset.get(new Integer(4)));
090: rset.clear();
091: }
092: rs.close();
093:
094: if (cols.size() == 0)
095: throw new Exception(bundle().getString(
096: "EXC_NoUsableColumnInPlace")); // NOI18N
097:
098: // Create and execute command
099: AddIndexDialog dlg = new AddIndexDialog(cols, spec, info);
100: dlg.setIndexName(tablename + "_idx"); // NOI18N
101: if (dlg.run()) {
102: nfo.addIndex(dlg.getIndexName());
103: }
104: } catch (Exception exc) {
105: DbUtilities.reportError(bundle().getString(
106: "ERR_UnableToAddIndex"), exc.getMessage()); // NOI18N
107: }
108: }
109: }
|