Generate DDL via SDK

[Alessandro]

I would like to generate the Database DDL using via the SDK from a Java program.

I could not find any reference in the documentation nor any method in the JAR that looks like it could do the job.

Is the DDL generation supported from via the SDK?

Many thanks
Alessandro

[leonlian]

I have the exactly same question here. Anyone can help? Thanks.

[Makulik]

Hi guys,

Though I didn't test this myself, triggering Code-Generation from the Automation Interface should do the job for DDL as well as it does for any other Language.
Look here:
http://www.sparxsystems.com/uml_tool_guide/sdk_for_enterprise_architect/project_2.html

Refer to the GenerateClass, GeneratePackage methods of the Project class.

HTH
Günther

[leonlian]

Hi guys,

Though I didn't test this myself, triggering Code-Generation from the Automation Interface should do the job for DDL as well as it does for any other Language.
Look here:
http://www.sparxsystems.com/uml_tool_guide/sdk_for_enterprise_architect/project_2.html

Refer to the GenerateClass, GeneratePackage methods of the Project class.

HTH
Günther

i checked it out, but i cannot find any references for DDL Generation.

[g.makulik]

Shouldn't be s.th. special regarding DDL there. The kind of language code ist set using the 'Language' property of the concerned package and class elements (tables I guess). The DDL code generated itself is steered using the associated code generation templates.
You select the appropriate package or table element with the calls and it should to the job.

HTH
Günther

[Eve]

I've very sorry to say that:
a) DDL generation is not driven by code templates.
b) Unless I'm mistaken you can't perform it from the API.

[g.makulik]

Oops, sorry!!
That was just a logical guess ... (but I at least mentioned it   )

g.

[leonlian]

I've very sorry to say that:
a) DDL generation is not driven by code templates.
b) Unless I'm mistaken you can't perform it from the API.

We want to use an Java application to automatically generate the DDL for an EA project file (which contains a set of tables).

If the API does not work, is there any other SDK we can use to make it?

[Geert Bellekens]

I'm sorry, the API==SDK

You could always send a feature request to Sparx using the link on the bottom of the page.
In the meantime you'll have to, either click the appropriate options manually, or write your own UML->DLL transformation.

Geert