Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: EA_enthusiast on January 10, 2021, 12:54:11 pm

Title: Relationships do not show on the diagram
Post by: EA_enthusiast on January 10, 2021, 12:54:11 pm: Hello, EA Experts,

I imported this Python code
https://ibb.co/RQrJRLb

To get these classes on a diagram but without relationships shown
https://ibb.co/C9H2LHX

When I transformed the model to DDL, I still do not see relationships
https://ibb.co/mBv3zgt

I checked the diagram properties and I confirmed that "Show Relationships" is checked
https://ibb.co/M14VSnL

What should I do to show the relationships?

Thank you,
Mo
Title: Re: Relationships do not show on the diagram
Post by: Geert Bellekens on January 10, 2021, 05:32:39 pm: I guess EA didn't create any relationships when importing your code.

Geert
Title: Re: Relationships do not show on the diagram
Post by: qwerty on January 10, 2021, 08:20:15 pm: class without self? What Python code is that?

q.
Title: Re: Relationships do not show on the diagram
Post by: EA_enthusiast on January 11, 2021, 09:52:37 am: Thank you, Geert and q. for your responses.

Is this a problem from EA's side or something missing in the code?

Is there a way to fix that?

Thank you,
Mo
Title: Re: Relationships do not show on the diagram
Post by: Eve on January 11, 2021, 10:13:54 am: The problem is that Python doesn't explicitly declare the type for the variables and EA can't infer it.
Title: Re: Relationships do not show on the diagram
Post by: qwerty on January 11, 2021, 10:16:42 am: Well, your code isn't Python. A class needs self as first parameter. Always. Formally: this is not a sentence of the Python language. The compiler will not swallow it. And EA will probably not even croak but do "something".

q.
Title: Re: Relationships do not show on the diagram
Post by: Eve on January 11, 2021, 10:45:00 am: Are you sure qwerty?

My (limited) Python understanding says that what is defined there are class definitions with static variables. As there are no methods at all there's no reason why there should be a self parameter. I assume that django requires a database structure to to be specified like this.
Title: Re: Relationships do not show on the diagram
Post by: EA_enthusiast on January 11, 2021, 05:49:27 pm: I have very little knowledge of Python. I just got this code from another team member and tried to import it to EA.

It was successfully imported (as a Python code) but with no relationships on the class diagram created by EA as I indicated earlier

When I told the developer that there are no relationships shown in EA, he exported this ERD from Django-extensions (and it shows relationships)

https://ibb.co/NSV9zYc

He also shared the below code of the ERD (as a .dott file) but I could not import this .dot file to EA

