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     protected TestEnvironment createTestEnvironment (TestParameters Param,
  95     PrintWriter log)
  96     {
  97         XInterface oObj = null;
  98
  99         Object oDBSource = null;
 100         Object newQuery = null;
 101         XStorable store = null;
 102
 103         try
 104         {
 105             ((XMultiServiceFactory) Param.getMSF ())
 106             .createInstance ("com.sun.star.sdb.DatabaseContext");
 107             oDBSource = ((XMultiServiceFactory) Param.getMSF ())
 108             .createInstance ("com.sun.star.sdb.DataSource");
 109             newQuery = ((XMultiServiceFactory) Param.getMSF ())
 110             .createInstance ("com.sun.star.sdb.QueryDefinition");
 111             ((XMultiServiceFactory) Param.getMSF ())
 112             .createInstance ("com.sun.star.awt.Toolkit");
 113         } catch (com.sun.star.uno.Exception e)
 114         {
 115             e.printStackTrace (log);
 116             throw new StatusException (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             e.printStackTrace (log);
 154             throw new StatusException (Status.failed (
 155             "Couldn't set property value"));
 156         } catch (com.sun.star.lang.IllegalArgumentException e)
 157         {
 158             e.printStackTrace (log);
 159             throw new StatusException (Status.failed (
 160             "Couldn't set property value"));
 161         } catch (com.sun.star.beans.PropertyVetoException e)
 162         {
 163             e.printStackTrace (log);
 164             throw new StatusException (Status.failed (
 165             "Couldn't set property value"));
 166         } catch (com.sun.star.beans.UnknownPropertyException e)
 167         {
 168             e.printStackTrace (log);
 169             throw new StatusException (Status.failed (
 170             "Couldn't set property value"));
 171         }
 172
 173         try
 174         {
 175             log.println ("writing database file ...");
 176             XDocumentDataSource xDDS = UnoRuntime.queryInterface(XDocumentDataSource.class, oDBSource);
 177             store = UnoRuntime.queryInterface(XStorable.class,
 178                     xDDS.getDatabaseDocument());
 179             aFile = utils.getOfficeTemp ((XMultiServiceFactory) Param.getMSF ())+"JoinView.odb";
 180             log.println ("... filename will be "+aFile);
 181             store.storeAsURL (aFile,new PropertyValue[]
 182             {});
 183             log.println ("... done");
 184         } catch (com.sun.star.uno.Exception e)
 185         {
 186             e.printStackTrace (log);
 187             throw new StatusException (Status.failed ("Couldn't register object"));
 188         }
 189
 190         isolConnection = UnoRuntime.queryInterface (
 191         XIsolatedConnection.class,
 192         oDBSource);
 193
 194         XConnection connection = null;
 195         XStatement statement = null;
 196
 197         final String tbl_name1 = "tst_table1";
 198         final String tbl_name2 = "tst_table2";
 199         final String col_name1 = "id1";
 200         final String col_name2 = "id2";
 201
 202         try
 203         {
 204             connection = isolConnection.getIsolatedConnection (user, password);
 205             statement = connection.createStatement ();
 206             statement.executeUpdate ("drop table if exists " + tbl_name1);
 207             statement.executeUpdate ("drop table if exists " + tbl_name2);
 208             statement.executeUpdate ("create table " + tbl_name1 + " (" +
 209             col_name1 + " int)");
 210             statement.executeUpdate ("create table " + tbl_name2 + " (" +
 211             col_name2 + " int)");
 212         } catch (com.sun.star.sdbc.SQLException e)
 213         {
 214             try
 215             {
 216                 shortWait ();
 217                 connection = isolConnection.getIsolatedConnection (user,
 218                 password);
 219                 statement = connection.createStatement ();
 220                 statement.executeUpdate ("drop table if exists " + tbl_name1);
 221                 statement.executeUpdate ("drop table if exists " + tbl_name2);
 222                 statement.executeUpdate ("create table " + tbl_name1 + " (" +
 223                 col_name1 + " int)");
 224                 statement.executeUpdate ("create table " + tbl_name2 + " (" +
 225                 col_name2 + " int)");
 226             } catch (com.sun.star.sdbc.SQLException e2)
 227             {
 228                 e2.printStackTrace (log);
 229                 throw new StatusException (Status.failed ("SQLException"));
 230             }
 231         }
 232
 233         XQueryDefinitionsSupplier querySuppl = UnoRuntime.queryInterface (
 234         XQueryDefinitionsSupplier.class,
 235         oDBSource);
 236
 237         XNameAccess defContainer = querySuppl.getQueryDefinitions ();
 238
 239         XPropertySet queryProp = UnoRuntime.queryInterface (
 240         XPropertySet.class, newQuery);
 241
 242         try
 243         {
 244             final String query = "select * from " + tbl_name1 + ", " +
 245             tbl_name2 + " where " + tbl_name1 + "." +
 246             col_name1 + "=" + tbl_name2 + "." +
 247             col_name2;
 248             queryProp.setPropertyValue ("Command", query);
 249         } catch (com.sun.star.lang.WrappedTargetException e)
 250         {
 251             e.printStackTrace (log);
 252             throw new StatusException (Status.failed (
 253             "Couldn't set property value"));
 254         } catch (com.sun.star.lang.IllegalArgumentException e)
 255         {
 256             e.printStackTrace (log);
 257             throw new StatusException (Status.failed (
 258             "Couldn't set property value"));
 259         } catch (com.sun.star.beans.PropertyVetoException e)
 260         {
 261             e.printStackTrace (log);
 262             throw new StatusException (Status.failed (
 263             "Couldn't set property value"));
 264         } catch (com.sun.star.beans.UnknownPropertyException e)
 265         {
 266             e.printStackTrace (log);
 267             throw new StatusException (Status.failed (
 268             "Couldn't set property value"));
 269         }
 270
 271         XNameContainer queryContainer = UnoRuntime.queryInterface (
 272         XNameContainer.class,
 273         defContainer);
 274
 275         try
 276         {
 277             queryContainer.insertByName ("Query1", newQuery);
 278             store.store ();
 279             connection.close ();
 280         } catch (com.sun.star.lang.WrappedTargetException e)
 281         {
 282             e.printStackTrace (log);
 283             throw new StatusException (Status.failed ("Couldn't insert query"));
 284         } catch (com.sun.star.container.ElementExistException e)
 285         {
 286             e.printStackTrace (log);
 287             throw new StatusException (Status.failed ("Couldn't insert query"));
 288         } catch (com.sun.star.lang.IllegalArgumentException e)
 289         {
 290             e.printStackTrace (log);
 291             throw new StatusException (Status.failed ("Couldn't insert query"));
 292         } catch (com.sun.star.io.IOException e)
 293         {
 294             e.printStackTrace (log);
 295             throw new StatusException (Status.failed ("Couldn't insert query"));
 296         } catch (com.sun.star.sdbc.SQLException e)
 297         {
 298             e.printStackTrace (log);
 299             throw new StatusException (Status.failed ("Couldn't insert query"));
 300         }
 301
 302         PropertyValue[] loadProps = new PropertyValue[3];
 303         loadProps[0] = new PropertyValue ();
 304         loadProps[0].Name = "QueryDesignView";
 305         loadProps[0].Value = Boolean.TRUE;
 306
 307         loadProps[1] = new PropertyValue ();
 308         loadProps[1].Name = "CurrentQuery";
 309         loadProps[1].Value = "Query1";
 310
 311         loadProps[2] = new PropertyValue ();
 312         loadProps[2].Name = "DataSource";
 313         loadProps[2].Value = oDBSource;
 314
 315         QueryComponent = DesktopTools.loadDoc ((XMultiServiceFactory) Param.getMSF (),".component:DB/QueryDesign",loadProps);
 316
 317         xWindow = UnoRuntime.queryInterface(XModel.class, QueryComponent).
 318             getCurrentController().getFrame().getContainerWindow();
 319
 320         XAccessible xRoot = AccessibilityTools.getAccessibleObject (xWindow);
 321
 322         AccessibilityTools.printAccessibleTree (log,xRoot, Param.getBool(util.PropertyName.DEBUG_IS_ACTIVE));
 323
 324         oObj = AccessibilityTools.getAccessibleObjectForRole(xRoot, AccessibleRole.VIEW_PORT);
 325
 326         log.println("ImplementationName " + util.utils.getImplName(oObj));
 327
 328         log.println("creating TestEnvironment");
 329
 330         TestEnvironment tEnv = new TestEnvironment(oObj);
 331
 332         shortWait();
 333
 334         final XWindow queryWin = xWindow;
 335
 336         tEnv.addObjRelation("EventProducer",
 337                             new ifc.accessibility._XAccessibleEventBroadcaster.EventProducer() {
 338             public void fireEvent() {
 339                 Rectangle rect = queryWin.getPosSize();
 340                 queryWin.setPosSize(rect.X, rect.Y, rect.Height-5, rect.Width-5, PosSize.POSSIZE);
 341             }
 342         });
 343
 344         return tEnv;
 345     } // finish method getTestEnvironment
 346
 347     /**
 348      * Closes the DatasourceAdministration dialog and Query Dialog.
 349      */
 350     protected void cleanup(TestParameters Param, PrintWriter log) {
 351         try
 352         {
 353
 354             log.println ("closing QueryComponent ...");
 355             DesktopTools.closeDoc (QueryComponent);
 356             log.println ("... done");
 357             XMultiServiceFactory xMSF = (XMultiServiceFactory)Param.getMSF ();
 358             Object sfa = xMSF.createInstance ("com.sun.star.comp.ucb.SimpleFileAccess");
 359             XSimpleFileAccess xSFA = UnoRuntime.queryInterface (XSimpleFileAccess.class, sfa);
 360             log.println ("deleting database file");
 361             xSFA.kill (aFile);
 362             log.println ("Could delete file "+aFile+": "+!xSFA.exists (aFile));
 363         } catch (Exception e)
 364         {
 365             e.printStackTrace ();
 366         }
 367     }
 368
 369     /**
 370     * Sleeps for 1.5 sec. to allow StarOffice to react on <code>
 371     * reset</code> call.
 372     */
 373     private void shortWait() {
 374         try {
 375             Thread.sleep(1500);
 376         } catch (InterruptedException e) {
 377             log.println("While waiting :" + e);
 378         }
 379     }
 380 }