Search in sources :

Example 11 with ERDAssociation

use of org.jkiss.dbeaver.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;
    ERDElement primaryEntity = association.getTargetEntity();
    // cannot connect to itself
    if (primaryEntity.equals(sourceEntity)) {
        returnVal = false;
    } else {
        List<ERDAssociation> relationships = sourceEntity.getAssociations();
        for (ERDAssociation relationship : relationships) {
            if (relationship.getTargetEntity().equals(targetEntity) && relationship.getSourceEntity().equals(sourceEntity)) {
                returnVal = false;
                break;
            }
        }
    }
    return returnVal;
}
Also used : ERDElement(org.jkiss.dbeaver.erd.model.ERDElement) ERDAssociation(org.jkiss.dbeaver.erd.model.ERDAssociation)

Example 12 with ERDAssociation

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

the class AssociationPart method createFigure.

@Override
protected IFigure createFigure() {
    PolylineConnection conn = new PolylineConnection();
    conn.setForegroundColor(UIUtils.getColorRegistry().get(ERDUIConstants.COLOR_ERD_LINES_FOREGROUND));
    boolean showComments = getDiagramPart().getDiagram().hasAttributeStyle(ERDViewStyle.COMMENTS);
    if (showComments) {
        ERDAssociation association = getAssociation();
        if (association != null && association.getObject() != null && !CommonUtils.isEmpty(association.getObject().getDescription())) {
            ConnectionLocator descLabelLocator = new ConnectionLocator(conn, ConnectionLocator.MIDDLE);
            // descLabelLocator.setRelativePosition(50);
            // descLabelLocator.setGap(50);
            Label descLabel = new Label(association.getObject().getDescription());
            descLabel.setForegroundColor(UIUtils.getColorRegistry().get(ERDUIConstants.COLOR_ERD_ATTR_FOREGROUND));
            // Border border = new MarginBorder(20, 0, 0, 0);
            // descLabel.setBorder(border);
            conn.add(descLabel, descLabelLocator);
        }
    }
    setConnectionStyles(conn);
    setConnectionRouting(conn);
    setConnectionToolTip(conn);
    return conn;
}
Also used : ERDAssociation(org.jkiss.dbeaver.erd.model.ERDAssociation)

Example 13 with ERDAssociation

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

the class AssociationPart method setConnectionRouting.

protected void setConnectionRouting(PolylineConnection conn) {
    ERDAssociation association = getAssociation();
    // Set router and initial bends
    ConnectionLayer cLayer = (ConnectionLayer) getLayer(LayerConstants.CONNECTION_LAYER);
    conn.setConnectionRouter(cLayer.getConnectionRouter());
    if (!CommonUtils.isEmpty(association.getInitBends())) {
        List<AbsoluteBendpoint> connBends = new ArrayList<>();
        for (int[] bend : association.getInitBends()) {
            connBends.add(new AbsoluteBendpoint(bend[0], bend[1]));
        }
        conn.setRoutingConstraint(connBends);
    } else if (association.getTargetEntity() != null && association.getTargetEntity() == association.getSourceEntity()) {
        EditPart entityPart = getSource();
        if (entityPart == null) {
            entityPart = getTarget();
        }
        if (entityPart instanceof GraphicalEditPart) {
            // Self link
            final IFigure entityFigure = ((GraphicalEditPart) entityPart).getFigure();
            // EntityPart entity = (EntityPart) connEdge.source.getParent().data;
            // final Dimension entitySize = entity.getFigure().getSize();
            final Dimension figureSize = entityFigure.getMinimumSize();
            int entityWidth = figureSize.width;
            int entityHeight = figureSize.height;
            List<RelativeBendpoint> bends = new ArrayList<>();
            {
                RelativeBendpoint bp1 = new RelativeBendpoint(conn);
                bp1.setRelativeDimensions(new Dimension(entityWidth, entityHeight / 2), new Dimension(entityWidth / 2, entityHeight / 2));
                bends.add(bp1);
            }
            {
                RelativeBendpoint bp2 = new RelativeBendpoint(conn);
                bp2.setRelativeDimensions(new Dimension(-entityWidth, entityHeight / 2), new Dimension(entityWidth, entityHeight));
                bends.add(bp2);
            }
            conn.setRoutingConstraint(bends);
        }
    }
}
Also used : ArrayList(java.util.ArrayList) ERDAssociation(org.jkiss.dbeaver.erd.model.ERDAssociation) Dimension(org.eclipse.draw2d.geometry.Dimension) PointList(org.eclipse.draw2d.geometry.PointList) ArrayList(java.util.ArrayList) List(java.util.List)

