/************************************************************************* * * $RCSfile: SwXMailMerge.java,v $ * * $Revision: 1.5 $ * * last change:$Date: 2003/09/08 12:46:48 $ * * The Contents of this file are made available subject to the terms of * either of the following licenses * * - GNU Lesser General Public License Version 2.1 * - Sun Industry Standards Source License Version 1.1 * * Sun Microsystems Inc., October, 2000 * * GNU Lesser General Public License Version 2.1 * ============================================= * Copyright 2000 by Sun Microsystems, Inc. * 901 San Antonio Road, Palo Alto, CA 94303, USA * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License version 2.1, as published by the Free Software Foundation. * * 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., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * * * Sun Industry Standards Source License Version 1.1 * ================================================= * The contents of this file are subject to the Sun Industry Standards * Source License Version 1.1 (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.openoffice.org/license.html. * * Software provided under this License is provided on an "AS IS" basis, * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. * See the License for the specific provisions governing your rights and * obligations concerning the Software. * * The Initial Developer of the Original Code is: Sun Microsystems, Inc. * * Copyright: 2000 by Sun Microsystems, Inc. * * All Rights Reserved. * * Contributor(s): _______________________________________ * * ************************************************************************/ package mod._sw; import java.io.PrintWriter; import lib.StatusException; import lib.TestCase; import lib.TestEnvironment; import lib.TestParameters; import util.utils; import com.sun.star.beans.NamedValue; import com.sun.star.beans.XPropertySet; import com.sun.star.container.XNameAccess; import com.sun.star.lang.XMultiServiceFactory; import com.sun.star.sdbc.XConnection; import com.sun.star.sdbc.XDataSource; import com.sun.star.sdbc.XResultSet; import com.sun.star.sdbc.XRowSet; import com.sun.star.sdbcx.XRowLocate; import com.sun.star.task.XJob; import com.sun.star.uno.UnoRuntime; import com.sun.star.uno.XInterface; /** * Here com.sun.star.text.MailMerge service is tested.

* @see com.sun.star.text.MailMerge * @see com.sun.star.task.XJob * @see com.sun.star.text.XMailMergeBroadcaster */ public class SwXMailMerge extends TestCase { public void initialize( TestParameters tParam, PrintWriter log ) { } /** * Creating a Testenvironment for the interfaces to be tested.

* Creates MailMerge service * Object relations created : *

*/ protected synchronized TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) { XInterface oObj = null; XInterface oRowSet = null; Object oConnection = null; XConnection oXConnection = null; XJob Job = null; try { oObj = (XInterface) ( (XMultiServiceFactory) Param.getMSF()).createInstance ("com.sun.star.text.MailMerge"); } catch (com.sun.star.uno.Exception e) { throw new StatusException("Can't create object environment", e) ; } if (oObj == null) System.out.println("mist"); // String cTestDoc = utils.getFullTestURL("MailMerge.sxw"); //cMailMerge_DocumentURL = cTestDoc String cOutputURL = utils.getOfficeTemp( (XMultiServiceFactory) Param.getMSF()); String cDataSourceName = "Bibliography"; String cDataCommand = "biblio"; Object[] sel = new Object[2]; sel[0] = new int[2]; sel[1] = new int[5]; Object[] myBookMarks = new Object[2]; // // try { oRowSet = (XInterface) ( (XMultiServiceFactory) Param.getMSF()).createInstance ("com.sun.star.sdb.RowSet"); } catch (com.sun.star.uno.Exception e) { throw new StatusException("Can't create com.sun.star.sdb.RowSet", e); } XPropertySet oRowSetProps = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, oRowSet); XRowSet xRowSet = (XRowSet) UnoRuntime.queryInterface(XRowSet.class, oRowSet); try { oRowSetProps.setPropertyValue("DataSourceName",cDataSourceName); oRowSetProps.setPropertyValue("Command",cDataCommand); oRowSetProps.setPropertyValue("CommandType", new Integer(com.sun.star.sdb.CommandType.TABLE)); } catch (com.sun.star.beans.UnknownPropertyException e) { throw new StatusException("Can't set properties on oRowSet", e); } catch (com.sun.star.beans.PropertyVetoException e) { throw new StatusException("Can't set properties on oRowSet", e); } catch (com.sun.star.lang.IllegalArgumentException e) { throw new StatusException("Can't set properties on oRowSet", e); } catch (com.sun.star.lang.WrappedTargetException e) { throw new StatusException("Can't set properties on oRowSet", e); } try { xRowSet.execute(); } catch (com.sun.star.sdbc.SQLException e) { throw new StatusException("Can't execute oRowSet", e); } XResultSet oResultSet = (XResultSet) UnoRuntime.queryInterface(XResultSet.class, oRowSet); XInterface oDataCont = null; try { oDataCont = (XInterface)( (XMultiServiceFactory) Param.getMSF()).createInstance ("com.sun.star.sdb.DatabaseContext"); } catch(com.sun.star.uno.Exception e) { throw new StatusException("Couldn't create instance of 'com.sun.star.sdb.DatabaseContext'", e); } XNameAccess xNADataCont = (XNameAccess) UnoRuntime.queryInterface(XNameAccess.class, oDataCont); String[] dataNames = xNADataCont.getElementNames(); try{ Object oDataBase = xNADataCont.getByName(dataNames[0]); XDataSource xDataSource = (XDataSource) UnoRuntime.queryInterface(XDataSource.class, oDataBase); oXConnection = xDataSource.getConnection("",""); } catch ( com.sun.star.container.NoSuchElementException e){ throw new StatusException("Couldn't get registered data base", e); } catch ( com.sun.star.lang.WrappedTargetException e){ throw new StatusException("Couldn't get registered data base", e); } catch ( com.sun.star.sdbc.SQLException e){ throw new StatusException("Couldn't get XConnection from registered data base", e); } // try { // oConnection = oRowSetProps.getPropertyValue("ActiveConnection"); // } catch (com.sun.star.beans.UnknownPropertyException e){ // throw new StatusException("Can't get active connection", e); // } // catch (com.sun.star.lang.WrappedTargetException e) { // throw new StatusException("Can't get active connection", e); // } // oXConnection = (XConnection) // UnoRuntime.queryInterface(XConnection.class, oConnection); // // try { XRowLocate oRowLocate = (XRowLocate) UnoRuntime.queryInterface( XRowLocate.class, oResultSet); oResultSet.first(); myBookMarks[0] = oRowLocate.getBookmark(); oResultSet.next(); myBookMarks[1] = oRowLocate.getBookmark(); } catch (com.sun.star.sdbc.SQLException e) { throw new StatusException("Cant get Bookmarks", e); } // // XPropertySet oObjProps = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, oObj); try { oObjProps.setPropertyValue("ActiveConnection", oXConnection); oObjProps.setPropertyValue("DataSourceName", cDataSourceName); oObjProps.setPropertyValue("Command", cDataCommand); oObjProps.setPropertyValue("CommandType", new Integer(com.sun.star.sdb.CommandType.TABLE)); oObjProps.setPropertyValue("OutputType", new Short(com.sun.star.text.MailMergeType.FILE)); oObjProps.setPropertyValue("DocumentURL", cTestDoc); oObjProps.setPropertyValue("OutputURL", cOutputURL); oObjProps.setPropertyValue("FileNamePrefix", "Author"); oObjProps.setPropertyValue("FileNameFromColumn", new Boolean(false)); oObjProps.setPropertyValue("Selection", new Object[0]); } catch (com.sun.star.beans.UnknownPropertyException e) { throw new StatusException("Can't set properties on oObj", e); } catch (com.sun.star.beans.PropertyVetoException e) { throw new StatusException("Can't set properties on oObj", e); } catch (com.sun.star.lang.IllegalArgumentException e) { throw new StatusException("Can't set properties on oObj", e); } catch (com.sun.star.lang.WrappedTargetException e) { throw new StatusException("Can't set properties on oObj", e); } // // 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", new Integer(com.sun.star.sdb.CommandType.TABLE)); vXJobArg0[3] = new NamedValue("OutputType", new Short(com.sun.star.text.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", new Boolean(true)); // vXJobArg0[8] = new NamedValue("Selection", sel); //second Arguments vXJobArg1[0] = new NamedValue("DataSourceName", cDataSourceName); vXJobArg1[1] = new NamedValue("Command", cDataCommand); vXJobArg1[2] = new NamedValue("CommandType", new Integer(com.sun.star.sdb.CommandType.TABLE)); vXJobArg1[3] = new NamedValue("OutputType", new Short(com.sun.star.text.MailMergeType.PRINTER)); vXJobArg1[4] = new NamedValue("DocumentURL", cTestDoc); vXJobArg1[5] = new NamedValue("FileNamePrefix", "Author"); vXJobArg1[6] = new NamedValue("FileNameFromColumn", new Boolean(true)); // vXJobArg1[7] = new NamedValue("Selection", sel); // third Arguments vXJobArg2[0] = new NamedValue("ActiveConnection", oXConnection); vXJobArg2[1] = new NamedValue("DataSourceName", cDataSourceName); vXJobArg2[2] = new NamedValue("Command", cDataCommand); vXJobArg2[3] = new NamedValue("CommandType", new Integer(com.sun.star.sdb.CommandType.TABLE)); vXJobArg2[4] = new NamedValue("OutputType", new Short(com.sun.star.text.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", new Boolean(true)); vXJobArg2[9] = new NamedValue("Selection", myBookMarks); // vXJobArg2[9] = new NamedValue("Selection", sel); vXJobArgs[0] = vXJobArg0; vXJobArgs[1] = vXJobArg1; vXJobArgs[2] = vXJobArg2; vXJobArgs[3] = vXJobArg3; Job = (XJob) UnoRuntime.queryInterface(XJob.class, oObj); try{ Job.execute(vXJobArg2); } catch ( com.sun.star.lang.IllegalArgumentException e){ System.out.println(e.toString()); } catch ( com.sun.star.uno.Exception e){ System.out.println(e.toString()); } // try { oRowSet = (XInterface) ( (XMultiServiceFactory) Param.getMSF()).createInstance ("com.sun.star.sdb.RowSet"); } catch (com.sun.star.uno.Exception e) { throw new StatusException("Can't create com.sun.star.sdb.RowSet", e); } oRowSetProps = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, oRowSet); xRowSet = (XRowSet) UnoRuntime.queryInterface(XRowSet.class, oRowSet); try { oRowSetProps.setPropertyValue("DataSourceName",cDataSourceName); oRowSetProps.setPropertyValue("Command",cDataCommand); oRowSetProps.setPropertyValue("CommandType", new Integer(com.sun.star.sdb.CommandType.TABLE)); } catch (com.sun.star.beans.UnknownPropertyException e) { throw new StatusException("Can't set properties on oRowSet", e); } catch (com.sun.star.beans.PropertyVetoException e) { throw new StatusException("Can't set properties on oRowSet", e); } catch (com.sun.star.lang.IllegalArgumentException e) { throw new StatusException("Can't set properties on oRowSet", e); } catch (com.sun.star.lang.WrappedTargetException e) { throw new StatusException("Can't set properties on oRowSet", e); } try { xRowSet.execute(); } catch (com.sun.star.sdbc.SQLException e) { throw new StatusException("Can't execute oRowSet", e); } oResultSet = (XResultSet) UnoRuntime.queryInterface(XResultSet.class, oRowSet); // // try { // oConnection = oRowSetProps.getPropertyValue("ActiveConnection"); // } catch (com.sun.star.beans.UnknownPropertyException e){ // throw new StatusException("Can't get active connection", e); // } // catch (com.sun.star.lang.WrappedTargetException e) { // throw new StatusException("Can't get active connection", e); // } // oXConnection = (XConnection) // UnoRuntime.queryInterface(XConnection.class, oConnection); TestEnvironment tEnv = new TestEnvironment(oObj) ; // // com.sun.star.sdb.DataAccessDescriptor System.out.println("is void: "+utils.isVoid(oXConnection)); tEnv.addObjRelation("XResultSet", oResultSet); tEnv.addObjRelation("XConnection", oXConnection); // com.sun.star.text.XMailMergeBroadcaster tEnv.addObjRelation( "executeArgs", vXJobArg0); tEnv.addObjRelation( "Job", Job); // com.sun.star.task.XJob tEnv.addObjRelation("XJobArgs", vXJobArgs); // // adding connection string as relation // tEnv.addObjRelation("XAcceptor.connectStr", // "socket,host=" + sOfficeHost + ",port=" + curPort) ; // adding port number for freeing it. //tEnv.addObjRelation("Acceptor.Port", new Integer(curPort)) ; return tEnv ; } }