diff options
Diffstat (limited to 'sc/qa/complex')
-rw-r--r-- | sc/qa/complex/dataPilot/CheckDataPilot.java | 315 |
1 files changed, 0 insertions, 315 deletions
diff --git a/sc/qa/complex/dataPilot/CheckDataPilot.java b/sc/qa/complex/dataPilot/CheckDataPilot.java deleted file mode 100644 index 7554d1661a01..000000000000 --- a/sc/qa/complex/dataPilot/CheckDataPilot.java +++ /dev/null @@ -1,315 +0,0 @@ -/* - * This file is part of the LibreOffice project. - * - * This Source Code Form is subject to the terms of the Mozilla Public - * License, v. 2.0. If a copy of the MPL was not distributed with this - * file, You can obtain one at http://mozilla.org/MPL/2.0/. - * - * This file incorporates work covered by the following license notice: - * - * Licensed to the Apache Software Foundation (ASF) under one or more - * contributor license agreements. See the NOTICE file distributed - * with this work for additional information regarding copyright - * ownership. The ASF licenses this file to you 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 . - */ - -package complex.dataPilot; - -import com.sun.star.beans.XPropertySet; -import com.sun.star.container.XIndexAccess; -import com.sun.star.container.XNamed; -import com.sun.star.lang.XMultiServiceFactory; -import com.sun.star.sheet.XDataPilotDescriptor; -import com.sun.star.sheet.XDataPilotTable; -import com.sun.star.sheet.XDataPilotTables; -import com.sun.star.sheet.XDataPilotTablesSupplier; -import com.sun.star.sheet.XSpreadsheet; -import com.sun.star.sheet.XSpreadsheetDocument; -import com.sun.star.sheet.XSpreadsheets; -import com.sun.star.table.CellAddress; -import com.sun.star.table.CellRangeAddress; -import com.sun.star.uno.AnyConverter; -import com.sun.star.uno.Type; -import com.sun.star.uno.UnoRuntime; -import com.sun.star.uno.XInterface; -import com.sun.star.util.XCloseable; -import lib.TestParameters; -import util.SOfficeFactory; - -import org.junit.After; -import org.junit.AfterClass; -import org.junit.Before; -import org.junit.BeforeClass; -import org.junit.Test; -import org.openoffice.test.OfficeConnection; -import static org.junit.Assert.*; - - -/** - * check the DataPilot of Calc. - */ -public class CheckDataPilot { - /** The data pilot field object **/ - private XInterface mDataPilotFieldObject = null; - /** The data pilot table object **/ - private XInterface mDataPilotTableObject = null; - - - private XSpreadsheetDocument xSheetDoc = null; - - /** - * A field is filled some values. This integer determines the size of the - * field in x and y direction. - */ - private static final int mMaxFieldIndex = 6; - - /** - * The test parameters - */ - private static TestParameters param = null; - - /** - * Get all test methods - * @return The test methods - */ - public String[] getTestMethodNames() { - return new String[]{"testDataPilotTableObject", - "testDataPilotFieldObject"}; - } - - /** - * Test the data pilot field object: - * simply execute the interface tests in a row - */ - @Test public void testDataPilotFieldObject() { - System.out.println("Starting 'testDataPilotFieldObject'"); - // _XNamed - XNamed xNamed = UnoRuntime.queryInterface( - XNamed.class, mDataPilotFieldObject); - - _XNamed _xNamed = new _XNamed(xNamed/*, log*/, param); - assertTrue("_getName failed.",_xNamed._getName()); - assertTrue("_setName failed.",_xNamed._setName()); - - // _XPropertySet - XPropertySet xProp = UnoRuntime.queryInterface( - XPropertySet.class, mDataPilotFieldObject); - _XPropertySet _xProp = new _XPropertySet(xProp/*, log*/, param); - assertTrue("_getPropertySetInfo failed.",_xProp._getPropertySetInfo()); - assertTrue("_addPropertyChangeListener failed.",_xProp._addPropertyChangeListener()); - assertTrue("_addVetoableChangeListener failed.",_xProp._addVetoableChangeListener()); - assertTrue("_setPropertyValue failed.",_xProp._setPropertyValue()); - assertTrue("_getPropertyValue failed.",_xProp._getPropertyValue()); - assertTrue("_removePropertyChangeListener failed.",_xProp._removePropertyChangeListener()); - assertTrue("_removeVetoableChangeListener failed.",_xProp._removeVetoableChangeListener()); - - } - - /** - * Test the data pilot table object: - * simply execute the interface tests in a row - */ - @Test public void testDataPilotTableObject() { - System.out.println("Starting 'testDataPilotTableObject'"); - // _XNamed - XNamed xNamed = UnoRuntime.queryInterface( - XNamed.class, mDataPilotTableObject); - _XNamed _xNamed = new _XNamed(xNamed/*, log*/, param); - assertTrue("_getName failed.",_xNamed._getName()); - assertTrue("_setName failed.",_xNamed._setName()); - - // _XDataPilotTable - XDataPilotTable xDataPilotTable = - UnoRuntime.queryInterface(XDataPilotTable.class, - mDataPilotTableObject); - _XDataPilotTable _xDataPilotTable = - new _XDataPilotTable(xDataPilotTable/*, log*/, param); - assertTrue("before failed.", _xDataPilotTable.before()); - assertTrue("_getOutputRange failed.", _xDataPilotTable._getOutputRange()) ; - - // _XDataPilotDescriptor - XDataPilotDescriptor xDataPilotDescriptor = - UnoRuntime.queryInterface(XDataPilotDescriptor.class, - mDataPilotTableObject); - _XDataPilotDescriptor _xDataPilotDescriptor = - new _XDataPilotDescriptor(xDataPilotDescriptor/*, log*/, param); - assertTrue("before failed.", _xDataPilotDescriptor.before()); - assertTrue("_setTag failed.", _xDataPilotDescriptor._setTag()) ; - assertTrue("_getTag failed.", _xDataPilotDescriptor._getTag()) ; - assertTrue("_getFilterDescriptor failed.", _xDataPilotDescriptor._getFilterDescriptor()) ; - assertTrue("_getDataPilotFields failed.", _xDataPilotDescriptor._getDataPilotFields()) ; - assertTrue("_getColumnFields failed.", _xDataPilotDescriptor._getColumnFields()) ; - assertTrue("_getRowFields failed.", _xDataPilotDescriptor._getRowFields()) ; - assertTrue("_getDataFields failed.", _xDataPilotDescriptor._getDataFields()) ; - assertTrue("_getHiddenFields failed.", _xDataPilotDescriptor._getHiddenFields()) ; - assertTrue("_getPageFields failed.", _xDataPilotDescriptor._getPageFields()) ; - assertTrue("_setSourceRange failed.", _xDataPilotDescriptor._setSourceRange()) ; - assertTrue("_getSourceRange failed.", _xDataPilotDescriptor._getSourceRange()) ; - } - - /** - * create an environment for the test - */ - @Before public void before() throws Exception { - - final XMultiServiceFactory xMsf = UnoRuntime.queryInterface(XMultiServiceFactory.class, connection.getComponentContext().getServiceManager()); - SOfficeFactory SOF = SOfficeFactory.getFactory(xMsf); - - param = new TestParameters(); - param.put("ServiceFactory", xMsf); - - // the cell range - CellRangeAddress sCellRangeAdress = new CellRangeAddress(); - sCellRangeAdress.Sheet = 0; - sCellRangeAdress.StartColumn = 1; - sCellRangeAdress.StartRow = 0; - sCellRangeAdress.EndColumn = mMaxFieldIndex-1; - sCellRangeAdress.EndRow = mMaxFieldIndex - 1; - - // position of the data pilot table - CellAddress sCellAdress = new CellAddress(); - sCellAdress.Sheet = 0; - sCellAdress.Column = 7; - sCellAdress.Row = 8; - - System.out.println( "Creating a Spreadsheet document" ); - xSheetDoc = SOF.createCalcDoc(null); - - System.out.println("Getting a sheet"); - XSpreadsheets xSpreadsheets = xSheetDoc.getSheets(); - XSpreadsheet oSheet = null; - XSpreadsheet oSheet2 = null; - XIndexAccess oIndexAccess = - UnoRuntime.queryInterface(XIndexAccess.class, xSpreadsheets); - - // Per default there's now just one sheet, make sure we have at least two, then - xSpreadsheets.insertNewByName("Some Sheet", (short)0); - - oSheet = (XSpreadsheet) AnyConverter.toObject( - new Type(XSpreadsheet.class),oIndexAccess.getByIndex(0)); - oSheet2 = (XSpreadsheet) AnyConverter.toObject( - new Type(XSpreadsheet.class),oIndexAccess.getByIndex(1)); - - System.out.println("Filling a table"); - for (int i = 1; i < mMaxFieldIndex; i++) { - oSheet.getCellByPosition(i, 0).setFormula("Col" + i); - oSheet.getCellByPosition(0, i).setFormula("Row" + i); - oSheet2.getCellByPosition(i, 0).setFormula("Col" + i); - oSheet2.getCellByPosition(0, i).setFormula("Row" + i); - } - - for (int i = 1; i < mMaxFieldIndex; i++) - { - for (int j = 1; j < mMaxFieldIndex; j++) - { - oSheet.getCellByPosition(i, j).setValue(i * (j + 1)); - oSheet2.getCellByPosition(i, j).setValue(i * (j + 2)); - } - } - - // change a value of a cell and check the change in the data pilot - // (for the XDataPilotTable.refresh() test) - Object oChangeCell = null; - Object oCheckCell = null; - Integer aChangeValue = null; - // cell of data - oChangeCell = oSheet.getCellByPosition(1, 5); - int x = sCellAdress.Column; - int y = sCellAdress.Row + 3; - // cell of the data pilot output - oCheckCell = oSheet.getCellByPosition(x, y); - aChangeValue = Integer.valueOf(27); - - - // create the test objects - System.out.println("Getting test objects") ; - XDataPilotTablesSupplier DPTS = - UnoRuntime.queryInterface(XDataPilotTablesSupplier.class, oSheet); - XDataPilotTables DPT = DPTS.getDataPilotTables(); - XDataPilotDescriptor DPDsc = DPT.createDataPilotDescriptor(); - DPDsc.setSourceRange(sCellRangeAdress); - - XPropertySet fieldPropSet = null; - Object oDataPilotField = DPDsc.getDataPilotFields().getByIndex(0); - fieldPropSet = - UnoRuntime.queryInterface(XPropertySet.class, oDataPilotField); - - fieldPropSet.setPropertyValue("Function", - com.sun.star.sheet.GeneralFunction.SUM); - fieldPropSet.setPropertyValue("Orientation", - com.sun.star.sheet.DataPilotFieldOrientation.DATA); - - System.out.println("Insert the DataPilotTable"); - if (DPT.hasByName("DataPilotTable")) { - DPT.removeByName("DataPilotTable"); - } - DPT.insertNewByName("DataPilotTable", sCellAdress, DPDsc); - mDataPilotTableObject = (XInterface) AnyConverter.toObject( - new Type(XInterface.class),DPT.getByName(DPT.getElementNames()[0])); - - XIndexAccess IA = DPDsc.getDataPilotFields(); - mDataPilotFieldObject = (XInterface)AnyConverter.toObject( - new Type(XInterface.class),IA.getByIndex(0)); - - // Other parameters required for interface tests - param.put("OUTPUTRANGE", sCellAdress); - param.put("CELLFORCHANGE", oChangeCell); - param.put("CELLFORCHECK", oCheckCell); - param.put("CHANGEVALUE", aChangeValue); - param.put("FIELDSAMOUNT", Integer.valueOf(5)); - - } - - /* - * this method closes a calc document and resets the corresponding class variable xSheetDoc - */ - protected boolean closeSpreadsheetDocument() { - boolean worked = true; - - System.out.println(" disposing xSheetDoc "); - - try { - XCloseable oCloser = UnoRuntime.queryInterface( - XCloseable.class, xSheetDoc); - oCloser.close(true); - } catch (com.sun.star.util.CloseVetoException e) { - worked = false; - System.out.println("Couldn't close document"); - } catch (com.sun.star.lang.DisposedException e) { - worked = false; - System.out.println("Document already disposed"); - } catch (NullPointerException e) { - worked = false; - System.out.println("Couldn't get XCloseable"); - } - - xSheetDoc = null; - - return worked; - } - - @After public void after() - { - closeSpreadsheetDocument(); - } - - - @BeforeClass public static void setUpConnection() throws Exception { - System.out.println("setUpConnection()"); - connection.setUp(); - } - - @AfterClass public static void tearDownConnection() - throws InterruptedException, com.sun.star.uno.Exception - { - System.out.println("tearDownConnection()"); - connection.tearDown(); - } - - private static final OfficeConnection connection = new OfficeConnection(); - - -} |