01: /*
02: * Copyright 2004-2008 H2 Group. Licensed under the H2 License, Version 1.0
03: * (http://h2database.com/html/license.html).
04: * Initial Developer: H2 Group
05: */
06: package org.h2.command.ddl;
07:
08: import java.sql.SQLException;
09:
10: import org.h2.constant.ErrorCode;
11: import org.h2.engine.Database;
12: import org.h2.engine.Right;
13: import org.h2.engine.Session;
14: import org.h2.message.Message;
15: import org.h2.schema.Schema;
16: import org.h2.schema.TriggerObject;
17: import org.h2.table.Table;
18:
19: /**
20: * This class represents the statement
21: * DROP TRIGGER
22: */
23: public class DropTrigger extends SchemaCommand {
24:
25: private String triggerName;
26: private boolean ifExists;
27:
28: public DropTrigger(Session session, Schema schema) {
29: super (session, schema);
30: }
31:
32: public void setIfExists(boolean b) {
33: ifExists = b;
34: }
35:
36: public void setTriggerName(String triggerName) {
37: this .triggerName = triggerName;
38: }
39:
40: public int update() throws SQLException {
41: session.commit(true);
42: Database db = session.getDatabase();
43: TriggerObject trigger = getSchema().findTrigger(triggerName);
44: if (trigger == null) {
45: if (!ifExists) {
46: throw Message.getSQLException(
47: ErrorCode.TRIGGER_NOT_FOUND_1, triggerName);
48: }
49: } else {
50: Table table = trigger.getTable();
51: session.getUser().checkRight(table, Right.ALL);
52: db.removeSchemaObject(session, trigger);
53: }
54: return 0;
55: }
56:
57: }
|