|
Re: From UML to SQL [message #1829432 is a reply to message #1829428] |
Fri, 03 July 2020 09:24 |
|
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
|
|
|
|
Re: From UML to SQL [message #1829440 is a reply to message #1829433] |
Fri, 03 July 2020 14:20 |
|
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
|
|
|
Re: From UML to SQL [message #1830334 is a reply to message #1829440] |
Thu, 23 July 2020 13:40 |
|
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
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03609 seconds