Adding upstream version 1:7.0.4.upstream/1%7.0.4upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 355 insertions, 0 deletions

diff --git a/qadevOOo/tests/java/mod/_sw/SwXMailMerge.java b/qadevOOo/tests/java/mod/_sw/SwXMailMerge.java
new file mode 100644
index 000000000..f3bb2b2f2
--- /dev/null
+++ b/qadevOOo/tests/java/mod/_sw/SwXMailMerge.java
@@ -0,0 +1,355 @@
+/*
+ * 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 mod._sw;
+
+import com.sun.star.beans.NamedValue;
+
+import util.DBTools;
+import util.utils;
+import com.sun.star.beans.XPropertySet;
+import com.sun.star.container.NoSuchElementException;
+import com.sun.star.container.XNameAccess;
+import com.sun.star.lang.IllegalArgumentException;
+import com.sun.star.lang.WrappedTargetException;
+import com.sun.star.lang.XMultiServiceFactory;
+import com.sun.star.sdb.CommandType;
+import com.sun.star.sdbc.*;
+import com.sun.star.sdbcx.XRowLocate;
+import com.sun.star.task.XJob;
+import com.sun.star.text.MailMergeType;
+import com.sun.star.uno.Exception;
+import com.sun.star.uno.UnoRuntime;
+import com.sun.star.uno.XInterface;
+import java.io.PrintWriter;
+import lib.StatusException;
+import lib.TestCase;
+import lib.TestEnvironment;
+import lib.TestParameters;
+
+/**
+* Here <code>com.sun.star.text.MailMerge</code> service is tested.<p>
+* @see com.sun.star.text.MailMerge
+* @see com.sun.star.task.XJob
+* @see com.sun.star.text.XMailMergeBroadcaster
+*/
+public class SwXMailMerge extends TestCase {
+
+    @Override
+    public void initialize( TestParameters Param, PrintWriter log ) {
+        if (! Param.containsKey("uniqueSuffix")){
+            Param.put("uniqueSuffix", Integer.valueOf(0));
+        }
+    }
+
+    /**
+     * Creating a TestEnvironment for the interfaces to be tested. <p>
+     * Creates <code>MailMerge</code> service     * Object relations created :
+    * <ul>
+    *  <li> <code>'executeArgs'</code> for
+    *    {@link ifc.text._XMailMergeBroadcaster} : NamedValue[]</li>
+    *  <li> <code>'Job'</code> for
+    *    {@link ifc.text._XMailMergeBroadcaster} : XJob</li>
+    *  <li> <code>'XJobArgs'</code> for
+    *    {@link ifc.task._XJob} : Object[]</li>
+    * </ul>
+     */
+    @Override
+    protected TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) throws Exception {
+
+        XInterface oObj = null;
+        XInterface oRowSet = null;
+        XJob Job = null;
+
+        log.println(" instantiate MailMerge service");
+        oObj = (XInterface) Param.getMSF().createInstance
+            ("com.sun.star.text.MailMerge");
+
+        // <set some variables>
+        String cTestDoc = utils.getFullTestURL("MailMerge.sxw");
+        //cMailMerge_DocumentURL = cTestDoc
+        String cOutputURL = utils.getOfficeTemp( Param.getMSF());
+        String cDataSourceName  = "Bibliography";
+        String cDataCommand = "biblio";
+        Object[] myBookMarks = new Object[2];
+        // </set some variables>
+
+        // <create XResultSet>
+        log.println("create a XResultSet");
+        oRowSet = (XInterface) Param.getMSF().createInstance
+            ("com.sun.star.sdb.RowSet");
+        XPropertySet oRowSetProps = UnoRuntime.queryInterface(XPropertySet.class, oRowSet);
+        XRowSet xRowSet = UnoRuntime.queryInterface(XRowSet.class, oRowSet);
+        oRowSetProps.setPropertyValue("DataSourceName",cDataSourceName);
+        oRowSetProps.setPropertyValue("Command",cDataCommand);
+        oRowSetProps.setPropertyValue("CommandType", Integer.valueOf(CommandType.TABLE));
+        xRowSet.execute();
+
+        XResultSet oResultSet = UnoRuntime.queryInterface(XResultSet.class, oRowSet);
+
+
+
+
+        // <create Bookmarks>
+        log.println("create bookmarks");
+        XRowLocate oRowLocate = UnoRuntime.queryInterface(
+                                              XRowLocate.class, oResultSet);
+        oResultSet.first();
+        myBookMarks[0] = oRowLocate.getBookmark();
+        oResultSet.next();
+        myBookMarks[1] = oRowLocate.getBookmark();
+        // </create Bookmarks>
+
+        // <fill object with values>
+
+        log.println("fill MailMerge with default connection");
+
+        XPropertySet oObjProps = UnoRuntime.queryInterface(XPropertySet.class, oObj);
+        oObjProps.setPropertyValue("ActiveConnection", getLocalXConnection(Param));
+        oObjProps.setPropertyValue("DataSourceName", cDataSourceName);
+        oObjProps.setPropertyValue("Command", cDataCommand);
+        oObjProps.setPropertyValue("CommandType", Integer.valueOf(CommandType.TABLE));
+        oObjProps.setPropertyValue("OutputType", Short.valueOf(MailMergeType.FILE));
+        oObjProps.setPropertyValue("DocumentURL", cTestDoc);
+        oObjProps.setPropertyValue("OutputURL", cOutputURL);
+        oObjProps.setPropertyValue("FileNamePrefix", "Author");
+        oObjProps.setPropertyValue("FileNameFromColumn", Boolean.FALSE);
+        oObjProps.setPropertyValue("Selection", new Object[0]);
+
+        // </fill object with values>
+
+
+        // <create object relations>
+        Object[] vXJobArgs = new Object[4];
+        NamedValue[] vXJobArg0 = new NamedValue[8];
+        NamedValue[] vXJobArg1 = new NamedValue[7];
+        NamedValue[] vXJobArg2 = new NamedValue[10];
+        NamedValue[] vXJobArg3 = new NamedValue[0];
+
+        // first Arguments
+        vXJobArg0[0] = new NamedValue("DataSourceName", cDataSourceName);
+        vXJobArg0[1] = new NamedValue("Command", cDataCommand);
+        vXJobArg0[2] = new NamedValue("CommandType",Integer.valueOf(CommandType.TABLE));
+        vXJobArg0[3] = new NamedValue("OutputType",Short.valueOf(MailMergeType.FILE));
+        vXJobArg0[4] = new NamedValue("DocumentURL", cTestDoc);
+        vXJobArg0[5] = new NamedValue("OutputURL", cOutputURL);
+        vXJobArg0[6] = new NamedValue("FileNamePrefix", "Identifier");
+        vXJobArg0[7] = new NamedValue("FileNameFromColumn", Boolean.TRUE);
+
+        //second Arguments
+        vXJobArg1[0] = new NamedValue("DataSourceName", cDataSourceName);
+        vXJobArg1[1] = new NamedValue("Command", cDataCommand);
+        vXJobArg1[2] = new NamedValue("CommandType",Integer.valueOf(CommandType.TABLE));
+        vXJobArg1[3] = new NamedValue("OutputType",
+                             Short.valueOf(MailMergeType.PRINTER));
+        vXJobArg1[4] = new NamedValue("DocumentURL", cTestDoc);
+        vXJobArg1[5] = new NamedValue("FileNamePrefix", "Author");
+        vXJobArg1[6] = new NamedValue("FileNameFromColumn", Boolean.TRUE);
+
+        // third Arguments
+        vXJobArg2[0] = new NamedValue("ActiveConnection", getLocalXConnection(Param));
+        vXJobArg2[1] = new NamedValue("DataSourceName", cDataSourceName);
+        vXJobArg2[2] = new NamedValue("Command", cDataCommand);
+        vXJobArg2[3] = new NamedValue("CommandType",Integer.valueOf(CommandType.TABLE));
+        vXJobArg2[4] = new NamedValue("OutputType",
+                             Short.valueOf(MailMergeType.FILE));
+        vXJobArg2[5] = new NamedValue("ResultSet", oResultSet);
+        vXJobArg2[6] = new NamedValue("OutputURL", cOutputURL);
+        vXJobArg2[7] = new NamedValue("FileNamePrefix", "Identifier");
+        vXJobArg2[8] = new NamedValue("FileNameFromColumn", Boolean.TRUE);
+        vXJobArg2[9] = new NamedValue("Selection", myBookMarks);
+
+        vXJobArgs[0] = vXJobArg0;
+        vXJobArgs[1] = vXJobArg1;
+        vXJobArgs[2] = vXJobArg2;
+        vXJobArgs[3] = vXJobArg3;
+
+
+        Job = UnoRuntime.queryInterface(XJob.class, oObj);
+        try{
+            Job.execute(vXJobArg2);
+        } catch ( IllegalArgumentException e){
+            System.out.println(e.toString());
+        } catch (  Exception e){
+            System.out.println(e.toString());
+        }
+
+
+        // <create XResultSet>
+        log.println("create XResultSet");
+
+        oRowSet = (XInterface) Param.getMSF().createInstance
+            ("com.sun.star.sdb.RowSet");
+        oRowSetProps = UnoRuntime.queryInterface(XPropertySet.class, oRowSet);
+
+        xRowSet = UnoRuntime.queryInterface(XRowSet.class, oRowSet);
+
+        oRowSetProps.setPropertyValue("DataSourceName",cDataSourceName);
+        oRowSetProps.setPropertyValue("Command",cDataCommand);
+        oRowSetProps.setPropertyValue("CommandType", Integer.valueOf(CommandType.TABLE));
+        xRowSet.execute();
+
+        oResultSet = UnoRuntime.queryInterface(XResultSet.class, oRowSet);
+
+        XResultSet oMMXResultSet = null;
+        oMMXResultSet = UnoRuntime.queryInterface(XResultSet.class,
+               Param.getMSF().createInstance("com.sun.star.sdb.RowSet"));
+        // </create object relations>
+
+        TestEnvironment tEnv = new TestEnvironment(oObj) ;
+
+        // <adding object relations>
+
+        // com.sun.star.sdb.DataAccessDescriptor
+        tEnv.addObjRelation("DataAccessDescriptor.XResultSet", oResultSet);
+        tEnv.addObjRelation("DataAccessDescriptor.XConnection", getRemoteXConnection(Param));
+
+        // com.sun.star.text.MailMerge
+        tEnv.addObjRelation("MailMerge.XConnection", getRemoteXConnection(Param));
+        tEnv.addObjRelation("MailMerge.XResultSet", oMMXResultSet);
+
+        // com.sun.star.text.XMailMergeBroadcaster
+        tEnv.addObjRelation( "executeArgs", vXJobArg0);
+        tEnv.addObjRelation( "Job", Job);
+
+        // com.sun.star.task.XJob
+        tEnv.addObjRelation("XJobArgs", vXJobArgs);
+
+        // </adding object relations>
+
+        return tEnv ;
+    }
+
+    private XConnection getRemoteXConnection(TestParameters Param){
+
+        log.println("create remote connection");
+
+        String databaseName = null ;
+        XMultiServiceFactory xMSF = null ;
+        int uniqueSuffix = Param.getInt("uniqueSuffix");
+
+        try {
+            xMSF = Param.getMSF();
+            xMSF.createInstance( "com.sun.star.sdb.DatabaseContext" );
+
+            // retrieving temp directory for database
+            String tmpDatabaseUrl = utils.getOfficeTempDir(Param.getMSF());
+
+            databaseName = "NewDatabaseSource" + uniqueSuffix ;
+
+            String tmpDatabaseFile = tmpDatabaseUrl + databaseName + ".odb";
+            System.out.println("try to delete '"+tmpDatabaseFile+"'");
+            utils.deleteFile(Param.getMSF(), tmpDatabaseFile);
+
+
+            tmpDatabaseUrl = "sdbc:dbase:file:///" + tmpDatabaseUrl ;
+
+            // Creating new DBase data source in the TEMP directory
+            XInterface newSource = (XInterface) xMSF.createInstance
+                ("com.sun.star.sdb.DataSource") ;
+
+            XPropertySet xSrcProp = UnoRuntime.queryInterface(XPropertySet.class, newSource);
+
+            xSrcProp.setPropertyValue("URL", tmpDatabaseUrl) ;
+
+            DBTools dbt = new DBTools( Param.getMSF() );
+            // registering source in DatabaseContext
+            log.println("register database '"+tmpDatabaseUrl+"' as '"+databaseName+"'" );
+            dbt.reRegisterDB(databaseName, newSource) ;
+
+            uniqueSuffix++;
+            Param.put("uniqueSuffix", Integer.valueOf(uniqueSuffix));
+
+            return dbt.connectToSource(newSource);
+        }
+        catch( Exception e ) {
+            uniqueSuffix++;
+            Param.put("uniqueSuffix", Integer.valueOf(uniqueSuffix));
+            log.println("could not register new database" );
+            e.printStackTrace();
+            throw new StatusException("could not register new database", e) ;
+        }
+    }
+
+    private XConnection getLocalXConnection(TestParameters Param){
+
+        log.println("create local connection");
+
+        XInterface oDataCont = null;
+        try {
+            oDataCont = (XInterface)Param.getMSF().createInstance
+                                   ("com.sun.star.sdb.DatabaseContext");
+        } catch(Exception e) {
+            throw new StatusException("Couldn't create instance of 'com.sun.star.sdb.DatabaseContext'", e);
+        }
+        XNameAccess xNADataCont = UnoRuntime.queryInterface(XNameAccess.class, oDataCont);
+
+        String[] dataNames = xNADataCont.getElementNames();
+
+        String dataName="";
+        for (int i = 0; i < dataNames.length; i++){
+            if (dataNames[i].startsWith("Biblio")) dataName=dataNames[i];
+        }
+
+        try{
+
+            Object oDataBase = xNADataCont.getByName(dataName);
+            XDataSource xDataSource = UnoRuntime.queryInterface(XDataSource.class, oDataBase);
+
+            return xDataSource.getConnection("","");
+
+        } catch ( NoSuchElementException e){
+            throw new StatusException("Couldn't get registered data base", e);
+        } catch (  WrappedTargetException e){
+            throw new StatusException("Couldn't get registered data base", e);
+        } catch (   SQLException e){
+            throw new StatusException("Couldn't get XConnection from registered data base", e);
+        }
+
+    }
+
+    @Override
+    protected void cleanup(TestParameters Param, PrintWriter log) {
+        log.println("closing connections...");
+        XMultiServiceFactory xMsf = Param.getMSF();
+        DBTools dbt = new DBTools( xMsf );
+
+        if (Param.containsKey("uniqueSuffix")){
+            int uniqueSuffix = Param.getInt("uniqueSuffix");
+            uniqueSuffix--;
+            String databaseName =  "";
+            while (uniqueSuffix >= 0){
+
+                databaseName = "NewDatabaseSource" + uniqueSuffix ;
+
+                log.println("revoke '"+databaseName+"'");
+
+                try{
+                    dbt.revokeDB(databaseName);
+                } catch (com.sun.star.uno.Exception e){
+                }
+
+                uniqueSuffix--;
+            }
+        }
+
+    }
+
+}
+
+