@Override
public void create(boolean ignoreAlreadyExists) throws SQLException {
super.create(ignoreAlreadyExists);
PreparedStatement ps =
yordifier
.getConnection()
.prepareStatement(
"INSERT INTO "
+ Yordifier.TRIGGERS
+ " (NAME, FUNCTION_NAME, TABLE_NAME) VALUES (?, ?, ?)");
ps.setString(1, name);
ps.setString(2, procedure.getName());
ps.setString(3, table);
ps.execute();
}
@Override
public void drop(boolean ignoreDoesNotExist) throws SQLException {
try {
super.drop(ignoreDoesNotExist);
} catch (SQLException ex) {
if (ex.getSQLState().equals("42P01")) {
// the triggers table does not exist anymore
// ignore...
} else {
throw ex;
}
}
PreparedStatement ps =
yordifier
.getConnection()
.prepareStatement("DELETE FROM " + Yordifier.TRIGGERS.getName() + " WHERE NAME = ?");
ps.setString(1, name);
ps.execute();
}