01: package com.quadcap.sql;
02:
03: /* Copyright 1999 - 2003 Quadcap Software. All rights reserved.
04: *
05: * This software is distributed under the Quadcap Free Software License.
06: * This software may be used or modified for any purpose, personal or
07: * commercial. Open Source redistributions are permitted. Commercial
08: * redistribution of larger works derived from, or works which bundle
09: * this software requires a "Commercial Redistribution License"; see
10: * http://www.quadcap.com/purchase.
11: *
12: * Redistributions qualify as "Open Source" under one of the following terms:
13: *
14: * Redistributions are made at no charge beyond the reasonable cost of
15: * materials and delivery.
16: *
17: * Redistributions are accompanied by a copy of the Source Code or by an
18: * irrevocable offer to provide a copy of the Source Code for up to three
19: * years at the cost of materials and delivery. Such redistributions
20: * must allow further use, modification, and redistribution of the Source
21: * Code under substantially the same terms as this license.
22: *
23: * Redistributions of source code must retain the copyright notices as they
24: * appear in each source code file, these license terms, and the
25: * disclaimer/limitation of liability set forth as paragraph 6 below.
26: *
27: * Redistributions in binary form must reproduce this Copyright Notice,
28: * these license terms, and the disclaimer/limitation of liability set
29: * forth as paragraph 6 below, in the documentation and/or other materials
30: * provided with the distribution.
31: *
32: * The Software is provided on an "AS IS" basis. No warranty is
33: * provided that the Software is free of defects, or fit for a
34: * particular purpose.
35: *
36: * Limitation of Liability. Quadcap Software shall not be liable
37: * for any damages suffered by the Licensee or any third party resulting
38: * from use of the Software.
39: */
40:
41: import java.util.Vector;
42:
43: import java.io.IOException;
44:
45: import java.sql.SQLException;
46:
47: import com.quadcap.util.Debug;
48:
49: /**
50: * Implementation of the SQL <b>DROP INDEX</b> statement.
51: *
52: * @author Stan Bailes
53: */
54:
55: public class StmtDropIndex implements Stmt {
56: String indexName;
57:
58: public StmtDropIndex() {
59: }
60:
61: public StmtDropIndex(String indexName) {
62: this .indexName = indexName;
63: }
64:
65: public void execute(Session session) throws IOException,
66: SQLException {
67: session.getTableWriteLock("#Schema");
68: Database db = session.getDatabase();
69: String tableName = db.getTableForIndex(indexName);
70: if (tableName == null) {
71: throw new SQLException("No such index: " + indexName);
72: }
73: session.getTableWriteLock(tableName);
74: Table t = (Table) db.getRelation(tableName);
75: if (t == null) {
76: throw new SQLException("No table: " + tableName
77: + " for index " + indexName);
78: }
79: Constraint c = t.getConstraint(indexName);
80: if (c == null) {
81: throw new SQLException(
82: "Can't find constraint associated with " + "index "
83: + indexName + " for table " + tableName);
84: }
85: session.doStep(new DeleteConstraint(session, t, c, true));
86: }
87: }
|