Source code: org/hsqldb/View.java
1 /* Copyright (c) 2001-2002, The HSQL Development Group
2 * All rights reserved.
3 *
4 * Redistribution and use in source and binary forms, with or without
5 * modification, are permitted provided that the following conditions are met:
6 *
7 * Redistributions of source code must retain the above copyright notice, this
8 * list of conditions and the following disclaimer.
9 *
10 * Redistributions in binary form must reproduce the above copyright notice,
11 * this list of conditions and the following disclaimer in the documentation
12 * and/or other materials provided with the distribution.
13 *
14 * Neither the name of the HSQL Development Group nor the names of its
15 * contributors may be used to endorse or promote products derived from this
16 * software without specific prior written permission.
17 *
18 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
19 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
20 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
21 * ARE DISCLAIMED. IN NO EVENT SHALL HSQL DEVELOPMENT GROUP, HSQLDB.ORG,
22 * OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL,
23 * EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO,
24 * PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
25 * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND
26 * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
27 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
28 * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
29 */
30
31
32 package org.hsqldb;
33
34 import java.sql.SQLException;
35
36 // fredt@users 20020420 - patch523880 by leptipre@users - VIEW support - modified
37
38 /**
39 * Implementation of SQL VIEWS based on a SELECT query.
40 *
41 * @author leptipre@users
42 * @version 1.7.0
43 */
44 class View extends Table {
45
46 String sStatement;
47
48 View(Database db, HsqlName name) throws SQLException {
49
50 super(db, name, VIEW, null);
51
52 sStatement = "";
53 }
54
55 void addColumns(Result result) throws SQLException {
56
57 for (int i = 0; i < result.getColumnCount(); i++) {
58 String name = result.sTable[i];
59 Table t = dDatabase.findUserTable(name);
60
61 if (t != null && t.isTemp()) {
62 throw Trace.error(Trace.TABLE_NOT_FOUND);
63 }
64
65 if (result.sLabel[i] == null) {
66
67 // fredt - this does not guarantee the uniqueness of column
68 // names but addColumns() will throw if names are not unique.
69 result.sLabel[i] = "COL_" + String.valueOf(i);
70 }
71 }
72
73 super.addColumns(result);
74
75 iVisibleColumns = iColumnCount;
76 }
77
78 /**
79 * Tokenize the SELECT statement to get rid of any comment line that
80 * may exist at the end. Store the result
81 * for performing selects and logging the DDL at checkpoints.
82 *
83 * @param s
84 *
85 * @throws SQLException
86 */
87 void setStatement(String s) throws SQLException {
88
89 int position;
90 String str;
91 Tokenizer t = new Tokenizer(s);
92
93 // fredt@users - this establishes the end of the actual statement
94 // to get rid of any end semicolon or comment line after the end
95 // of statement
96 do {
97 position = t.getPosition();
98 str = t.getString();
99 } while (str.length() != 0 || t.wasValue());
100
101 sStatement = s.substring(0, position);
102 }
103
104 String getStatement() throws SQLException {
105 return sStatement;
106 }
107 }