DDL Transformation

[Helmut Ortmann]

Hello,

I don't really understand the transformation of the Attribute type to the Column type.

As far as I understand: In the Class Diagram I have to use a Common Type as defined in Settings, Database Types. I have no possibility to extend the Common Types.

An Example: The example model has a data type "String/string". This is converted to something like varchar. Why? There is no Common Type "String/string".

I hope someone can explain me the magic behind that


Thanks in advance,

Helmut

[qwerty]

I searched for "ddl datatype" in the help and probably the 4th entry is (per title) what you are looking for. I did not read it in detail, though.

q.

[Helmut Ortmann]

Thanks Thomas!

The documentation you found is in fact a description of the elements maintained by the settings dialog.

I have no good idea how the transformation works.


Helmut

[qwerty]

If I were convinced of the concept I would start writing a booklet, but honestly I do not like this awkward scripting language Sparx has invented here.

Maybe some kind soul at Sparx can help out.

q.

[Dermot]

With the MDA Transforms in general they are using the UML standard Data type set which only includes Integer, Boolean, String etc.
These are transformed in the Attribute transform script.

For an example of manipulating this there are some scripts on the community site for reverse transform from Physical to Logical model - this uses standard script to translate the Physical DBMS types - see:
http://community.sparxsystems.com/community-resources/512-84data-modeling-logical-and-conceptual-mda-transforms