2Pack handler for SQL Statements that must not fail

Description

At this moment 2Pack has a handler for SQL Statement, this handler is written in a way that it can fail silently and 2Pack still completes and is marked as successful, even if the SQL Statement fails.

This was developed that way because of certain SQL statements that are OK when running the first time - but will fail for sure if 2pack is ran for second time, for example adding a foreign key.

This approach is very dangerous as we still need some SQL statements to be mandatory for the success of 2pack.

So, proposal here is to add a new handler for SQLMandatory, so we still have the old SQLStatement (which optionally can fail and 2pack still keeps completing) and the new SQLMandatory which cannot fail and will force a rollback in case of failure.

Regards,

Carlos Ruiz

Environment

None

Status

Assignee

Carlos Ruiz

Reporter

Carlos Ruiz

Labels

None

Tested By

None

Priority

Major
Configure