Creating table PKs with Javascript

[davidn]

Hey,

I'm wondering how to create primary keys on tables with Javascript. I have a table and know which Attribute (var attr) I want to set the Primary Key as. However, the following code is not updating the Attribute to a PK:

Code: [Select]

attr.IsOrdered = true;
attr.Update();
theElement.Update();
theElement has Stereotype table and Gentype MySql.

Going into EA and then manually ticking the PK box on attr updates it to a PK.

Any insight? Thanks!

[Geert Bellekens]

Creating a PK is a bit more involved.

Please look a the Class PrimaryKey: https://github.com/GeertBellekens/Enterprise-Architect-Add-in-Framework/blob/master/EAAddinFramework/Databases/PrimaryKey.cs
and it's base class Constraint: https://github.com/GeertBellekens/Enterprise-Architect-Add-in-Framework/blob/master/EAAddinFramework/Databases/Constraint.cs

Geert

[Sunshine]

If the JavaScript is becoming too much effort then an alternative path to get a quick result of  adding PK and FK might be to do a DDL transformation. However that adds new attributes.

[davidn]

Thanks, guys.

Sunshine, how can I do the DDL transform you mentioned?

[Sunshine]

To do transform select package and from ribbon Design > Tools > Transform > Transform Selection
Apply Transform
Select classes
Select DDL Transform
Click Do Transform button
For detailed description see
https://sparxsystems.com/resources/user-guides/14.0/model-domains/model-transformation.pdf
Try the search its wonderful at finding things