To change the generation of the particular Oracle Object, add a new functionality to its macro in the velocity template. The Helper utility class will assist in retrieving model information.
We suggest to make a back up of the default template. The default template is stored in <program installation folder>\ data\DB_engineering\Oracle_template folder. The template file can be changed in the CG Properties Editor dialog box (in the Oracle DDL set shortcut menu, choose the Properties command).
When generating DDL, objects are passed from the code engineering set to the velocity engine. Objects, that are passed to the Oracle DDL velocity engine are presented in the following table:
| Object name | Object type | Description |
|---|---|---|
$CESList | List<NamedEleme nt> | The list of model elements that are added to the code engineering set. |
$dropRequired | boolean | Flag to notify if the drop objects is required. This is a drop setting option which generates the Drop statement. |
$oracleHelper | Java.lang.Class | This is a helper class for retrieving information from model elements. Use this class to check the element for applied stereotypes, get tagged values and element’s owned information. |
$newLineBracket | boolean | The generation Option to generate a bracket in a new line. |
$genDocumentation | boolean | The language option for the documentation generation. |