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-2007 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.sql.framework.ui.output.dataview;
043:
044: import com.sun.sql.framework.exception.BaseException;
045: import com.sun.sql.framework.exception.DBSQLException;
046: import java.sql.Connection;
047: import java.util.List;
048: import org.netbeans.modules.sql.framework.codegen.AbstractGeneratorFactory;
049: import org.netbeans.modules.sql.framework.codegen.DB;
050: import org.netbeans.modules.sql.framework.codegen.DBFactory;
051: import org.netbeans.modules.sql.framework.codegen.StatementContext;
052: import org.netbeans.modules.sql.framework.common.jdbc.SQLUtils;
053: import org.netbeans.modules.sql.framework.common.utils.DBExplorerUtil;
054: import org.netbeans.modules.sql.framework.model.DBColumn;
055: import org.netbeans.modules.sql.framework.model.DBConnectionDefinition;
056: import org.netbeans.modules.sql.framework.model.SQLDBModel;
057: import org.netbeans.modules.sql.framework.model.SQLDBTable;
058: import org.openide.util.Exceptions;
059:
060: /**
061: *
062: * @author Ahimanikya Satapathy
063: */
064: public class DBTableMetadata {
065: private SQLDBTable dbTable;
066: private DBConnectionDefinition connDef;
067: private List<DBColumn> columns;
068: private int dbType;
069: private AbstractGeneratorFactory genFactory;
070: private StatementContext stmtContext = new StatementContext();
071:
072: public DBTableMetadata(SQLDBTable table) {
073: try {
074: construct(table);
075: DB db = DBFactory.getInstance().getDatabase(dbType);
076: genFactory = db.getGeneratorFactory();
077: } catch (BaseException ex) {
078: throw new RuntimeException(ex.getMessage());
079: }
080: }
081:
082: public Connection createConnection() throws DBSQLException {
083: return DBExplorerUtil.createConnection(connDef
084: .getConnectionProperties());
085: }
086:
087: public void refresh(SQLDBTable table) throws DBSQLException {
088: if (table.getColumnList().size() != getColumnCount()) {
089: construct(table);
090: }
091: }
092:
093: public SQLDBTable getTable() {
094: return dbTable;
095: }
096:
097: public boolean isDBType(int type) {
098: return type == dbType ? true : false;
099: }
100:
101: public String getQualifiedTableName() {
102: try {
103: return genFactory.generate(dbTable, stmtContext);
104: } catch (BaseException ex) {
105: Exceptions.printStackTrace(ex);
106: }
107: return dbTable.getName();
108: }
109:
110: public DBColumn getColumn(int index) {
111: return columns.get(index);
112: }
113:
114: public int getColumnType(int index) {
115: return columns.get(index).getJdbcType();
116: }
117:
118: public String getColumnName(int index) {
119: return columns.get(index).getName();
120: }
121:
122: public int getColumnCount() {
123: return columns.size();
124: }
125:
126: public int getDBType() {
127: return dbType;
128: }
129:
130: private void construct(SQLDBTable table) throws DBSQLException {
131: try {
132: dbTable = table;
133: columns = dbTable.getColumnList();
134: connDef = ((SQLDBModel) dbTable.getParentObject())
135: .getETLDBConnectionDefinition();
136: dbType = SQLUtils.getSupportedDBType(connDef.getDBType());
137: } catch (Exception ex) {
138: throw new DBSQLException(ex);
139: }
140: }
141:
142: }
|