Code: [Select]
digraph model_graph { // Dotfile by Django-Extensions graph_models // Created: 2021-01-08 07:36 // Cli Options: -a fontname = "Roboto" fontsize = 8 splines = true node [ fontname = "Roboto" fontsize = 8 shape = "plaintext" ] edge [ fontname = "Roboto" fontsize = 8 ] // Labels django_contrib_admin_models_LogEntry [label=< <TABLE BGCOLOR="white" BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR><TD COLSPAN="2" CELLPADDING="5" ALIGN="CENTER" BGCOLOR="#1b563f"> LogEntry </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> id </TD><TD ALIGN="LEFT"> AutoField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> content_type </TD><TD ALIGN="LEFT"> ForeignKey (id) </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> user </TD><TD ALIGN="LEFT"> ForeignKey (id) </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> action_flag </TD><TD ALIGN="LEFT"> PositiveSmallIntegerField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> action_time </TD><TD ALIGN="LEFT"> DateTimeField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> change_message </TD><TD ALIGN="LEFT"> TextField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> object_id </TD><TD ALIGN="LEFT"> TextField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> object_repr </TD><TD ALIGN="LEFT"> CharField </TD></TR> </TABLE> >] django_contrib_auth_models_AbstractUser [label=< <TABLE BGCOLOR="white" BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR><TD COLSPAN="2" CELLPADDING="5" ALIGN="CENTER" BGCOLOR="#1b563f"> AbstractUser <AbstractBaseUser,PermissionsMixin> </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> date_joined </TD><TD ALIGN="LEFT"> DateTimeField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> email </TD><TD ALIGN="LEFT"> EmailField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> first_name </TD><TD ALIGN="LEFT"> CharField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> is_active </TD><TD ALIGN="LEFT"> BooleanField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> is_staff </TD><TD ALIGN="LEFT"> BooleanField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> is_superuser </TD><TD ALIGN="LEFT"> BooleanField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> last_login </TD><TD ALIGN="LEFT"> DateTimeField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> last_name </TD><TD ALIGN="LEFT"> CharField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> password </TD><TD ALIGN="LEFT"> CharField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> username </TD><TD ALIGN="LEFT"> CharField </TD></TR> </TABLE> >] django_contrib_auth_models_Permission [label=< <TABLE BGCOLOR="white" BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR><TD COLSPAN="2" CELLPADDING="5" ALIGN="CENTER" BGCOLOR="#1b563f"> Permission </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> id </TD><TD ALIGN="LEFT"> AutoField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> content_type </TD><TD ALIGN="LEFT"> ForeignKey (id) </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> codename </TD><TD ALIGN="LEFT"> CharField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> name </TD><TD ALIGN="LEFT"> CharField </TD></TR> </TABLE> >] django_contrib_auth_models_Group [label=< <TABLE BGCOLOR="white" BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR><TD COLSPAN="2" CELLPADDING="5" ALIGN="CENTER" BGCOLOR="#1b563f"> Group </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> id </TD><TD ALIGN="LEFT"> AutoField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> name </TD><TD ALIGN="LEFT"> CharField </TD></TR> </TABLE> >] django_contrib_auth_models_User [label=< <TABLE BGCOLOR="white" BORDER="1" CELLBORDER="0" CELLSPACING="0"> <TR><TD COLSPAN="2" CELLPADDING="5" ALIGN="CENTER" BGCOLOR="#1b563f"> User <AbstractUser> </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> id </TD><TD ALIGN="LEFT"> AutoField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> date_joined </TD><TD ALIGN="LEFT"> DateTimeField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> email </TD><TD ALIGN="LEFT"> EmailField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> first_name </TD><TD ALIGN="LEFT"> CharField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> is_active </TD><TD ALIGN="LEFT"> BooleanField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> is_staff </TD><TD ALIGN="LEFT"> BooleanField </TD></TR> <TR><TD ALIGN="LEFT" BORDER="0"> is_superuser </TD><TD ALIGN="LEFT"> BooleanField </TD><...
Title: Re: Relationships do not show on the diagram
Post by: Geert Bellekens on January 11, 2021, 05:57:04 pm: What did you expect? I didn't see any relations in the python code, just a whole bunch of html inside the code.

If EA parses code it will show the relations it can extract from the code. It will definitely not parse the HTML and do something with it.

Geert
Title: Re: Relationships do not show on the diagram
Post by: EA_enthusiast on January 11, 2021, 06:00:38 pm: Thank you, Geert.

But do you know how did he manage to export an ERD (with relationships ) from Django-extensions? Also, the image he extracted from Django shows relationships.

When I noticed no relations in the Python code and asked the developed, he said "look for models.forignkey"

Any advice would be appreciated.

Thank you,
Mo
Title: Re: Relationships do not show on the diagram
Post by: qwerty on January 11, 2021, 07:42:31 pm: Quote from: Eve on January 11, 2021, 10:45:00 am
Are you sure qwerty?

My (limited) Python understanding says that what is defined there are class definitions with static variables. As there are no methods at all there's no reason why there should be a self parameter. I assume that django requires a database structure to to be specified like this.
Well, it was late. They use the Django framework. So this IS legal Python. However, I don't think Sparx is using a fullly fledged Python compiler and will not recognize that structure. Personally I would not blame EA for not being able...

q.
Title: Re: Relationships do not show on the diagram
Post by: Eve on January 12, 2021, 07:55:29 am: Quote from: Mo on January 11, 2021, 06:00:38 pm
When I noticed no relations in the Python code and asked the developed, he said "look for models.forignkey"
EA imports associations between classes when the explicitly declared type matches the name of another class.

It can not infer the type from the ways that it is used, including the initial value. Even if it could, it knows nothing about django in order to parse the model.ForeignKey invocation.
Title: Re: Relationships do not show on the diagram
Post by: EA_enthusiast on January 12, 2021, 09:01:28 am: Thank you, Eve, q. and Geert for your input. I really appreciate it.