Attach ActionPin with Operation in Script

[Cisore]

Hi,

I want to do a script that generates the same result that if I slip an operation in a activity's diagram !

(On Action with a ActionPin's element who it linking with the operation !)

Actually I arrived to generate the Action and the ActionPin element but I don't arrived to link the ActionPin with the Operation !

Someone can help me ?

[qwerty]

It appears that the Classifier_GUID of the action is that of the operation.

q.

[Cisore]

I'm sorry but I don't have attribute Classifier_GUID !

(I have ClassifierID, it's a int whereas ClassifierID of the operation are String, and it's read only !)

May be I don't have build the Action correctly :

Code: [Select]

EA.Element elm = (EA.Element)diag.Elements.AddNew(nomAct, "Action");
elm.Update();
diag.Elements.Refresh();

[qwerty]

Classifier_GUID is a column in t_object. It does not seem as there is any corresponding property in Element. So (I guess) you have to poke that in via a SQL.

q.

[Geert Bellekens]

The trick in these kind of cases is:
- Start with an empty model
- Create what you need manually
- Inspect the results in the database
- Try to replicate the same results using the API
- If that doesn't work (because some attribute isn't exposed) then you resort to Repository.Execute(SQLString)

Geert

[Cisore]

The trick in these kind of cases is:
- Start with an empty model
- Create what you need manually
[highlight]- Inspect the results in the database[/highlight]
- Try to replicate the same results using the API
- If that doesn't work (because some attribute isn't exposed) then you resort to Repository.Execute(SQLString)

How can I do that ?

Classifier_GUID is a column in t_object. It does not seem as there is any corresponding property in Element. So (I guess) you have to poke that in via a SQL.

(where can I find example of SQL request to change this table ? It's the first time, I hear spoken of this table !   )

[Geert Bellekens]

depends on what you are using as repository.
For .eap file use MS Access or your favorite generic sql client.

Geert

[Cisore]

What is the name of the base ? (the location, the password and the login name ?)

[qwerty]

Have a look in my Inside book. I guess the basics are explained rather clearly in it.

q.

[Cisore]

Ok I find the base (and the good table) but ...

Who can I run a SQL request in a script ?

(I have read yours book : ScriptingEA and InsideEA but I don't find the information !)

[Geert Bellekens]

The trick in these kind of cases is:
- Start with an empty model
- Create what you need manually
- Inspect the results in the database
- Try to replicate the same results using the API
- If that doesn't work (because some attribute isn't exposed) [highlight]then you resort to Repository.Execute(SQLString)[/highlight]

Geert

I must say I'm getting tired of repeating myself

Geert

[qwerty]

(I have read yours book : ScriptingEA and InsideEA but I don't find the information !)

True. i haven't put that in my books yet. Repository.Execute is some unofficial stuff (though you find it listed in the Scripting book on pg. 44). However, I'm about to put in an example on how to use this method.

q.

[Cisore]

Sorry ! and thanks

[size=8]We never tire of hearing you that's why they make you repeat[/size]

[qwerty]

Cisore,
have you managed to get it to work? I just peeked around and found this very strange. An action created normally can not be transformed to one created from an operation. The Advanced menu for both is different, though they are all Actions. Obviously there are also two entries created in t_xref, but until now I was not able to create such an operation-action. Very, very strange.

q.

[Cisore]

Heu ... Yes I have a code how works :

diag = Activity Element
vue = EA.Diagram (attach to diag)

Code: [Select]

EA.Element elm = (EA.Element)diag.Elements.AddNew(nomAct, "Action");

elm.Update();
diag.Elements.Refresh();

EA.Element tar = (EA.Element)elm.Elements.AddNew("target", "ActionPin");
tar.Update();

Repository.Execute("UPDATE t_object SET Classifier_guid='"+methodExec.MethodGUID+"' WHERE Name='"+nomAct+"';");

Guid g1 = Guid.NewGuid();
String sqlRequest1 = "INSERT INTO t_xref VALUES ";
sqlRequest1 +=                                  "(\""+g1.ToString()+"\",";
sqlRequest1 +=                                  "\"CustomProperties\",";
sqlRequest1 +=                                  "\"element property\",";
sqlRequest1 +=                                  "\"Public\",";
sqlRequest1 +=                                  "NULL,";
sqlRequest1 +=                                  "NULL,";
sqlRequest1 +=                                  "NULL,";
sqlRequest1 +=                                  "NULL,";
sqlRequest1 +=                                  "0,";
sqlRequest1 +=                                  "\"@PROP=@NAME=kind@ENDNAME;@TYPE=ActionKind@ENDTYPE;@VALU=CallOperation@ENDVALU;@PRMT=@ENDPRMT;@ENDPROP;\",";
sqlRequest1 +=                                  "\"" +elm.ElementGUID+ "\",";
sqlRequest1 +=                                  "\"<none>\",";
sqlRequest1 +=                                  "NULL)";

Repository.Execute(sqlRequest1);

Guid g2 = Guid.NewGuid();
String sqlRequest2 = "INSERT into t_xref VALUES";
sqlRequest2+=                                   "(\""+g2.ToString()+"\",";
sqlRequest2+=                                   "\"MOFProps\",";
sqlRequest2+=                                   "\"element property\",";
sqlRequest2+=                                   "\"Public\",";
sqlRequest2+=                                   "NULL,";
sqlRequest2+=                                   "NULL,";
sqlRequest2+=                                   "NULL,";
sqlRequest2+=                                   "\"target\",";
sqlRequest2+=                                   "0,";
sqlRequest2+=                                   "\""+tar.ElementGUID+"\",";
sqlRequest2+=                                   "\""+elm.ElementGUID+"\",";
sqlRequest2+=                                   "\"<none>\",";
sqlRequest2+=                                   "NULL)";
Repository.Execute(sqlRequest2);

EA.DiagramObject ob = (EA.DiagramObject)vue.DiagramObjects.AddNew(nomAct, "");
ob.ElementID = elm.ElementID;
ob.Update();                                    

I'm not sure to have understand your question.  :-/