Examples with ERDAssociation org.jkiss.dbeaver.ext.erd.model.ERDAssociation used on opensource projects

Example 1 with ERDAssociation

use of org.jkiss.dbeaver.ext.erd.model.ERDAssociation in project dbeaver by serge-rider.

the class AssociationEditPolicy method createDeleteCommand.

@Override
protected Command createDeleteCommand(GroupRequest request) {
    ERDAssociation relationship = (ERDAssociation) getHost().getModel();
    ERDEntity primaryKeyTarget = relationship.getPrimaryKeyEntity();
    ERDEntity foreignKeySource = relationship.getForeignKeyEntity();
    AssociationDeleteCommand deleteCmd = new AssociationDeleteCommand(foreignKeySource, primaryKeyTarget, relationship);
    return deleteCmd;
}

Example 2 with ERDAssociation

use of org.jkiss.dbeaver.ext.erd.model.ERDAssociation in project dbeaver by serge-rider.

the class ERDExportGraphML method exportDiagramToGraphML.

void exportDiagramToGraphML(String filePath) {
    try {
        try (FileOutputStream fos = new FileOutputStream(filePath)) {
            XMLBuilder xml = new XMLBuilder(fos, GeneralUtils.UTF8_ENCODING);
            xml.setButify(true);
            xml.startElement("graphml");
            xml.addAttribute("xmlns", "http://graphml.graphdrawing.org/xmlns");
            xml.addAttribute("xmlns:xsi", "http://www.w3.org/2001/XMLSchema-instance");
            xml.addAttribute("xsi:schemaLocation", "http://graphml.graphdrawing.org/xmlns/1.0/graphml.xsd");
            xml.addAttribute("xmlns:y", "http://www.yworks.com/xml/graphml");
            xml.startElement("key");
            xml.addAttribute("for", "node");
            xml.addAttribute("id", "nodegraph");
            xml.addAttribute("yfiles.type", "nodegraphics");
            xml.endElement();
            xml.startElement("key");
            xml.addAttribute("for", "edge");
            xml.addAttribute("id", "edgegraph");
            xml.addAttribute("yfiles.type", "edgegraphics");
            xml.endElement();
            xml.startElement("graph");
            xml.addAttribute("edgedefault", "directed");
            xml.addAttribute("id", "G");
            Map<ERDEntity, String> entityMap = new HashMap<>();
            int nodeNum = 0;
            for (ERDEntity entity : diagram.getEntities()) {
                nodeNum++;
                String nodeId = "n" + nodeNum;
                entityMap.put(entity, nodeId);
                // node
                xml.startElement("node");
                xml.addAttribute("id", nodeId);
                {
                    // Graph data
                    xml.startElement("data");
                    xml.addAttribute("key", "nodegraph");
                    {
                        // Generic node
                        EntityPart entityPart = diagramPart.getEntityPart(entity);
                        EntityFigure entityFigure = (EntityFigure) entityPart.getFigure();
                        Rectangle partBounds = entityPart.getBounds();
                        xml.startElement("y:GenericNode");
                        xml.addAttribute("configuration", "com.yworks.entityRelationship.big_entity");
                        // Geometry
                        xml.startElement("y:Geometry");
                        xml.addAttribute("height", partBounds.height());
                        xml.addAttribute("width", partBounds.width);
                        xml.addAttribute("x", partBounds.x());
                        xml.addAttribute("y", partBounds.y());
                        xml.endElement();
                        // Fill
                        xml.startElement("y:Fill");
                        xml.addAttribute("color", getHtmlColor(entityFigure.getBackgroundColor()));
                        //xml.addAttribute("color2", partBounds.width);
                        xml.addAttribute("transparent", "false");
                        xml.endElement();
                        // Border
                        xml.startElement("y:BorderStyle");
                        xml.addAttribute("color", getHtmlColor(entityFigure.getForegroundColor()));
                        xml.addAttribute("type", "line");
                        xml.addAttribute("width", "1.0");
                        xml.endElement();
                        {
                            // Entity Name
                            Rectangle nameBounds = entityFigure.getNameLabel().getBounds();
                            xml.startElement("y:NodeLabel");
                            xml.addAttribute("alignment", "center");
                            xml.addAttribute("autoSizePolicy", "content");
                            xml.addAttribute("configuration", "com.yworks.entityRelationship.label.name");
                            xml.addAttribute("fontFamily", "Courier");
                            xml.addAttribute("fontSize", "12");
                            xml.addAttribute("fontStyle", "plain");
                            xml.addAttribute("hasLineColor", "false");
                            xml.addAttribute("modelName", "internal");
                            xml.addAttribute("modelPosition", "t");
                            xml.addAttribute("backgroundColor", getHtmlColor(entityFigure.getNameLabel().getBackgroundColor()));
                            xml.addAttribute("textColor", getHtmlColor(entityFigure.getNameLabel().getForegroundColor()));
                            xml.addAttribute("visible", "true");
                            xml.addAttribute("height", nameBounds.height());
                            xml.addAttribute("width", nameBounds.width);
                            xml.addAttribute("x", nameBounds.x());
                            xml.addAttribute("y", nameBounds.y());
                            xml.addText(entity.getName());
                            xml.endElement();
                        }
                        {
                            // Attributes
                            AttributeListFigure columnsFigure = entityFigure.getColumnsFigure();
                            Rectangle attrsBounds = columnsFigure.getBounds();
                            xml.startElement("y:NodeLabel");
                            xml.addAttribute("alignment", "left");
                            xml.addAttribute("autoSizePolicy", "content");
                            xml.addAttribute("configuration", "com.yworks.entityRelationship.label.attributes");
                            xml.addAttribute("fontFamily", "Courier");
                            xml.addAttribute("fontSize", "12");
                            xml.addAttribute("fontStyle", "plain");
                            xml.addAttribute("hasLineColor", "false");
                            xml.addAttribute("modelName", "custom");
                            xml.addAttribute("modelPosition", "t");
                            xml.addAttribute("backgroundColor", getHtmlColor(columnsFigure.getBackgroundColor()));
                            xml.addAttribute("textColor", getHtmlColor(columnsFigure.getForegroundColor()));
                            xml.addAttribute("visible", "true");
                            xml.addAttribute("height", attrsBounds.height());
                            xml.addAttribute("width", attrsBounds.width);
                            xml.addAttribute("x", attrsBounds.x());
                            xml.addAttribute("y", attrsBounds.y());
                            StringBuilder attrsString = new StringBuilder();
                            for (ERDEntityAttribute attr : entity.getColumns()) {
                                if (attrsString.length() > 0) {
                                    attrsString.append("\n");
                                }
                                attrsString.append(attr.getName());
                            }
                            xml.addText(attrsString.toString());
                            xml.startElement("y:LabelModel");
                            xml.startElement("y:ErdAttributesNodeLabelModel");
                            xml.endElement();
                            xml.endElement();
                            xml.startElement("y:ModelParameter");
                            xml.startElement("y:ErdAttributesNodeLabelModelParameter");
                            xml.endElement();
                            xml.endElement();
                            xml.endElement();
                        }
                        xml.endElement();
                    }
                    xml.endElement();
                }
                xml.endElement();
            }
            int edgeNum = 0;
            for (ERDEntity entity : diagram.getEntities()) {
                EntityPart entityPart = diagramPart.getEntityPart(entity);
                for (ERDAssociation association : entity.getForeignKeyRelationships()) {
                    AssociationPart associationPart = entityPart.getConnectionPart(association, true);
                    if (associationPart == null) {
                        log.debug("Association part not found");
                        continue;
                    }
                    edgeNum++;
                    String edgeId = "e" + edgeNum;
                    xml.startElement("edge");
                    xml.addAttribute("id", edgeId);
                    xml.addAttribute("source", entityMap.get(entity));
                    xml.addAttribute("target", entityMap.get(association.getPrimaryKeyEntity()));
                    xml.startElement("data");
                    xml.addAttribute("key", "edgegraph");
                    xml.startElement("y:PolyLineEdge");
                    // sx="0.0" sy="0.0" tx="0.0" ty="0.0"/>
                    xml.startElement("y:Path");
                    for (Bendpoint bp : associationPart.getBendpoints()) {
                        xml.startElement("y:Point");
                        xml.addAttribute("x", bp.getLocation().x);
                        xml.addAttribute("y", bp.getLocation().x);
                        xml.endElement();
                    }
                    xml.endElement();
                    xml.startElement("y:LineStyle");
                    xml.addAttribute("color", "#000000");
                    xml.addAttribute("type", !association.isIdentifying() || association.isLogical() ? "dashed" : "line");
                    xml.addAttribute("width", "1.0");
                    xml.endElement();
                    xml.startElement("y:Arrows");
                    String sourceStyle = !association.isIdentifying() ? "white_diamond" : "none";
                    xml.addAttribute("source", sourceStyle);
                    xml.addAttribute("target", "circle");
                    xml.endElement();
                    xml.startElement("y:BendStyle");
                    xml.addAttribute("smoothed", "false");
                    xml.endElement();
                    xml.endElement();
                    xml.endElement();
                    xml.endElement();
                }
            }
            xml.endElement();
            xml.endElement();
            xml.flush();
            fos.flush();
        }
        UIUtils.launchProgram(filePath);
    } catch (Exception e) {
        UIUtils.showErrorDialog(null, "Save ERD as GraphML", null, e);
    }
}

