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

Example 1 with ERDAssociation

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

the class EntityDeleteCommand method deleteRelationships.

private void deleteRelationships(ERDEntity t) {
    this.foreignKeyRelationships.addAll(t.getAssociations());
    // for all relationships where current entity is foreign key
    for (ERDAssociation association : foreignKeyRelationships) {
        association.getTargetEntity().removeReferenceAssociation(association, true);
        t.removeAssociation(association, true);
    }
    // for all relationships where current entity is primary key
    this.primaryKeyRelationships.addAll(t.getReferences());
    for (ERDAssociation r : primaryKeyRelationships) {
        r.getSourceEntity().removeAssociation(r, true);
        t.removeReferenceAssociation(r, true);
    }
}

Example 2 with ERDAssociation

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

the class AssociationReconnectTargetCommand method canExecute.

/**
 * Makes sure that foreign key doesn't reconnect to itself or try to create
 * a relationship which already exists
 */
@Override
public boolean canExecute() {
    boolean returnVal = true;
    ERDElement foreignKeyEntity = relationship.getSourceEntity();
    if (foreignKeyEntity.equals(targetEntity)) {
        returnVal = false;
    } else {
        List<ERDAssociation> relationships = targetEntity.getReferences();
        for (ERDAssociation relationship : relationships) {
            if (relationship.getSourceEntity().equals(sourceEntity) && relationship.getTargetEntity().equals(targetEntity)) {
                returnVal = false;
                break;
            }
        }
    }
    return returnVal;
}

Example 3 with ERDAssociation

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

the class AssociationPart method setConnectionStyles.

protected void setConnectionStyles(PolylineConnection conn) {
    ERDAssociation association = getAssociation();
    boolean identifying = ERDUtils.isIdentifyingAssociation(association);
    DBSEntityConstraintType constraintType = association.getObject().getConstraintType();
    if (constraintType == DBSEntityConstraintType.INHERITANCE) {
        final PolygonDecoration srcDec = new PolygonDecoration();
        srcDec.setTemplate(PolygonDecoration.TRIANGLE_TIP);
        srcDec.setFill(true);
        srcDec.setBackgroundColor(getParent().getViewer().getControl().getBackground());
        srcDec.setScale(10, 6);
        conn.setTargetDecoration(srcDec);
    } else if (constraintType.isAssociation()) {
        final CircleDecoration sourceDecor = new CircleDecoration();
        sourceDecor.setRadius(3);
        sourceDecor.setFill(true);
        sourceDecor.setBackgroundColor(getParent().getViewer().getControl().getForeground());
        // dec.setBackgroundColor(getParent().getViewer().getControl().getBackground());
        conn.setSourceDecoration(sourceDecor);
        if (!identifying) {
            final RhombusDecoration targetDecor = new RhombusDecoration();
            targetDecor.setBackgroundColor(getParent().getViewer().getControl().getBackground());
            // dec.setBackgroundColor(getParent().getViewer().getControl().getBackground());
            conn.setTargetDecoration(targetDecor);
        }
    }
    if (!identifying || constraintType.isLogical()) {
        conn.setLineStyle(SWT.LINE_CUSTOM);
        conn.setLineDash(constraintType.isLogical() ? new float[] { 4 } : new float[] { 5 });
    }
}

Example 4 with ERDAssociation

use of org.jkiss.dbeaver.erd.model.ERDAssociation in project dbeaver by dbeaver.

the class AssociationPart method setConnectionStyles.

protected void setConnectionStyles(PolylineConnection conn) {
    ERDAssociation association = getAssociation();
    boolean identifying = ERDUtils.isIdentifyingAssociation(association);
    DBSEntityConstraintType constraintType = association.getObject().getConstraintType();
    if (constraintType == DBSEntityConstraintType.INHERITANCE) {
        final PolygonDecoration srcDec = new PolygonDecoration();
        srcDec.setTemplate(PolygonDecoration.TRIANGLE_TIP);
        srcDec.setFill(true);
        srcDec.setBackgroundColor(getParent().getViewer().getControl().getBackground());
        srcDec.setScale(10, 6);
        conn.setTargetDecoration(srcDec);
    } else if (constraintType.isAssociation()) {
        final CircleDecoration sourceDecor = new CircleDecoration();
        sourceDecor.setRadius(3);
        sourceDecor.setFill(true);
        sourceDecor.setBackgroundColor(getParent().getViewer().getControl().getForeground());
        // dec.setBackgroundColor(getParent().getViewer().getControl().getBackground());
        conn.setSourceDecoration(sourceDecor);
        if (!identifying) {
            final RhombusDecoration targetDecor = new RhombusDecoration();
            targetDecor.setBackgroundColor(getParent().getViewer().getControl().getBackground());
            // dec.setBackgroundColor(getParent().getViewer().getControl().getBackground());
            conn.setTargetDecoration(targetDecor);
        }
    }
    if (!identifying || constraintType.isLogical()) {
        conn.setLineStyle(SWT.LINE_CUSTOM);
        conn.setLineDash(constraintType.isLogical() ? new float[] { 4 } : new float[] { 5 });
    }
}

