#3 SQL Policy

[Mark De Vries]

Hi,
it would be a valueable addition to have the possibility to enforce policies for the SQL Files.

For example:
SQL files should only contain max one "create table" statement
SQL files should not contain commits (since the commit is done by dbMaintain at the end of the script)

These two rules (and maybe some additional ones) would prevent the DB being in an inconsistent state after execution of a script fails.
If nothing is "manually" committed and only one "create table" statement per sql file nothing is permanently created before the script is completely executed or fails, thus nothing to clean up in the db before fixing the script.

If the number of "policies" is very small this could be done by an additional configuration parameter in the properties file.
It would be nicer if this could be done via a seperate "policy interface" which could then be implemented to ones special requirements and checked by dbmaintain before execution of the sql files.