Example 3 with ERDAssociation

use of org.jkiss.dbeaver.ext.erd.model.ERDAssociation in project dbeaver by serge-rider.

the class AssociationReconnectSourceCommand method canExecute.

/**
	 * Makes sure that primary key doesn't reconnect to itself or try to create
	 * a relationship which already exists
	 */
@Override
public boolean canExecute() {
    boolean returnVal = true;
    ERDEntity primaryKeyEntity = relationship.getPrimaryKeyEntity();
    //cannot connect to itself
    if (primaryKeyEntity.equals(sourceForeignKey)) {
        returnVal = false;
    } else {
        List<?> relationships = sourceForeignKey.getForeignKeyRelationships();
        for (int i = 0; i < relationships.size(); i++) {
            ERDAssociation relationship = ((ERDAssociation) (relationships.get(i)));
            if (relationship.getPrimaryKeyEntity().equals(targetPrimaryKey) && relationship.getForeignKeyEntity().equals(sourceForeignKey)) {
                returnVal = false;
                break;
            }
        }
    }
    return returnVal;
}

Example 4 with ERDAssociation

use of org.jkiss.dbeaver.ext.erd.model.ERDAssociation in project dbeaver by serge-rider.

the class EntityDeleteCommand method deleteRelationships.

private void deleteRelationships(ERDEntity t) {
    this.foreignKeyRelationships.addAll(t.getForeignKeyRelationships());
    //for all relationships where current entity is foreign key
    for (int i = 0; i < foreignKeyRelationships.size(); i++) {
        ERDAssociation r = foreignKeyRelationships.get(i);
        r.getPrimaryKeyEntity().removePrimaryKeyRelationship(r, true);
        t.removeForeignKeyRelationship(r, true);
    }
    //for all relationships where current entity is primary key
    this.primaryKeyRelationships.addAll(t.getPrimaryKeyRelationships());
    for (int i = 0; i < primaryKeyRelationships.size(); i++) {
        ERDAssociation r = primaryKeyRelationships.get(i);
        r.getForeignKeyEntity().removeForeignKeyRelationship(r, true);
        t.removePrimaryKeyRelationship(r, true);
    }
}

Example 5 with ERDAssociation

use of org.jkiss.dbeaver.ext.erd.model.ERDAssociation in project dbeaver by serge-rider.

the class EntityDeleteCommand method restoreRelationships.

private void restoreRelationships() {
    for (int i = 0; i < foreignKeyRelationships.size(); i++) {
        ERDAssociation r = foreignKeyRelationships.get(i);
        r.getForeignKeyEntity().addForeignKeyRelationship(r, true);
        r.getPrimaryKeyEntity().addPrimaryKeyRelationship(r, true);
    }
    foreignKeyRelationships.clear();
    for (int i = 0; i < primaryKeyRelationships.size(); i++) {
        ERDAssociation r = primaryKeyRelationships.get(i);
        r.getForeignKeyEntity().addForeignKeyRelationship(r, true);
        r.getPrimaryKeyEntity().addPrimaryKeyRelationship(r, true);
    }
    primaryKeyRelationships.clear();
}