Example 5 with ERDAssociation

use of org.jkiss.dbeaver.erd.model.ERDAssociation in project dbeaver by dbeaver.

the class ERDExportGraphML method exportDiagram.

@Override
public void exportDiagram(EntityDiagram diagram, IFigure figure, DiagramPart diagramPart, File targetFile) throws DBException {
    try {
        try (FileOutputStream fos = new FileOutputStream(targetFile)) {
            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:java", "http://www.yworks.com/xml/yfiles-common/1.0/java");
            xml.addAttribute("xmlns:sys", "http://www.yworks.com/xml/yfiles-common/markup/primitives/2.0");
            xml.addAttribute("xmlns:x", "http://www.yworks.com/xml/yfiles-common/markup/2.0");
            xml.addAttribute("xmlns:xsi", "http://www.w3.org/2001/XMLSchema-instance");
            xml.addAttribute("xmlns:y", "http://www.yworks.com/xml/graphml");
            xml.addAttribute("xmlns:yed", "http://www.yworks.com/xml/yed/3");
            xml.addAttribute("xsi:schemaLocation", "http://graphml.graphdrawing.org/xmlns http://www.yworks.com/xml/schema/graphml/1.1/ygraphml.xsd");
            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 = 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 + getExtraTableLength(diagram, entity));
                        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", fontSize);
                            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", "#FFFFFF");
                            xml.addAttribute("visible", "true");
                            xml.addAttribute("horizontalTextPosition", "center");
                            xml.addAttribute("iconTextGap", "4");
                            xml.addAttribute("height", nameBounds.height);
                            xml.addAttribute("width", nameBounds.width);
                            xml.addAttribute("x", 0);
                            xml.addAttribute("y", 4);
                            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", fontSize);
                            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("horizontalTextPosition", "center");
                            xml.addAttribute("iconTextGap", "4");
                            xml.addAttribute("height", attrsBounds.height);
                            xml.addAttribute("width", attrsBounds.width);
                            // numbers from yEd Graph Editor
                            xml.addAttribute("x", 2);
                            xml.addAttribute("y", 31.66796875);
                            StringBuilder attrsString = new StringBuilder();
                            for (ERDEntityAttribute attr : entity.getAttributes()) {
                                if (attrsString.length() > 0) {
                                    attrsString.append("\n");
                                }
                                attrsString.append(ERDUIUtils.getFullAttributeLabel(diagram, attr, true));
                            }
                            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.getAssociations()) {
                    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.getTargetEntity()));
                    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");
                    xml.addAttribute("sx", 0.0);
                    xml.addAttribute("sy", 0.0);
                    xml.addAttribute("tx", 0.0);
                    xml.addAttribute("ty", 0.0);
                    for (Bendpoint bp : associationPart.getBendpoints()) {
                        xml.startElement("y:Point");
                        xml.addAttribute("x", bp.getLocation().x);
                        xml.addAttribute("y", bp.getLocation().y);
                        xml.endElement();
                    }
                    xml.endElement();
                    boolean identifying = ERDUtils.isIdentifyingAssociation(association);
                    xml.startElement("y:LineStyle");
                    xml.addAttribute("color", "#000000");
                    xml.addAttribute("type", !identifying || association.isLogical() ? "dashed" : "line");
                    xml.addAttribute("width", "1.0");
                    xml.endElement();
                    xml.startElement("y:Arrows");
                    String sourceStyle = !identifying ? "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(targetFile.getAbsolutePath());
    } catch (Exception e) {
        DBWorkbench.getPlatformUI().showError("Save ERD as GraphML", null, e);
    }
}