diff options
Diffstat (limited to 'qadevOOo/tests/java/mod/_dbaccess/JoinViewAccessibility.java')
| -rw-r--r-- | qadevOOo/tests/java/mod/_dbaccess/JoinViewAccessibility.java | 254 |
1 files changed, 254 insertions, 0 deletions
diff --git a/qadevOOo/tests/java/mod/_dbaccess/JoinViewAccessibility.java b/qadevOOo/tests/java/mod/_dbaccess/JoinViewAccessibility.java new file mode 100644 index 000000000..499779ebf --- /dev/null +++ b/qadevOOo/tests/java/mod/_dbaccess/JoinViewAccessibility.java @@ -0,0 +1,254 @@ +/* + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (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.apache.org/licenses/LICENSE-2.0 . + */ +package mod._dbaccess; + +import java.io.PrintWriter; + +import lib.Status; +import lib.StatusException; +import lib.TestCase; +import lib.TestEnvironment; +import lib.TestParameters; +import util.AccessibilityTools; + +import com.sun.star.accessibility.AccessibleRole; +import com.sun.star.accessibility.XAccessible; +import com.sun.star.awt.PosSize; +import com.sun.star.awt.Rectangle; +import com.sun.star.awt.XWindow; +import com.sun.star.beans.PropertyValue; +import com.sun.star.beans.XPropertySet; +import com.sun.star.container.XNameAccess; +import com.sun.star.container.XNameContainer; +import com.sun.star.frame.XModel; +import com.sun.star.frame.XStorable; +import com.sun.star.lang.XComponent; +import com.sun.star.lang.XMultiServiceFactory; +import com.sun.star.sdb.XDocumentDataSource; +import com.sun.star.sdb.XQueryDefinitionsSupplier; +import com.sun.star.sdbc.XConnection; +import com.sun.star.sdbc.XIsolatedConnection; +import com.sun.star.sdbc.XStatement; +import com.sun.star.ucb.XSimpleFileAccess; +import com.sun.star.uno.UnoRuntime; +import com.sun.star.uno.XInterface; +import util.DesktopTools; +import util.utils; + + +/** +* Object implements the following interfaces : +* <ul> +* <li><code>::com::sun::star::accessibility::XAccessible</code></li> +* <li><code>::com::sun::star::accessibility::XAccessibleContext +* </code></li> +* <li><code>::com::sun::star::accessibility::XAccessibleEventBroadcaster +* </code></li> +* </ul><p> +* @see com.sun.star.accessibility.XAccessible +* @see com.sun.star.accessibility.XAccessibleContext +* @see com.sun.star.accessibility.XAccessibleEventBroadcaster +* @see ifc.accessibility._XAccessible +* @see ifc.accessibility._XAccessibleContext +* @see ifc.accessibility._XAccessibleEventBroadcaster +*/ +public class JoinViewAccessibility extends TestCase { + XWindow xWindow = null; + String aFile = ""; + XIsolatedConnection isolConnection = null; + XComponent QueryComponent = null; + String user = ""; + String password=""; + + /** + * Creates a new DataSource and stores it. + * Creates a connection and using it + * creates two tables in database. + * Creates a new query and adds it to DefinitionContainer. + * Opens the QueryComponent.with loadComponentFromURL + * and gets the object with the role UNKNOWN and the implementation + * name that contains ConnectionLine + * @param Param test parameters + * @param log writer to log information while testing + * @return + * @throws StatusException + * @see TestEnvironment + */ + @Override + protected TestEnvironment createTestEnvironment (TestParameters Param, + PrintWriter log) throws Exception + { + XInterface oObj = null; + + Param.getMSF().createInstance("com.sun.star.sdb.DatabaseContext"); + Object oDBSource = Param.getMSF() + .createInstance("com.sun.star.sdb.DataSource"); + Object newQuery = Param.getMSF().createInstance( + "com.sun.star.sdb.QueryDefinition"); + Param.getMSF().createInstance("com.sun.star.awt.Toolkit"); + + String mysqlURL = (String) Param.get ("mysql.url"); + + if (mysqlURL == null) + { + throw new StatusException (Status.failed ( + "Couldn't get 'mysql.url' from ini-file")); + } + + user = (String) Param.get ("jdbc.user"); + password = (String) Param.get ("jdbc.password"); + + if ((user == null) || (password == null)) + { + throw new StatusException (Status.failed ( + "Couldn't get 'jdbc.user' or 'jdbc.password' from ini-file")); + } + + PropertyValue[] info = new PropertyValue[2]; + info[0] = new PropertyValue (); + info[0].Name = "user"; + info[0].Value = user; + info[1] = new PropertyValue (); + info[1].Name = "password"; + info[1].Value = password; + + XPropertySet propSetDBSource = UnoRuntime.queryInterface ( + XPropertySet.class, oDBSource); + + propSetDBSource.setPropertyValue ("URL", mysqlURL); + propSetDBSource.setPropertyValue ("Info", info); + + log.println ("writing database file ..."); + XDocumentDataSource xDDS = UnoRuntime.queryInterface(XDocumentDataSource.class, oDBSource); + XStorable store = UnoRuntime.queryInterface(XStorable.class, + xDDS.getDatabaseDocument()); + aFile = utils.getOfficeTemp (Param.getMSF ())+"JoinView.odb"; + log.println ("... filename will be "+aFile); + store.storeAsURL (aFile,new PropertyValue[]{}); + log.println ("... done"); + + isolConnection = UnoRuntime.queryInterface ( + XIsolatedConnection.class, + oDBSource); + + final String tbl_name1 = "tst_table1"; + final String tbl_name2 = "tst_table2"; + final String col_name1 = "id1"; + final String col_name2 = "id2"; + + util.utils.waitForEventIdle(Param.getMSF()); + XConnection connection = isolConnection.getIsolatedConnection (user, password); + XStatement statement = connection.createStatement (); + statement.executeUpdate ("drop table if exists " + tbl_name1); + statement.executeUpdate ("drop table if exists " + tbl_name2); + statement.executeUpdate ("create table " + tbl_name1 + " (" + + col_name1 + " int)"); + statement.executeUpdate ("create table " + tbl_name2 + " (" + + col_name2 + " int)"); + + XQueryDefinitionsSupplier querySuppl = UnoRuntime.queryInterface ( + XQueryDefinitionsSupplier.class, + oDBSource); + + XNameAccess defContainer = querySuppl.getQueryDefinitions (); + + XPropertySet queryProp = UnoRuntime.queryInterface ( + XPropertySet.class, newQuery); + + final String query = "select * from " + tbl_name1 + ", " + + tbl_name2 + " where " + tbl_name1 + "." + + col_name1 + "=" + tbl_name2 + "." + + col_name2; + queryProp.setPropertyValue ("Command", query); + + XNameContainer queryContainer = UnoRuntime.queryInterface ( + XNameContainer.class, + defContainer); + + queryContainer.insertByName ("Query1", newQuery); + store.store (); + connection.close (); + + PropertyValue[] loadProps = new PropertyValue[3]; + loadProps[0] = new PropertyValue (); + loadProps[0].Name = "QueryDesignView"; + loadProps[0].Value = Boolean.TRUE; + + loadProps[1] = new PropertyValue (); + loadProps[1].Name = "CurrentQuery"; + loadProps[1].Value = "Query1"; + + loadProps[2] = new PropertyValue (); + loadProps[2].Name = "DataSource"; + loadProps[2].Value = oDBSource; + + QueryComponent = DesktopTools.loadDoc (Param.getMSF (),".component:DB/QueryDesign",loadProps); + + xWindow = UnoRuntime.queryInterface(XModel.class, QueryComponent). + getCurrentController().getFrame().getContainerWindow(); + + XAccessible xRoot = AccessibilityTools.getAccessibleObject (xWindow); + + AccessibilityTools.printAccessibleTree (log,xRoot, Param.getBool(util.PropertyName.DEBUG_IS_ACTIVE)); + + oObj = AccessibilityTools.getAccessibleObjectForRole(xRoot, AccessibleRole.VIEW_PORT); + + log.println("ImplementationName " + util.utils.getImplName(oObj)); + + log.println("creating TestEnvironment"); + + TestEnvironment tEnv = new TestEnvironment(oObj); + + util.utils.waitForEventIdle(Param.getMSF()); + + final XWindow queryWin = xWindow; + + tEnv.addObjRelation("EventProducer", + new ifc.accessibility._XAccessibleEventBroadcaster.EventProducer() { + public void fireEvent() { + Rectangle rect = queryWin.getPosSize(); + queryWin.setPosSize(rect.X, rect.Y, rect.Height-5, rect.Width-5, PosSize.POSSIZE); + } + }); + + return tEnv; + } // finish method getTestEnvironment + + /** + * Closes the DatasourceAdministration dialog and Query Dialog. + */ + @Override + protected void cleanup(TestParameters Param, PrintWriter log) { + try + { + + log.println ("closing QueryComponent ..."); + DesktopTools.closeDoc (QueryComponent); + log.println ("... done"); + XMultiServiceFactory xMSF = Param.getMSF (); + Object sfa = xMSF.createInstance ("com.sun.star.comp.ucb.SimpleFileAccess"); + XSimpleFileAccess xSFA = UnoRuntime.queryInterface (XSimpleFileAccess.class, sfa); + log.println ("deleting database file"); + xSFA.kill (aFile); + log.println ("Could delete file "+aFile+": "+!xSFA.exists (aFile)); + } catch (Exception e) + { + e.printStackTrace (); + } + } +} |