SqlToClipboard - Helmut-Ortmann/EnterpriseArchitect_hoTools GitHub Wiki

SQL to Clipboard

Copy SQL string from selection to Clipboard

hoTools, File, Do, SQL selected to Clipboard.

Select something and run 'SQL selected to Clipboard'.

hoTools gives you information like:

Attribute

1 attr1  Attribute
 
Select ea_guid As CLASSGUID, 'Attribute' As CLASSTYPE,* from t_attribute attr where ea_guid = '{8EB1B135-6C28-437e-B260-309823D9A692}'
 Class has Attributes:
 Select attr.ea_guid As CLASSGUID, 'Attribute' As CLASSTYPE, 
      o.Name As Class, o.object_type, 
      attr.Name As AttrName, attr.Type As Type, 
      typAttr.Name 
      from (t_object o INNER JOIN t_attribute attr on (o.object_id = attr.object_id)) 
               LEFT JOIN  t_object typAttr on (attr.Classifier = Format(typAttr.object_id))
      where attr.ea_guid = '{8EB1B135-6C28-437e-B260-309823D9A692}'

Connector

{80D867C4-0DFA-45e2-852A-A69A85FFABD4}  Aggregation

Connector: Select ea_guid As CLASSGUID, connector_type As CLASSTYPE,* from t_connector con where ea_guid = '{80D867C4-0DFA-45e2-852A-A69A85FFABD4}'

Select o.ea_guid As CLASSGUID, o.object_type As CLASSTYPE,o.name As Name, o.object_type AS ObjectType, o.PDATA1, o.Stereotype, 
                   con.Name, con.connector_type, con.Stereotype, con.ea_guid As ConnectorGUID, dia.Name As DiagrammName, dia.ea_GUID As DiagramGUID,
                   o.ea_guid, o.Classifier_GUID,o.Classifier 
from (((t_connector con INNER JOIN t_object o              on con.start_object_id   = o.object_id)  
INNER JOIN t_diagramlinks diaLink  on con.connector_id      = diaLink.connectorid ) 
INNER JOIN t_diagram dia           on diaLink.DiagramId     = dia.Diagram_ID) 
INNER JOIN t_diagramobjects diaObj on diaObj.diagram_ID     = dia.Diagram_ID and o.object_id = diaObj.object_id 
where         con.ea_guid = '{80D867C4-0DFA-45e2-852A-A69A85FFABD4}' 
AND dialink.Hidden  = 0 

Diagram

{29363FD3-13E5-4a10-B951-16C22A5B4299} Package1 Logical

Select ea_guid As CLASSGUID, diagram_type As CLASSTYPE,* from t_diagram dia where ea_guid = '{29363FD3-13E5-4a10-B951-16C22A5B4299}'

Diagram Object

{D627DE44-084D-43d6-B48E-731174ABFF0A}: Block1 Class

Select ea_guid As CLASSGUID, object_type As CLASSTYPE,* from t_object o where ea_guid = '{D627DE44-084D-43d6-B48E-731174ABFF0A}'

select * from t_diagramobjects where object_id = 12

Operation

{2E7BB1EB-69CE-4042-A70F-27B384B01EA1} op1  Operation 
Operation may have type 
Select op.ea_guid As CLASSGUID, 'Operation' As CLASSTYPE,opTyp As OperationType, op.Name As OperationName, typ.Name As TypName,*
   from t_operation op LEFT JOIN t_object typ on (op.classifier = typ.object_id)
   where op.ea_guid = '{2E7BB1EB-69CE-4042-A70F-27B384B01EA1}';
 
Class has Operation 
Select op.ea_guid As CLASSGUID, 'Operation' As CLASSTYPE,* 
     from t_operation op INNER JOIN t_object o on (o.object_id = op.object_id)
     where op.ea_guid = '{2E7BB1EB-69CE-4042-A70F-27B384B01EA1}';
 
Class has Operation has Parameters/Typ and may have operationtype
Select op.ea_guid As CLASSGUID, 'Operation' As CLASSTYPE,op.Name As ClassName, op.Name As OperationName, opTyp.Name As OperationTyp, par.Name As ParName,parTyp.name As ParTypeName 
  from ((t_operation op INNER JOIN t_operationparams par on (op.OperationID = par.OperationID) )
                     LEFT JOIN t_object parTyp on (par.classifier = Format(parTyp.object_id))) 
                     LEFT JOIN t_object opTyp  on (op.classifier  = Format(opTyp.object_id))
   where op.ea_guid = '{2E7BB1EB-69CE-4042-A70F-27B384B01EA1}' 
  Order by par.Pos 

Package in Diagram

{B872A299-954F-4c5c-A3C1-BB1EE05A0753} Package1  Package 

Select ea_guid As CLASSGUID, 'Package' As CLASSTYPE,* from t_package pkg where ea_guid = '{B872A299-954F-4c5c-A3C1-BB1EE05A0753}'

Part

{B870CC15-2003-44a7-BC8B-322B7B7F25E7}:/{3938178D-EF0D-4edd-961C-C07D20E64DC8}  Part

Select ea_guid As CLASSGUID, object_type As CLASSTYPE,* from t_object o where ea_guid = '{B870CC15-2003-44a7-BC8B-322B7B7F25E7}'
 PDATA1:  Select ea_guid As CLASSGUID, object_type As CLASSTYPE,* from t_object o where ea_guid = '{3938178D-EF0D-4edd-961C-C07D20E64DC8}'

Menu Do in hoTools

Configuration

Keine.

References