/*****************************************************************************
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 static java.util.Calendar.DAY_OF_WEEK;
import java.sql.Timestamp;
import java.util.Calendar;
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;
public class DayOfWeek extends PostfixCommand {
final public int getNumberOfParameters() {
return 1;
}
public Comparable<?>[] evaluate(ASTFunNode node, JepRuntime runtime) throws ParseException {
node.childrenAccept(runtime.ev, null);
Comparable<?> param = runtime.stack.pop();
return new Comparable<?>[]{param};
}
public static Integer dayOfWeek(Comparable<?> param, Calendar cal) throws ParseException {
if (param == null) {
return null;
}
if (param instanceof Timestamp || param instanceof java.sql.Date) {
java.util.Date ts = (java.util.Date)param;
cal.setTimeInMillis(ts.getTime());
int dayOfWeek = cal.get(DAY_OF_WEEK)-1;
if (dayOfWeek == 0) {
dayOfWeek = 7;
}
return new Integer(dayOfWeek);
}
throw new ParseException(WRONG_TYPE+" dayofweek("+param.getClass()+")");
}
public Comparable<?> getResult(Comparable<?>... comparables)
throws ParseException {
return (dayOfWeek(comparables[0], JepRuntime.getCalendar()));
}
}