Ejemplo n.º 1
0
 public void createBeforeChangeFunction(MIndexTable index) throws SQLException {
   final String ddlFunction = index.getBeforeChangeCodeFunctionDDL();
   if (Check.isEmpty(ddlFunction, true)) return;
   executeDDL(ddlFunction, index.get_TrxName());
   //
   final String ddlTrigger = index.getBeforeChangeCodeTriggerDDL();
   if (Check.isEmpty(ddlTrigger, true)) return;
   if (existsFunction(index.getDBFunctionName()))
     executeDDL(
         "DROP TRIGGER IF EXISTS " + index.getDBTriggerName() + " ON " + index.getTableName(),
         index.get_TrxName());
   executeDDL(ddlTrigger, index.get_TrxName());
 }