DB model. Generating DB Schema

[MiloszeS]

Hi all,

I've modelled a DB using EA 7.5. A db contains a four schemas (I've added a schema stereotype on a package containing tables). During a DDL generation everything works fine except schemas. All tables has been generated under a public schema. What should i switch to generate tables in a designed schemas.

As a db I've chosen a posgtresql.


Regards,
MiloszeS

[Oliver F.]

This is one of the reasons why we went away from the DDL script generation.
Now, we use a custom template to create the appropriate SQL scripts. The schema is written in a tagged value during transformation and the filename of the file to create is set appropriately (eg. schema1.sql, etc.).
That way you can set the appropriate usage statement for the schema.

Oliver

[MiloszeS]

Should I use a code generation templates or transformation templates? Sorry for a silly question, but I'm a rookie in a template area.


MiloszeS

[Oliver F.]

Should I use a code generation templates or transformation templates? Sorry for a silly question, but I'm a rookie in a template area.

Sorry about not being precise enough. I am refering to SQL code generation. The integrated DDL code generation can not handle multiple DB schema definitions as far as I have noticed. Therefore we transform the model with the schema being written into tagged values and then generate SQL code through our own custom language code templates which in fact simply creates the SQL scripts.

Oliver

[MiloszeS]

Thank you.

Regards,
MiloszeS

[MiloszeS]

OK,

I've created my own template. A schema, table names, fields and comments are ok. Unfortunately I cannot find a way to retrieve an info about PK and FK.

I've founded a PK name but, cannot find info about which field is described by the operation. Could you help me with that?


Regards,
MiloszeS

[Oliver F.]

OK,

I've created my own template. A schema, table names, fields and comments are ok. Unfortunately I cannot find a way to retrieve an info about PK and FK.

I've founded a PK name but, cannot find info about which field is described by the operation. Could you help me with that?

Primary keys are operations with the PK stereotype and the field used as parameter so you can create an operation template and override it by a template triggered by that stereotype. For PK and Oracle this looks like this:

Code: [Select]

ADD CONSTRAINT %opName% UNIQUE ( %list="Parameter" @separator="," @indent=""% )

For a PK a constraint is added with all parameters (usually only 1) in the brackets.
For other databases it might look different but you get the idea, hopefully.

Oliver

[MiloszeS]

%list="Parameter" @separator="," @indent=""% - this is a reason, why it doesn't worked in my case. I've used it as a 1:1 relation (%Parameter%).

Thanks again.
MiloszeS