001: /*
002: * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
003: *
004: * Copyright 1997-2007 Sun Microsystems, Inc. All rights reserved.
005: *
006: * The contents of this file are subject to the terms of either the GNU
007: * General Public License Version 2 only ("GPL") or the Common
008: * Development and Distribution License("CDDL") (collectively, the
009: * "License"). You may not use this file except in compliance with the
010: * License. You can obtain a copy of the License at
011: * http://www.netbeans.org/cddl-gplv2.html
012: * or nbbuild/licenses/CDDL-GPL-2-CP. See the License for the
013: * specific language governing permissions and limitations under the
014: * License. When distributing the software, include this License Header
015: * Notice in each file and include the License file at
016: * nbbuild/licenses/CDDL-GPL-2-CP. Sun designates this
017: * particular file as subject to the "Classpath" exception as provided
018: * by Sun in the GPL Version 2 section of the License file that
019: * accompanied this code. If applicable, add the following below the
020: * License Header, with the fields enclosed by brackets [] replaced by
021: * your own identifying information:
022: * "Portions Copyrighted [year] [name of copyright owner]"
023: *
024: * Contributor(s):
025: *
026: * The Original Software is NetBeans. The Initial Developer of the Original
027: * Software is Sun Microsystems, Inc. Portions Copyright 1997-2007 Sun
028: * Microsystems, Inc. All Rights Reserved.
029: *
030: * If you wish your version of this file to be governed by only the CDDL
031: * or only the GPL Version 2, indicate your decision by adding
032: * "[Contributor] elects to include this software in this distribution
033: * under the [CDDL or GPL Version 2] license." If you do not indicate a
034: * single choice of license, a recipient has the option to distribute
035: * your version of this file under either the CDDL, the GPL Version 2 or
036: * to extend the choice of license to its licensees as provided above.
037: * However, if you add GPL Version 2 code and therefore, elected the GPL
038: * Version 2 license, then the option applies only if the new code is
039: * made subject to such option by the copyright holder.
040: */
041: package org.netbeans.modules.db.sql.visualeditor.querymodel;
042:
043: import org.netbeans.modules.db.sql.visualeditor.parser.SQLParser;
044: import org.netbeans.modules.db.sql.visualeditor.parser.ParseException;
045: import java.util.ArrayList;
046:
047: public class SQLQueryFactory {
048:
049: public static Query parse(String query) throws ParseException {
050: SQLParser parser = new SQLParser(
051: new java.io.StringReader(query));
052: return (Query) parser.SQLQuery();
053: }
054:
055: public static Where createWhere(Expression expr) {
056: return new WhereNode(expr);
057: }
058:
059: public static Predicate createPredicate(Value val1, Value val2,
060: String op) {
061: return new Predicate(val1, val2, op);
062: }
063:
064: public static Predicate createPredicate(Value val1, Object literal,
065: String op) {
066: Literal val2 = new Literal(literal);
067: return new Predicate(val1, val2, op);
068: }
069:
070: public static Predicate createPredicate(String[] rel) {
071: return new Predicate(rel);
072: }
073:
074: public static GroupBy createGroupBy(ArrayList columnList) {
075: return new GroupByNode(columnList);
076: }
077:
078: public static OrderBy createOrderBy() {
079: return new OrderByNode();
080: }
081:
082: public static Column createColumn(String tableSpec,
083: String columnName) {
084: return new ColumnNode(tableSpec, columnName);
085: }
086:
087: public static Literal createLiteral(Object value) {
088: return new Literal(value);
089: }
090:
091: public static Table createTable(String tableName, String corrName,
092: String schemaName) {
093: return new TableNode(tableName, corrName, schemaName);
094: }
095:
096: public static JoinTable createJoinTable(Table table) {
097: return new JoinTableNode((TableNode) table);
098: }
099:
100: public static And createAnd(Expression expr1, Expression expr2) {
101: ArrayList items = new ArrayList();
102: items.add(expr1);
103: items.add(expr2);
104: return new AndNode(items);
105: }
106:
107: public static Or createOr(Expression expr1, Expression expr2) {
108: ArrayList items = new ArrayList();
109: items.add(expr1);
110: items.add(expr2);
111: return new OrNode(items);
112: }
113: }
|