qadevOOo/tests/java/mod/_dbaccess/JoinViewAccessibility.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 java.io.PrintWriter;
  21
  22 import lib.Status;
  23 import lib.StatusException;
  24 import lib.TestCase;
  25 import lib.TestEnvironment;
  26 import lib.TestParameters;
  27 import util.AccessibilityTools;
  28
  29 import com.sun.star.accessibility.AccessibleRole;
  30 import com.sun.star.accessibility.XAccessible;
  31 import com.sun.star.awt.PosSize;
  32 import com.sun.star.awt.Rectangle;
  33 import com.sun.star.awt.XWindow;
  34 import com.sun.star.beans.PropertyValue;
  35 import com.sun.star.beans.XPropertySet;
  36 import com.sun.star.container.XNameAccess;
  37 import com.sun.star.container.XNameContainer;
  38 import com.sun.star.frame.XModel;
  39 import com.sun.star.frame.XStorable;
  40 import com.sun.star.lang.XComponent;
  41 import com.sun.star.lang.XMultiServiceFactory;
  42 import com.sun.star.sdb.XDocumentDataSource;
  43 import com.sun.star.sdb.XQueryDefinitionsSupplier;
  44 import com.sun.star.sdbc.XConnection;
  45 import com.sun.star.sdbc.XIsolatedConnection;
  46 import com.sun.star.sdbc.XStatement;
  47 import com.sun.star.ucb.XSimpleFileAccess;
  48 import com.sun.star.uno.UnoRuntime;
  49 import com.sun.star.uno.XInterface;
  50 import util.DesktopTools;
  51 import util.utils;
  52
  53
  54 /**
  55 * Object implements the following interfaces :
  56 * <ul>
  57 *   <li><code>::com::sun::star::accessibility::XAccessible</code></li>
  58 *   <li><code>::com::sun::star::accessibility::XAccessibleContext
  59 *   </code></li>
  60 *   <li><code>::com::sun::star::accessibility::XAccessibleEventBroadcaster
  61 *   </code></li>
  62 * </ul><p>
  63 * @see com.sun.star.accessibility.XAccessible
  64 * @see com.sun.star.accessibility.XAccessibleContext
  65 * @see com.sun.star.accessibility.XAccessibleEventBroadcaster
  66 * @see ifc.accessibility._XAccessible
  67 * @see ifc.accessibility._XAccessibleContext
  68 * @see ifc.accessibility._XAccessibleEventBroadcaster
  69 */
  70 public class JoinViewAccessibility extends TestCase {
  71     XWindow xWindow = null;
  72     Object oDBSource = null;
  73     String aFile = "";
  74     XConnection connection = null;
  75     XIsolatedConnection isolConnection = null;
  76     XComponent QueryComponent = null;
  77     String user = "";
  78     String password="";
  79
  80     /**
  81      * Creates a new DataSource and stores it.
  82      * Creates a connection and using it
  83      * creates two tables in database.
  84      * Creates a new query and adds it to DefinitionContainer.
  85      * Opens the QueryComponent.with loadComponentFromURL
  86      * and gets the object with the role UNKNOWN and the Impplementation
  87      * name that contains ConnectionLine
  88      * @param Param test parameters
  89      * @param log writer to log information while testing
  90      * @return
  91      * @throws StatusException
  92      * @see TestEnvironment
  93      */
  94     @Override
  95     protected TestEnvironment createTestEnvironment (TestParameters Param,
  96     PrintWriter log)
  97     {
  98         XInterface oObj = null;
  99
 100         Object oDBSource = null;
 101         Object newQuery = null;
 102         XStorable store = null;
 103
 104         try
 105         {
 106             Param.getMSF ()
 107             .createInstance ("com.sun.star.sdb.DatabaseContext");
 108             oDBSource = Param.getMSF ()
 109             .createInstance ("com.sun.star.sdb.DataSource");
 110             newQuery = Param.getMSF ()
 111             .createInstance ("com.sun.star.sdb.QueryDefinition");
 112             Param.getMSF ()
 113             .createInstance ("com.sun.star.awt.Toolkit");
 114         } catch (com.sun.star.uno.Exception e)
 115         {
 116             throw new StatusException(e, Status.failed ("Couldn't create instance"));
 117         }
 118
 119         String mysqlURL = (String) Param.get ("mysql.url");
 120
 121         if (mysqlURL == null)
 122         {
 123             throw new StatusException (Status.failed (
 124             "Couldn't get 'mysql.url' from ini-file"));
 125         }
 126
 127         user = (String) Param.get ("jdbc.user");
 128         password = (String) Param.get ("jdbc.password");
 129
 130         if ((user == null) || (password == null))
 131         {
 132             throw new StatusException (Status.failed (
 133             "Couldn't get 'jdbc.user' or 'jdbc.password' from ini-file"));
 134         }
 135
 136         PropertyValue[] info = new PropertyValue[2];
 137         info[0] = new PropertyValue ();
 138         info[0].Name = "user";
 139         info[0].Value = user;
 140         info[1] = new PropertyValue ();
 141         info[1].Name = "password";
 142         info[1].Value = password;
 143
 144         XPropertySet propSetDBSource = UnoRuntime.queryInterface (
 145         XPropertySet.class, oDBSource);
 146
 147         try
 148         {
 149             propSetDBSource.setPropertyValue ("URL", mysqlURL);
 150             propSetDBSource.setPropertyValue ("Info", info);
 151         } catch (com.sun.star.lang.WrappedTargetException e)
 152         {
 153             throw new StatusException(e, Status.failed("Couldn't set property value"));
 154         } catch (com.sun.star.lang.IllegalArgumentException e)
 155         {
 156             throw new StatusException(e, Status.failed("Couldn't set property value"));
 157         } catch (com.sun.star.beans.PropertyVetoException e)
 158         {
 159             throw new StatusException(e, Status.failed("Couldn't set property value"));
 160         } catch (com.sun.star.beans.UnknownPropertyException e)
 161         {
 162             throw new StatusException(e, Status.failed("Couldn't set property value"));
 163         }
 164
 165         try
 166         {
 167             log.println ("writing database file ...");
 168             XDocumentDataSource xDDS = UnoRuntime.queryInterface(XDocumentDataSource.class, oDBSource);
 169             store = UnoRuntime.queryInterface(XStorable.class,
 170                     xDDS.getDatabaseDocument());
 171             aFile = utils.getOfficeTemp (Param.getMSF ())+"JoinView.odb";
 172             log.println ("... filename will be "+aFile);
 173             store.storeAsURL (aFile,new PropertyValue[]
 174             {});
 175             log.println ("... done");
 176         } catch (com.sun.star.uno.Exception e)
 177         {
 178             throw new StatusException(e, Status.failed ("Couldn't register object"));
 179         }
 180
 181         isolConnection = UnoRuntime.queryInterface (
 182         XIsolatedConnection.class,
 183         oDBSource);
 184
 185         XConnection connection = null;
 186         XStatement statement = null;
 187
 188         final String tbl_name1 = "tst_table1";
 189         final String tbl_name2 = "tst_table2";
 190         final String col_name1 = "id1";
 191         final String col_name2 = "id2";
 192
 193         try
 194         {
 195             connection = isolConnection.getIsolatedConnection (user, password);
 196             statement = connection.createStatement ();
 197             statement.executeUpdate ("drop table if exists " + tbl_name1);
 198             statement.executeUpdate ("drop table if exists " + tbl_name2);
 199             statement.executeUpdate ("create table " + tbl_name1 + " (" +
 200             col_name1 + " int)");
 201             statement.executeUpdate ("create table " + tbl_name2 + " (" +
 202             col_name2 + " int)");
 203         } catch (com.sun.star.sdbc.SQLException e)
 204         {
 205             try
 206             {
 207                 util.utils.pause(1500);
 208                 connection = isolConnection.getIsolatedConnection (user,
 209                 password);
 210                 statement = connection.createStatement ();
 211                 statement.executeUpdate ("drop table if exists " + tbl_name1);
 212                 statement.executeUpdate ("drop table if exists " + tbl_name2);
 213                 statement.executeUpdate ("create table " + tbl_name1 + " (" +
 214                 col_name1 + " int)");
 215                 statement.executeUpdate ("create table " + tbl_name2 + " (" +
 216                 col_name2 + " int)");
 217             } catch (com.sun.star.sdbc.SQLException e2)
 218             {
 219                 throw new StatusException(e, Status.failed ("SQLException"));
 220             }
 221         }
 222
 223         XQueryDefinitionsSupplier querySuppl = UnoRuntime.queryInterface (
 224         XQueryDefinitionsSupplier.class,
 225         oDBSource);
 226
 227         XNameAccess defContainer = querySuppl.getQueryDefinitions ();
 228
 229         XPropertySet queryProp = UnoRuntime.queryInterface (
 230         XPropertySet.class, newQuery);
 231
 232         try
 233         {
 234             final String query = "select * from " + tbl_name1 + ", " +
 235             tbl_name2 + " where " + tbl_name1 + "." +
 236             col_name1 + "=" + tbl_name2 + "." +
 237             col_name2;
 238             queryProp.setPropertyValue ("Command", query);
 239         } catch (com.sun.star.lang.WrappedTargetException e)
 240         {
 241             throw new StatusException(e, Status.failed("Couldn't set property value"));
 242         } catch (com.sun.star.lang.IllegalArgumentException e)
 243         {
 244             throw new StatusException(e, Status.failed("Couldn't set property value"));
 245         } catch (com.sun.star.beans.PropertyVetoException e)
 246         {
 247             throw new StatusException(e, Status.failed("Couldn't set property value"));
 248         } catch (com.sun.star.beans.UnknownPropertyException e)
 249         {
 250             throw new StatusException(e, Status.failed("Couldn't set property value"));
 251         }
 252
 253         XNameContainer queryContainer = UnoRuntime.queryInterface (
 254         XNameContainer.class,
 255         defContainer);
 256
 257         try
 258         {
 259             queryContainer.insertByName ("Query1", newQuery);
 260             store.store ();
 261             connection.close ();
 262         } catch (com.sun.star.lang.WrappedTargetException e)
 263         {
 264             throw new StatusException(e, Status.failed ("Couldn't insert query"));
 265         } catch (com.sun.star.container.ElementExistException e)
 266         {
 267             throw new StatusException(e, Status.failed ("Couldn't insert query"));
 268         } catch (com.sun.star.lang.IllegalArgumentException e)
 269         {
 270             throw new StatusException(e, Status.failed ("Couldn't insert query"));
 271         } catch (com.sun.star.io.IOException e)
 272         {
 273             throw new StatusException(e, Status.failed ("Couldn't insert query"));
 274         } catch (com.sun.star.sdbc.SQLException e)
 275         {
 276             throw new StatusException(e, Status.failed ("Couldn't insert query"));
 277         }
 278
 279         PropertyValue[] loadProps = new PropertyValue[3];
 280         loadProps[0] = new PropertyValue ();
 281         loadProps[0].Name = "QueryDesignView";
 282         loadProps[0].Value = Boolean.TRUE;
 283
 284         loadProps[1] = new PropertyValue ();
 285         loadProps[1].Name = "CurrentQuery";
 286         loadProps[1].Value = "Query1";
 287
 288         loadProps[2] = new PropertyValue ();
 289         loadProps[2].Name = "DataSource";
 290         loadProps[2].Value = oDBSource;
 291
 292         QueryComponent = DesktopTools.loadDoc (Param.getMSF (),".component:DB/QueryDesign",loadProps);
 293
 294         xWindow = UnoRuntime.queryInterface(XModel.class, QueryComponent).
 295             getCurrentController().getFrame().getContainerWindow();
 296
 297         XAccessible xRoot = AccessibilityTools.getAccessibleObject (xWindow);
 298
 299         AccessibilityTools.printAccessibleTree (log,xRoot, Param.getBool(util.PropertyName.DEBUG_IS_ACTIVE));
 300
 301         oObj = AccessibilityTools.getAccessibleObjectForRole(xRoot, AccessibleRole.VIEW_PORT);
 302
 303         log.println("ImplementationName " + util.utils.getImplName(oObj));
 304
 305         log.println("creating TestEnvironment");
 306
 307         TestEnvironment tEnv = new TestEnvironment(oObj);
 308
 309         util.utils.pause(1500);
 310
 311         final XWindow queryWin = xWindow;
 312
 313         tEnv.addObjRelation("EventProducer",
 314                             new ifc.accessibility._XAccessibleEventBroadcaster.EventProducer() {
 315             public void fireEvent() {
 316                 Rectangle rect = queryWin.getPosSize();
 317                 queryWin.setPosSize(rect.X, rect.Y, rect.Height-5, rect.Width-5, PosSize.POSSIZE);
 318             }
 319         });
 320
 321         return tEnv;
 322     } // finish method getTestEnvironment
 323
 324     /**
 325      * Closes the DatasourceAdministration dialog and Query Dialog.
 326      */
 327     @Override
 328     protected void cleanup(TestParameters Param, PrintWriter log) {
 329         try
 330         {
 331
 332             log.println ("closing QueryComponent ...");
 333             DesktopTools.closeDoc (QueryComponent);
 334             log.println ("... done");
 335             XMultiServiceFactory xMSF = Param.getMSF ();
 336             Object sfa = xMSF.createInstance ("com.sun.star.comp.ucb.SimpleFileAccess");
 337             XSimpleFileAccess xSFA = UnoRuntime.queryInterface (XSimpleFileAccess.class, sfa);
 338             log.println ("deleting database file");
 339             xSFA.kill (aFile);
 340             log.println ("Could delete file "+aFile+": "+!xSFA.exists (aFile));
 341         } catch (Exception e)
 342         {
 343             e.printStackTrace ();
 344         }
 345     }
 346 }