DDL : define attribute types mapping rules

[Guillaume]

Hi,

I have a UML class diagram that I use to generate my DDL (e.g. in MySQL). I'd like to define custom rules to map class attribute types (including custom ones) to data types in MySQL

e.g. map String to nvarchar(255), map int to INTEGER, map largeint to BIGINT, etc.
This way I can reduce the amount of amendments on my DDL diagram once it's been generated from the class diagram.

thanks
Guillaume

[Geert Bellekens]

Guillaume,

I think you first need an MDA transformation form your PIM model (String) to a PSM model (nvarchar(255)).
Then you can use the standard ddl generation to generate the sql.

Geert

[Guillaume]

Hi Geert,

Thanks for the info. I have to create a new template in the Transformation Templates (probably in the Attribute type).

I had a look at the DDL template and it contains the following script :
Column
{
  %TRANSFORM_CURRENT("type", "stereotype", "collection", "constant", "containment", "ordered", "static", "volatile")%
  type=%qt%%CONVERT_TYPE(genOptDefaultDatabase,attType)%%qt%
}

I'm not sure about the next step to achieve this : do I need to write my mapping rules there ? (e.g. map string to nvarchar(255), etc.) ?
I had a look at the Help section but it's not straightforward. A quick tutorial would be helpful


 

[Geert Bellekens]

Hi Guillaume,

I'm afraid my knowledge of those things is strictly theoretical
I hope someone else will be able to help you with the practical side.

Geert

[Guillaume]

Thanks Geert - I'll update this thread if I make some progress.