/***************************************************************************** SQLJEP - Java SQL Expression Parser 0.2 November 1 2006 (c) Copyright 2006, Alexey Gaidukov SQLJEP Author: Alexey Gaidukov SQLJEP is based on JEP 2.24 (http://www.singularsys.com/jep/) (c) Copyright 2002, Nathan Funk See LICENSE.txt for license information. *****************************************************************************/ package com.meidusa.amoeba.sqljep.function; import com.meidusa.amoeba.sqljep.function.ComparativeComparator; import com.meidusa.amoeba.sqljep.function.PostfixCommand; import com.meidusa.amoeba.sqljep.ASTFunNode; import com.meidusa.amoeba.sqljep.JepRuntime; import com.meidusa.amoeba.sqljep.ParseException; @Deprecated public final class Decode extends PostfixCommand { final public int getNumberOfParameters() { return -1; } public Comparable<?>[] evaluate(ASTFunNode node, JepRuntime runtime) throws ParseException { int num = node.jjtGetNumChildren(); if (num > 2) { boolean elseCase; if (num % 2 == 0) { elseCase = true; num--; } else { elseCase = false; } node.jjtGetChild(0).jjtAccept(runtime.ev, null); Comparable<?> source = runtime.stack.pop(); int result = -1; if (source == null) { for (int i = 1; i < num; i += 2) { node.jjtGetChild(i).jjtAccept(runtime.ev, null); Comparable<?> variant = runtime.stack.pop(); if (variant == null) { result = i; break; } } if (result < 0 && elseCase) { result = num-1; } } else { for (int i = 1; i < num; i += 2) { node.jjtGetChild(i).jjtAccept(runtime.ev, null); Comparable<?> variant = runtime.stack.pop(); if (variant != null && ComparativeComparator.compareTo(source, variant) == 0) { result = i; break; } } if (result < 0 && elseCase) { result = num-1; } } if (result > 0) { node.jjtGetChild(result+1).jjtAccept(runtime.ev, null); Comparable<?> variant = runtime.stack.pop(); runtime.stack.push(variant); } else { runtime.stack.push(null); } } else { throw new ParseException("Few arguments for decode"); } return null; } public Comparable<?> getResult(Comparable<?>... comparables) throws ParseException { // TODO Auto-generated method stub return null; } }