001: /*
002: * $Id: InFunction.java,v 1.14 2005/12/20 18:32:28 ahimanikya Exp $
003: * =======================================================================
004: * Copyright (c) 2004-2005 Axion Development Team. All rights reserved.
005: *
006: * Redistribution and use in source and binary forms, with or without
007: * modification, are permitted provided that the following conditions
008: * are met:
009: *
010: * 1. Redistributions of source code must retain the above
011: * copyright notice, this list of conditions and the following
012: * disclaimer.
013: *
014: * 2. Redistributions in binary form must reproduce the above copyright
015: * notice, this list of conditions and the following disclaimer in
016: * the documentation and/or other materials provided with the
017: * distribution.
018: *
019: * 3. The names "Tigris", "Axion", nor the names of its contributors may
020: * not be used to endorse or promote products derived from this
021: * software without specific prior written permission.
022: *
023: * 4. Products derived from this software may not be called "Axion", nor
024: * may "Tigris" or "Axion" appear in their names without specific prior
025: * written permission.
026: *
027: * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
028: * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
029: * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A
030: * PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
031: * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
032: * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
033: * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
034: * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
035: * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
036: * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
037: * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
038: * =======================================================================
039: */
040:
041: package org.axiondb.functions;
042:
043: import org.axiondb.AxionException;
044: import org.axiondb.DataType;
045: import org.axiondb.FunctionFactory;
046: import org.axiondb.Row;
047: import org.axiondb.RowDecorator;
048: import org.axiondb.RowIterator;
049: import org.axiondb.Selectable;
050: import org.axiondb.types.BooleanType;
051: import org.axiondb.engine.commands.SubSelectCommand;
052:
053: /**
054: * @version $Revision: 1.14 $ $Date: 2005/12/20 18:32:28 $
055: * @author Chuck Burdick
056: * @author Amrish Lal
057: * @author Rodney Waldhoff
058: * @author Ahimanikya Satapathy
059: */
060: public class InFunction extends BaseFunction implements ScalarFunction,
061: FunctionFactory {
062:
063: public InFunction() {
064: super ("IN");
065: }
066:
067: public ConcreteFunction makeNewInstance() {
068: return new InFunction();
069: }
070:
071: public DataType getDataType() {
072: return BOOLEAN_TYPE;
073: }
074:
075: // NOTE: if multiple columns are used the current impl will not work
076: public Object evaluate(RowDecorator row) throws AxionException {
077: Object lval = getArgument(0).evaluate(row);
078: if (lval == null) {
079: // if the value in the row is null, we know we don't match
080: return Boolean.FALSE;
081: }
082:
083: DataType ltype = getArgument(0).getDataType();
084: for (int i = 1, I = getArgumentCount(); i < I; i++) {
085: Selectable arg = getArgument(i);
086: // handle sub-select here
087: if (arg instanceof SubSelectCommand) {
088: return handleSubSelect((SubSelectCommand) arg, row,
089: lval, ltype);
090: } else {
091: // else handle list
092: try {
093: Object rval = ltype.convert(arg.evaluate(row));
094: if (null != rval && ltype.compare(lval, rval) == 0) {
095: return Boolean.TRUE;
096: }
097: } catch (AxionException e) {
098: // ignore, that's OK.
099: }
100: }
101: }
102: return Boolean.FALSE;
103: }
104:
105: private Boolean handleSubSelect(SubSelectCommand cmd,
106: RowDecorator row, Object lval, DataType ltype)
107: throws AxionException {
108: RowIterator iter = (RowIterator) cmd.evaluate(row);
109: while (iter.hasNext()) {
110: Row rrow = iter.next();
111: for (int j = 0, J = rrow.size(); j < J; j++) {
112: Object rval = rrow.get(j);
113: try {
114: rval = ltype.convert(rval);
115: if (null != rval && ltype.compare(lval, rval) == 0) {
116: return Boolean.TRUE;
117: }
118: } catch (AxionException e) {
119: // ignore, that's OK.
120: }
121: }
122: }
123: return Boolean.FALSE;
124: }
125:
126: public boolean isValid() {
127: return (getArgumentCount() >= 1);
128: }
129:
130: private static final DataType BOOLEAN_TYPE = new BooleanType();
131: }
|