Generating tables from a UML model attribute varchar default length

[UrsulaGreen]

I am trying to generate a DDL schema from a platform independent model using the transform functionality.  I have a UML based model from which I am generating a database table model an then generating the DDL from the table (fro a MySQL database).

The attributes in the tables are defaulting to varchar (which is ok) but the default length is set to zero.  Ideally I would like this set to 255 but I am not sure how to do this in the transform templates or if it is possible.

I am using sparx EA 15.5

[RoyC]

EA 15.5?  Should that be 13.5?

[qwerty]

No, he's been teleported here from the future xD

q.

[UrsulaGreen]

whoops typo; I'm using version 13.5 
Time travel is beyond my skillset

[SamSepi0l]

Try this:

• Modify the "DDL" Template (Design -> Tools -> Transform -> Transform Templates)
• Replace: type=%qt%%CONVERT_DB_TYPE(genOptDefaultDatabase, attType)%%qt%
  with:
      type = %qt%varchar%qt%
      length = %255%qt%

And see if works.

[UrsulaGreen]

thank you I will give it a go

[Geert Bellekens]

Try this:

• Modify the "DDL" Template (Design -> Tools -> Transform -> Transform Templates)
• Replace: type=%qt%%CONVERT_DB_TYPE(genOptDefaultDatabase, attType)%%qt%
  with:
      type = %qt%varchar%qt%
      length = %255%qt%

And see if works.

Wouldn't that make ALL columns of type varchar(255)?

Geert

[Sunshine]

Time travel is beyond my skillset

Don't under estimate yourself. You are travelling forward into the future one second at a time.

Try this:

• Modify the "DDL" Template (Design -> Tools -> Transform -> Transform Templates)
• Replace: type=%qt%%CONVERT_DB_TYPE(genOptDefaultDatabase, attType)%%qt%
  with:
      type = %qt%varchar%qt%
      length = %255%qt%

And see if works.

Wouldn't that make ALL columns of type varchar(255)?

Geert

Your right Geert. There needs to be some kind of %if ...% statement. However looking at the MySQL DDL transform it looks like
modification of a few lines DDL Data Type (lines 24 to 26) might be the answer as that looks like it sets the length to 0 there.

Code: [Select]

%elseIf $Type=="varchar" or $Type=="nvarchar" or $Type=="varbinary" %
(0)
%endIf%
However isn't the point of varchar is that it has a variable length otherwise just use char and fix the length.

[Glassboy]

Don't under estimate yourself. You are travelling forward into the future one second at a time.

In a block universe that is reference frame dependent.

[Paolo F Cantoni]

Don't under estimate yourself. You are travelling forward into the future one second at a time.

In a block universe that is reference frame dependent.

From, at least, the southern hemisphere.

Paolo