/* * JBoss, Home of Professional Open Source. * See the COPYRIGHT.txt file distributed with this work for information * regarding copyright ownership. Some portions may be licensed * to Red Hat, Inc. under one or more contributor license agreements. * * 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, write to the Free Software * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA * 02110-1301 USA. */ package org.teiid.query.function.aggregate; import java.io.IOException; import java.io.Writer; import java.sql.Array; import java.sql.SQLException; import java.util.Arrays; import java.util.List; import javax.sql.rowset.serial.SerialBlob; import org.teiid.common.buffer.FileStore; import org.teiid.common.buffer.FileStore.FileStoreOutputStream; import org.teiid.common.buffer.FileStoreInputStreamFactory; import org.teiid.core.TeiidComponentException; import org.teiid.core.TeiidProcessingException; import org.teiid.core.types.BlobImpl; import org.teiid.core.types.BlobType; import org.teiid.core.types.Streamable; import org.teiid.query.QueryPlugin; import org.teiid.query.sql.symbol.DerivedColumn; import org.teiid.query.sql.symbol.ElementSymbol; import org.teiid.query.sql.symbol.TextLine; import org.teiid.query.util.CommandContext; /** * Aggregates Text entries */ public class TextAgg extends SingleArgumentAggregateFunction { private FileStoreInputStreamFactory result; private TextLine textLine; public TextAgg(TextLine textLine) { this.textLine = textLine; } private FileStoreInputStreamFactory buildResult(CommandContext context) throws TeiidProcessingException { try { FileStore fs = context.getBufferManager().createFileStore("textagg"); //$NON-NLS-1$ FileStoreInputStreamFactory fisf = new FileStoreInputStreamFactory(fs, textLine.getEncoding()==null?Streamable.ENCODING:textLine.getEncoding()); Writer w = fisf.getWriter(); if (textLine.isIncludeHeader()) { Object[] header = TextLine.evaluate(textLine.getExpressions(), new TextLine.ValueExtractor<DerivedColumn>() { public Object getValue(DerivedColumn t) { if (t.getAlias() == null && t.getExpression() instanceof ElementSymbol) { return ((ElementSymbol)t.getExpression()).getShortName(); } return t.getAlias(); } }, textLine); writeList(w, header); } w.flush(); return fisf; } catch (IOException e) { throw new TeiidProcessingException(QueryPlugin.Event.TEIID30420, e); } } private void writeList(Writer w, Object[] list) throws IOException { for (int i = 0; i < list.length; i++) { w.write(list[i].toString()); } } public void reset() { this.result = null; } /** * @throws TeiidProcessingException * @throws TeiidComponentException * @see org.teiid.query.function.aggregate.AggregateFunction#addInputDirect(List, CommandContext, CommandContext) */ public void addInputDirect(Object input, List<?> tuple, CommandContext commandContext) throws TeiidComponentException, TeiidProcessingException { try { if (this.result == null) { this.result = buildResult(commandContext); } Array in = (Array)input; Writer w = result.getWriter(); writeList(w, (Object[])in.getArray()); w.flush(); } catch (SQLException e) { throw new TeiidProcessingException(QueryPlugin.Event.TEIID30421, e); } catch (IOException e) { throw new TeiidProcessingException(QueryPlugin.Event.TEIID30421, e); } } /** * @see org.teiid.query.function.aggregate.AggregateFunction#getResult(CommandContext) */ public Object getResult(CommandContext commandContext) throws TeiidProcessingException{ if (this.result == null) { this.result = buildResult(commandContext); } try { FileStoreOutputStream fs = this.result.getOuputStream(); fs.close(); if (fs.bytesWritten()) { return new BlobType(new BlobImpl(result)); } return new BlobType(new SerialBlob(Arrays.copyOf(fs.getBuffer(), fs.getCount()))); } catch (IOException e) { throw new TeiidProcessingException(QueryPlugin.Event.TEIID30422, e); } catch (SQLException e) { throw new TeiidProcessingException(QueryPlugin.Event.TEIID30423, e); } } }