@Override boolean catchException(DbEntity entity, SQLException ex) { LOGGER.info("Error getting relationships for '" + entity.getCatalog() + "." + entity.getSchema() + "', ignoring. " + ex.getMessage(), ex); return true; }
@Override ResultSet getResultSet(DbEntity dbEntity, DatabaseMetaData metaData) throws SQLException { return metaData.getPrimaryKeys(dbEntity.getCatalog(), dbEntity.getSchema(), dbEntity.getName()); }
/** * Returns catalog of the parent entity. */ public String getCatalog() { return (getParentEntity() != null) ? getParentEntity().getCatalog() : null; }
void setCatalog(String text) { if (text != null && text.trim().length() == 0) { text = null; } DbEntity ent = mediator.getCurrentDbEntity(); if (ent != null && !Util.nullSafeEquals(ent.getCatalog(), text)) { ent.setCatalog(text); mediator.fireDbEntityEvent(new EntityEvent(this, ent)); } }
@Override ResultSet getResultSet(DbEntity dbEntity, DatabaseMetaData metaData) throws SQLException { return metaData.getExportedKeys(dbEntity.getCatalog(), dbEntity.getSchema(), dbEntity.getName()); }
private Collection<DbEntity> filter() { if(filtersConfig == null) { return container.getDbEntities(); } Collection<DbEntity> existingFiltered = new LinkedList<>(); for (DbEntity entity : container.getDbEntities()) { TableFilter tableFilter = filtersConfig.tableFilter(entity.getCatalog(), entity.getSchema()); if (tableFilter != null && tableFilter.isIncludeTable(entity.getName())) { existingFiltered.add(entity); } } return existingFiltered; } }
/** * Returns expected primary key sequence name for a DbEntity. */ protected String sequenceName(DbEntity entity) { // use custom generator if possible DbKeyGenerator keyGenerator = entity.getPrimaryKeyGenerator(); if (keyGenerator != null && DbKeyGenerator.ORACLE_TYPE.equals(keyGenerator.getGeneratorType()) && keyGenerator.getGeneratorName() != null) { return keyGenerator.getGeneratorName().toLowerCase(); } else { String seqName = getSequencePrefix() + entity.getName().toLowerCase(); return adapter.getQuotingStrategy().quotedIdentifier(entity, entity.getCatalog(), entity.getSchema(), seqName); } }
@Override public String quotedFullyQualifiedName(DbEntity entity) { return quotedIdentifier(entity.getDataMap(), entity.getCatalog(), entity.getSchema(), entity.getName()); }
while (entitiesToConvert.hasNext()) { DbEntity entity = (DbEntity) entitiesToConvert.next(); Table table = new Table(entity.getCatalog(), entity.getSchema(), entity .getName()); fillInMetadata(table, entity);
if (targetAttribute.isPrimaryKey()) { ForeignKey fk = new ForeignKey(); fk.setPkTableCatalog(target.getCatalog()); fk.setPkTableSchema(target.getSchema()); fk.setPkTableName(target.getName());
/** * Prints itself as XML to the provided XMLEncoder. * * @since 1.1 */ public void encodeAsXML(XMLEncoder encoder) { encoder.print("<db-entity name=\""); encoder.print(Util.encodeXmlAttribute(getName())); encoder.print('\"'); if (getSchema() != null && getSchema().trim().length() > 0) { encoder.print(" schema=\""); encoder.print(Util.encodeXmlAttribute(getSchema().trim())); encoder.print('\"'); } if (getCatalog() != null && getCatalog().trim().length() > 0) { encoder.print(" catalog=\""); encoder.print(Util.encodeXmlAttribute(getCatalog().trim())); encoder.print('\"'); } encoder.println('>'); encoder.indent(1); encoder.print(getAttributeMap()); if (getPrimaryKeyGenerator() != null) { getPrimaryKeyGenerator().encodeAsXML(encoder); } encoder.indent(-1); encoder.println("</db-entity>"); }
if (getCatalog() != null && getCatalog().trim().length() > 0) { encoder.print(" catalog=\""); encoder.print(Util.encodeXmlAttribute(getCatalog().trim())); encoder.print('\"');
pkEntity.getCatalog(), pkEntity.getSchema(), pkEntity.getName());
catalog.setText(entity.getCatalog()); schema.setText(entity.getSchema()); qualifier.setText(new ExpressionConvertor().valueAsString(entity.getQualifier()));
.append(pkEntity.getCatalog(), PK.getCatalog()) .append(pkEntity.getSchema(), PK.getSchema()).append(fkEntity.getCatalog(), FK.getCatalog()) .append(fkEntity.getSchema(), PK.getSchema()).isEquals()) { LOGGER.info(" primary key entity: '" + pkEntity.getCatalog() + "." + pkEntity.getSchema() + "'"); LOGGER.info(" relation foreign key: '" + FK.getCatalog() + "." + FK.getSchema() + "'"); LOGGER.info(" foreign key entity: '" + fkEntity.getCatalog() + "." + fkEntity.getSchema() + "'"); continue;
private void searchInDbEntities(Pattern pattern, List<SearchResultEntry> result, DataMap dataMap) { for (DbEntity ent : dataMap.getDbEntities()) { if (match(ent.getName(), pattern)) { result.add(new SearchResultEntry(ent, ent.getName())); } for (DbAttribute attr : ent.getAttributes()) { if (match(attr.getName(), pattern)) { result.add(new SearchResultEntry(attr, ent.getName() + "." + attr.getName())); } } for (DbRelationship rel : ent.getRelationships()) { if (match(rel.getName(), pattern)) { result.add(new SearchResultEntry(rel, ent.getName() + "." + rel.getName())); } } checkCatalogOrSchema(pattern, result, ent, ent.getCatalog()); checkCatalogOrSchema(pattern, result, ent, ent.getSchema()); } }
protected void updateCatalog() { boolean doAll = isAllEntities(); String defaultCatalog = dataMap.getDefaultCatalog(); // set catalog for DbEntities for (DbEntity entity : dataMap.getDbEntities()) { if (doAll || Util.isEmptyString(entity.getCatalog())) { if (!Util.nullSafeEquals(defaultCatalog, entity.getCatalog())) { entity.setCatalog(defaultCatalog); // any way to batch events, a big change will flood the app // with entity events..? mediator.fireDbEntityEvent(new EntityEvent(this, entity)); } } } // set catalog for procedures... for (Procedure procedure : dataMap.getProcedures()) { if (doAll || Util.isEmptyString(procedure.getCatalog())) { if (!Util.nullSafeEquals(defaultCatalog, procedure.getCatalog())) { procedure.setCatalog(defaultCatalog); // any way to batch events, a big change will flood the app // with procedure events..? mediator.fireProcedureEvent(new ProcedureEvent(this, procedure)); } } } view.dispose(); }