Eclipse Community Forums: Papyrus

Help

Home

Home » Modeling » Papyrus » From UML to SQL

Show: Today's Messages :: Show Polls :: Message Navigator

From UML to SQL [message #1829428]

Fri, 03 July 2020 07:50

Yoann Farré

Messages: 235
Registered: November 2017

Senior Member

Hello,

I could be interested by a way to generate SQL code from an UML model. I am aware of the Information Modeling project but I'm not sure it adress this topic, As far as I know, we can't generate SQL code to create a relationnal DB from a model. I believe we can do that with EA for example. Is there such feature in Eclipse/UML/Papyrus world?
If not, what could be the most appropriate entry point to do that? Information Modeling project? Existing profile?

Regards.

Yoann.

Report message to a moderator

Re: From UML to SQL [message #1829432 is a reply to message #1829428]

Fri, 03 July 2020 09:24

Carsten Pitz

Messages: 479
Registered: May 2015
Location: Germany

Senior Member

Hi Yoann,

to generate which SQL code?
There is CRUD (create, read, update, delete) for both the tables themselves and the data to be managed.

And why?
The persistence frameworks around abstract completely from the kind of database without any runtime performance impact. And if you decide to use a rDBMS the persistence framework does the SQL magic.

/Carsten

Report message to a moderator

Re: From UML to SQL [message #1829433 is a reply to message #1829432]

Fri, 03 July 2020 09:45

Yoann Farré

Messages: 235
Registered: November 2017

Senior Member

Hi Carsten,

For the moment, I would generate SQL code to init the DB (at least tables creation). If possible manage all operations (CRUD) on the tables would be good.

And to answer to the why : I'm developping a feature to make easier the interaction between a code generated from Papyrus (in C++) with a relationnal DB. I would like to make that the user can create the database structure in UML and use a SQL generator to build the corresponding DB.

Hopefully the need is clearer.

Yoann.

Report message to a moderator

Re: From UML to SQL [message #1829440 is a reply to message #1829433]

Fri, 03 July 2020 14:20

Carsten Pitz

Messages: 479
Registered: May 2015
Location: Germany

Senior Member

Hi Yoann,

I am not aware of any such generator for Eclipse Papyrus.

I wrote such a generator for a customer as AndroMDA cartridge some 15 years ago. That generator utilized some naming conventions to mark table columns should be unique or indexed. Query-, update- and delete-operations were only generated for indexed columns. These conventions made the generator damn easy to implement and the resulting code quite well performing.

But this approach requires a pure data model being used by other code.

/Carsten

Report message to a moderator

Re: From UML to SQL [message #1830334 is a reply to message #1829440]

Thu, 23 July 2020 13:40

Vincent Lorenzo

Messages: 248
Registered: June 2010
Location: Paris Saclay, France

Senior Member

Hello Yoann,
Papyrus doesn't provide such a generator to create SQL table. I think you should modelize your table with a Class Diagram, then write the generator to create the table.

Regards,
/Vincent

Report message to a moderator

Re: From UML to SQL [message #1836608 is a reply to message #1830334]

Fri, 08 January 2021 21:51

pere joseph rodríguez

Messages: 51
Registered: October 2014

Member

Https://www.samsara-software.es
Can find a plugin for Oracle, mysql and Postgres.
Code generation for JPA and queries included for JPQL.
If interested, contact perelengo@hotmail.com the project is in standby but can provide some help.

Report message to a moderator