KickJava   Java API By Example, From Geeks To Geeks.

Java > Open Source Codes > com > quadcap > sql > StmtCreateIndex


1 package com.quadcap.sql;
2
3 /* Copyright 1999 - 2003 Quadcap Software. All rights reserved.
4  *
5  * This software is distributed under the Quadcap Free Software License.
6  * This software may be used or modified for any purpose, personal or
7  * commercial. Open Source redistributions are permitted. Commercial
8  * redistribution of larger works derived from, or works which bundle
9  * 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 JavaDoc;
42
43 import java.io.IOException JavaDoc;
44
45 import java.sql.SQLException JavaDoc;
46
47 import com.quadcap.util.Debug;
48
49 /**
50  * Implementation of the SQL <B>CREATE INDEX</B> statement.
51  *
52  * @author Stan Bailes
53  */
54
55 public class StmtCreateIndex implements Stmt {
56     String JavaDoc indexName;
57     String JavaDoc tableName;
58     Vector JavaDoc columns;
59     boolean unique;
60     boolean text;
61
62     public StmtCreateIndex() {}
63     
64     public StmtCreateIndex(String JavaDoc indexName, String JavaDoc tableName, Vector JavaDoc columns,
65                boolean unique, boolean text) {
66     this.indexName = indexName;
67     this.tableName = tableName;
68     this.columns = columns;
69     this.unique = unique;
70         this.text = text;
71     }
72
73     public void execute(Session session) throws IOException JavaDoc, SQLException JavaDoc {
74         session.getTableWriteLock("#Schema");
75         session.getTableWriteLock(tableName);
76     Database db = session.getDatabase();
77     Relation r = db.getRelation(tableName);
78     if (r == null) {
79         throw new SQLException JavaDoc("No such table: " + tableName, "42000");
80     }
81     if (!(r instanceof Table)) {
82         throw new SQLException JavaDoc("Not a base table: " + tableName, "42000");
83     }
84     if (db.getTableForIndex(indexName) != null) {
85         throw new SQLException JavaDoc("Index: " + indexName + " exists", "42000");
86     }
87     Table t = (Table)r;
88     Constraint c = null;
89     if (unique) {
90         c = new UniqueConstraint(indexName, columns);
91         //} else if (text) {
92 // c = new TextIndexConstraint(indexName, columns);
93 } else {
94         c = new NonUniqueIndexConstraint(indexName, columns);
95     }
96         c.setGlobal(true);
97     c.setTable(t);
98     t.nameConstraint(c);
99     session.doStep(new AddConstraint(session, t, c, true));
100     }
101 }
102
103
Popular Tags