Configuring by adding notes predefined by generation

Free SQL sections: sqlAfter and sqlBefore

You have the possibility of defining notes such as sqlafter or sqlbefore within packages or classes, according to whether you want to insert SQL at the beginning or at the end of generation on the current unit.

This feature is especially useful for specifying in pure SQL, at invariant and pre- and post-condition level, integrity constraints which are not deduced from the model.

Example

text : sqlAfter

insert into graphic_object values (10,11);

insert into graphic_object values (50,100);

grant select on table graphic_object to public;

Notes defined on a package

The ... note type	is inserted ...
sqlBefore	at the beginning of the file containing the SQL instructions generated for the package.
sqlAfter	at the end of the file containing the SQL instructions generated for the package.

Notes defined on a class

The ... note type	is inserted ...
sqlBefore	at the beginning of the SQL instructions related to the class
sqlAfter	at the end of the SQL instructions related to the class

Note: These text zones can be created through Objecteering MDA Modeler, in order to automate the generation of model context information.