01: /*
02: * $Id: CreateViewCommand.java,v 1.10 2005/12/20 18:32:28 ahimanikya Exp $
03: * =======================================================================
04: * Copyright (c) 2004 Axion Development Team. All rights reserved.
05: *
06: * Redistribution and use in source and binary forms, with or without
07: * modification, are permitted provided that the following conditions
08: * are met:
09: *
10: * 1. Redistributions of source code must retain the above
11: * copyright notice, this list of conditions and the following
12: * disclaimer.
13: *
14: * 2. Redistributions in binary form must reproduce the above copyright
15: * notice, this list of conditions and the following disclaimer in
16: * the documentation and/or other materials provided with the
17: * distribution.
18: *
19: * 3. The names "Tigris", "Axion", nor the names of its contributors may
20: * not be used to endorse or promote products derived from this
21: * software without specific prior written permission.
22: *
23: * 4. Products derived from this software may not be called "Axion", nor
24: * may "Tigris" or "Axion" appear in their names without specific prior
25: * written permission.
26: *
27: * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
28: * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
29: * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A
30: * PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
31: * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
32: * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
33: * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
34: * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
35: * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
36: * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
37: * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
38: * =======================================================================
39: */
40:
41: package org.axiondb.engine.commands;
42:
43: import org.axiondb.AxionException;
44: import org.axiondb.Database;
45: import org.axiondb.engine.tables.TableView;
46: import org.axiondb.parser.AxionSqlParser;
47:
48: /**
49: * A <code>CREATE VIEW AS sub-query</code> command.
50: * <p>
51: * TODO: support for CREATE VIEW table_name [ ( column_name1, column_name2, ... ) ]...
52: *
53: * @version $Revision: 1.10 $ $Date: 2005/12/20 18:32:28 $
54: * @author Ahimanikya Satapathy
55: */
56: public class CreateViewCommand extends CreateCommand {
57: public CreateViewCommand() {
58: }
59:
60: public void setSubQuery(String query) {
61: _subQuery = query;
62: }
63:
64: public boolean execute(Database db) throws AxionException {
65: assertNotReadOnly(db);
66: if (!db.hasTable(getObjectName())) {
67: AxionSqlParser parser = new AxionSqlParser();
68: SelectCommand selectCmd = (SelectCommand) parser
69: .parse(_subQuery);
70: SubSelectCommand subSelectCmd = new SubSelectCommand(
71: selectCmd.getQueryContext());
72: TableView table = (TableView) subSelectCmd.getTableView(db,
73: getObjectName());
74: table.setSubQuery(_subQuery);
75: table.setType(TableView.VIEW);
76: db.addTable(table);
77: } else if (!isIfNotExists()) {
78: throw new AxionException("A table/view named \""
79: + getObjectName() + "\" already exists.");
80: }
81: return false;
82: }
83:
84: private String _subQuery;
85:
86: }
|