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 java.util.Collection;
044:
045: import org.netbeans.api.db.sql.support.SQLIdentifiers;
046:
047: /**
048: * Represents a SQL Set function (AVG, COUNT, MAX, MIN, SUM)
049: * Example Form: SUM(Orders.Quantity), MAX(Employee.Salary), COUNT(Employee.Name)
050: */
051:
052: public class SetFunction extends ColumnItem implements UnaryExpression {
053:
054: public static final int NONE = 0;
055: public static final int AVG = 1;
056: public static final int COUNT = 2;
057: public static final int MAX = 3;
058: public static final int MIN = 4;
059: public static final int SUM = 5;
060:
061: private int _type;
062: private ColumnNode _argument;
063: private Identifier _alias;
064:
065: private SetFunction() {
066: }
067:
068: public SetFunction(int type, ColumnNode argument, Identifier alias) {
069: _type = type;
070: _argument = argument;
071: _alias = alias;
072: }
073:
074: Column getReferencedColumn() {
075: return _argument;
076: }
077:
078: public void getReferencedColumns(Collection columns) {
079: columns.add(_argument);
080: }
081:
082: public String genText(SQLIdentifiers.Quoter quoter) {
083: String funcType = null;
084: switch (_type) {
085: case AVG:
086: funcType = "AVG(";
087: break;
088: case COUNT:
089: funcType = "COUNT(";
090: break;
091: case MAX:
092: funcType = "MAX(";
093: break;
094: case MIN:
095: funcType = "MIN(";
096: break;
097: case SUM:
098: funcType = "SUM(";
099: break;
100: default:
101: break;
102: }
103: funcType += _argument.genText(quoter);
104: funcType += ")";
105: if (_alias != null) {
106: funcType += " AS " + _alias.genText(quoter);
107: }
108: return funcType;
109: }
110:
111: public Expression findExpression(String table1, String column1,
112: String table2, String column2) {
113: return null;
114: }
115:
116: /**
117: * Rename the table part of the column spec
118: */
119: public void renameTableSpec(String oldTableSpec, String corrName) {
120: _argument.renameTableSpec(oldTableSpec, corrName);
121: }
122:
123: public boolean isParameterized() {
124: return false;
125: }
126:
127: public Expression getOperand() {
128: return _argument;
129: }
130:
131: }
|