001: /*
002: * Copyright (c) 1998-2008 Caucho Technology -- all rights reserved
003: *
004: * This file is part of Resin(R) Open Source
005: *
006: * Each copy or derived work must preserve the copyright notice and this
007: * notice unmodified.
008: *
009: * Resin Open Source is free software; you can redistribute it and/or modify
010: * it under the terms of the GNU General Public License as published by
011: * the Free Software Foundation; either version 2 of the License, or
012: * (at your option) any later version.
013: *
014: * Resin Open Source is distributed in the hope that it will be useful,
015: * but WITHOUT ANY WARRANTY; without even the implied warranty of
016: * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE, or any warranty
017: * of NON-INFRINGEMENT. See the GNU General Public License for more
018: * details.
019: *
020: * You should have received a copy of the GNU General Public License
021: * along with Resin Open Source; if not, write to the
022: * Free SoftwareFoundation, Inc.
023: * 59 Temple Place, Suite 330
024: * Boston, MA 02111-1307 USA
025: *
026: * @author Scott Ferguson
027: */
028:
029: package com.caucho.ejb.ql;
030:
031: import com.caucho.config.ConfigException;
032: import com.caucho.util.CharBuffer;
033:
034: /**
035: * A between expression
036: */
037: class BetweenExpr extends Expr {
038: // value expression
039: private Expr _value;
040: // min expression
041: private Expr _min;
042: // max expression
043: private Expr _max;
044: // true if this is a negative between
045: private boolean _isNot;
046:
047: /**
048: * Creates a binary expression.
049: *
050: * @param value the value expression
051: * @param min the minimum expression
052: * @param max the maximum expression
053: * @param isNot if true, this the between is negated
054: */
055: BetweenExpr(Expr value, Expr min, Expr max, boolean isNot)
056: throws ConfigException {
057: _value = value;
058: _min = min;
059: _max = max;
060: _isNot = isNot;
061:
062: evalTypes();
063: }
064:
065: /**
066: * Evaluates the types for the expression
067: */
068: void evalTypes() throws ConfigException {
069: if (getJavaType() != null)
070: return;
071:
072: setJavaType(boolean.class);
073:
074: if (_value.isDate() && _min.isDate() && _max.isDate())
075: return;
076:
077: else if (_value.isDate())
078: throw error(L
079: .l(
080: "BETWEEN expects date expression at `{0}'. All values must either be date values or all must be numeric values.",
081: _value));
082:
083: else if (_min.isDate())
084: throw error(L
085: .l(
086: "BETWEEN expects date expression at `{0}'. All values must either be date values or all must be numeric values.",
087: _min));
088:
089: else if (_max.isDate())
090: throw error(L
091: .l(
092: "BETWEEN expects date expression at `{0}'. All values must either be date values or all must be numeric values.",
093: _max));
094:
095: if (!_value.isNumeric())
096: throw error(L.l(
097: "BETWEEN expects numeric expression at `{0}'",
098: _value));
099:
100: if (!_min.isNumeric())
101: throw error(L
102: .l("BETWEEN expects numeric expression at `{0}'",
103: _min));
104:
105: if (!_max.isNumeric())
106: throw error(L
107: .l("BETWEEN expects numeric expression at `{0}'",
108: _max));
109: }
110:
111: /**
112: * Prints the where SQL for this expression
113: *
114: * @param cb the java code generator
115: */
116: void generateWhere(CharBuffer cb) {
117: _value.generateWhereSubExpr(cb);
118:
119: if (_isNot)
120: cb.append(" NOT BETWEEN ");
121: else
122: cb.append(" BETWEEN ");
123:
124: _min.generateWhereSubExpr(cb);
125:
126: cb.append(" AND ");
127:
128: _max.generateWhereSubExpr(cb);
129: }
130:
131: /**
132: * Prints the where SQL for this expression
133: */
134: void generateWhereSubExpr(CharBuffer cb) {
135: cb.append("(");
136: generateWhere(cb);
137: cb.append(")");
138: }
139:
140: public String toString() {
141: if (_isNot)
142: return "NOT BETWEEN " + _min + " AND " + _max;
143: else
144: return "BETWEEN " + _min + " AND " + _max;
145: }
146: }
|