/** * Expands the specified tree node. * * @param node the tree node to expand */ public void expandNode(ObjectTreeNode node) { IDatabaseObjectInfo info = node.getDatabaseObjectInfo(); TreePath path = getTreePath(info.getCatalogName(), info.getSchemaName(), new FilterMatcher(info.getSimpleName(), null)); _tree.fireTreeExpanded(path); }
public static IDatabaseObjectInfo getSchemaFromDbObject(IDatabaseObjectInfo dbObject, SchemaInfo schemaInfo) { if (dbObject.getDatabaseObjectType().equals(DatabaseObjectType.SCHEMA)) { return dbObject; } else { return new DatabaseObjectInfo(dbObject.getCatalogName(), dbObject.getSchemaName(), dbObject.getSimpleName(), DatabaseObjectType.SCHEMA, schemaInfo.getSQLDatabaseMetaData()); } } }
private boolean dbObjectInfoEquals(String catalog, String schema, FilterMatcher objectMatcher, IDatabaseObjectInfo doi) { if(null != catalog) { if(false == catalog.equalsIgnoreCase(doi.getCatalogName())) { return false; } } if(null != schema) { if(false == schema.equalsIgnoreCase(doi.getSchemaName())) { return false; } } if(null != objectMatcher.getMetaDataMatchString()) { if( false == objectMatcher.matches(doi.getSimpleName()) && false == objectMatcher.getMetaDataMatchString().equalsIgnoreCase(doi.getQualifiedName())) { return false; } } return true; }
public static String getSchemaNameFromDbObject(IDatabaseObjectInfo dbObject) { String destSchema; if (dbObject.getDatabaseObjectType().equals(DatabaseObjectType.SCHEMA)) { destSchema = dbObject.getSimpleName(); } else { destSchema = dbObject.getSchemaName(); } return destSchema; }
/** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.PSFormattedSourceTab#getBindValues() */ @Override protected String[] getBindValues() { final IDatabaseObjectInfo doi = getDatabaseObjectInfo(); return new String[] { doi.getCatalogName(), doi.getSimpleName() }; }
/** * This method simply returns a String array containing the schema name and the selected object's simple * name, in that order. If the SQL returned from getSqlStatement must specify a different order, or for * example uses that catalog of the object, instead of or in addition to schema, then this method must be * overridden to return the necessary bind variable values, in the order required by the SQL statement. * * @return a String array of bind variable values */ protected String[] getBindValues() { final IDatabaseObjectInfo doi = getDatabaseObjectInfo(); return new String[] { doi.getSchemaName(), doi.getSimpleName() }; }
else if(DatabaseObjectType.TABLE_TYPE_DBO == doi.getDatabaseObjectType()) _schemaInfoCache.clearTables(doi.getCatalogName(), doi.getSchemaName(), null, null); loadTables(doi.getCatalogName(), doi.getSchemaName(), null, null, 0); else if(DatabaseObjectType.TABLE == doi.getDatabaseObjectType()) _schemaInfoCache.clearTables(doi.getCatalogName(), doi.getSchemaName(), null, new String[]{"TABLE"}); loadTables(doi.getCatalogName(), doi.getSchemaName(), null, new String[]{"TABLE"}, 1); else if(DatabaseObjectType.VIEW == doi.getDatabaseObjectType()) _schemaInfoCache.clearTables(doi.getCatalogName(), doi.getSchemaName(), null, new String[]{"VIEW"}); loadTables(doi.getCatalogName(), doi.getSchemaName(), null, new String[]{"VIEW"}, 1); else if(DatabaseObjectType.PROCEDURE == doi.getDatabaseObjectType() || DatabaseObjectType.PROC_TYPE_DBO == doi.getDatabaseObjectType()) _schemaInfoCache.clearStoredProcedures(doi.getCatalogName(), doi.getSchemaName(), null); loadStoredProcedures(doi.getCatalogName(), doi.getSchemaName(), null, 1); else if(DatabaseObjectType.SCHEMA == doi.getDatabaseObjectType()) _schemaInfoCache.clearTables(null, doi.getSchemaName(), null, null); int progress = loadTables(null, doi.getSchemaName(), null, null, 1); _schemaInfoCache.clearStoredProcedures(null, doi.getSchemaName(), null); loadStoredProcedures(null, doi.getSchemaName(), null, progress); else if(DatabaseObjectType.CATALOG == doi.getDatabaseObjectType())
/** * Create the child nodes for the passed parent node and return them. Note * that this method should <B>not</B> actually add the child nodes to the * parent node as this is taken care of in the caller. * * @param session Current session. * @param node Node to be expanded. * * @return A list of <TT>ObjectTreeNode</TT> objects representing the child * nodes for the passed node. */ public List<ObjectTreeNode> createChildren(ISession session, ObjectTreeNode parentNode) throws SQLException { final IDatabaseObjectInfo parentDbinfo = parentNode.getDatabaseObjectInfo(); final String catalogName = parentDbinfo.getCatalogName(); final String schemaName = parentDbinfo.getSchemaName(); return createProcedureNodes(session, catalogName, schemaName); }
if (parentDbinfo.getDatabaseObjectType() == DatabaseObjectType.SESSION) else if (parentDbinfo.getDatabaseObjectType() == DatabaseObjectType.CATALOG) final String catalogName = parentDbinfo.getSimpleName(); List<ObjectTreeNode> addedChildren = new ArrayList<ObjectTreeNode>(); if (supportsSchemas) else if (parentDbinfo.getDatabaseObjectType() == DatabaseObjectType.SCHEMA) final String catalogName = parentDbinfo.getCatalogName(); final String schemaName = parentDbinfo.getSimpleName(); childNodes.addAll(createObjectTypeNodes(session, catalogName, schemaName));
ResultSet rs = rowCountStmt.executeQuery("select count(*) from " + dbinfo.getQualifiedName()); try StringBuilder buf = new StringBuilder(dbinfo.getSimpleName()); buf.append(" (").append(nbrRows).append(")"); return buf.toString(); s_log.error("Error retrieving row count for: " + dbinfo.getQualifiedName(), ex); return dbinfo.getSimpleName(); return dbinfo.getSimpleName();
private boolean isMQT() { final IDatabaseObjectInfo doi = getDatabaseObjectInfo(); boolean isMQT = false; if (doi.getDatabaseObjectType() == DatabaseObjectType.TABLE) { ITableInfo info = (ITableInfo) doi; if (info.getType().startsWith("MATERIALIZED")) { isMQT = true; if (s_log.isDebugEnabled()) { s_log.debug("Table " + doi.getSimpleName() + " appears to be an MQT"); } } else { if (s_log.isDebugEnabled()) { s_log.debug("Table " + doi.getSimpleName() + " appears to be a regular table"); } } } return isMQT; }
/** * Gets the simple view names of the selected DatabaseObjectInfos. * * @param dbInfo InfoObjects of the selected items in the tree. * @return the simple names of the database item. */ private String[] getSimpleNames(IDatabaseObjectInfo[] dbInfo) { String[] result = new String[dbInfo.length]; for (int i = 0; i < result.length; i++) { result[i] = dbInfo[i].getSimpleName(); } return result; }
/** * Convenience method to get the database object type for this node. * * @return the database object type of this node. */ public DatabaseObjectType getDatabaseObjectType() { return _dboInfo.getDatabaseObjectType(); }
public IndexParentInfo(IDatabaseObjectInfo tableInfo, String schema, SQLDatabaseMetaData md) throws SQLException { super(tableInfo.getCatalogName(), schema, "INDEX", DatabaseObjectType.INDEX_TYPE_DBO, md); _tableInfo = tableInfo; }
public Object getValueAt(int rowIndex, int columnIndex) { switch (columnIndex) { case 0: return _objectInfo.get(rowIndex); case 1: return _objectInfo.get(rowIndex).getSchemaName(); default: return null; } }
if (DatabaseObjectType.TABLE_TYPE_DBO.equals(dbObjs[0].getDatabaseObjectType())) { IDatabaseObjectInfo tableLabelInfo = dbObjs[0]; ISQLConnection destCon = destSession.getSQLConnection(); tableLabelInfo.getSchemaName(), tableLabelInfo.getSchemaName(), DatabaseObjectType.SCHEMA, md);
/** * Retrieve the MySQL command to run. * * * @return the MySQL command to run. */ protected String getMySQLCommand(IDatabaseObjectInfo dbObj) { return "explain " + dbObj.getQualifiedName(); } }
/** * This method simply returns a String array containing the schema name and the selected object's simple * name, in that order. If the SQL returned from getSqlStatement must specify a different order, or for * example uses that catalog of the object, instead of or in addition to schema, then this method must be * overridden to return the necessary bind variable values, in the order required by the SQL statement. * * @return a String array of bind variable values */ protected String[] getBindValues() { final IDatabaseObjectInfo doi = getDatabaseObjectInfo(); return new String[] { doi.getSchemaName(), doi.getSimpleName() }; }
/** * @see net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.tabs.table.PSFormattedSourceTab#getBindValues() */ @Override protected String[] getBindValues() { final IDatabaseObjectInfo doi = getDatabaseObjectInfo(); return new String[] { doi.getCatalogName(), doi.getSimpleName() }; }
else if(DatabaseObjectType.TABLE_TYPE_DBO == doi.getDatabaseObjectType()) _schemaInfoCache.clearTables(doi.getCatalogName(), doi.getSchemaName(), null, null); loadTables(doi.getCatalogName(), doi.getSchemaName(), null, null, 0); else if(DatabaseObjectType.TABLE == doi.getDatabaseObjectType()) _schemaInfoCache.clearTables(doi.getCatalogName(), doi.getSchemaName(), null, new String[]{"TABLE"}); loadTables(doi.getCatalogName(), doi.getSchemaName(), null, new String[]{"TABLE"}, 1); else if(DatabaseObjectType.VIEW == doi.getDatabaseObjectType()) _schemaInfoCache.clearTables(doi.getCatalogName(), doi.getSchemaName(), null, new String[]{"VIEW"}); loadTables(doi.getCatalogName(), doi.getSchemaName(), null, new String[]{"VIEW"}, 1); else if(DatabaseObjectType.PROCEDURE == doi.getDatabaseObjectType() || DatabaseObjectType.PROC_TYPE_DBO == doi.getDatabaseObjectType()) _schemaInfoCache.clearStoredProcedures(doi.getCatalogName(), doi.getSchemaName(), null); loadStoredProcedures(doi.getCatalogName(), doi.getSchemaName(), null, 1); else if(DatabaseObjectType.SCHEMA == doi.getDatabaseObjectType()) _schemaInfoCache.clearTables(null, doi.getSchemaName(), null, null); int progress = loadTables(null, doi.getSchemaName(), null, null, 1); _schemaInfoCache.clearStoredProcedures(null, doi.getSchemaName(), null); loadStoredProcedures(null, doi.getSchemaName(), null, progress); else if(DatabaseObjectType.CATALOG == doi.getDatabaseObjectType())