| /************************************************************** |
| * |
| * 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 |
| * |
| * 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. |
| * |
| *************************************************************/ |
| |
| |
| |
| package complex.reportdesign; |
| |
| import java.io.File; |
| import java.util.ArrayList; |
| |
| import com.sun.star.beans.PropertyValue; |
| import com.sun.star.beans.XPropertySet; |
| import com.sun.star.container.XNameAccess; |
| import com.sun.star.frame.XComponentLoader; |
| import com.sun.star.frame.XDesktop; |
| import com.sun.star.frame.XModel; |
| import com.sun.star.frame.XStorable; |
| import com.sun.star.lang.XComponent; |
| import com.sun.star.lang.XMultiServiceFactory; |
| import com.sun.star.sdb.XDocumentDataSource; |
| import com.sun.star.sdb.XOfficeDatabaseDocument; |
| import com.sun.star.sdb.XReportDocumentsSupplier; |
| import com.sun.star.sdb.application.XDatabaseDocumentUI; |
| import com.sun.star.uno.UnoRuntime; |
| import com.sun.star.uno.XInterface; |
| import com.sun.star.util.XCloseable; |
| |
| // import util.BasicMacroTools; |
| // import util.DesktopTools; |
| // import util.dbg; |
| // import complexlib.ComplexTestCase; |
| // import util.utils; |
| import helper.OfficeProvider; |
| import helper.URLHelper; |
| // import helper.OfficeWatcher; |
| |
| import convwatch.DB; |
| |
| // import java.util.Date; |
| // import java.text.SimpleDateFormat; |
| // import java.text.ParsePosition; |
| // import java.sql.Time; |
| // |
| // import java.io.BufferedReader; |
| // import java.io.File; |
| // import java.io.FileReader; |
| // import java.io.IOException; |
| // import java.io.FilenameFilter; |
| // |
| // import java.util.Vector; |
| // |
| // import helper.AppProvider; |
| // import java.text.DecimalFormat; |
| // import util.DynamicClassLoader; |
| // import java.util.StringTokenizer; |
| |
| 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.*; |
| |
| |
| class PropertySetHelper |
| { |
| XPropertySet m_xPropertySet; |
| public PropertySetHelper(Object _aObj) |
| { |
| m_xPropertySet = UnoRuntime.queryInterface(XPropertySet.class, _aObj); |
| } |
| |
| /** |
| get a property and don't convert it |
| @param _sName the string name of the property |
| @return the object value of the property without any conversion |
| */ |
| public Object getPropertyValueAsObject(String _sName) |
| { |
| Object aObject = null; |
| |
| if (m_xPropertySet != null) |
| { |
| try |
| { |
| aObject = m_xPropertySet.getPropertyValue(_sName); |
| } |
| catch (com.sun.star.beans.UnknownPropertyException e) |
| { |
| System.out.println("ERROR: UnknownPropertyException caught. '" + _sName + "'"); |
| System.out.println("Message: " + e.getMessage()); |
| } |
| catch (com.sun.star.lang.WrappedTargetException e) |
| { |
| System.out.println("ERROR: WrappedTargetException caught."); |
| System.out.println("Message: " + e.getMessage()); |
| } |
| } |
| return aObject; |
| } |
| } |
| |
| class PropertyHelper |
| { |
| /** |
| Create a PropertyValue[] from a ArrayList |
| @param _aArrayList |
| @return a PropertyValue[] |
| */ |
| public static PropertyValue[] createPropertyValueArrayFormArrayList(ArrayList _aPropertyList) |
| { |
| // copy the whole PropertyValue List to an PropertyValue Array |
| PropertyValue[] aSaveProperties = null; |
| |
| if (_aPropertyList == null) |
| { |
| aSaveProperties = new PropertyValue[0]; |
| } |
| else |
| { |
| if (_aPropertyList.size() > 0) |
| { |
| aSaveProperties = new PropertyValue[_aPropertyList.size()]; |
| for (int i = 0;i<_aPropertyList.size(); i++) |
| { |
| aSaveProperties[i] = (PropertyValue) _aPropertyList.get(i); |
| } |
| } |
| else |
| { |
| aSaveProperties = new PropertyValue[0]; |
| } |
| } |
| return aSaveProperties; |
| } |
| } |
| |
| public class ReportDesignerTest |
| { |
| |
| String mTestDocumentPath; |
| |
| // public String[] getTestMethodNames() |
| // { |
| // return new String[] {"firsttest"}; |
| // } |
| |
| @Before public void before() |
| { |
| System.out.println("before"); |
| // String tempdir = System.getProperty("java.io.tmpdir"); |
| // |
| int dummy = 0; |
| // m_xXMultiServiceFactory = getMSF(); |
| } |
| |
| @After public void after() |
| { |
| System.out.println("after"); |
| } |
| |
| // private void checkIfOfficeExists(String _sOfficePathWithTrash) |
| // { |
| // String sOfficePath = ""; |
| // int nIndex = _sOfficePathWithTrash.indexOf("soffice.exe"); |
| // if (nIndex > 0) |
| // { |
| // sOfficePath = _sOfficePathWithTrash.substring(0, nIndex + 11); |
| // } |
| // else |
| // { |
| // nIndex = _sOfficePathWithTrash.indexOf("soffice"); |
| // if (nIndex > 0) |
| // { |
| // sOfficePath = _sOfficePathWithTrash.substring(0, nIndex + 7); |
| // } |
| // } |
| // |
| // System.out.println(sOfficePath); |
| // File sOffice = new File(sOfficePath); |
| // if (! sOffice.exists()) |
| // { |
| // System.out.println("ERROR: There exists no office installation at given path: '" + sOfficePath + "'"); |
| // System.exit(0); |
| // } |
| // } |
| |
| |
| private XDesktop m_xDesktop = null; |
| public XDesktop getXDesktop() |
| { |
| |
| if (m_xDesktop == null) |
| { |
| try |
| { |
| XInterface xInterface = (XInterface) getMSF().createInstance( "com.sun.star.frame.Desktop" ); |
| m_xDesktop = UnoRuntime.queryInterface(XDesktop.class, xInterface); |
| assertNotNull("Can't get XDesktop", m_xDesktop); |
| } |
| catch (com.sun.star.uno.Exception e) |
| { |
| System.out.println("ERROR: uno.Exception caught"); |
| System.out.println("Message: " + e.getMessage()); |
| } |
| } |
| return m_xDesktop; |
| } |
| |
| private void showElements(XNameAccess _xNameAccess) |
| { |
| if (_xNameAccess != null) |
| { |
| String[] sElementNames = _xNameAccess.getElementNames(); |
| for(int i=0;i<sElementNames.length; i++) |
| { |
| System.out.println("Value: [" + i + "] := " + sElementNames[i]); |
| } |
| } |
| else |
| { |
| System.out.println("Warning: Given object is null."); |
| } |
| } |
| |
| |
| private OfficeProvider m_aProvider = null; |
| // private void startOffice() |
| // { |
| // // int tempTime = param.getInt("SingleTimeOut"); |
| // param.put("TimeOut", new Integer(300000)); |
| // System.out.println("TimeOut: " + param.getInt("TimeOut")); |
| // System.out.println("ThreadTimeOut: " + param.getInt("ThreadTimeOut")); |
| // |
| // // OfficeProvider aProvider = null; |
| // m_aProvider = new OfficeProvider(); |
| // m_xXMultiServiceFactory = (XMultiServiceFactory) m_aProvider.getManager(param); |
| // param.put("ServiceFactory", m_xXMultiServiceFactory); |
| // } |
| // |
| // private void stopOffice() |
| // { |
| // if (m_aProvider != null) |
| // { |
| // m_aProvider.closeExistingOffice(param, true); |
| // m_aProvider = null; |
| // } |
| // } |
| |
| private String m_sMailAddress = null; |
| private String m_sUPDMinor; |
| private String m_sCWS_WORK_STAMP; |
| |
| private static final int WRITER = 1; |
| private static final int CALC = 2; |
| |
| @Test public void firsttest() |
| { |
| // convwatch.GlobalLogWriter.set(log); |
| |
| // -------------------- preconditions, try to find an office -------------------- |
| |
| // String sAppExecutionCommand = (String) param.get("AppExecutionCommand"); |
| |
| String sUser = System.getProperty("user.name"); |
| System.out.println("user.name='" + sUser + "'"); |
| |
| String sVCSID = System.getProperty("VCSID"); |
| System.out.println("VCSID='" + sVCSID + "'"); |
| m_sMailAddress = sVCSID + "@openoffice.org"; |
| System.out.println("Assumed mail address: " + m_sMailAddress); |
| |
| m_sUPDMinor = System.getProperty("UPDMINOR"); |
| m_sCWS_WORK_STAMP = System.getProperty("CWS_WORK_STAMP"); |
| // createDBEntry(); |
| System.out.println("Current CWS: " + m_sCWS_WORK_STAMP); |
| System.out.println("Current MWS: " + m_sUPDMinor); |
| |
| // System.exit(1); |
| |
| // sAppExecutionCommand = sAppExecutionCommand.replaceAll( "\\$\\{USERNAME\\}", sUser); |
| // System.out.println("sAppExecutionCommand='" + sAppExecutionCommand + "'"); |
| // |
| // an other way to replace strings |
| // sAppExecutionCommand = utils.replaceAll13(sAppExecutionCommand, "${USERNAME}", sUser); |
| |
| // checkIfOfficeExists(sAppExecutionCommand); |
| // param.put("AppExecutionCommand", new String(sAppExecutionCommand)); |
| |
| // --------------------------- Start the given Office --------------------------- |
| |
| // startOffice(); |
| |
| // ------------------------------ Start a test run ------------------------------ |
| |
| // String sCurrentDirectory = System.getProperty("user.dir"); |
| // System.out.println("Current Dir: " + sCurrentDirectory); |
| // |
| String sWriterDocument = TestDocument.getUrl("RPTWriterTests.odb"); |
| startTestForFile(sWriterDocument, WRITER); |
| |
| String sCalcDocument = TestDocument.getUrl("RPTCalcTests.odb"); |
| startTestForFile(sCalcDocument, CALC); |
| // catch (AssureException e) |
| // { |
| // stopOffice(); |
| // throw new AssureException(e.getMessage()); |
| // } |
| // |
| // ------------------------------ Office shutdown ------------------------------ |
| // stopOffice(); |
| } |
| |
| // ----------------------------------------------------------------------------- |
| private void startTestForFile(String _sDocument, int _nType) |
| { |
| FileURL aFileURL = new FileURL(_sDocument); |
| assertTrue("Test File doesn't '" + _sDocument + "'exist.", aFileURL.exists()); |
| |
| String sFileURL = _sDocument; // URLHelper.getFileURLFromSystemPath(_sDocument); |
| System.out.println("File URL: " + sFileURL); |
| |
| XComponent xDocComponent = loadComponent(sFileURL, getXDesktop(), null); |
| System.out.println("Load done"); |
| assertNotNull("Can't load document ", xDocComponent); |
| |
| // context = createUnoService("com.sun.star.sdb.DatabaseContext") |
| // oDataBase = context.getByName("hh") |
| // oDBDoc = oDataBase.DatabaseDocument |
| // |
| // dim args(1) as new com.sun.star.beans.PropertyValue |
| // args(0).Name = "ActiveConnection" |
| // args(0).Value = oDBDoc.getCurrentController().getPropertyValue("ActiveConnection") |
| // reportContainer = oDBDoc.getReportDocuments() |
| // report = reportContainer.loadComponentFromURL("Report40","",0,args) |
| |
| try |
| { |
| XInterface x = (XInterface)getMSF().createInstance("com.sun.star.sdb.DatabaseContext"); |
| assertNotNull("can't create instance of com.sun.star.sdb.DatabaseContext", x); |
| System.out.println("createInstance com.sun.star.sdb.DatabaseContext done"); |
| |
| XNameAccess xNameAccess = UnoRuntime.queryInterface(XNameAccess.class, x); |
| showElements(xNameAccess); |
| Object aObj = xNameAccess.getByName(sFileURL); |
| // System.out.println("1"); |
| |
| // PropertySetHelper aHelper = new PropertySetHelper(aObj); |
| XDocumentDataSource xDataSource = UnoRuntime.queryInterface(XDocumentDataSource.class, aObj); |
| // Object aDatabaseDocmuent = aHelper.getPropertyValueAsObject("DatabaseDocument"); |
| XOfficeDatabaseDocument xOfficeDBDoc = xDataSource.getDatabaseDocument(); |
| |
| // XOfficeDatabaseDocument xOfficeDBDoc = (XOfficeDatabaseDocument)UnoRuntime.queryInterface(XOfficeDatabaseDocument.class, aDatabaseDocument); |
| assertNotNull("can't access DatabaseDocument", xOfficeDBDoc); |
| // System.out.println("2"); |
| |
| XModel xDBSource = UnoRuntime.queryInterface(XModel.class, xOfficeDBDoc); |
| Object aController = xDBSource.getCurrentController(); |
| assertNotNull("Controller of xOfficeDatabaseDocument is empty!", aController); |
| // System.out.println("3"); |
| |
| XDatabaseDocumentUI aDBDocUI = UnoRuntime.queryInterface(XDatabaseDocumentUI.class, aController); |
| /* boolean isConnect = */ |
| // TODO: throws an exception in DEV300m78 |
| aDBDocUI.connect(); |
| // if (isConnect) |
| // { |
| // System.out.println("true"); |
| // } |
| // else |
| // { |
| // System.out.println("false"); |
| // } |
| // System.out.println("4"); |
| |
| // aHelper = new PropertySetHelper(aController); |
| |
| // Object aActiveConnectionObj = aHelper.getPropertyValueAsObject("ActiveConnection"); |
| Object aActiveConnectionObj = aDBDocUI.getActiveConnection(); |
| assertNotNull("ActiveConnection is empty", aActiveConnectionObj); |
| // System.out.println("5"); |
| |
| XReportDocumentsSupplier xSupplier = UnoRuntime.queryInterface(XReportDocumentsSupplier.class, xOfficeDBDoc); |
| xNameAccess = xSupplier.getReportDocuments(); |
| assertNotNull("xOfficeDatabaseDocument returns no Report Document", xNameAccess); |
| // System.out.println("5"); |
| |
| showElements(xNameAccess); |
| |
| ArrayList<PropertyValue> aPropertyList = new ArrayList<PropertyValue>(); |
| |
| PropertyValue aActiveConnection = new PropertyValue(); |
| aActiveConnection.Name = "ActiveConnection"; |
| aActiveConnection.Value = aActiveConnectionObj; |
| aPropertyList.add(aActiveConnection); |
| |
| loadAndStoreReports(xNameAccess, aPropertyList, _nType); |
| createDBEntry(_nType); |
| } |
| catch(com.sun.star.uno.Exception e) |
| { |
| fail("ERROR: Exception caught" + e.getMessage()); |
| } |
| |
| // String mTestDocumentPath = (String) param.get("TestDocumentPath"); |
| // System.out.println("mTestDocumentPath: '" + mTestDocumentPath + "'"); |
| // // workaround for issue using deprecated "DOCPTH" prop |
| // System.setProperty("DOCPTH", mTestDocumentPath); |
| |
| // Close the document |
| closeComponent(xDocComponent); |
| } |
| |
| private String getDocumentPoolName(int _nType) |
| { |
| return getFileFormat(_nType); |
| } |
| |
| // ----------------------------------------------------------------------------- |
| private void createDBEntry(int _nType) |
| { |
| // try to connect the database |
| String sDBConnection = ""; // (String)param.get( convwatch.PropertyName.DB_CONNECTION_STRING ); |
| System.out.println("DBConnection: " + sDBConnection); |
| DB.init(sDBConnection); |
| String sDestinationVersion = m_sCWS_WORK_STAMP; |
| if (sDestinationVersion.length() == 0) |
| { |
| sDestinationVersion = m_sUPDMinor; |
| } |
| String sDestinationName = ""; |
| String sDestinationCreatorType = ""; |
| String sDocumentPoolDir = getOutputPath(_nType); |
| String sDocumentPoolName = getDocumentPoolName(_nType); |
| String sSpecial = ""; |
| |
| String sFixRefSubDirectory = "ReportDesign_qa_complex_" + getFileFormat(_nType); |
| // DB.insertinto_documentcompare(sFixRefSubDirectory, "", "fixref", |
| // sDestinationVersion, sDestinationName, sDestinationCreatorType, |
| // sDocumentPoolDir, sDocumentPoolName, m_sMailAddress, |
| // sSpecial); |
| // DB.test(); |
| // System.exit(1); |
| } |
| |
| private void loadAndStoreReports(XNameAccess _xNameAccess, ArrayList _aPropertyList, int _nType) |
| { |
| if (_xNameAccess != null) |
| { |
| String[] sElementNames = _xNameAccess.getElementNames(); |
| for(int i=0;i<sElementNames.length; i++) |
| { |
| String sReportName = sElementNames[i]; |
| XComponent xDoc = loadComponent(sReportName, _xNameAccess, _aPropertyList); |
| // print? or store? |
| storeComponent(sReportName, xDoc, _nType); |
| closeComponent(xDoc); |
| } |
| } |
| } |
| |
| private String getFormatExtension(int _nType) |
| { |
| String sExtension; |
| switch(_nType) |
| { |
| case WRITER: |
| sExtension = ".odt"; |
| break; |
| case CALC: |
| sExtension = ".ods"; |
| break; |
| default: |
| sExtension = ".UNKNOWN"; |
| } |
| return sExtension; |
| } |
| private String getFileFormat(int _nType) |
| { |
| String sFileType; |
| switch(_nType) |
| { |
| case WRITER: |
| sFileType = "writer8"; |
| break; |
| case CALC: |
| sFileType = "calc8"; |
| break; |
| default: |
| sFileType = "UNKNOWN"; |
| } |
| return sFileType; |
| } |
| |
| private String getOutputPath(int _nType) |
| { |
| String sOutputPath = util.utils.getOfficeTemp/*Dir*/(getMSF());// (String)param.get( convwatch.PropertyName.DOC_COMPARATOR_OUTPUT_PATH ); |
| |
| if (!sOutputPath.endsWith("/") || // construct the output file name |
| !sOutputPath.endsWith("\\")) |
| { |
| sOutputPath += System.getProperty("file.separator"); |
| } |
| sOutputPath += "tmp_123"; |
| sOutputPath += System.getProperty("file.separator"); |
| |
| // sOutputPath += getFileFormat(_nType); |
| // sOutputPath += System.getProperty("file.separator"); |
| |
| File aOutputFile = new File(sOutputPath); // create the directory of the given output path |
| aOutputFile.mkdirs(); |
| |
| return sOutputPath; |
| } |
| |
| /* |
| store given _xComponent under the given Name in DOC_COMPARATOR_INPUTPATH |
| */ |
| private void storeComponent(String _sName, Object _xComponent, int _nType) |
| { |
| String sOutputPath = getOutputPath(_nType); |
| |
| // add DocumentPoolName |
| sOutputPath += getDocumentPoolName(_nType); |
| sOutputPath += System.getProperty("file.separator"); |
| |
| File aOutputFile = new File(sOutputPath); // create the directory of the given output path |
| aOutputFile.mkdirs(); |
| |
| sOutputPath += _sName; |
| sOutputPath += getFormatExtension(_nType); |
| |
| String sOutputURL = URLHelper.getFileURLFromSystemPath(sOutputPath); |
| |
| ArrayList<PropertyValue> aPropertyList = new ArrayList<PropertyValue>(); // set some properties for storeAsURL |
| |
| PropertyValue aFileFormat = new PropertyValue(); |
| aFileFormat.Name = "FilterName"; |
| aFileFormat.Value = getFileFormat(_nType); |
| aPropertyList.add(aFileFormat); |
| |
| PropertyValue aOverwrite = new PropertyValue(); // always overwrite already exist files |
| aOverwrite.Name = "Overwrite"; |
| aOverwrite.Value = Boolean.TRUE; |
| aPropertyList.add(aOverwrite); |
| |
| // store the document in an other directory |
| XStorable aStorable = UnoRuntime.queryInterface(XStorable.class, _xComponent); |
| if (aStorable != null) |
| { |
| System.out.println("store document as URL: '" + sOutputURL + "'"); |
| try |
| { |
| aStorable.storeAsURL(sOutputURL, PropertyHelper.createPropertyValueArrayFormArrayList(aPropertyList)); |
| } |
| catch (com.sun.star.io.IOException e) |
| { |
| System.out.println("ERROR: Exception caught"); |
| System.out.println("Can't write document URL: '" + sOutputURL + "'"); |
| System.out.println("Message: " + e.getMessage()); |
| } |
| } |
| } |
| |
| private XComponent loadComponent(String _sName, Object _xComponent, ArrayList _aPropertyList) |
| { |
| XComponent xDocComponent = null; |
| XComponentLoader xComponentLoader = UnoRuntime.queryInterface(XComponentLoader.class, _xComponent); |
| |
| try |
| { |
| PropertyValue[] aLoadProperties = PropertyHelper.createPropertyValueArrayFormArrayList(_aPropertyList); |
| System.out.println("Load component: '" + _sName + "'"); |
| xDocComponent = xComponentLoader.loadComponentFromURL(_sName, "_blank", 0, aLoadProperties); |
| } |
| catch (com.sun.star.io.IOException e) |
| { |
| System.out.println("ERROR: Exception caught"); |
| System.out.println("Can't load document '" + _sName + "'"); |
| System.out.println("Message: " + e.getMessage()); |
| } |
| catch (com.sun.star.lang.IllegalArgumentException e) |
| { |
| System.out.println("ERROR: Exception caught"); |
| System.out.println("Illegal Arguments given to loadComponentFromURL."); |
| System.out.println("Message: " + e.getMessage()); |
| } |
| return xDocComponent; |
| } |
| |
| private void closeComponent(XComponent _xDoc) |
| { |
| // Close the document |
| XCloseable xCloseable = UnoRuntime.queryInterface(XCloseable.class, _xDoc); |
| try |
| { |
| xCloseable.close(true); |
| } |
| catch (com.sun.star.util.CloseVetoException e) |
| { |
| System.out.println("ERROR: CloseVetoException caught"); |
| System.out.println("CloseVetoException occured Can't close document."); |
| System.out.println("Message: " + e.getMessage()); |
| } |
| } |
| |
| |
| private XMultiServiceFactory getMSF() |
| { |
| final XMultiServiceFactory xMSF1 = UnoRuntime.queryInterface(XMultiServiceFactory.class, connection.getComponentContext().getServiceManager()); |
| return xMSF1; |
| } |
| |
| // setup and close connections |
| @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(); |
| |
| } |