01: /**
02: * com.mckoi.database.interpret.DropTrigger 14 Sep 2001
03: *
04: * Mckoi SQL Database ( http://www.mckoi.com/database )
05: * Copyright (C) 2000, 2001, 2002 Diehl and Associates, Inc.
06: *
07: * This program is free software; you can redistribute it and/or
08: * modify it under the terms of the GNU General Public License
09: * Version 2 as published by the Free Software Foundation.
10: *
11: * This program is distributed in the hope that it will be useful,
12: * but WITHOUT ANY WARRANTY; without even the implied warranty of
13: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14: * GNU General Public License Version 2 for more details.
15: *
16: * You should have received a copy of the GNU General Public License
17: * Version 2 along with this program; if not, write to the Free Software
18: * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
19: *
20: * Change Log:
21: *
22: *
23: */package com.mckoi.database.interpret;
24:
25: import com.mckoi.database.*;
26: import com.mckoi.util.IntegerVector;
27: import java.util.ArrayList;
28: import java.util.List;
29:
30: /**
31: * A parsed state container for the 'DROP TRIGGER' statement.
32: *
33: * @author Tobias Downer
34: */
35:
36: public class DropTrigger extends Statement {
37:
38: /**
39: * The name of this trigger.
40: */
41: String trigger_name;
42:
43: // ---------- Implemented from Statement ----------
44:
45: public void prepare() throws DatabaseException {
46: trigger_name = (String) cmd.getObject("trigger_name");
47: }
48:
49: public Table evaluate() throws DatabaseException {
50:
51: String type = (String) cmd.getObject("type");
52:
53: DatabaseQueryContext context = new DatabaseQueryContext(
54: database);
55:
56: if (type.equals("callback_trigger")) {
57: database.deleteTrigger(trigger_name);
58: } else {
59:
60: // Convert the trigger into a table name,
61: String schema_name = database.getCurrentSchema();
62: TableName t_name = TableName.resolve(schema_name,
63: trigger_name);
64: t_name = database.tryResolveCase(t_name);
65:
66: ConnectionTriggerManager manager = database
67: .getConnectionTriggerManager();
68: manager.dropTrigger(t_name.getSchema(), t_name.getName());
69:
70: // Drop the grants for this object
71: database.getGrantManager().revokeAllGrantsOnObject(
72: GrantManager.TABLE, t_name.toString());
73: }
74:
75: // Return '0' if we created the trigger.
76: return FunctionTable.resultTable(context, 0);
77: }
78:
79: }
|