qadevOOo/tests/java/mod/_dbaccess/OQueryDesign.java

   1 /*
   2  * This file is part of the LibreOffice project.
   3  *
   4  * This Source Code Form is subject to the terms of the Mozilla Public
   5  * License, v. 2.0. If a copy of the MPL was not distributed with this
   6  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   7  *
   8  * This file incorporates work covered by the following license notice:
   9  *
  10  *   Licensed to the Apache Software Foundation (ASF) under one or more
  11  *   contributor license agreements. See the NOTICE file distributed
  12  *   with this work for additional information regarding copyright
  13  *   ownership. The ASF licenses this file to you under the Apache
  14  *   License, Version 2.0 (the "License"); you may not use this file
  15  *   except in compliance with the License. You may obtain a copy of
  16  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  17  */
  18 package mod._dbaccess;
  19
  20 import com.sun.star.sdbc.XConnection;
  21 import com.sun.star.uno.Exception;
  22 import java.io.PrintWriter;
  23
  24 import lib.Status;
  25 import lib.StatusException;
  26 import lib.TestCase;
  27 import lib.TestEnvironment;
  28 import lib.TestParameters;
  29 import util.DesktopTools;
  30
  31 import com.sun.star.beans.PropertyValue;
  32 import com.sun.star.container.XNameAccess;
  33 import com.sun.star.frame.XController;
  34 import com.sun.star.frame.XDesktop;
  35 import com.sun.star.frame.XDispatch;
  36 import com.sun.star.frame.XDispatchProvider;
  37 import com.sun.star.frame.XFrame;
  38 import com.sun.star.frame.XModel;
  39 import com.sun.star.lang.XInitialization;
  40 import com.sun.star.lang.XMultiServiceFactory;
  41 import com.sun.star.text.XTextDocument;
  42 import com.sun.star.uno.UnoRuntime;
  43 import com.sun.star.uno.XInterface;
  44 import com.sun.star.util.URL;
  45 import util.SOfficeFactory;
  46 import com.sun.star.sdb.XDocumentDataSource;
  47 import com.sun.star.sdbc.XDataSource;
  48
  49 public class OQueryDesign extends TestCase {
  50
  51     private static XDesktop xDesk;
  52     private static XFrame xFrame;
  53     private static final String sDataSourceName = "Bibliography";
  54     private static XConnection xConn;
  55     private static XTextDocument xTextDoc;
  56
  57
  58     /**
  59      * Creates the Desktop service (<code>com.sun.star.frame.Desktop</code>).
  60      */
  61     @Override
  62     protected void initialize(TestParameters Param, PrintWriter log) throws Exception {
  63         xDesk = DesktopTools.createDesktop(Param.getMSF());
  64     }
  65
  66     @Override
  67     protected TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) throws Exception {
  68
  69         log.println( "creating a test environment" );
  70
  71         XDispatchProvider aProv = UnoRuntime.queryInterface(XDispatchProvider.class,xDesk);
  72         XMultiServiceFactory xMSF = Param.getMSF();
  73
  74         // we use the first datasource
  75         XNameAccess xNameAccess = UnoRuntime.queryInterface(
  76                     XNameAccess.class,
  77                     xMSF.createInstance("com.sun.star.sdb.DatabaseContext"));
  78         XDataSource xDS = UnoRuntime.queryInterface(
  79                 XDataSource.class, xNameAccess.getByName( "Bibliography" ));
  80
  81         log.println("check XMultiServiceFactory");
  82
  83         xConn = xDS.getConnection("", "");
  84
  85         log.println( "opening QueryDesign" );
  86         URL the_url = new URL();
  87         the_url.Complete = ".component:DB/QueryDesign";
  88         XDispatch getting = aProv.queryDispatch(the_url,"Query",12);
  89         PropertyValue[] Args = new PropertyValue[2];
  90         PropertyValue param1 = new PropertyValue();
  91         param1.Name = "DataSourceName";
  92         param1.Value = "Bibliography";
  93         Args[0] = param1;
  94         PropertyValue param2 = new PropertyValue();
  95         param2.Name = "QueryDesignView";
  96         param2.Value = Boolean.FALSE;
  97         Args[1] = param2;
  98         param1.Name = "ActiveConnection";
  99         param1.Value = xConn;
 100         Args[1] = param2;
 101         getting.dispatch(the_url,Args);
 102
 103         util.utils.waitForEventIdle(Param.getMSF());
 104
 105         Object oDBC = xMSF.createInstance( "com.sun.star.sdb.DatabaseContext" );
 106
 107         Object oDataSource = null;
 108         XNameAccess xNA = UnoRuntime.queryInterface(XNameAccess.class, oDBC);
 109         oDataSource = xNA.getByName(sDataSourceName);
 110         UnoRuntime.queryInterface(XDocumentDataSource.class, oDataSource);
 111
 112         xFrame = DesktopTools.getCurrentFrame(xMSF);
 113
 114         SOfficeFactory SOF = null;
 115
 116         SOF = SOfficeFactory.getFactory( xMSF );
 117         log.println( "creating a textdocument" );
 118         xTextDoc = SOF.createTextDoc( null );
 119
 120         XModel xDocMod = UnoRuntime.queryInterface(XModel.class, xTextDoc);
 121
 122         XFrame xTextFrame  = xDocMod.getCurrentController().getFrame();
 123
 124         Object[] params = new Object[3];
 125         param1 = new PropertyValue();
 126         param1.Name = "DataSourceName";
 127         param1.Value = "Bibliography";
 128         params[0] = param1;
 129         param2 = new PropertyValue();
 130         param2.Name = "Frame";
 131         param2.Value = xTextFrame;
 132         params[1] = param2;
 133         PropertyValue param3 = new PropertyValue();
 134         param3.Name = "QueryDesignView";
 135         param3.Value = Boolean.TRUE;
 136         params[2] = param3;
 137
 138
 139         XInterface oObj = xFrame.getController();
 140
 141         TestEnvironment tEnv = new TestEnvironment(oObj);
 142
 143         //Adding ObjRelations for XInitialization
 144         tEnv.addObjRelation("XInitialization.args", params);
 145
 146         Object[] ExceptionParams = new Object[3];
 147         PropertyValue ExceptionParam1 = new PropertyValue();
 148         ExceptionParam1.Name = "DataSourceName";
 149         ExceptionParam1.Value = "Bibliography2";
 150         ExceptionParams[0] = ExceptionParam1;
 151         PropertyValue ExceptionParam2 = new PropertyValue();
 152         ExceptionParam2.Name = "Frame";
 153         ExceptionParam2.Value = null;
 154         ExceptionParams[1] = ExceptionParam2;
 155         PropertyValue ExceptionParam3 = new PropertyValue();
 156         ExceptionParam3.Name = "QueryDesignView";
 157         ExceptionParam3.Value = Integer.valueOf(17);//Boolean.TRUE;
 158         ExceptionParams[2] = ExceptionParam3;
 159
 160         tEnv.addObjRelation("XInitialization.ExceptionArgs", ExceptionParams);
 161
 162         tEnv.addObjRelation("Frame", xFrame);
 163
 164         tEnv.addObjRelation("XInitialization.xIni", getUninitializedObj(Param));
 165
 166         log.println("ImplementationName: "+util.utils.getImplName(oObj));
 167
 168         return tEnv;
 169
 170     } // finish method getTestEnvironment
 171
 172     private XInitialization getUninitializedObj(TestParameters Param) throws Exception {
 173         // creating an object which ist not initialized
 174
 175         // get a model of a DataSource
 176         Object oDBC = null;
 177         XMultiServiceFactory xMSF;
 178
 179         xMSF = Param.getMSF();
 180         oDBC = xMSF.createInstance( "com.sun.star.sdb.DatabaseContext" );
 181
 182         Object oDataSource = null;
 183         XNameAccess xNA = UnoRuntime.queryInterface(XNameAccess.class, oDBC);
 184         oDataSource = xNA.getByName(sDataSourceName);
 185
 186         XDocumentDataSource xDDS = UnoRuntime.queryInterface(XDocumentDataSource.class, oDataSource);
 187         XModel xMod = UnoRuntime.queryInterface(XModel.class, xDDS.getDatabaseDocument ());
 188
 189         // get an instance of QueryDesign
 190         Object oQueryDesign = xMSF.createInstance("com.sun.star.sdb.QueryDesign");
 191
 192         XController xCont = UnoRuntime.queryInterface(XController.class, oQueryDesign);
 193
 194         // marry them all
 195         boolean bSuccess = xCont.attachModel(xMod);
 196         if (!bSuccess)
 197         {
 198             throw new StatusException (Status.failed (
 199             "Couldn't attach model"));
 200         }
 201
 202         xMod.connectController(xCont);
 203         xMod.setCurrentController(xCont);
 204
 205         return UnoRuntime.queryInterface(XInitialization.class, oQueryDesign);
 206     }
 207
 208     @Override
 209     protected void cleanup(TestParameters tParam, PrintWriter log) {
 210         try {
 211             xConn.close() ;
 212             DesktopTools.closeDoc(xFrame);
 213             DesktopTools.closeDoc(xTextDoc);
 214         } catch (com.sun.star.uno.Exception e) {
 215             log.println("Can't close the connection") ;
 216             e.printStackTrace(log) ;
 217         } catch (com.sun.star.lang.DisposedException e) {
 218             log.println("Connection was already closed. It's OK.") ;
 219         }
 220
 221     }
 222
 223 }    // finish class oDatasourceBrowser
 224