need help on DDL transformation template...

[incanus]

I'm performing a DDL transformation, and i need that the field name of a primary key be set
to exampleID_PK instead of PK exampleID.
I know that i should modify the DDL transformation template, but idont know where i should
insert the changes.
Perhaps you could help and tell me in wich place or line insert the changes.
Best regards.

[Eve]

The class template creates a primary key column and the connector template references that column in the foreign key target.  (They should match, otherwise the foreign key will create a column anyway.)

[incanus]

Hi Simonm, thanks for the answer.

In the class template i have:
name=%qt%%CONVERT_NAME(className, "Pascal Case","Camel Case")%ID%qt%

How should i modify this to set the name to exampleID_PK.

Best regards.

[Eve]

Okay, I'm in tutor/teacher mode, so I'm not going to give you the answer.  Lets have a look at the different components of that line.

• name= - Literal text, denotes that the following will string will specify the name.
  
• %qt% - Generates a quote character to denote the start of the value for "name".
  
• %CONVERT_NAME(className, "Pascal Case","Camel Case")% - Generates the name of the class with a lower case first letter.
  
• ID - Literal text.
  
• %qt% - Generates a quote character to denote the end of the value for "name".
  

So if you want to change that to generate exampleID_PK instead of exampleID, what do you need to change?

[incanus]

simonm, thanks for the answer, it is precisely the kind of answer that i've been looking for, for now i really understand what that line does.
I should change to:
name=%qt%%CONVERT_NAME(className, "Pascal Case","Camel Case")%ID_PK%qt%

is it correct?.
Best regards.

[thomaskilian]

It is. Don't you have a playground where you can test the result?

[incanus]

yes, i have, but i post it before testing the results, just to answer the question of mi tutor...
best regards...

[Eve]

Yes, as Thomas has said, that's correct.