Book a Demo

Author Topic: Customizing DDL generation -- accessing the model  (Read 2053 times)

Egmont

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Customizing DDL generation -- accessing the model
« on: September 11, 2015, 12:53:41 pm »
I'm primarily using EA (12) to model database tables, targetting Postgresql 9. I'm using the DDL generation capabilities (which I really like) but I want to tweak the supplied DDL generation script based on attributes within the model. Specifically, I want to use "CREATE UNLOGGED TABLE" rather than "CREATE TABLE" when generating for a Dev environment (where tear-downs and reloads are frequent, and robustness is not required.)

I am familiar with the DDL scripts as I already tweaked one to fix an error with the "serial" type, but I don't understand, and cannot find documentation on how you identify and map objects within the model (Ideally, creating a tag called "target" with values of "dev"/"test"/"prod" in the "Data Model" package) to the DDL script. I can't delve into the EA database as I don't have a copy of MS/Access: I'm running EA within a Win7 VM on top of OSX.

Please, can someone can point me to the documentation, or explain what I need to do?