Java tutorial
/* * Copyright 2013 ENERKO Informatik GmbH * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. * * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE * FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL * DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. */ package de.enerko.reports2.engine; import java.io.BufferedOutputStream; import java.io.ByteArrayInputStream; import java.io.ByteArrayOutputStream; import java.io.File; import java.io.FileInputStream; import java.io.FileOutputStream; import java.io.IOException; import java.io.InputStream; import java.util.List; import java.util.logging.Level; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.Workbook; import org.junit.Assert; import org.junit.Test; import de.enerko.reports2.AbstractDatabaseTest; /** * @author Michael J. Simons, 2013-06-18 */ public class ReportEngineTest extends AbstractDatabaseTest { @Test public void shouldHandleValidStatements() throws IOException { final ReportEngine reportEngine = new ReportEngine(connection); final Report report = reportEngine.createReportFromStatement( "Select 's1' as sheetname, 1 as cell_column, 1 as cell_row, 'c1' as cell_name, 'string' as cell_type, 'cv' as cell_value from dual"); File outFile = File.createTempFile(ReportEngineTest.class.getSimpleName() + "-", ".xls"); report.write(new BufferedOutputStream(new FileOutputStream(outFile))); ReportEngine.logger.log(Level.INFO, String.format("Report written to %s", outFile.getAbsolutePath())); } @Test public void shouldHandleValidFunctions() throws IOException { final ReportEngine reportEngine = new ReportEngine(connection); final Report report = reportEngine.createReport("pck_enerko_reports2_test.f_fb_report_source_test", "5", "21.09.1979", "test"); File outFile = File.createTempFile(ReportEngineTest.class.getSimpleName() + "-", ".xls"); report.write(new BufferedOutputStream(new FileOutputStream(outFile))); ReportEngine.logger.log(Level.INFO, String.format("Report written to %s", outFile.getAbsolutePath())); } @Test public void shouldHandleTemplates() throws IOException { final ReportEngine reportEngine = new ReportEngine(connection); final InputStream template = this.getClass().getResource("/template1.xls").openStream(); final Report report = reportEngine.createReport("pck_enerko_reports2_test.f_fb_report_source_test", template, "5", "21.09.1979", "test"); File outFile = File.createTempFile(ReportEngineTest.class.getSimpleName() + "-", ".xls"); report.write(new BufferedOutputStream(new FileOutputStream(outFile))); ReportEngine.logger.log(Level.INFO, String.format("Report written to %s", outFile.getAbsolutePath())); } @Test public void displayAllFeatures() throws IOException { final ReportEngine reportEngine = new ReportEngine(connection); final Report report = reportEngine.createReport("pck_enerko_reports2_test.f_all_features", this.getClass().getResource("/template2.xls").openStream()); File outFile = File.createTempFile(ReportEngineTest.class.getSimpleName() + "-", ".xls"); report.write(new BufferedOutputStream(new FileOutputStream(outFile))); ReportEngine.logger.log(Level.INFO, String.format("Report written to %s", outFile.getAbsolutePath())); } @Test public void shouldEvaluateReport() throws IOException { final ReportEngine reportEngine = new ReportEngine(connection); final Report report = reportEngine.createReport("pck_enerko_reports2_test.f_all_features", this.getClass().getResource("/template2.xls").openStream()); final ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream(); report.write(new BufferedOutputStream(byteArrayOutputStream)); @SuppressWarnings("unused") final List<CellDefinition> cells = reportEngine .createReport(new ByteArrayInputStream(byteArrayOutputStream.toByteArray())).evaluateWorkbook(); } @Test public void shouldHandleSheetManipulation() throws IOException { final ReportEngine reportEngine = new ReportEngine(connection); final Report report = reportEngine.createReport("pck_enerko_reports2_test.f_sheet_manipulation", this.getClass().getResource("/sheet_manipulation.xls").openStream()); File outFile = File.createTempFile(ReportEngineTest.class.getSimpleName() + "-", ".xls"); report.write(new BufferedOutputStream(new FileOutputStream(outFile))); final Workbook workbook = new HSSFWorkbook(new FileInputStream(outFile)); Assert.assertTrue(workbook.isSheetHidden(workbook.getSheetIndex("hide_me"))); Assert.assertEquals(-1, workbook.getSheetIndex("delete_me")); ReportEngine.logger.log(Level.INFO, String.format("Report written to %s", outFile.getAbsolutePath())); } }