/**
*
* Copyright (c) 2014, the Railo Company Ltd. All rights reserved.
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library. If not, see <http://www.gnu.org/licenses/>.
*
**/
package lucee.runtime.functions.query;
import java.util.Iterator;
import lucee.runtime.PageContext;
import lucee.runtime.config.NullSupportHelper;
import lucee.runtime.db.SQLCaster;
import lucee.runtime.exp.PageException;
import lucee.runtime.ext.function.BIF;
import lucee.runtime.op.Caster;
import lucee.runtime.type.Array;
import lucee.runtime.type.ArrayImpl;
import lucee.runtime.type.KeyImpl;
import lucee.runtime.type.Query;
import lucee.runtime.type.QueryColumn;
import lucee.runtime.type.UDF;
public class QueryColumnData extends BIF {
private static final long serialVersionUID = 3915214686428831274L;
public static Array call(PageContext pc, Query query, String columnName) throws PageException {
return call(pc, query, columnName, null);
}
public static Array call(PageContext pc, Query query, String columnName, UDF udf) throws PageException {
Array arr=new ArrayImpl();
QueryColumn column = query.getColumn(KeyImpl.init(columnName));
Iterator<Object> it = column.valueIterator();
Object value;
short type = SQLCaster.toCFType(column.getType(), lucee.commons.lang.CFTypes.TYPE_UNDEFINED);
while(it.hasNext()) {
value=it.next();
if(!NullSupportHelper.full(pc) && value==null) value="";
// callback call
if(udf!=null)value=udf.call(pc, new Object[]{value}, true);
// convert (if necessary)
value=Caster.castTo(pc, type, column.getTypeAsString(), value,value);
arr.append(value);
}
return arr;
}
@Override
public Object invoke(PageContext pc, Object[] args) throws PageException {
if(args.length==2)return call(pc,Caster.toQuery(args[0]),Caster.toString(args[1]));
return call(pc,Caster.toQuery(args[0]),Caster.toString(args[1]),Caster.toFunction(args[2]));
}
}