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.dbschema.jdbcimpl;
043:
044: import java.sql.*;
045: import java.util.Arrays;
046:
047: import org.netbeans.modules.dbschema.*;
048:
049: public class ForeignKeyElementImpl extends KeyElementImpl implements
050: ForeignKeyElement.Impl {
051:
052: private TableElementImpl tei;
053:
054: public ForeignKeyElementImpl() {
055: this (null, null);
056: }
057:
058: public ForeignKeyElementImpl(TableElementImpl tei, String name) {
059: super (name);
060:
061: this .tei = tei;
062: }
063:
064: protected DBElementsCollection initializeCollection() {
065: return new DBElementsCollection(this , new ColumnPairElement[0]);
066: }
067:
068: public ColumnPairElement[] getColumnPairs() {
069: DBElement[] dbe = getColumnCollection().getElements();
070: return (ColumnPairElement[]) Arrays.asList(dbe).toArray(
071: new ColumnPairElement[dbe.length]);
072: }
073:
074: public ColumnPairElement getColumnPair(DBIdentifier name) {
075: return (ColumnPairElement) getColumnCollection().find(name);
076: }
077:
078: public void changeColumnPairs(ColumnPairElement[] pairs, int action)
079: throws DBException {
080: getColumnCollection().changeElements(pairs, action);
081: }
082:
083: public ColumnElement[] getColumns() {
084: ColumnPairElement[] cpe = getColumnPairs();
085:
086: if (cpe == null || cpe.length == 0)
087: return null;
088:
089: ColumnElement[] ce = new ColumnElement[cpe.length];
090:
091: for (int i = 0; i < cpe.length; i++) {
092: String localColumn = cpe[i].getName().getFullName();
093: int pos = localColumn.indexOf(";");
094: localColumn = localColumn.substring(0, pos);
095:
096: ce[i] = ((ForeignKeyElement) element).getDeclaringTable()
097: .getColumn(DBIdentifier.create(localColumn));
098: }
099:
100: return ce;
101: }
102:
103: public ColumnElement getColumn(DBIdentifier name) {
104: ColumnPairElement[] cpe = getColumnPairs();
105:
106: if (cpe == null || cpe.length == 0)
107: return null;
108:
109: for (int i = 0; i < cpe.length; i++) {
110: String localColumn = cpe[i].getName().getFullName();
111: int pos = localColumn.indexOf(";");
112: localColumn = localColumn.substring(0, pos);
113:
114: if (name.getName().equals(
115: DBIdentifier.create(localColumn).getName())) //need to check
116: return ((ForeignKeyElement) element)
117: .getDeclaringTable().getColumn(name);
118: }
119:
120: return null;
121: }
122:
123: }
|