For all of our tables, we add audit columns with triggers that maintain dates and user info for creation and edit operatoins. we spent too much time doing this for new development and I would like to automate adding the columns (and the trigger) to each entity in a physical model.
I’m fairly handy with vbScript, but i’m struggling quite a bit sorting out how to really get started in extending TDM to do something like this…
If someone could help me get started that would be a HUGE kick-start for my effort.
here is an example of what i want to do
From a logical model when doing the conversion (or separately as a macro), extend the scripting section for mysql5 entity to add two columns for ‘date_created’ and ‘date_modified’ with a date datatype. and then create two simple triggers for each entity…
Can someone help shell out a wireframe of this? I don’t need it to be done for me, but i just need to see the way!