Example 14 with ERDAssociation

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

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);
    }
}
Also used : EntityFigure(org.jkiss.dbeaver.erd.ui.figures.EntityFigure) HashMap(java.util.HashMap) ERDEntity(org.jkiss.dbeaver.erd.model.ERDEntity) Rectangle(org.eclipse.draw2d.geometry.Rectangle) ERDAssociation(org.jkiss.dbeaver.erd.model.ERDAssociation) XMLBuilder(org.jkiss.utils.xml.XMLBuilder) Bendpoint(org.eclipse.draw2d.Bendpoint) AttributeListFigure(org.jkiss.dbeaver.erd.ui.figures.AttributeListFigure) DBException(org.jkiss.dbeaver.DBException) ERDEntityAttribute(org.jkiss.dbeaver.erd.model.ERDEntityAttribute) FileOutputStream(java.io.FileOutputStream) AssociationPart(org.jkiss.dbeaver.erd.ui.part.AssociationPart) EntityPart(org.jkiss.dbeaver.erd.ui.part.EntityPart) Bendpoint(org.eclipse.draw2d.Bendpoint)

Example 15 with ERDAssociation

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

the class AssociationPart method setConnectionRouting.

protected void setConnectionRouting(PolylineConnection conn) {
    ERDAssociation association = getAssociation();
    // Set router and initial bends
    ConnectionLayer cLayer = (ConnectionLayer) getLayer(LayerConstants.CONNECTION_LAYER);
    conn.setConnectionRouter(cLayer.getConnectionRouter());
    if (!CommonUtils.isEmpty(association.getInitBends())) {
        List<AbsoluteBendpoint> connBends = new ArrayList<>();
        for (int[] bend : association.getInitBends()) {
            connBends.add(new AbsoluteBendpoint(bend[0], bend[1]));
        }
        conn.setRoutingConstraint(connBends);
    } else if (association.getTargetEntity() != null && association.getTargetEntity() == association.getSourceEntity()) {
        EditPart entityPart = getSource();
        if (entityPart == null) {
            entityPart = getTarget();
        }
        if (entityPart instanceof GraphicalEditPart) {
            // Self link
            final IFigure entityFigure = ((GraphicalEditPart) entityPart).getFigure();
            // EntityPart entity = (EntityPart) connEdge.source.getParent().data;
            // final Dimension entitySize = entity.getFigure().getSize();
            final Dimension figureSize = entityFigure.getMinimumSize();
            int entityWidth = figureSize.width;
            int entityHeight = figureSize.height;
            List<RelativeBendpoint> bends = new ArrayList<>();
            {
                RelativeBendpoint bp1 = new RelativeBendpoint(conn);
                bp1.setRelativeDimensions(new Dimension(entityWidth, entityHeight / 2), new Dimension(entityWidth / 2, entityHeight / 2));
                bends.add(bp1);
            }
            {
                RelativeBendpoint bp2 = new RelativeBendpoint(conn);
                bp2.setRelativeDimensions(new Dimension(-entityWidth, entityHeight / 2), new Dimension(entityWidth, entityHeight));
                bends.add(bp2);
            }
            conn.setRoutingConstraint(bends);
        }
    }
}
Also used : ArrayList(java.util.ArrayList) ERDAssociation(org.jkiss.dbeaver.erd.model.ERDAssociation) Dimension(org.eclipse.draw2d.geometry.Dimension) PointList(org.eclipse.draw2d.geometry.PointList) ArrayList(java.util.ArrayList) List(java.util.List)

Aggregations

ERDAssociation (org.jkiss.dbeaver.erd.model.ERDAssociation)16 ERDElement (org.jkiss.dbeaver.erd.model.ERDElement)4 FileOutputStream (java.io.FileOutputStream)2 ArrayList (java.util.ArrayList)2 HashMap (java.util.HashMap)2 List (java.util.List)2 Bendpoint (org.eclipse.draw2d.Bendpoint)2 Dimension (org.eclipse.draw2d.geometry.Dimension)2 PointList (org.eclipse.draw2d.geometry.PointList)2 Rectangle (org.eclipse.draw2d.geometry.Rectangle)2 DBException (org.jkiss.dbeaver.DBException)2 ERDEntity (org.jkiss.dbeaver.erd.model.ERDEntity)2 ERDEntityAttribute (org.jkiss.dbeaver.erd.model.ERDEntityAttribute)2 AttributeListFigure (org.jkiss.dbeaver.erd.ui.figures.AttributeListFigure)2 EntityFigure (org.jkiss.dbeaver.erd.ui.figures.EntityFigure)2 AssociationPart (org.jkiss.dbeaver.erd.ui.part.AssociationPart)2 EntityPart (org.jkiss.dbeaver.erd.ui.part.EntityPart)2 DBSEntityConstraintType (org.jkiss.dbeaver.model.struct.DBSEntityConstraintType)2 XMLBuilder (org.jkiss.utils.xml.XMLBuilder)2