| /************************************************************** |
| * |
| * 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 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| * |
| *************************************************************/ |
| |
| |
| 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.accessibility.XAccessibleComponent; |
| import com.sun.star.awt.Point; |
| 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 java.awt.Robot; |
| import java.awt.event.InputEvent; |
| 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 TableWindowAccessibility extends TestCase { |
| XWindow xWindow = null; |
| Object oDBSource = null; |
| String aFile = ""; |
| XConnection connection = null; |
| 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 PANEL and the implementation |
| * name that contains TabelViewAccessibility |
| * @param Param test parameters |
| * @param log writer to log information while testing |
| * @return |
| * @throws StatusException |
| * @see TestEnvironment |
| */ |
| protected TestEnvironment createTestEnvironment(TestParameters Param, |
| PrintWriter log) { |
| XInterface oObj = null; |
| |
| Object oDBContext = null; |
| Object oDBSource = null; |
| Object newQuery = null; |
| Object toolkit = null; |
| XStorable store = null; |
| |
| try { |
| oDBContext = ((XMultiServiceFactory) Param.getMSF()) |
| .createInstance("com.sun.star.sdb.DatabaseContext"); |
| oDBSource = ((XMultiServiceFactory) Param.getMSF()) |
| .createInstance("com.sun.star.sdb.DataSource"); |
| newQuery = ((XMultiServiceFactory) Param.getMSF()) |
| .createInstance("com.sun.star.sdb.QueryDefinition"); |
| toolkit = ((XMultiServiceFactory) Param.getMSF()) |
| .createInstance("com.sun.star.awt.Toolkit"); |
| } catch (com.sun.star.uno.Exception e) { |
| e.printStackTrace(log); |
| throw new StatusException(Status.failed("Couldn't create instance")); |
| } |
| |
| 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 = (XPropertySet) UnoRuntime.queryInterface( |
| XPropertySet.class, oDBSource); |
| |
| try { |
| propSetDBSource.setPropertyValue("URL", mysqlURL); |
| propSetDBSource.setPropertyValue("Info", info); |
| } catch (com.sun.star.lang.WrappedTargetException e) { |
| e.printStackTrace(log); |
| throw new StatusException(Status.failed( |
| "Couldn't set property value")); |
| } catch (com.sun.star.lang.IllegalArgumentException e) { |
| e.printStackTrace(log); |
| throw new StatusException(Status.failed( |
| "Couldn't set property value")); |
| } catch (com.sun.star.beans.PropertyVetoException e) { |
| e.printStackTrace(log); |
| throw new StatusException(Status.failed( |
| "Couldn't set property value")); |
| } catch (com.sun.star.beans.UnknownPropertyException e) { |
| e.printStackTrace(log); |
| throw new StatusException(Status.failed( |
| "Couldn't set property value")); |
| } |
| |
| try { |
| log.println ("writing database file ..."); |
| XDocumentDataSource xDDS = (XDocumentDataSource) |
| UnoRuntime.queryInterface(XDocumentDataSource.class, oDBSource); |
| store = (XStorable) UnoRuntime.queryInterface(XStorable.class, |
| xDDS.getDatabaseDocument()); |
| aFile = utils.getOfficeTemp ((XMultiServiceFactory) Param.getMSF ())+"TableWindow.odb"; |
| log.println("... filename will be "+aFile); |
| store.storeAsURL(aFile,new PropertyValue[]{}); |
| log.println("... done"); |
| } catch (com.sun.star.uno.Exception e) { |
| e.printStackTrace(log); |
| throw new StatusException(Status.failed("Couldn't register object")); |
| } |
| |
| isolConnection = (XIsolatedConnection) UnoRuntime.queryInterface( |
| XIsolatedConnection.class, |
| oDBSource); |
| |
| XConnection connection = null; |
| XStatement statement = null; |
| |
| final String tbl_name1 = "tst_table1"; |
| final String tbl_name2 = "tst_table2"; |
| final String col_name1 = "id1"; |
| final String col_name2 = "id2"; |
| |
| try { |
| connection = isolConnection.getIsolatedConnection(user, password); |
| 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)"); |
| } catch (com.sun.star.sdbc.SQLException e) { |
| try { |
| shortWait(); |
| connection = isolConnection.getIsolatedConnection(user, |
| password); |
| 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)"); |
| } catch (com.sun.star.sdbc.SQLException e2) { |
| e2.printStackTrace(log); |
| throw new StatusException(Status.failed("SQLException")); |
| } |
| } |
| |
| XQueryDefinitionsSupplier querySuppl = (XQueryDefinitionsSupplier) UnoRuntime.queryInterface( |
| XQueryDefinitionsSupplier.class, |
| oDBSource); |
| |
| XNameAccess defContainer = querySuppl.getQueryDefinitions(); |
| |
| XPropertySet queryProp = (XPropertySet) UnoRuntime.queryInterface( |
| XPropertySet.class, newQuery); |
| |
| try { |
| final String query = "select * from " + tbl_name1 + ", " + |
| tbl_name2 + " where " + tbl_name1 + "." + |
| col_name1 + "=" + tbl_name2 + "." + |
| col_name2; |
| queryProp.setPropertyValue("Command", query); |
| } catch (com.sun.star.lang.WrappedTargetException e) { |
| e.printStackTrace(log); |
| throw new StatusException(Status.failed( |
| "Couldn't set property value")); |
| } catch (com.sun.star.lang.IllegalArgumentException e) { |
| e.printStackTrace(log); |
| throw new StatusException(Status.failed( |
| "Couldn't set property value")); |
| } catch (com.sun.star.beans.PropertyVetoException e) { |
| e.printStackTrace(log); |
| throw new StatusException(Status.failed( |
| "Couldn't set property value")); |
| } catch (com.sun.star.beans.UnknownPropertyException e) { |
| e.printStackTrace(log); |
| throw new StatusException(Status.failed( |
| "Couldn't set property value")); |
| } |
| |
| XNameContainer queryContainer = (XNameContainer) UnoRuntime.queryInterface( |
| XNameContainer.class, |
| defContainer); |
| |
| try { |
| queryContainer.insertByName("Query1", newQuery); |
| store.store(); |
| connection.close (); |
| } catch (com.sun.star.lang.WrappedTargetException e) { |
| e.printStackTrace(log); |
| throw new StatusException(Status.failed("Couldn't insert query")); |
| } catch (com.sun.star.container.ElementExistException e) { |
| e.printStackTrace(log); |
| throw new StatusException(Status.failed("Couldn't insert query")); |
| } catch (com.sun.star.lang.IllegalArgumentException e) { |
| e.printStackTrace(log); |
| throw new StatusException(Status.failed("Couldn't insert query")); |
| } catch (com.sun.star.io.IOException e) { |
| e.printStackTrace(log); |
| throw new StatusException(Status.failed("Couldn't insert query")); |
| } catch (com.sun.star.sdbc.SQLException e) { |
| e.printStackTrace(log); |
| throw new StatusException(Status.failed("Couldn't insert query")); |
| } |
| |
| 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((XMultiServiceFactory) 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.PANEL, "", |
| "TableWindowAccessibility"); |
| |
| log.println("ImplementationName " + util.utils.getImplName(oObj)); |
| |
| log.println("creating TestEnvironment ... done"); |
| |
| TestEnvironment tEnv = new TestEnvironment(oObj); |
| |
| shortWait(); |
| |
| XAccessibleComponent accComp = (XAccessibleComponent) UnoRuntime.queryInterface( |
| XAccessibleComponent.class, |
| oObj); |
| |
| |
| final Point point = accComp.getLocationOnScreen(); |
| |
| tEnv.addObjRelation("EventProducer", |
| new ifc.accessibility._XAccessibleEventBroadcaster.EventProducer() { |
| public void fireEvent() { |
| try { |
| Robot rob = new Robot(); |
| rob.mouseMove(point.X + 2, point.Y + 7); |
| rob.mousePress(InputEvent.BUTTON1_MASK); |
| rob.mouseMove(point.X + 400, point.Y); |
| rob.mouseRelease (InputEvent.BUTTON1_MASK); |
| } catch (java.awt.AWTException e) { |
| System.out.println("desired child doesn't exist"); |
| } |
| } |
| }); |
| |
| return tEnv; |
| } // finish method getTestEnvironment |
| |
| /** |
| * Closes all open documents. |
| */ |
| protected void cleanup(TestParameters Param, PrintWriter log) { |
| try |
| { |
| |
| log.println ("closing QueryComponent ..."); |
| DesktopTools.closeDoc (QueryComponent); |
| log.println ("... done"); |
| XMultiServiceFactory xMSF = (XMultiServiceFactory)Param.getMSF (); |
| Object sfa = xMSF.createInstance ("com.sun.star.comp.ucb.SimpleFileAccess"); |
| XSimpleFileAccess xSFA = (XSimpleFileAccess) 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 (); |
| } |
| } |
| |
| |
| /** |
| * Sleeps for 1.5 sec. to allow StarOffice to react on <code> |
| * reset</code> call. |
| */ |
| private void shortWait() { |
| try { |
| Thread.sleep(1500); |
| } catch (InterruptedException e) { |
| log.println("While waiting :" + e); |
| } |
| } |
| } |
