1ef39d40dSAndrew Rist /************************************************************** 2*084e0718Smseidel * 3ef39d40dSAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4ef39d40dSAndrew Rist * or more contributor license agreements. See the NOTICE file 5ef39d40dSAndrew Rist * distributed with this work for additional information 6ef39d40dSAndrew Rist * regarding copyright ownership. The ASF licenses this file 7ef39d40dSAndrew Rist * to you under the Apache License, Version 2.0 (the 8ef39d40dSAndrew Rist * "License"); you may not use this file except in compliance 9ef39d40dSAndrew Rist * with the License. You may obtain a copy of the License at 10*084e0718Smseidel * 11ef39d40dSAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12*084e0718Smseidel * 13ef39d40dSAndrew Rist * Unless required by applicable law or agreed to in writing, 14ef39d40dSAndrew Rist * software distributed under the License is distributed on an 15ef39d40dSAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16ef39d40dSAndrew Rist * KIND, either express or implied. See the License for the 17ef39d40dSAndrew Rist * specific language governing permissions and limitations 18ef39d40dSAndrew Rist * under the License. 19*084e0718Smseidel * 20ef39d40dSAndrew Rist *************************************************************/ 21ef39d40dSAndrew Rist 22ef39d40dSAndrew Rist 23*084e0718Smseidel 24cdf0e10cSrcweir package mod._dbaccess; 25cdf0e10cSrcweir 26cdf0e10cSrcweir import java.io.PrintWriter; 27cdf0e10cSrcweir 28cdf0e10cSrcweir import lib.StatusException; 29cdf0e10cSrcweir import lib.TestCase; 30cdf0e10cSrcweir import lib.TestEnvironment; 31cdf0e10cSrcweir import lib.TestParameters; 32cdf0e10cSrcweir import util.DesktopTools; 33cdf0e10cSrcweir import util.FormTools; 34cdf0e10cSrcweir import util.SOfficeFactory; 35cdf0e10cSrcweir import util.WriterTools; 36cdf0e10cSrcweir 37cdf0e10cSrcweir import com.sun.star.awt.XControl; 38cdf0e10cSrcweir import com.sun.star.awt.XControlModel; 39cdf0e10cSrcweir import com.sun.star.awt.XWindow; 40cdf0e10cSrcweir import com.sun.star.beans.PropertyValue; 41cdf0e10cSrcweir import com.sun.star.drawing.XControlShape; 42cdf0e10cSrcweir import com.sun.star.drawing.XShape; 43cdf0e10cSrcweir import com.sun.star.frame.XController; 44cdf0e10cSrcweir import com.sun.star.frame.XDesktop; 45cdf0e10cSrcweir import com.sun.star.frame.XDispatch; 46cdf0e10cSrcweir import com.sun.star.frame.XDispatchProvider; 47cdf0e10cSrcweir import com.sun.star.frame.XFrame; 48cdf0e10cSrcweir import com.sun.star.frame.XModel; 49cdf0e10cSrcweir import com.sun.star.lang.XInitialization; 50cdf0e10cSrcweir import com.sun.star.lang.XMultiServiceFactory; 51cdf0e10cSrcweir import com.sun.star.text.XTextDocument; 52cdf0e10cSrcweir import com.sun.star.uno.UnoRuntime; 53cdf0e10cSrcweir import com.sun.star.uno.XInterface; 54cdf0e10cSrcweir import com.sun.star.util.URL; 55cdf0e10cSrcweir import com.sun.star.util.XCloseable; 56cdf0e10cSrcweir import com.sun.star.view.XControlAccess; 57cdf0e10cSrcweir 58cdf0e10cSrcweir 59cdf0e10cSrcweir /** 60cdf0e10cSrcweir * Test for object which is represented by service 61cdf0e10cSrcweir * <code>com.sun.star.sdb.DataSourceBrowser</code>. <p> 62cdf0e10cSrcweir * Object implements the following interfaces : 63cdf0e10cSrcweir * <ul> 64cdf0e10cSrcweir * <li> <code>com::sun::star::container::XChild</code></li> 65cdf0e10cSrcweir * <li> <code>com::sun::star::lang::XInitialization</code></li> 66cdf0e10cSrcweir * <li> <code>com::sun::star::util::XModifyBroadcaster</code></li> 67cdf0e10cSrcweir * <li> <code>com::sun::star::awt::XTabController</code></li> 68cdf0e10cSrcweir * <li> <code>com::sun::star::form::XFormController</code></li> 69cdf0e10cSrcweir * <li> <code>com::sun::star::container::XElementAccess</code></li> 70cdf0e10cSrcweir * <li> <code>com::sun::star::frame::XDispatchProvider</code></li> 71cdf0e10cSrcweir * <li> <code>com::sun::star::container::XEnumerationAccess</code></li> 72cdf0e10cSrcweir * <li> <code>com::sun::star::frame::XController</code></li> 73cdf0e10cSrcweir * <li> <code>com::sun::star::lang::XComponent</code></li> 74cdf0e10cSrcweir * </ul> <p> 75cdf0e10cSrcweir * This object test <b> is NOT </b> designed to be run in several 76*084e0718Smseidel * threads concurrently. 77cdf0e10cSrcweir * 78cdf0e10cSrcweir * @see com.sun.star.container.XChild 79cdf0e10cSrcweir * @see com.sun.star.lang.XInitialization 80cdf0e10cSrcweir * @see com.sun.star.util.XModifyBroadcaster 81cdf0e10cSrcweir * @see com.sun.star.awt.XTabController 82cdf0e10cSrcweir * @see com.sun.star.form.XFormController 83cdf0e10cSrcweir * @see com.sun.star.container.XElementAccess 84cdf0e10cSrcweir * @see com.sun.star.frame.XDispatchProvider 85cdf0e10cSrcweir * @see com.sun.star.container.XEnumerationAccess 86cdf0e10cSrcweir * @see com.sun.star.frame.XController 87cdf0e10cSrcweir * @see com.sun.star.lang.XComponent 88cdf0e10cSrcweir * @see ifc.container._XChild 89cdf0e10cSrcweir * @see ifc.lang._XInitialization 90cdf0e10cSrcweir * @see ifc.util._XModifyBroadcaster 91cdf0e10cSrcweir * @see ifc.awt._XTabController 92cdf0e10cSrcweir * @see ifc.form._XFormController 93cdf0e10cSrcweir * @see ifc.container._XElementAccess 94cdf0e10cSrcweir * @see ifc.frame._XDispatchProvider 95cdf0e10cSrcweir * @see ifc.container._XEnumerationAccess 96cdf0e10cSrcweir * @see ifc.frame._XController 97cdf0e10cSrcweir * @see ifc.lang._XComponent 98cdf0e10cSrcweir */ 99cdf0e10cSrcweir public class ODatasourceBrowser extends TestCase { 100cdf0e10cSrcweir XDesktop the_Desk; 101cdf0e10cSrcweir XTextDocument xTextDoc; 102cdf0e10cSrcweir 103cdf0e10cSrcweir /** 104cdf0e10cSrcweir * Creates the Desktop service (<code>com.sun.star.frame.Desktop</code>). 105cdf0e10cSrcweir */ initialize(TestParameters Param, PrintWriter log)106cdf0e10cSrcweir protected void initialize(TestParameters Param, PrintWriter log) { 107*084e0718Smseidel the_Desk = (XDesktop) UnoRuntime.queryInterface(XDesktop.class, 108cdf0e10cSrcweir DesktopTools.createDesktop( 109cdf0e10cSrcweir (XMultiServiceFactory)Param.getMSF())); 110cdf0e10cSrcweir System.setProperty("hideMe", "false"); 111cdf0e10cSrcweir } 112cdf0e10cSrcweir 113cdf0e10cSrcweir /** 114cdf0e10cSrcweir * Disposes the document, if exists, created in 115cdf0e10cSrcweir * <code>createTestEnvironment</code> method. 116cdf0e10cSrcweir */ cleanup(TestParameters Param, PrintWriter log)117cdf0e10cSrcweir protected void cleanup(TestParameters Param, PrintWriter log) { 118cdf0e10cSrcweir log.println("disposing xTextDoc"); 119cdf0e10cSrcweir System.setProperty("hideMe", "true"); 120cdf0e10cSrcweir 121cdf0e10cSrcweir if (xTextDoc != null) { 122cdf0e10cSrcweir log.println(" disposing xTextDoc "); 123cdf0e10cSrcweir 124cdf0e10cSrcweir try { 125cdf0e10cSrcweir XCloseable closer = (XCloseable) UnoRuntime.queryInterface( 126cdf0e10cSrcweir XCloseable.class, xTextDoc); 127cdf0e10cSrcweir closer.close(true); 128cdf0e10cSrcweir } catch (com.sun.star.util.CloseVetoException e) { 129cdf0e10cSrcweir log.println("couldn't close document"); 130cdf0e10cSrcweir } catch (com.sun.star.lang.DisposedException e) { 131cdf0e10cSrcweir log.println("couldn't close document"); 132cdf0e10cSrcweir } 133cdf0e10cSrcweir } 134cdf0e10cSrcweir } 135cdf0e10cSrcweir 136cdf0e10cSrcweir /** 137cdf0e10cSrcweir * Creating a Testenvironment for the interfaces to be tested. 138cdf0e10cSrcweir * 139cdf0e10cSrcweir * Creates a new text document disposing the old one if it was 140cdf0e10cSrcweir * created. Using <code>Desktop</code> service get the frame 141cdf0e10cSrcweir * of the document and with its help creates 142cdf0e10cSrcweir * <code>DataSourceBrowser</code> dispatching the URL 143cdf0e10cSrcweir * <code>'.component:DB/DataSourceBrowser'</code>. The 144cdf0e10cSrcweir * component for testing is the controller of the 145cdf0e10cSrcweir * <code>Browser</code> and it's got by searching its 146cdf0e10cSrcweir * frame with the help of TextDocument frame, and obtaining 147cdf0e10cSrcweir * the frame's controller. <p> 148cdf0e10cSrcweir * 149cdf0e10cSrcweir * <b>Note</b>: after creating the text document a short 150cdf0e10cSrcweir * pause is needed to give a possibility to a frame to be 151cdf0e10cSrcweir * created for the document. Else 152cdf0e10cSrcweir * <code>Desktop.getCurrentFrame()</code> method can return 153cdf0e10cSrcweir * <code>null</code> value. <p> 154cdf0e10cSrcweir * 155cdf0e10cSrcweir * Object relations created : 156cdf0e10cSrcweir * <ul> 157cdf0e10cSrcweir * <li> <code>'XDispatchProvider.URL'</code> for 158cdf0e10cSrcweir * {@link ifc.frame._XDispatchProvider} </li> 159cdf0e10cSrcweir * <li> <code>'SecondModel'</code> for 160cdf0e10cSrcweir * {@link ifc.frame._XController} : the model of 161cdf0e10cSrcweir * the TextDocument. </li> 162cdf0e10cSrcweir * <li> <code>'otherWindow'</code> for 163cdf0e10cSrcweir * {@link ifc.frame._XController} : the window of 164cdf0e10cSrcweir * the added shape. </li> 165cdf0e10cSrcweir * <li> <code>'SecondController'</code> for 166cdf0e10cSrcweir * {@link ifc.frame._XController} : the controller of 167cdf0e10cSrcweir * the TextDocument. </li> 168cdf0e10cSrcweir * <li> <code>'HasViewData'</code> for 169cdf0e10cSrcweir * {@link ifc.frame._XController} : the 170cdf0e10cSrcweir * <code>DataSourceBrowser</code> has no view data. </li> 171cdf0e10cSrcweir * <li> <code>'XInitialization.args'</code> for 172cdf0e10cSrcweir * {@link ifc.lang._XInitialization} : the arguments for 173cdf0e10cSrcweir * tbe initialization</li> 174cdf0e10cSrcweir * </ul> 175cdf0e10cSrcweir * 176cdf0e10cSrcweir * @see com.sun.star.frame.Desktop 177cdf0e10cSrcweir * @see com.sun.star.frame.XModel 178cdf0e10cSrcweir * @see com.sun.star.frame.XFrame 179cdf0e10cSrcweir * @see com.sun.star.frame.XController 180cdf0e10cSrcweir * @see com.sun.star.frame.XDispatchProvider 181cdf0e10cSrcweir */ createTestEnvironment(TestParameters Param, PrintWriter log)182*084e0718Smseidel protected synchronized TestEnvironment createTestEnvironment(TestParameters Param, 183cdf0e10cSrcweir PrintWriter log) { 184cdf0e10cSrcweir log.println("creating a test environment"); 185cdf0e10cSrcweir 186cdf0e10cSrcweir if (xTextDoc != null) { 187cdf0e10cSrcweir log.println(" disposing xTextDoc "); 188cdf0e10cSrcweir 189cdf0e10cSrcweir try { 190cdf0e10cSrcweir XCloseable closer = (XCloseable) UnoRuntime.queryInterface( 191cdf0e10cSrcweir XCloseable.class, xTextDoc); 192cdf0e10cSrcweir closer.close(true); 193cdf0e10cSrcweir } catch (com.sun.star.util.CloseVetoException e) { 194cdf0e10cSrcweir log.println("couldn't close document"); 195cdf0e10cSrcweir } catch (com.sun.star.lang.DisposedException e) { 196cdf0e10cSrcweir log.println("couldn't close document"); 197cdf0e10cSrcweir } 198cdf0e10cSrcweir } 199cdf0e10cSrcweir 200cdf0e10cSrcweir // get a soffice factory object 201cdf0e10cSrcweir SOfficeFactory SOF = SOfficeFactory.getFactory(((XMultiServiceFactory) Param.getMSF())); 202cdf0e10cSrcweir 203cdf0e10cSrcweir try { 204cdf0e10cSrcweir log.println("creating a text document"); 205cdf0e10cSrcweir xTextDoc = SOF.createTextDoc(null); 206cdf0e10cSrcweir } catch (com.sun.star.uno.Exception e) { 207*084e0718Smseidel // Some exception occurred.FAILED 208cdf0e10cSrcweir e.printStackTrace(log); 209cdf0e10cSrcweir throw new StatusException("Couldn't create document", e); 210cdf0e10cSrcweir } 211cdf0e10cSrcweir 212cdf0e10cSrcweir shortWait(); 213cdf0e10cSrcweir 214*084e0718Smseidel XModel aModel1 = (XModel) UnoRuntime.queryInterface(XModel.class, 215cdf0e10cSrcweir xTextDoc); 216cdf0e10cSrcweir 217cdf0e10cSrcweir XController secondController = aModel1.getCurrentController(); 218cdf0e10cSrcweir 219cdf0e10cSrcweir XFrame the_frame1 = the_Desk.getCurrentFrame(); 220cdf0e10cSrcweir 221cdf0e10cSrcweir if (the_frame1 == null) { 222cdf0e10cSrcweir log.println("Current frame was not found !!!"); 223cdf0e10cSrcweir } 224cdf0e10cSrcweir 225cdf0e10cSrcweir XDispatchProvider aProv = (XDispatchProvider) UnoRuntime.queryInterface( 226cdf0e10cSrcweir XDispatchProvider.class, the_frame1); 227cdf0e10cSrcweir 228cdf0e10cSrcweir XDispatch getting = null; 229cdf0e10cSrcweir 230cdf0e10cSrcweir log.println("opening DatasourceBrowser"); 231cdf0e10cSrcweir 232cdf0e10cSrcweir URL the_url = new URL(); 233cdf0e10cSrcweir the_url.Complete = ".component:DB/DataSourceBrowser"; 234cdf0e10cSrcweir getting = aProv.queryDispatch(the_url, "_beamer", 12); 235cdf0e10cSrcweir 236cdf0e10cSrcweir PropertyValue[] noArgs = new PropertyValue[0]; 237cdf0e10cSrcweir getting.dispatch(the_url, noArgs); 238cdf0e10cSrcweir 239cdf0e10cSrcweir XFrame the_frame2 = the_frame1.findFrame("_beamer", 4); 240cdf0e10cSrcweir 241cdf0e10cSrcweir the_frame2.setName("DatasourceBrowser"); 242cdf0e10cSrcweir 243cdf0e10cSrcweir XInterface oObj = the_frame2.getController(); 244cdf0e10cSrcweir 245cdf0e10cSrcweir Object[] params = new Object[3]; 246cdf0e10cSrcweir PropertyValue param1 = new PropertyValue(); 247cdf0e10cSrcweir param1.Name = "DataSourceName"; 248cdf0e10cSrcweir param1.Value = "Bibliography"; 249cdf0e10cSrcweir params[0] = param1; 250cdf0e10cSrcweir 251cdf0e10cSrcweir PropertyValue param2 = new PropertyValue(); 252cdf0e10cSrcweir param2.Name = "CommandType"; 253cdf0e10cSrcweir param2.Value = new Integer(com.sun.star.sdb.CommandType.TABLE); 254cdf0e10cSrcweir params[1] = param2; 255cdf0e10cSrcweir 256cdf0e10cSrcweir PropertyValue param3 = new PropertyValue(); 257cdf0e10cSrcweir param3.Name = "Command"; 258cdf0e10cSrcweir param3.Value = "biblio"; 259cdf0e10cSrcweir params[2] = param3; 260cdf0e10cSrcweir 261cdf0e10cSrcweir try { 262cdf0e10cSrcweir XInitialization xInit = (XInitialization) UnoRuntime.queryInterface( 263cdf0e10cSrcweir XInitialization.class, oObj); 264cdf0e10cSrcweir xInit.initialize(params); 265cdf0e10cSrcweir } catch (com.sun.star.uno.Exception e) { 266*084e0718Smseidel // Some exception occurred.FAILED 267cdf0e10cSrcweir e.printStackTrace(log); 268cdf0e10cSrcweir throw new StatusException("Couldn't initialize document", e); 269cdf0e10cSrcweir } 270cdf0e10cSrcweir 271cdf0e10cSrcweir shortWait(); 272cdf0e10cSrcweir 273*084e0718Smseidel XControlShape aShape = FormTools.createControlShape(xTextDoc, 3000, 274*084e0718Smseidel 4500, 15000, 10000, 275cdf0e10cSrcweir "CommandButton"); 276cdf0e10cSrcweir WriterTools.getDrawPage(xTextDoc).add((XShape) aShape); 277cdf0e10cSrcweir 278cdf0e10cSrcweir XControlModel shapeModel = aShape.getControl(); 279cdf0e10cSrcweir 280cdf0e10cSrcweir XControlAccess xCtrlAccess = (XControlAccess) UnoRuntime.queryInterface( 281*084e0718Smseidel XControlAccess.class, 282cdf0e10cSrcweir secondController); 283cdf0e10cSrcweir XControl xCtrl = null; 284cdf0e10cSrcweir 285cdf0e10cSrcweir try { 286cdf0e10cSrcweir xCtrl = xCtrlAccess.getControl(shapeModel); 287cdf0e10cSrcweir } catch (com.sun.star.uno.Exception e) { 288*084e0718Smseidel // Some exception occurred.FAILED 289cdf0e10cSrcweir e.printStackTrace(log); 290cdf0e10cSrcweir } 291cdf0e10cSrcweir 292*084e0718Smseidel XWindow docWindow = (XWindow) UnoRuntime.queryInterface(XWindow.class, 293cdf0e10cSrcweir xCtrl); 294cdf0e10cSrcweir log.println("creating a new environment for ODatasourceBrowser object"); 295cdf0e10cSrcweir 296cdf0e10cSrcweir TestEnvironment tEnv = new TestEnvironment(oObj); 297cdf0e10cSrcweir 298cdf0e10cSrcweir 299cdf0e10cSrcweir //Adding ObjRelations for XInitialization 300cdf0e10cSrcweir tEnv.addObjRelation("XInitialization.args", params); 301cdf0e10cSrcweir 302cdf0e10cSrcweir 303cdf0e10cSrcweir //Adding ObjRelations for XController 304cdf0e10cSrcweir tEnv.addObjRelation("Frame", the_frame1); 305cdf0e10cSrcweir tEnv.addObjRelation("SecondModel", aModel1); 306cdf0e10cSrcweir tEnv.addObjRelation("otherWindow", docWindow); 307cdf0e10cSrcweir tEnv.addObjRelation("SecondController", secondController); 308cdf0e10cSrcweir tEnv.addObjRelation("HasViewData", new Boolean(false)); 309cdf0e10cSrcweir 310cdf0e10cSrcweir 311*084e0718Smseidel // Adding relation for XDispatchProvider 312*084e0718Smseidel tEnv.addObjRelation("XDispatchProvider.URL", 313cdf0e10cSrcweir ".uno:DataSourceBrowser/FormLetter"); 314cdf0e10cSrcweir 315cdf0e10cSrcweir return tEnv; 316cdf0e10cSrcweir } // finish method getTestEnvironment 317cdf0e10cSrcweir 318cdf0e10cSrcweir /** 319*084e0718Smseidel * Sleeps for 0.2 sec. to allow OpenOffice to react on <code> 320cdf0e10cSrcweir * reset</code> call. 321cdf0e10cSrcweir */ shortWait()322cdf0e10cSrcweir private void shortWait() { 323cdf0e10cSrcweir try { 324cdf0e10cSrcweir Thread.sleep(5000); 325cdf0e10cSrcweir } catch (InterruptedException e) { 326cdf0e10cSrcweir System.out.println("While waiting :" + e); 327cdf0e10cSrcweir } 328cdf0e10cSrcweir } 329cdf0e10cSrcweir } // finish class oDatasourceBrowser 330*084e0718Smseidel 331