Welcome to the Toad Data Modeling Community
Advanced Search - Help - Search Toad World
Welcome, Guest
Login Login / Register
Help
NEW? Get Plugged In

Forums » Join Discussions About... » Toad Data Modeler

Thread: Customizing PDM DDL Script generation

This question is not answered. Helpful answers available: 2. Answered answers available: 1.


Permlink Replies: 1 - Pages: 1 - Last Post: Nov 3, 2009 1:45 AM by: vladka
AndreasL

Posts: 49
Registered: 2/25/09
Customizing PDM DDL Script generation
Posted: Oct 29, 2009 7:13 AM
 
  Click to reply to this thread Reply

Using script explorer and script editor I managed to customize DDL script generation, e.g. PERCodeGeneratorMY. This works fine.
But how can I easily switch between different generators?
At the moment I have to edit the original script and press save and commit.
Is there a way to easily connect the DDL script generation dialog with different scripts, e.g. PERCodeGeneratorMY1, PERCodeGeneratorMY2, PERCodeGeneratorMY3?
A dropdown list in DDL script generation dialog to select the variant I need would be great!
Where are the scripts saved in the filesystem, I'd like to backup my changes?

Is there a way to define custom properties in a PDM, e.g. additional boolean checkboxes in a customized Edit Table dialog?
Or is there a way to set custom parameters manually somehow in the Edit Table dialog?
Even in the Edit Attribute dialog would be very helpful.
I like to use this additional parameters to influence the generation done by my customized DDL Script generator.
The only idea I have on that is to use a special comment in After Script oder Comment area and parse for that in the generator script!?

Thanx for your hints on this.

Kind regards
Andreas


vladka


Posts: 1,738
Registered: 2/20/07
Re: Customizing PDM DDL Script generation
Posted: Nov 3, 2009 1:45 AM   in response to: AndreasL
 
  Click to reply to this thread Reply

Hello Andreas,

Customization of DDL Script Generation:
Unfortunately, it is possible to have only one generator for one model type (MY51, OR10 etc.). However, it is possible to extend or change functionality of the generator. The generator can behave in a different way (accordig to defined parameters), but it is not possible to have two different generators.
An example on how to modify the generator is shown in the attached package (done for MySQL 5.1).

Please copy the .txg file to the location where you store your user packages. Default location is:
C:\Documents and Settings\user name\My Documents\Toad Data Modeler\Installation name\Packages\{DCB5CB9B-CF65-4350-86B5-285D246FC5AC}

Run TDM and open MySQL 5.1 model. See the changes in the DDL Script Generation dialog.

Tip: We recommend you to have a look at the script FmPERGenerator that is the starting point for execution of the generator. The script is saved in folder Form Events in Script Explorer.

====
To add a new component + property on a form/dialog:
Please read our User Guide - in TDM select Help | User Guide.
See topic Customization - Sample. (Add New Properties in Metamodel + Modify Form).
Flash movie:
http://modeling.inside.quest.com/entry.jspa?externalID=1699&categoryID=281

If you need any help with this, please write us what property you want to add and where and we will send you an example.

Good luck!

Regards,

Vladka + Daril




Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums