session.commit(true); Database db = session.getDatabase(); if (getSchema().findTrigger(triggerName) != null) { if (ifNotExists) { return 0; Table table = getSchema().getTableOrView(session, tableName); TriggerObject trigger = new TriggerObject(getSchema(), id, triggerName, table); trigger.setInsteadOf(insteadOf); trigger.setBefore(before);
public int update() throws SQLException { // TODO rights: what rights are required to create a trigger? session.commit(true); Database db = session.getDatabase(); if (getSchema().findTrigger(triggerName) != null) { if (ifNotExists) { return 0; } throw Message.getSQLException(ErrorCode.TRIGGER_ALREADY_EXISTS_1, triggerName); } int id = getObjectId(false, true); Table table = getSchema().getTableOrView(session, tableName); TriggerObject trigger = new TriggerObject(getSchema(), id, triggerName, table); trigger.setBefore(before); trigger.setNoWait(noWait); trigger.setQueueSize(queueSize); trigger.setRowBased(rowBased); trigger.setTypeMask(typeMask); trigger.setTriggerClassName(session, triggerClassName, force); db.addSchemaObject(session, trigger); table.addTrigger(trigger); return 0; }
session.commit(true); Database db = session.getDatabase(); if (getSchema().findTrigger(triggerName) != null) { if (ifNotExists) { return 0; Table table = getSchema().getTableOrView(session, tableName); TriggerObject trigger = new TriggerObject(getSchema(), id, triggerName, table); trigger.setInsteadOf(insteadOf); trigger.setBefore(before);
session.commit(true); Database db = session.getDatabase(); if (getSchema().findTrigger(triggerName) != null) { if (ifNotExists) { return 0; Table table = getSchema().getTableOrView(session, tableName); TriggerObject trigger = new TriggerObject(getSchema(), id, triggerName, table); trigger.setInsteadOf(insteadOf); trigger.setBefore(before);