Beispiel #1
0
  /**
   * Creates an instance of the service <code>com.sun.star.sdbc.Driver</code>.
   *
   * <p>Object relations created :
   *
   * <ul>
   *   <li><code>'XDriver.URL'</code> for {@link ifc.sdbc._XDriver}: is the URL of the database to
   *       which to connect. The URL is obtained from the parameter <code>mozab.url</code>
   *   <li><code>'XDriver.UNSUITABLE_URL'</code> for {@link ifc.sdbc._XDriver}: the wrong kind of
   *       URL to connect using given driver. The URL is obtained from the parameter <code>jdbc.url
   *       </code>
   *   <li><code>'XDriver.INFO'</code> for {@link ifc.sdbc._XDriver}: a list of arbitrary string
   *       tag/value pairs as connection arguments.
   * </ul>
   */
  @Override
  protected TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log)
      throws Exception {

    XInterface oObj =
        (XInterface) Param.getMSF().createInstance("com.sun.star.comp.sdbc.MozabDriver");

    log.println("creating a new environment for object");
    TestEnvironment tEnv = new TestEnvironment(oObj);

    // adding relation for sdbc.XDriver
    String mozabURL = (String) Param.get("mozab.url");
    if (mozabURL == null) {
      throw new StatusException(Status.failed("Couldn't get 'mozabURL' from ini-file"));
    }
    tEnv.addObjRelation("XDriver.URL", "sdbc:address:" + mozabURL);

    PropertyValue[] info = new PropertyValue[0];
    tEnv.addObjRelation("XDriver.INFO", info);

    String jdbcUrl = (String) Param.get("jdbc.url");
    if (jdbcUrl == null) {
      throw new StatusException(Status.failed("Couldn't get 'jdbc.url' from ini-file"));
    }
    tEnv.addObjRelation("XDriver.UNSUITABLE_URL", "jdbc:" + jdbcUrl);

    return tEnv;
  }
  /**
   * Creating a Testenvironment for the interfaces to be tested. Creates an instance of the service
   * <code>com.sun.star.sheet.RecentFunctions</code> and an instance of the service <code>
   * com.sun.star.sheet.FunctionDescriptions</code>. Object relations created :
   *
   * <ul>
   *   <li><code>'FUNCTIONLIST'</code> for {@link ifc.sheet._XRecentFunctions}(the second created
   *       instance)
   * </ul>
   */
  public synchronized TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log)
      throws StatusException {

    XInterface oObj = null;
    XInterface allFunctions = null;

    // creation of testobject here
    // first we write what we are intend to do to log file
    log.println("Creating a test environment");

    try {
      log.println("Getting test object ");
      XMultiServiceFactory oDocMSF = (XMultiServiceFactory) Param.getMSF();
      oObj = (XInterface) oDocMSF.createInstance("com.sun.star.sheet.RecentFunctions");
      allFunctions = (XInterface) oDocMSF.createInstance("com.sun.star.sheet.FunctionDescriptions");

      log.println("Creating object - " + ((oObj == null) ? "FAILED" : "OK"));
    } catch (com.sun.star.uno.Exception e) {
      e.printStackTrace(log);
      throw new StatusException("Couldn't create instance", e);
    }

    TestEnvironment tEnv = new TestEnvironment(oObj);

    // Other parameters required for interface tests
    XNameAccess NA = UnoRuntime.queryInterface(XNameAccess.class, allFunctions);
    tEnv.addObjRelation("FUNCTIONLIST", NA);

    return tEnv;
  }
  /**
   * Creating a TestEnvironment for the interfaces to be tested. Creates an instance of the service
   * <code>com.sun.star.frame.ContentHandlerFactory</code>.
   *
   * <p>
   */
  @Override
  protected TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log)
      throws Exception {
    XInterface oObj = null;
    Object oInterface = null;

    // now get the OButtonControl
    oInterface = Param.getMSF().createInstance("com.sun.star.frame.ContentHandlerFactory");

    oObj = (XInterface) oInterface;
    log.println("ImplName: " + utils.getImplName(oObj));

    log.println("creating a new environment for object");
    TestEnvironment tEnv = new TestEnvironment(oObj);

    XNameAccess xNA = UnoRuntime.queryInterface(XNameAccess.class, oObj);
    tEnv.addObjRelation("XMSF.serviceNames", xNA.getElementNames());
    xNA.getElementNames();

    // com.sun.star.container.XContainerQuery
    NamedValue[] querySequenze = new NamedValue[1];
    NamedValue query = new NamedValue();
    query.Name = "Name";
    query.Value = "com.sun.star.comp.framework.SoundHandler";
    querySequenze[0] = query;

    tEnv.addObjRelation("XContainerQuery.createSubSetEnumerationByProperties", querySequenze);

    return tEnv;
  } // finish method getTestEnvironment
Beispiel #4
0
  @Override
  protected void initialize(TestParameters Param, PrintWriter log) throws Exception {
    SOfficeFactory SOF = SOfficeFactory.getFactory(Param.getMSF());

    log.println("creating a textdocument");
    xTextDoc = SOF.createTextDoc(null);

    log.println("maximize the window size");
    XModel xModel = UnoRuntime.queryInterface(XModel.class, xTextDoc);
    XFrame xFrame = xModel.getCurrentController().getFrame();
    XWindow xWin = xFrame.getContainerWindow();

    Toolkit.getDefaultToolkit();
    Dimension dim = new Dimension(800, 600);

    Rectangle newPosSize = xWin.getPosSize();
    newPosSize.Width = new Double(dim.getWidth()).intValue();
    newPosSize.Height = new Double(dim.getHeight()).intValue();
    newPosSize.X = 0;
    newPosSize.Y = 0;

    xWin.setPosSize(
        newPosSize.X,
        newPosSize.Y,
        newPosSize.Width,
        newPosSize.Height,
        com.sun.star.awt.PosSize.POSSIZE);
  }
  /**
   * Creating a Testenvironment for the interfaces to be tested. Creates an instance of the service
   * <code>com.sun.star.ucprmt.ContentProvider</code>.
   *
   * <p>Object relations created :
   *
   * <ul>
   *   <li><code>'FACTORY'</code> for {@link ifc.ucb._XContentProvider} factory for content
   *       identifiers. Here it is <code>UniversalContentBroker</code> service.
   *   <li><code>'CONTENT1'</code> for {@link ifc.ucb._XContentProvider}: suitable content URL for
   *       this provider
   *   <li><code>'CONTENT2'</code> for {@link ifc.ucb._XContentProvider}: another suitable content
   *       URL for this provider
   * </ul>
   */
  public TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) {
    XInterface oObj = null;
    XMultiServiceFactory xMSF = (XMultiServiceFactory) Param.getMSF();
    XContentIdentifierFactory cntIDFac = null;

    try {
      oObj = (XInterface) xMSF.createInstance("com.sun.star.ucb.RemoteAccessContentProvider");
      cntIDFac = UnoRuntime.queryInterface(XContentIdentifierFactory.class, oObj);
    } catch (com.sun.star.uno.Exception e) {
      log.println("Can't create an object.");
      throw new StatusException("Can't create an object", e);
    }

    if (oObj == null) {
      log.println("!!! Object wasn't created !!!");
      throw new StatusException(Status.failed("!!! Object wasn't created !!!"));
    }

    TestEnvironment tEnv = new TestEnvironment(oObj);

    // adding relation for XContentProvider
    tEnv.addObjRelation("FACTORY", cntIDFac);
    tEnv.addObjRelation("CONTENT1", "vnd.sun.star.wfs:///user/work");
    tEnv.addObjRelation("CONTENT2", "vnd.sun.star.wfs:///user/config");

    return tEnv;
  } // finish method getTestEnvironment
  /**
   * Creating a Testenvironment for the interfaces to be tested. Creates an instance of the service
   * <code>com.sun.star.sdb.DatasourceAdministrationDialog</code>.
   */
  public TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log)
      throws StatusException {
    XInterface oObj = null;
    Object oInterface = null;

    try {
      oInterface =
          ((XMultiServiceFactory) Param.getMSF())
              .createInstance("com.sun.star.sdb.DatasourceAdministrationDialog");
    } catch (com.sun.star.uno.Exception e) {
      log.println("Service not available");
      throw new StatusException("Service not available", e);
    }

    if (oInterface == null) {
      log.println("Service wasn't created");
      throw new StatusException(Status.failed("Service wasn't created"));
    }

    oObj = (XInterface) oInterface;

    log.println("    creating a new environment for object");
    TestEnvironment tEnv = new TestEnvironment(oObj);

    return tEnv;
  } // finish method getTestEnvironment
  /** Creates Spreadsheet document. */
  @Override
  protected void initialize(TestParameters tParam, PrintWriter log) throws Exception {
    SOfficeFactory SOF = SOfficeFactory.getFactory(tParam.getMSF());

    log.println("creating a Spreadsheet document");
    xSheetDoc = SOF.createCalcDoc(null);
  }
Beispiel #8
0
  /** New text document created. */
  @Override
  protected void initialize(TestParameters tParam, PrintWriter log) throws Exception {

    // get a soffice factory object
    SOfficeFactory SOF = SOfficeFactory.getFactory(tParam.getMSF());

    log.println("creating a chartdocument");
    xChartDoc = SOF.createChartDoc();
  }
 /** Creates text document. */
 protected void initialize(TestParameters tParam, PrintWriter log) {
   SOfficeFactory SOF = SOfficeFactory.getFactory((XMultiServiceFactory) tParam.getMSF());
   try {
     log.println("creating a textdocument");
     xTextDoc = SOF.createTextDoc(null);
   } catch (com.sun.star.uno.Exception e) {
     e.printStackTrace(log);
     throw new StatusException("Couldn't create document", e);
   }
 }
  /**
   * Creating a Testenvironment for the interfaces to be tested. Creates an instance of the service
   * <code>com.sun.star.java.JavaVirtualMachine</code>.
   */
  protected TestEnvironment createTestEnvironment(TestParameters tParam, PrintWriter log) {
    XMultiServiceFactory xMSF = (XMultiServiceFactory) tParam.getMSF();

    try {
      XInterface xInt = (XInterface) xMSF.createInstance("com.sun.star.java.JavaVirtualMachine");

      return new TestEnvironment(xInt);
    } catch (com.sun.star.uno.Exception e) {
      e.printStackTrace(log);
      throw new StatusException("Unexpected exception", e);
    }
  }
  /** Creates Spreadsheet document. */
  protected void initialize(TestParameters tParam, PrintWriter log) {
    SOfficeFactory SOF = SOfficeFactory.getFactory(tParam.getMSF());

    try {
      log.println("creating a Spreadsheet document");
      xSpreadsheetDoc = SOF.createCalcDoc(null);
    } catch (com.sun.star.uno.Exception e) {
      // Some exception occurs.FAILED
      e.printStackTrace(log);
      throw new StatusException("Couldn't create document", e);
    }
  }
  /** New spreadsheet document created. */
  protected void initialize(TestParameters tParam, PrintWriter log) {
    SOfficeFactory SOF = SOfficeFactory.getFactory((XMultiServiceFactory) tParam.getMSF());

    try {
      log.println("creating a Spreadsheet document");
      xSheetDoc = SOF.createCalcDoc(null);
      comp = UnoRuntime.queryInterface(XComponent.class, xSheetDoc);
    } catch (com.sun.star.uno.Exception e) {
      // Some exception occurs.FAILED
      e.printStackTrace(log);
      throw new StatusException("Couldn't create document", e);
    }
  }
Beispiel #13
0
  /**
   * Initializes some class fields. Then creates DataSource, which serves as a single source for all
   * tables created in the test. This DataSource then registered in the global <code>DatabaseContext
   * </code> service. This data source's URL points to SOffice temp directory where tables are
   * copied from <code>TestDocuments</code> directory on every environment creation. To create
   * DataSource for MySQL database next parameters required in ini-file:
   *
   * <ul>
   *   <li><code>test.db.url</code> - URL to MySQL database. For example: <code>
   *       mysql://mercury:3306/api_current</code>
   *   <li><code>test.db.user</code> - user for MySQL database
   *   <li><code>test.db.password</code> - password for MySQL database
   * </ul>
   *
   * @throws StatusException if DataSource can not be created or registered.
   */
  protected void initialize(TestParameters Param, PrintWriter _log) throws StatusException {
    m_orb = (XMultiServiceFactory) Param.getMSF();

    String tmpDir = utils.getOfficeTemp(m_orb);

    origDB = util.utils.getFullTestDocName("TestDB/testDB.dbf");

    dbTools = new DBTools(m_orb, _log);

    // creating DataSource and registering it in DatabaseContext
    String dbURL = (String) Param.get("test.db.url");
    String dbUser = (String) Param.get("test.db.user");
    String dbPassword = (String) Param.get("test.db.password");

    log.println("Creating and registering DataSource ...");
    srcInf = new DataSourceDescriptor(m_orb);
    if (dbURL != null && dbUser != null && dbPassword != null) {
      isMySQLDB = true;
      log.println("dbURL = " + dbURL);
      log.println("dbUSER = "******"dbPASSWORD = "******"soffice_test_table";
      srcInf.URL = "jdbc:" + dbURL;
      srcInf.IsPasswordRequired = new Boolean(true);
      srcInf.Password = dbPassword;
      srcInf.User = dbUser;
      PropertyValue[] propInfo = new PropertyValue[1];
      propInfo[0] = new PropertyValue();
      propInfo[0].Name = "JavaDriverClass";
      propInfo[0].Value = "org.gjt.mm.mysql.Driver";
      srcInf.Info = propInfo;
    } else {
      srcInf.URL = "sdbc:dbase:" + DBTools.dirToUrl(tmpDir);
    }
    m_dataSource = srcInf.createDataSource();
    m_dataSource.registerAs(dbSourceName, true);
  }
  /**
   * Creating a Testenvironment for the interfaces to be tested. In case if OS is Win or not
   * specified tries to create an instance of the service <code>com.sun.star.system.SimpleSystemMail
   * </code>.
   *
   * <p>Object relations created :
   *
   * <ul>
   *   <li><code>'SystemMailExist'</code> for {@link ifc.system._XSimpleMailClientSupplier} : the
   *       value depends on tested platform and <code>test.system.mail.isExist</code> INI parameter.
   * </ul>
   */
  public TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log)
      throws StatusException {
    XInterface oObj = null;
    Object oInterface = null;
    boolean isWinOS = false;
    boolean isSystemMailExist = false;

    // if 'OS' parameter is not defined then by default
    // Win platform is used. If really not the error will occurs.
    isWinOS = Param.get("OS") == null || "wntmsci".equals(Param.get("OS"));
    isSystemMailExist = "true".equalsIgnoreCase((String) Param.get("test.system.mail.isExist"));

    XMultiServiceFactory xMSF = Param.getMSF();
    try {
      if (isWinOS) {
        log.println("The OS is Win : trying to create service");
        oInterface = xMSF.createInstance("com.sun.star.system.SimpleSystemMail");
      } else {
        log.println("The OS is NOT Win, SKIPPING this component");
        log.println("Creating Dummy object ...");
        oInterface = xMSF.createInstance("com.sun.star.io.Pipe");
      }
    } catch (com.sun.star.uno.Exception e) {
      log.println("Can't create an object.");
      throw new StatusException("Can't create an object", e);
    }

    oObj = (XInterface) oInterface;

    log.println("ImplementationName: " + util.utils.getImplName(oObj));

    TestEnvironment tEnv = new TestEnvironment(oObj);

    tEnv.addObjRelation("SystemMailExist", new Boolean(isSystemMailExist));

    return tEnv;
  } // finish method getTestEnvironment
  @Before
  public void before() throws Exception {
    xMSF = getMSF();
    param = new TestParameters();
    param.put("ServiceFactory", xMSF); // important for param.getMSF()

    assertNotNull("could not create MultiServiceFactory.", xMSF);
    XPropertySet xPropertySet = UnoRuntime.queryInterface(XPropertySet.class, xMSF);
    Object defaultCtx = xPropertySet.getPropertyValue("DefaultContext");
    xContext = UnoRuntime.queryInterface(XComponentContext.class, defaultCtx);
    assertNotNull("could not get component context.", xContext);

    tempDir = util.utils.getOfficeTemp /*Dir*/(xMSF);
    System.out.println("tempdir: " + tempDir);

    foo = URI.create(xContext, "uri:foo");
    assertNotNull("foo", foo);
    bar = URI.create(xContext, "uri:bar");
    assertNotNull("bar", bar);
    baz = URI.create(xContext, "uri:baz");
    assertNotNull("baz", baz);

    blank1 = BlankNode.create(xContext, "_:1");
    assertNotNull("blank1", blank1);
    blank2 = BlankNode.create(xContext, "_:2");
    assertNotNull("blank2", blank2);
    blank3 = BlankNode.create(xContext, "_:3");
    assertNotNull("blank3", blank3);
    blank4 = BlankNode.create(xContext, "_:4");
    assertNotNull("blank4", blank4);
    rdf_type = URI.createKnown(xContext, URIs.RDF_TYPE);
    assertNotNull("rdf_type", rdf_type);
    rdfs_label = URI.createKnown(xContext, URIs.RDFS_LABEL);
    assertNotNull("rdfs_label", rdfs_label);
    pkg_Document = URI.createKnown(xContext, URIs.PKG_DOCUMENT);
    assertNotNull("pkg_Document", pkg_Document);
    pkg_hasPart = URI.createKnown(xContext, URIs.PKG_HASPART);
    assertNotNull("pkg_hasPart", pkg_hasPart);
    pkg_MetadataFile = URI.createKnown(xContext, URIs.PKG_METADATAFILE);
    assertNotNull("pkg_MetadataFile", pkg_MetadataFile);
    odf_ContentFile = URI.createKnown(xContext, URIs.ODF_CONTENTFILE);
    assertNotNull("odf_ContentFile", odf_ContentFile);
    odf_StylesFile = URI.createKnown(xContext, URIs.ODF_STYLESFILE);
    assertNotNull("odf_StylesFile", odf_StylesFile);
    odf_Element = URI.createKnown(xContext, URIs.ODF_ELEMENT);
    assertNotNull("odf_Element", odf_Element);
  }
  /**
   * creating a TestEnvironment for the interfaces to be tested
   *
   * @param tParam class which contains additional test parameters
   * @param log class to log the test state and result
   * @return Status class
   * @see TestParameters
   * @see PrintWriter
   */
  @Override
  protected TestEnvironment createTestEnvironment(TestParameters tParam, PrintWriter log) {

    XInterface oObj = null;
    // create testobject here

    XEnumerationAccess xEA = null;
    try {
      SOfficeFactory SOF = SOfficeFactory.getFactory(tParam.getMSF());
      XShape oShape = SOF.createShape(xDrawDoc, 5000, 3500, 7500, 5000, "Text");
      DrawTools.getShapes(DrawTools.getDrawPage(xDrawDoc, 0)).add(oShape);

      XSimpleText text = UnoRuntime.queryInterface(XSimpleText.class, oShape);

      XTextCursor cursor = text.createTextCursor();

      text.insertString(cursor, "Paragraph 1", false);
      text.insertControlCharacter(cursor, ControlCharacter.PARAGRAPH_BREAK, false);
      text.insertString(cursor, "Paragraph 2", false);
      text.insertControlCharacter(cursor, ControlCharacter.PARAGRAPH_BREAK, false);
      text.insertString(cursor, "Paragraph 3", false);
      text.insertControlCharacter(cursor, ControlCharacter.PARAGRAPH_BREAK, false);

      xEA = UnoRuntime.queryInterface(XEnumerationAccess.class, text);

      XInterface oTextContent =
          (XInterface)
              AnyConverter.toObject(
                  new Type(XInterface.class), xEA.createEnumeration().nextElement());

      xEA = UnoRuntime.queryInterface(XEnumerationAccess.class, oTextContent);

      oObj = xEA.createEnumeration();

    } catch (Exception e) {
      log.println("Can't create test object");
      e.printStackTrace(log);
    }

    // create test environment here
    TestEnvironment tEnv = new TestEnvironment(oObj);

    tEnv.addObjRelation("ENUM", xEA);

    return tEnv;
  } // finish method getTestEnvironment
  /**
   * Create test environment:
   *
   * <ul>
   *   <li>create a text doc
   *   <li>get the model from the text doc
   *   <li>query model for XUIConfigurationManagerSupplier interface
   *   <li>get the manager from the supplier
   * </ul>
   *
   * @param tParam The test parameters.
   * @param log The log writer.
   * @return The test environment.
   */
  protected TestEnvironment createTestEnvironment(TestParameters tParam, PrintWriter log) {
    TestEnvironment tEnv = null;
    XMultiServiceFactory xMSF = (XMultiServiceFactory) tParam.getMSF();

    log.println("Creating instance...");
    xTextDoc = WriterTools.createTextDoc(xMSF);
    try {
      oObj = xMSF.createInstance("com.sun.star.ui.UIElementFactoryManager");
    } catch (com.sun.star.uno.Exception e) {
      throw new StatusException("Cannot create test object.", e);
    }
    log.println("TestObject: " + util.utils.getImplName(oObj));

    tEnv = new TestEnvironment((XInterface) oObj);

    return tEnv;
  }
  /** Disposes Writer document. */
  protected void cleanup(TestParameters tParam, PrintWriter log) {
    // closing the appearing dialog before disposing the document
    XInterface toolkit = null;

    try {
      toolkit =
          (XInterface)
              ((XMultiServiceFactory) tParam.getMSF()).createInstance("com.sun.star.awt.Toolkit");
    } catch (com.sun.star.uno.Exception e) {
      log.println("Couldn't get toolkit");
      e.printStackTrace(log);
      throw new StatusException("Couldn't get toolkit", e);
    }

    XExtendedToolkit tk = UnoRuntime.queryInterface(XExtendedToolkit.class, toolkit);

    Object atw = tk.getActiveTopWindow();

    XWindow xWindow = UnoRuntime.queryInterface(XWindow.class, atw);

    XAccessible xRoot = AccessibilityTools.getAccessibleObject(xWindow);

    XInterface button =
        AccessibilityTools.getAccessibleObjectForRole(xRoot, AccessibleRole.PUSH_BUTTON);

    XAccessibleAction action = UnoRuntime.queryInterface(XAccessibleAction.class, button);

    try {
      action.doAccessibleAction(0);
    } catch (com.sun.star.lang.IndexOutOfBoundsException iob) {
      log.println("couldn't close dialog");
    } catch (com.sun.star.lang.DisposedException e) {
      log.println("couldn't close dialog");
    }

    log.println("    disposing xTextDoc ");

    try {
      XCloseable closer = UnoRuntime.queryInterface(XCloseable.class, xTextDoc);
      closer.close(true);
    } catch (com.sun.star.util.CloseVetoException e) {
      log.println("couldn't close document");
    } catch (com.sun.star.lang.DisposedException e) {
      log.println("couldn't close document");
    }
  }
Beispiel #19
0
  /**
   * Creating a TestEnvironment for the interfaces to be tested. Creates an instance of the service
   * <code>com.sun.star.comp.Chart.XMLExporter</code> with argument which is an implementation of
   * <code>XDocumentHandler</code> and which can check if required tags and character data is
   * exported.
   *
   * <p>The chart document is set as a source document for exporter created. A new 'main title' is
   * set for chart. This made for checking if this title is successfully exported within the
   * document content. Object relations created :
   *
   * <ul>
   *   <li><code>'MediaDescriptor'</code> for {@link ifc.document._XFilter} interface
   *   <li><code>'XFilter.Checker'</code> for {@link ifc.document._XFilter} interface
   *   <li><code>'SourceDocument'</code> for {@link ifc.document._XExporter} interface
   * </ul>
   */
  @Override
  public TestEnvironment createTestEnvironment(TestParameters tParam, PrintWriter log)
      throws Exception {

    XMultiServiceFactory xMSF = tParam.getMSF();
    XInterface oObj = null;
    final String exportStr = "XMLExporter test.";

    FilterChecker filter = new FilterChecker(log);
    Any arg = new Any(new Type(XDocumentHandler.class), filter);

    oObj =
        (XInterface)
            xMSF.createInstanceWithArguments(
                "com.sun.star.comp.Chart.XMLExporter", new Object[] {arg});
    XExporter xEx = UnoRuntime.queryInterface(XExporter.class, oObj);
    xEx.setSourceDocument(xChartDoc);

    Object oTitle = xChartDoc.getTitle();
    XPropertySet xTitleProp = UnoRuntime.queryInterface(XPropertySet.class, oTitle);
    xTitleProp.setPropertyValue("String", exportStr);

    filter.addTag(new XMLTools.Tag("office:document"));
    filter.addTagEnclosed(new XMLTools.Tag("office:meta"), new XMLTools.Tag("office:document"));
    filter.addTagEnclosed(new XMLTools.Tag("office:body"), new XMLTools.Tag("office:document"));
    filter.addCharactersEnclosed(exportStr, new XMLTools.Tag("chart:title"));

    // create testobject here
    log.println("creating a new environment");
    TestEnvironment tEnv = new TestEnvironment(oObj);

    tEnv.addObjRelation(
        "MediaDescriptor",
        XMLTools.createMediaDescriptor(
            new String[] {"FilterName"}, new Object[] {"schart: StarOffice XML (Chart)"}));
    tEnv.addObjRelation("SourceDocument", xChartDoc);
    tEnv.addObjRelation("XFilter.Checker", filter);
    log.println("Implementation Name: " + util.utils.getImplName(oObj));

    return tEnv;
  }
  /**
   * Creating a Testenvironment for the interfaces to be tested. Using SOffice ServiceManager an
   * instance of <code>com.sun.star.sheet.TableAutoFormatField</code> service is created. From this
   * collection one Format is retrieved as object tested.
   */
  public TestEnvironment createTestEnvironment(TestParameters tParam, PrintWriter log) {

    XInterface oObj = null;
    XMultiServiceFactory oMSF = (XMultiServiceFactory) tParam.getMSF();
    try {
      XInterface formats = (XInterface) oMSF.createInstance("com.sun.star.sheet.TableAutoFormats");
      XIndexAccess formatsIndex = UnoRuntime.queryInterface(XIndexAccess.class, formats);
      oObj =
          (XInterface)
              AnyConverter.toObject(
                  new Type(XInterface.class), formatsIndex.getByIndex(formatsIndex.getCount() - 1));

      XNamed objNamed = UnoRuntime.queryInterface(XNamed.class, oObj);
      log.println("AutoFormat name is '" + objNamed.getName() + "'");
    } catch (com.sun.star.uno.Exception e) {
      e.printStackTrace(log);
      throw new StatusException("Unexpected exception", e);
    }

    TestEnvironment tEnv = new TestEnvironment(oObj);

    return tEnv;
  }
  /** * creating a Testenvironment for the interfaces to be tested */
  protected synchronized TestEnvironment createTestEnvironment(
      TestParameters Param, PrintWriter log) {
    if (xTextDoc != null) {
      try {
        XCloseable closer = UnoRuntime.queryInterface(XCloseable.class, xTextDoc);
        closer.close(true);
      } catch (com.sun.star.util.CloseVetoException e) {
        log.println("couldn't close document");
      } catch (com.sun.star.lang.DisposedException e) {
        log.println("couldn't close document");
      }

      log.println("Existing document disposed");
    }

    log.println("creating a text document");
    xTextDoc = WriterTools.createTextDoc(((XMultiServiceFactory) Param.getMSF()));

    // initialize test table
    if (isMySQLDB) {
      try {
        dbTools.initTestTableUsingJDBC(tableName, srcInf);
      } catch (java.sql.SQLException e) {
        e.printStackTrace(log);
        throw new StatusException(Status.failed("Couldn't " + " init test table. SQLException..."));
      } catch (java.lang.ClassNotFoundException e) {
        throw new StatusException(Status.failed("Couldn't " + "register mysql driver"));
      }
    }

    XInterface oObj = null;
    XShapes oShapes = null;
    XInterface oInstance = null;
    XConnection connection = null;

    // creation of testobject here
    // first we write what we are intend to do to log file
    log.println("creating a test environment");

    XNameContainer forms = FormTools.getForms(WriterTools.getDrawPage(xTextDoc));

    try {
      String[] formNames = forms.getElementNames();

      for (int i = 0; i < formNames.length; i++) {
        log.println("Removing form '" + formNames[i] + "' ...");
        forms.removeByName(formNames[i]);
      }
    } catch (com.sun.star.lang.WrappedTargetException e) {
      e.printStackTrace(log);
    } catch (com.sun.star.container.NoSuchElementException e) {
      e.printStackTrace(log);
    }

    String[] formNames = forms.getElementNames();
    FormTools.insertForm(xTextDoc, forms, "MyForm");
    formNames = forms.getElementNames();

    XLoadable formLoader = null;

    try {
      formLoader = FormTools.bindForm(xTextDoc, "MyForm", dbSourceName, tableName);
    } catch (com.sun.star.uno.Exception e) {
      log.println(
          "Cann't bind the form to source '" + dbSourceName + "', table '" + tableName + "' :");
      e.printStackTrace(log);
      throw new StatusException("Cann't bind a form", e);
    }

    // DEBUG
    log.println("Forms before adding controls : ");
    formNames = forms.getElementNames();

    for (int i = 0; i < formNames.length; i++) {
      log.println("    '" + formNames[i] + "'");
    }

    XControlShape shape1 = null;
    XControlShape shape2 = null;

    try {

      log.println("Elements in the 'MyForm' :");

      XIndexAccess formElements1 =
          UnoRuntime.queryInterface(XIndexAccess.class, forms.getByName("MyForm"));

      for (int i = 0; i < formElements1.getCount(); i++) {
        XNamed elemName = UnoRuntime.queryInterface(XNamed.class, formElements1.getByIndex(i));
        log.println("   '" + elemName.getName() + "'");
      }

      // END DEBUG
      // put something on the drawpage
      log.println("inserting some ControlShapes");
      oShapes = DrawTools.getShapes(WriterTools.getDrawPage(xTextDoc));
      shape1 = FormTools.createControlShape(xTextDoc, 3000, 4500, 15000, 1000, "CommandButton");
      shape2 = FormTools.createControlShape(xTextDoc, 5000, 3500, 7500, 5000, "TextField");

      XControlShape shape3 =
          FormTools.createControlShape(xTextDoc, 2000, 1500, 1000, 1000, "CheckBox");
      oShapes.add(shape1);
      oShapes.add(shape2);
      oShapes.add(shape3);
    } catch (Exception e) {
      e.printStackTrace(log);
    }

    log.println("Forms after adding controls : ");
    formNames = forms.getElementNames();

    for (int i = 0; i < formNames.length; i++) {
      log.println("    '" + formNames[i] + "'");
    }

    try {
      log.println("Elements in the 'MyForm' :");

      XIndexAccess formElements1 =
          UnoRuntime.queryInterface(XIndexAccess.class, forms.getByName("MyForm"));

      for (int i = 0; i < formElements1.getCount(); i++) {
        XNamed elemName = UnoRuntime.queryInterface(XNamed.class, formElements1.getByIndex(i));
        log.println("   '" + elemName.getName() + "'");
      }
    } catch (Exception e) {
      e.printStackTrace(log);
    }

    formLoader.load();

    try {
      oObj =
          (XForm)
              AnyConverter.toObject(
                  new Type(XForm.class),
                  (FormTools.getForms(WriterTools.getDrawPage(xTextDoc))).getByName("MyForm"));

      XPropertySet xSetProp = UnoRuntime.queryInterface(XPropertySet.class, oObj);
      connection =
          (XConnection)
              AnyConverter.toObject(
                  new Type(XConnection.class), xSetProp.getPropertyValue("ActiveConnection"));
    } catch (com.sun.star.uno.Exception e) {
      log.println("Couldn't get Form");
      e.printStackTrace(log);
    }

    // get a control
    oInstance = FormTools.createControl(xTextDoc, "TextField");

    log.println("creating a new environment for drawpage object");

    TestEnvironment tEnv = new TestEnvironment(oObj);

    // adding relation for closing connection while environment disposing.
    this.conn = connection;

    // adding relation for XSubmit
    XControlModel the_Model = shape2.getControl();
    XControlAccess the_access =
        UnoRuntime.queryInterface(XControlAccess.class, xTextDoc.getCurrentController());
    XControl cntrl = null;

    // now get the OEditControl
    try {
      cntrl = the_access.getControl(the_Model);
      log.println(cntrl.getClass().getName());
    } catch (com.sun.star.container.NoSuchElementException e) {
      log.println("Couldn't get OEditControl");
      e.printStackTrace(log);
      throw new StatusException("Couldn't get OEditControl", e);
    }

    XResultSet the_set = UnoRuntime.queryInterface(XResultSet.class, oObj);

    try {
      the_set.first();
    } catch (SQLException e) {
      log.println("Cann't move cursor to the first row.");
      e.printStackTrace();
      throw new StatusException("Can't move cursor to the first row.", e);
    }

    tEnv.addObjRelation("Model1", shape1.getControl());
    tEnv.addObjRelation("Model2", shape2.getControl());

    // adding an object for XNameReplace testing
    log.println("adding oInstace as obj relation to environment");
    tEnv.addObjRelation("INSTANCE", oInstance);

    // INDEX : _XNameContainer
    log.println("adding INDEX as obj relation to environment");
    tEnv.addObjRelation("INDEX", "0");

    // INDEX : _XNameReplace
    log.println("adding NameReplaceIndex as obj relation to environment");
    tEnv.addObjRelation("XNameReplaceINDEX", "2");

    // INSTANCEn : _XNameContainer; _XNameReplace
    log.println("adding INSTANCEn as obj relation to environment");

    // XComponent xComp = (XComponent)
    //    UnoRuntime.queryInterface(XComponent.class, xDrawDoc);
    String tc = (String) Param.get("THRCNT");
    int THRCNT = 1;

    if (tc != null) {
      THRCNT = Integer.parseInt(tc);
    }

    for (int n = 1; n < (2 * (THRCNT + 1)); n++) {
      log.println("adding INSTANCE" + n + " as obj relation to environment");
      tEnv.addObjRelation("INSTANCE" + n, FormTools.createControl(xTextDoc, "CheckBox"));
    }

    // adding relation for XNameContainer
    tEnv.addObjRelation("XNameContainer.AllowDuplicateNames", new Object());

    // adding relation for XPersistObject
    tEnv.addObjRelation("OBJNAME", "stardiv.one.form.component.Form");

    if (the_set != null) {
      log.println("The Form has a not empty ResultSet");
    }

    // Adding obj relation for XRowSetApproveBroadcaster test
    final XResultSet xResSet = UnoRuntime.queryInterface(XResultSet.class, oObj);
    final XResultSetUpdate xResSetUpdate = UnoRuntime.queryInterface(XResultSetUpdate.class, oObj);
    final XRowSet xRowSet = UnoRuntime.queryInterface(XRowSet.class, oObj);
    final PrintWriter logF = log;
    tEnv.addObjRelation(
        "XRowSetApproveBroadcaster.ApproveChecker",
        new ifc.sdb._XRowSetApproveBroadcaster.RowSetApproveChecker() {
          public void moveCursor() {
            try {
              xResSet.beforeFirst();
              xResSet.afterLast();
            } catch (com.sun.star.sdbc.SQLException e) {
              logF.println(
                  "### _XRowSetApproveBroadcaster." + "RowSetApproveChecker.moveCursor() :");
              e.printStackTrace(logF);
            }
          }

          public RowChangeEvent changeRow() {
            try {
              xResSet.first();

              XRowUpdate row = UnoRuntime.queryInterface(XRowUpdate.class, xResSet);
              row.updateString(1, "1");
              xResSetUpdate.updateRow();
            } catch (com.sun.star.sdbc.SQLException e) {
              logF.println(
                  "### _XRowSetApproveBroadcaster." + "RowSetApproveChecker.changeRow() :");
              e.printStackTrace(logF);
            }

            RowChangeEvent ev = new RowChangeEvent();
            ev.Action = com.sun.star.sdb.RowChangeAction.UPDATE;
            ev.Rows = 1;

            return ev;
          }

          public void changeRowSet() {
            try {
              xRowSet.execute();
            } catch (com.sun.star.sdbc.SQLException e) {
              logF.println(
                  "### _XRowSetApproveBroadcaster." + "RowSetApproveChecker.changeRowSet() :");
              e.printStackTrace(logF);
            }
          }
        });

    // Adding relation for XColumnLocate test
    tEnv.addObjRelation("XColumnLocate.ColumnName", DBTools.TST_STRING_F);

    // Adding relation for XParameters ifc test
    ArrayList<Object> params = new ArrayList<Object>();

    /** *** statement parameter types and their initial values must be added here as relation. */
    params.add("SAU99");
    params.add(new Boolean(false));
    params.add(new Byte((byte) 123));
    params.add(new Short((short) 234));
    params.add(new Integer(12345));
    params.add(new Long(23456));
    params.add(new Float(1.234));
    params.add(new Double(2.345));
    params.add(new byte[] {1, 2, 3});
    Date d = new Date();
    d.Day = 26;
    d.Month = 1;
    d.Year = 2001;
    params.add(d);
    Time t = new Time();
    t.Hours = 1;
    t.NanoSeconds = 123456789;
    t.Minutes = 25;
    t.Seconds = 14;
    params.add(t);
    DateTime dt = new DateTime();
    dt.Day = 26;
    dt.Month = 1;
    dt.Year = 2001;
    dt.Hours = 1;
    dt.NanoSeconds = 123456789;
    dt.Minutes = 25;
    dt.Seconds = 14;
    params.add(dt);
    tEnv.addObjRelation("XParameters.ParamValues", params);

    // Adding relation for XCompletedExecution
    tEnv.addObjRelation("InteractionHandlerChecker", new InteractionHandlerImpl());

    // Adding for XWarningSupplier
    tEnv.addObjRelation("CheckWarningsSupplier", new Boolean(isMySQLDB));

    // Adding relation for XDatabaseParameterBroadcaster
    tEnv.addObjRelation("ParameterListenerChecker", new ODatabaseForm.ParameterListenerImpl());
    XPropertySet xSetProp = UnoRuntime.queryInterface(XPropertySet.class, oObj);
    try {
      xSetProp.setPropertyValue("DataSourceName", dbSourceName);
      if (isMySQLDB) {
        xSetProp.setPropertyValue(
            "Command", "SELECT Column0  FROM soffice_test_table  WHERE ( (  Column0 = :param1 ) )");
      } else {
        xSetProp.setPropertyValue(
            "Command",
            "SELECT \"_TEXT\" FROM \"ODatabaseForm_tmp0\" WHERE ( ( \"_TEXT\" = :param1 ) )");
      }

      xSetProp.setPropertyValue("CommandType", new Integer(CommandType.COMMAND));
    } catch (Exception e) {
    }

    // Adding relation for XResultSetUpdate
    final XRowUpdate xRowUpdate = UnoRuntime.queryInterface(XRowUpdate.class, oObj);
    final XRow xRow = UnoRuntime.queryInterface(XRow.class, oObj);

    tEnv.addObjRelation(
        "XResultSetUpdate.UpdateTester",
        new ifc.sdbc._XResultSetUpdate.UpdateTester() {
          String lastUpdate = null;

          public int rowCount() throws SQLException {
            int prevPos = xResSet.getRow();
            xResSet.last();

            int count = xResSet.getRow();
            xResSet.absolute(prevPos);

            return count;
          }

          public void update() throws SQLException {
            lastUpdate = xRow.getString(1);
            lastUpdate += "_";
            xRowUpdate.updateString(1, lastUpdate);
          }

          public boolean wasUpdated() throws SQLException {
            String getStr = xRow.getString(1);

            return lastUpdate.equals(getStr);
          }

          public int currentRow() throws SQLException {
            return xResSet.getRow();
          }
        });

    // Adding relations for XRow as a Vector with all data
    // of current row of RowSet.

    ArrayList<Object> rowData = new ArrayList<Object>();

    for (int i = 0; i < DBTools.TST_TABLE_VALUES[0].length; i++) {
      rowData.add(DBTools.TST_TABLE_VALUES[0][i]);
    }

    tEnv.addObjRelation("CurrentRowData", rowData);

    // Adding relation for XRowUpdate
    XRow row = UnoRuntime.queryInterface(XRow.class, oObj);
    tEnv.addObjRelation("XRowUpdate.XRow", row);

    tEnv.addObjRelation("XPropertyContainer.propertyNotRemovable", "Cycle");

    PropertyValue propVal = new PropertyValue();
    propVal.Name = "Name";
    propVal.Value = "Text since XPropertyAccess";

    tEnv.addObjRelation("XPropertyAccess.propertyToChange", propVal);

    return tEnv;
  } // finish method getTestEnvironment
 /** Creates the Desktop service (<code>com.sun.star.frame.Desktop</code>). */
 @Override
 protected void initialize(TestParameters Param, PrintWriter log) throws Exception {
   the_Desk =
       UnoRuntime.queryInterface(XDesktop.class, DesktopTools.createDesktop(Param.getMSF()));
 }
  /**
   * Creating a Testenvironment for the interfaces to be tested. Creates an instance of the service
   * <code>com.sun.star.comp.Calc.XMLSettingsImporter</code>
   *
   * <p>The calc document is set as a target document for importer. Imported XML-data contains only
   * settings tags including tag with new number of iteration steps. After import 'IterationCount'
   * proeprty getting from target document is checked. Object relations created :
   *
   * <ul>
   *   <li><code>'XDocumentHandler.XMLData'</code> for {@link ifc.xml.sax._XDocumentHandler}
   *       interface
   *   <li><code>'XDocumentHandler.ImportChecker'</code> for {@link ifc.xml.sax._XDocumentHandler}
   *       interface
   *   <li><code>'TargetDocument'</code> for {@link ifc.document._XImporter} interface
   * </ul>
   */
  public synchronized TestEnvironment createTestEnvironment(TestParameters tParam, PrintWriter log)
      throws StatusException {

    XInterface oObj = null;
    Object oInt = null;

    // creation of testobject here
    // first we write what we are intend to do to log file
    log.println("creating a test environment");

    XMultiServiceFactory xMSF = (XMultiServiceFactory) tParam.getMSF();
    final XPropertySet xPropSet;

    try {
      oInt = xMSF.createInstance("com.sun.star.comp.Calc.XMLSettingsImporter");
      XImporter imp = UnoRuntime.queryInterface(XImporter.class, oInt);
      imp.setTargetDocument(comp);

      XModel xSheetModel = UnoRuntime.queryInterface(XModel.class, xSheetDoc);
      XController xController = xSheetModel.getCurrentController();
      xPropSet = UnoRuntime.queryInterface(XPropertySet.class, xController);
    } catch (com.sun.star.uno.Exception e) {
      e.printStackTrace(log);
      throw new StatusException("Can't create component.", e);
    }

    oObj = (XInterface) oInt;

    // create testobject here
    log.println("creating a new environment for Paragraph object");
    TestEnvironment tEnv = new TestEnvironment(oObj);

    // adding relation
    tEnv.addObjRelation("TargetDocument", comp);

    // adding relation for XDocumentHandler
    String[][] xml =
        new String[][] {
          {
            "start",
            "office:document-settings",
            "xmlns:office",
            "CDATA",
            "http://openoffice.org/2000/office",
            "xmlns:xlink",
            "CDATA",
            "http://www.w3.org/1999/xlink",
            "xmlns:config",
            "CDATA",
            "http://openoffice.org/2001/config"
          },
          {"start", "office:settings"},
          {"start", "config:config-item-set", "config:name", "CDATA", "view-settings"},
          {"start", "config:config-item-map-indexed", "config:name", "CDATA", "Views"},
          {"start", "config:config-item-map-entry"},
          {
            "start",
            "config:config-item",
            "config:name",
            "CDATA",
            "ShowGrid",
            "config:type",
            "CDATA",
            "boolean"
          },
          {"chars", "false"},
          {"end", "config:config-item"},
          {
            "start",
            "config:config-item",
            "config:name",
            "CDATA",
            "ZoomType",
            "config:type",
            "CDATA",
            "short"
          },
          {"chars", "0"},
          {
            "start",
            "config:config-item",
            "config:name",
            "CDATA",
            "ZoomValue",
            "config:type",
            "CDATA",
            "int"
          },
          {"chars", "124"},
          {"end", "config:config-item"},
          {"end", "config:config-item"},
          {"end", "config:config-item-map-entry"},
          {"end", "config:config-item-map-indexed"},
          {"end", "config:config-item-set"},
          {"end", "office:settings"},
          {"end", "office:document-settings"}
        };

    tEnv.addObjRelation("XDocumentHandler.XMLData", xml);

    final PrintWriter logF = log;

    tEnv.addObjRelation(
        "XDocumentHandler.ImportChecker",
        new ifc.xml.sax._XDocumentHandler.ImportChecker() {
          public boolean checkImport() {
            try {
              Object gVal = xPropSet.getPropertyValue("ShowGrid");
              logF.println("ShowGrid = " + gVal);
              return "false".equals(gVal);
            } catch (com.sun.star.uno.Exception e) {
              logF.println("Exception occurred while checking filter :");
              e.printStackTrace(logF);
              return false;
            }
          }
        });

    return tEnv;
  } // finish method getTestEnvironment
  /**
   * Creating a Testenvironment for the interfaces to be tested. Creates an instance of the service
   * <code>com.sun.star.text.AutoTextContainer</code>, then selects the 'mytexts' group from the
   * given container using <code>XNameAccess</code> interface, and inserts some text entry to this
   * group. Then entry passed as test component.
   *
   * <p>Object relations created :
   *
   * <ul>
   *   <li><code>'XTEXTINFO'</code> for {@link ifc.text._XText} : creates tables 6x4
   *   <li><code>'TEXTDOC'</code> for {@link ifc.text._XAutoTextEntry} : text document
   * </ul>
   */
  protected synchronized TestEnvironment createTestEnvironment(
      TestParameters Param, PrintWriter log) {

    XAutoTextEntry oEntry = null;
    XAutoTextContainer oContainer;
    XInterface oObj = null;
    log.println("creating a test environment");
    try {
      XMultiServiceFactory myMSF = (XMultiServiceFactory) Param.getMSF();
      Object oInst = myMSF.createInstance("com.sun.star.text.AutoTextContainer");
      oContainer = UnoRuntime.queryInterface(XAutoTextContainer.class, oInst);
    } catch (com.sun.star.uno.Exception e) {
      e.printStackTrace(log);
      throw new StatusException("Couldn't create AutoTextContainer", e);
    }

    XNameAccess oContNames = UnoRuntime.queryInterface(XNameAccess.class, oContainer);

    String contNames[] = oContNames.getElementNames();
    for (int i = 0; i < contNames.length; i++) {
      log.println("ContainerNames[ " + i + "]: " + contNames[i]);
    }

    try {
      oObj =
          (XInterface)
              AnyConverter.toObject(new Type(XInterface.class), oContNames.getByName("mytexts"));
    } catch (com.sun.star.uno.Exception e) {
      e.printStackTrace(log);
      throw new StatusException("Couldn't get AutoTextGroup", e);
    }

    oGroup = UnoRuntime.queryInterface(XAutoTextGroup.class, oObj);
    String[] oENames = oGroup.getElementNames();
    for (int i = 0; i < oENames.length; i++) {
      log.println("AutoTextEntryNames[" + i + "]: " + oENames[i]);
    }

    XText oText = xTextDoc.getText();
    oText.insertString(oText.getStart(), "New AutoText", true);
    XTextRange oTextRange = oText;
    try {
      if (oGroup.hasByName("NewEntryName")) {
        oGroup.removeByName("NewEntryName");
        log.println("Element 'NewEntryName' exists, removing...");
      }
      log.println("Adding new element 'NewEntryName' to group...");
      oGroup.insertNewByName("NewEntryName", "NewEntryTitle", oTextRange);
      oEntry =
          (XAutoTextEntry)
              AnyConverter.toObject(
                  new Type(XAutoTextEntry.class), oGroup.getByName("NewEntryName"));
    } catch (com.sun.star.container.ElementExistException e) {
      e.printStackTrace(log);
    } catch (com.sun.star.container.NoSuchElementException e) {
      e.printStackTrace(log);
    } catch (com.sun.star.lang.WrappedTargetException e) {
      e.printStackTrace(log);
    } catch (com.sun.star.lang.IllegalArgumentException e) {
      e.printStackTrace(log);
    }

    oObj = oEntry;

    log.println("Trying to use XText as TextRange in the method applyTo");
    oEntry.applyTo(oTextRange);

    oTextRange = oText.createTextCursor();
    log.println("Trying to use XTextCursor as TextRange in the method applyTo");
    oEntry.applyTo(oTextRange);

    log.println("creating a new environment for AutoTextEntry object");
    TestEnvironment tEnv = new TestEnvironment(oObj);

    // adding relation for XText
    DefaultDsc tDsc =
        new DefaultDsc("com.sun.star.text.XTextContent", "com.sun.star.text.TextField.DateTime");
    log.println("    adding InstCreator object");
    tEnv.addObjRelation("XTEXTINFO", new InstCreator(xTextDoc, tDsc));

    log.println("adding TextDocument as mod relation to environment");
    tEnv.addObjRelation("TEXTDOC", xTextDoc);

    return tEnv;
  } // finish method getTestEnvironment
  /**
   * Creating a Testenvironment for the interfaces to be tested.
   * For object creation first a
   * <code>com.sun.star.form.component.GridControl<code> instance
   * is added to the <code>ControlShape</code>. Then this model's
   * control is retrieved.
   *
   *     Object relations created :
   * <ul>
   *  <li> <code>'GRAPHICS'</code> for
   *      {@link ifc.awt._XView} test : <code>XGraphics</code>
   *   object different that belong to the object tested.</li>
   *  <li> <code>'CONTEXT'</code> for
   *      {@link ifc.awt._XControl} </li>
   *  <li> <code>'WINPEER'</code> for
   *      {@link ifc.awt._XControl} </li>
   *  <li> <code>'TOOLKIT'</code> for
   *      {@link ifc.awt._XControl} </li>
   *  <li> <code>'MODEL'</code> for
   *      {@link ifc.awt._XControl} </li>
   *  <li> <code>'XWindow.AnotherWindow'</code> for
   *      {@link ifc.awt._XWindow} for switching focus.</li>
   *  <li> <code>'XDispatch.URL'</code> for
   *      {@link ifc.frame._XDispatch} the url which moves
   *      DB cursor to the next row (".uno:FormSlots/moveToNext").</li>
   *  <li> <code>'XContainer.Container'</code> for
   *      {@link ifc.container._XContainer} as the component created
   *      doesn't support <code>XContainer</code> itself, but
   *      it is supported by its model. So this model is passed.</li>
   *  <li> <code>'INSTANCE'</code> for
   *      {@link ifc.container._XContainer} the instance to be
   *      inserted into collection. Is a column instance.</li>
   * </ul>
   */
  protected TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) {
    XInterface oObj = null;
    XWindowPeer the_win = null;
    XToolkit the_kit = null;
    XDevice aDevice = null;
    XGraphics aGraphic = null;
    XPropertySet aControl = null;
    XPropertySet aControl2 = null;
    XPropertySet aControl3 = null;
    XPropertySet aControl4 = null;
    XGridColumnFactory columns = null;

    // Insert a ControlShape and get the ControlModel
    XControlShape aShape = createGrid(xTextDoc, 3000, 4500, 15000, 10000);

    XControlModel the_Model = aShape.getControl();

    WriterTools.getDrawPage(xTextDoc).add(aShape);

    XLoadable formLoader = FormTools.bindForm(xTextDoc);

    // Try to query XControlAccess
    XControlAccess the_access =
        UnoRuntime.queryInterface(XControlAccess.class, xTextDoc.getCurrentController());

    try {
      columns = UnoRuntime.queryInterface(XGridColumnFactory.class, the_Model);
      aControl = columns.createColumn("TextField");
      aControl.setPropertyValue("DataField", "Identifier");
      aControl.setPropertyValue("Label", "Identifier");
      aControl2 = columns.createColumn("TextField");
      aControl2.setPropertyValue("DataField", "Publisher");
      aControl2.setPropertyValue("Label", "Publisher");
      aControl3 = columns.createColumn("TextField");
      aControl3.setPropertyValue("DataField", "Author");
      aControl3.setPropertyValue("Label", "Author");
      aControl4 = columns.createColumn("TextField");
      aControl4.setPropertyValue("DataField", "Title");
      aControl4.setPropertyValue("Label", "Title");
    } catch (com.sun.star.lang.IllegalArgumentException e) {
      // Some exception occurs.FAILED
      log.println("!!! Couldn't create instance : " + e);
      throw new StatusException("Can't create column instances.", e);
    } catch (com.sun.star.lang.WrappedTargetException e) {
      // Some exception occurs.FAILED
      log.println("!!! Couldn't create instance : " + e);
      throw new StatusException("Can't create column instances.", e);
    } catch (com.sun.star.beans.PropertyVetoException e) {
      // Some exception occurs.FAILED
      log.println("!!! Couldn't create instance : " + e);
      throw new StatusException("Can't create column instances.", e);
    } catch (com.sun.star.beans.UnknownPropertyException e) {
      // Some exception occurs.FAILED
      log.println("!!! Couldn't create instance : " + e);
      throw new StatusException("Can't create column instances.", e);
    }

    XNameContainer aContainer = UnoRuntime.queryInterface(XNameContainer.class, the_Model);

    try {
      aContainer.insertByName("First", aControl);
      aContainer.insertByName("Second", aControl2);
    } catch (com.sun.star.uno.Exception e) {
      log.println("!!! Could't insert column Instance");
      e.printStackTrace(log);
      throw new StatusException("Can't insert columns", e);
    }

    // now get the OGridControl
    try {
      oObj = the_access.getControl(the_Model);
      the_win = the_access.getControl(the_Model).getPeer();
      the_kit = the_win.getToolkit();
      aDevice = the_kit.createScreenCompatibleDevice(200, 200);
      aGraphic = aDevice.createGraphics();
    } catch (com.sun.star.uno.Exception e) {
      log.println("Couldn't get GridControl");
      e.printStackTrace(log);
      throw new StatusException("Couldn't get GridControl", e);
    }

    // creating another window
    aShape = FormTools.createControlShape(xTextDoc, 3000, 4500, 15000, 10000, "TextField");

    WriterTools.getDrawPage(xTextDoc).add(aShape);

    the_Model = aShape.getControl();

    // Try to query XControlAccess
    the_access = UnoRuntime.queryInterface(XControlAccess.class, xTextDoc.getCurrentController());

    // now get the TextControl
    XWindow win = null;
    Object cntrl = null;

    try {
      cntrl = the_access.getControl(the_Model);
      win = UnoRuntime.queryInterface(XWindow.class, cntrl);
    } catch (com.sun.star.uno.Exception e) {
      log.println("Couldn't get Control");
      e.printStackTrace(log);
      throw new StatusException("Couldn't get Control", e);
    }

    log.println("creating a new environment for object");

    TestEnvironment tEnv = new TestEnvironment(oObj);

    // Relations for XSelectionSupplier
    tEnv.addObjRelation(
        "Selections", new Object[] {new Object[] {new Integer(0)}, new Object[] {new Integer(1)}});
    tEnv.addObjRelation(
        "Comparer",
        new Comparator<Integer>() {
          public int compare(Integer o1, Integer o2) {
            return o1.compareTo(o2);
          }
        });

    // Realtion for XContainer
    tEnv.addObjRelation("XContainer.Container", aContainer);
    tEnv.addObjRelation("INSTANCE", aControl3);
    tEnv.addObjRelation("INSTANCE2", aControl4);

    // Adding ObjRelation for XView
    tEnv.addObjRelation("GRAPHICS", aGraphic);

    // Adding ObjRelation for XControl
    tEnv.addObjRelation("CONTEXT", xTextDoc);
    tEnv.addObjRelation("WINPEER", the_win);
    tEnv.addObjRelation("TOOLKIT", the_kit);
    tEnv.addObjRelation("MODEL", the_Model);

    // Adding relation for XWindow
    tEnv.addObjRelation("XWindow.AnotherWindow", win);

    // Adding relation for XDispatch
    URL url = new URL();
    url.Complete = ".uno:FormSlots/moveToNext";

    // url.Complete = ".uno:GridSlots/RowHeight";
    // url.Complete = ".uno:GridSlots/RowHeight" ;
    tEnv.addObjRelation("XDispatch.URL", url);

    log.println("ImplName: " + utils.getImplName(oObj));

    FormTools.switchDesignOf((XMultiServiceFactory) Param.getMSF(), xTextDoc);

    // adding relation for XUpdateBroadcaster
    final XInterface ctrl = oObj;
    final XLoadable formLoaderF = formLoader;
    final XPropertySet ps = UnoRuntime.queryInterface(XPropertySet.class, aControl2);
    tEnv.addObjRelation(
        "XUpdateBroadcaster.Checker",
        new ifc.form._XUpdateBroadcaster.UpdateChecker() {
          private String lastText = "";

          public void update() throws com.sun.star.uno.Exception {
            if (!formLoaderF.isLoaded()) {
              formLoaderF.load();
            }

            lastText = "_" + ps.getPropertyValue("Text");
            ps.setPropertyValue("Text", lastText);
          }

          public void commit() throws com.sun.star.sdbc.SQLException {
            XBoundComponent bound = UnoRuntime.queryInterface(XBoundComponent.class, ctrl);
            XResultSetUpdate update =
                UnoRuntime.queryInterface(XResultSetUpdate.class, formLoaderF);

            bound.commit();
            update.updateRow();
          }

          public boolean wasCommited() throws com.sun.star.uno.Exception {
            String getS = (String) ps.getPropertyValue("Text");

            return lastText.equals(getS);
          }
        });

    return tEnv;
  } // finish method getTestEnvironment
  /**
   * Called to create an instance of <code>TestEnvironment</code> with an object to test and related
   * objects. Creates a frame and inserts it into document. Obtains accessible object for the
   * inserted text frame.
   *
   * @param Param test parameters
   * @param log writer to log information while testing
   * @see TestEnvironment
   * @see #getTestEnvironment
   */
  protected TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) {

    XInterface oObj = null;
    XTextFrame oFrame1 = null;
    XPropertySet oPropSet = null;
    XText oText = null;
    XTextCursor oCursor = null;

    // get a soffice factory object
    SOfficeFactory SOF = SOfficeFactory.getFactory((XMultiServiceFactory) Param.getMSF());
    // creating Frames
    log.println("creating Frames");
    try {
      oFrame1 = SOfficeFactory.createTextFrame(xTextDoc, 500, 500);
      oPropSet = UnoRuntime.queryInterface(XPropertySet.class, oFrame1);
      oPropSet.setPropertyValue("AnchorType", TextContentAnchorType.AS_CHARACTER);
      oText = xTextDoc.getText();
      oCursor = oText.createTextCursor();

      log.println("inserting Frame1");
      XTextContent the_content = UnoRuntime.queryInterface(XTextContent.class, oFrame1);
      oText.insertTextContent(oCursor, the_content, true);
    } catch (Exception e) {
      e.printStackTrace(log);
      throw new StatusException("Couldn't insert TextFrame", e);
    }

    XModel aModel = UnoRuntime.queryInterface(XModel.class, xTextDoc);

    AccessibilityTools at = new AccessibilityTools();

    XWindow xWindow =
        AccessibilityTools.getCurrentWindow((XMultiServiceFactory) Param.getMSF(), aModel);
    XAccessible xRoot = AccessibilityTools.getAccessibleObject(xWindow);

    oObj = AccessibilityTools.getAccessibleObjectForRole(xRoot, AccessibleRole.TEXT_FRAME);

    log.println("ImplementationName " + utils.getImplName(oObj));
    AccessibilityTools.printAccessibleTree(
        log, xRoot, Param.getBool(util.PropertyName.DEBUG_IS_ACTIVE));

    TestEnvironment tEnv = new TestEnvironment(oObj);

    XController xController = xTextDoc.getCurrentController();
    XViewSettingsSupplier xViewSetSup =
        UnoRuntime.queryInterface(XViewSettingsSupplier.class, xController);

    final XPropertySet PropSet = xViewSetSup.getViewSettings();

    tEnv.addObjRelation(
        "EventProducer",
        new ifc.accessibility._XAccessibleEventBroadcaster.EventProducer() {
          public void fireEvent() {
            try {
              // change zoom value to 15%
              PropSet.setPropertyValue("ZoomValue", new Short("15"));
              // and back to 100%
              PropSet.setPropertyValue("ZoomValue", new Short("100"));
            } catch (com.sun.star.lang.WrappedTargetException e) {

            } catch (com.sun.star.lang.IllegalArgumentException e) {

            } catch (com.sun.star.beans.PropertyVetoException e) {

            } catch (com.sun.star.beans.UnknownPropertyException e) {

            }
          }
        });

    return tEnv;
  }
Beispiel #27
0
  /**
   * Creating a Testenvironment for the interfaces to be tested. The database (DBF) file is copied
   * from test document directory into SOffice temp dir with unique name for each environment
   * creation. If the file cann't be copied (is not released) then another unique name is used (file
   * name suffix incremented by 1).
   *
   * <p><code>com.sun.star.sdb.RowSet</code> service created and its source is all rows from the
   * current copy of the table. Then row set command ("select all rows from a table") is executed
   * and cursor is positioned to the first row.
   *
   * <p>Object relations created :
   *
   * <ul>
   *   <li><code>'ORowSet.Connection'</code> for internal component test usage. Is used for closing
   *       connection when cleaning up environment.
   *   <li><code>'XRowSetApproveBroadcaster.ApproveChecker'</code> for {@link
   *       ifc.sdb._XRowSetApproveBroadcaster} interface implementation which made actions required
   *   <li><code>'CurrentRowData'</code> for {@link ifc.sdbc._XRow}, {@link ifc.sdbc._XRowUpdate} :
   *       exports types and values of the current row data.
   *   <li><code>'XColumnLocate.ColumnName'</code> for {@link ifc.sdbc._XColumnLocate} : the name of
   *       the first column of the table.
   *   <li><code>'XParameters.ParamValues'</code> for {@link ifc.sdbc._XParameters} : Collection of
   *       parameter types presented in the query.
   *   <li><code>'XRowUpdate.XRow'</code> for {@link ifc.sdbc._XRowUpdate} : <code>XRow</code>
   *       interface of the current component.
   *   <li><code>'XResultSetUpdate.UpdateTester'</code> for {@link ifc.sdbc._XResultSetUpdate}
   * </ul>
   *
   * @see com.sun.star.sdb.DatabaseContext
   * @see com.sun.star.sdb.DataSource
   */
  protected TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) {
    XMultiServiceFactory orb = (XMultiServiceFactory) Param.getMSF();
    uniqueSuffix++;
    boolean envCreatedOK = false;

    // initialize test table
    if (isMySQLDB) {
      try {
        DBTools.DataSourceInfo legacyDescriptor = dbTools.newDataSourceInfo();
        legacyDescriptor.Name = srcInf.Name;
        legacyDescriptor.User = srcInf.User;
        legacyDescriptor.Password = srcInf.Password;
        legacyDescriptor.Info = srcInf.Info;
        legacyDescriptor.URL = srcInf.URL;
        legacyDescriptor.IsPasswordRequired = srcInf.IsPasswordRequired;
        dbTools.initTestTableUsingJDBC(tableName, legacyDescriptor);
      } catch (java.sql.SQLException e) {
        e.printStackTrace(log);
        throw new StatusException(Status.failed("Couldn't " + " init test table. SQLException..."));
      } catch (java.lang.ClassNotFoundException e) {
        throw new StatusException(Status.failed("Couldn't " + "register mysql driver"));
      }
    } else {
      String oldF = null;
      String newF = null;
      String tempFolder = utils.getOfficeTemp(orb);
      do {
        tableName = "ORowSet_tmp" + uniqueSuffix;
        oldF = utils.getFullURL(origDB);
        newF = tempFolder + tableName + ".dbf";
      } while (!utils.tryOverwriteFile(orb, oldF, newF));
      m_tableFile = newF;
    }

    try {
      m_rowSet = orb.createInstance("com.sun.star.sdb.RowSet");

      XPropertySet rowSetProps = UnoRuntime.queryInterface(XPropertySet.class, m_rowSet);

      log.println("Trying to open: " + tableName);

      rowSetProps.setPropertyValue("DataSourceName", dbSourceName);
      rowSetProps.setPropertyValue("Command", tableName);
      rowSetProps.setPropertyValue("CommandType", new Integer(CommandType.TABLE));

      final XRowSet rowSet = UnoRuntime.queryInterface(XRowSet.class, m_rowSet);
      rowSet.execute();
      m_connection =
          UnoRuntime.queryInterface(
              XConnection.class, rowSetProps.getPropertyValue("ActiveConnection"));

      XResultSet xRes = UnoRuntime.queryInterface(XResultSet.class, m_rowSet);
      xRes.first();

      log.println("creating a new environment for object");
      TestEnvironment tEnv = new TestEnvironment((XInterface) m_rowSet);

      // Adding obj relation for XRowSetApproveBroadcaster test
      {
        final XResultSet resultSet = UnoRuntime.queryInterface(XResultSet.class, m_rowSet);
        final XResultSetUpdate resultSetUpdate =
            UnoRuntime.queryInterface(XResultSetUpdate.class, m_rowSet);
        final XRowUpdate rowUpdate = UnoRuntime.queryInterface(XRowUpdate.class, m_rowSet);
        final PrintWriter logF = log;
        tEnv.addObjRelation(
            "XRowSetApproveBroadcaster.ApproveChecker",
            new ifc.sdb._XRowSetApproveBroadcaster.RowSetApproveChecker() {
              public void moveCursor() {
                try {
                  resultSet.beforeFirst();
                  resultSet.afterLast();
                  resultSet.first();
                } catch (com.sun.star.sdbc.SQLException e) {
                  logF.println(
                      "### _XRowSetApproveBroadcaster.RowSetApproveChecker.moveCursor() :");
                  e.printStackTrace(logF);
                  throw new StatusException("RowSetApproveChecker.moveCursor failed", e);
                }
              }

              public RowChangeEvent changeRow() {
                try {
                  resultSet.first();
                  rowUpdate.updateString(1, "ORowSetTest2");
                  resultSetUpdate.updateRow();
                } catch (com.sun.star.sdbc.SQLException e) {
                  logF.println("### _XRowSetApproveBroadcaster.RowSetApproveChecker.changeRow() :");
                  e.printStackTrace(logF);
                  throw new StatusException("RowSetApproveChecker.changeRow failed", e);
                }
                RowChangeEvent ev = new RowChangeEvent();
                ev.Action = com.sun.star.sdb.RowChangeAction.UPDATE;
                ev.Rows = 1;

                return ev;
              }

              public void changeRowSet() {
                try {
                  // since we gave the row set a parametrized statement, we need to ensure the
                  // parameter is actually filled, otherwise we would get an empty result set,
                  // which would imply some further tests failing
                  XParameters rowSetParams =
                      UnoRuntime.queryInterface(XParameters.class, resultSet);
                  rowSetParams.setString(1, "String2");
                  rowSet.execute();
                  resultSet.first();
                } catch (com.sun.star.sdbc.SQLException e) {
                  logF.println(
                      "### _XRowSetApproveBroadcaster.RowSetApproveChecker.changeRowSet() :");
                  e.printStackTrace(logF);
                  throw new StatusException("RowSetApproveChecker.changeRowSet failed", e);
                }
              }
            });
      }
      // Adding relations for XRow as a Vector with all data
      // of current row of RowSet.

      ArrayList<Object> rowData = new ArrayList<Object>();

      for (int i = 0; i < DBTools.TST_TABLE_VALUES[0].length; i++) {
        rowData.add(DBTools.TST_TABLE_VALUES[0][i]);
      }

      // here XRef must be added
      // here XBlob must be added
      // here XClob must be added
      // here XArray must be added

      tEnv.addObjRelation("CurrentRowData", rowData);

      // Adding relation for XColumnLocate ifc test
      tEnv.addObjRelation("XColumnLocate.ColumnName", DBTools.TST_STRING_F);

      // Adding relation for XCompletedExecution
      tEnv.addObjRelation("InteractionHandlerChecker", new InteractionHandlerImpl());
      try {
        String sqlCommand =
            isMySQLDB
                ? "SELECT Column0  FROM soffice_test_table  WHERE ( (  Column0 = :param1 ) )"
                : "SELECT \"_TEXT\" FROM \"" + tableName + "\" WHERE ( ( \"_TEXT\" = :param1 ) )";
        rowSetProps.setPropertyValue("DataSourceName", dbSourceName);
        rowSetProps.setPropertyValue("Command", sqlCommand);
        rowSetProps.setPropertyValue("CommandType", new Integer(CommandType.COMMAND));
      } catch (Exception e) {
        throw new StatusException("setting up the RowSet with a parametrized command failed", e);
      }

      // Adding relation for XParameters ifc test
      tEnv.addObjRelation("XParameters.ParamValues", new ArrayList<String>());

      // Adding relation for XRowUpdate
      final XRow row = UnoRuntime.queryInterface(XRow.class, m_rowSet);
      tEnv.addObjRelation("XRowUpdate.XRow", row);

      // Adding relation for XResultSetUpdate
      {
        final XResultSet resultSet = UnoRuntime.queryInterface(XResultSet.class, m_rowSet);
        final XRowUpdate rowUpdate = UnoRuntime.queryInterface(XRowUpdate.class, m_rowSet);

        tEnv.addObjRelation(
            "XResultSetUpdate.UpdateTester",
            new ifc.sdbc._XResultSetUpdate.UpdateTester() {
              String lastUpdate = null;

              public int rowCount() throws SQLException {
                int prevPos = resultSet.getRow();
                resultSet.last();
                int count = resultSet.getRow();
                resultSet.absolute(prevPos);

                return count;
              }

              public void update() throws SQLException {
                lastUpdate = row.getString(1);
                lastUpdate += "_";
                rowUpdate.updateString(1, lastUpdate);
              }

              public boolean wasUpdated() throws SQLException {
                String getStr = row.getString(1);
                return lastUpdate.equals(getStr);
              }

              public int currentRow() throws SQLException {
                return resultSet.getRow();
              }
            });
      }

      envCreatedOK = true;
      return tEnv;

    } catch (com.sun.star.uno.Exception e) {
      log.println("couldn't set up test environment:");
      e.printStackTrace(log);
      try {
        if (m_connection != null) m_connection.close();
      } catch (Exception ex) {
      }
      throw new StatusException("couldn't set up test environment", e);
    } finally {
      if (!envCreatedOK) {
        try {
          m_connection.close();
        } catch (Exception ex) {
        }
      }
    }
  } // finish method getTestEnvironment
  protected void initialize(TestParameters tParam, PrintWriter log) {
    // log.println( "creating a draw document" );
    // xTextDoc = WriterTools.createTextDoc(t((XMultiServiceFactory) Param.getMSF));
    tmpDir = utils.getOfficeTemp(((XMultiServiceFactory) tParam.getMSF()));

    origDB = util.utils.getFullTestDocName("TestDB/testDB.dbf");

    dbTools = new DBTools((XMultiServiceFactory) tParam.getMSF(), log);

    // creating DataSource and registering it in DatabaseContext
    String dbURL = (String) tParam.get("test.db.url");
    String dbUser = (String) tParam.get("test.db.user");
    String dbPassword = (String) tParam.get("test.db.password");

    log.println("Creating and registering DataSource ...");
    srcInf = dbTools.newDataSourceInfo();

    if ((dbURL != null) && (dbUser != null) && (dbPassword != null)) {
      isMySQLDB = true;
      log.println("dbURL = " + dbURL);
      log.println("dbUSER = "******"dbPASSWORD = "******"soffice_test_table";
        srcInf.URL = "jdbc:" + dbURL;
        srcInf.IsPasswordRequired = new Boolean(true);
        srcInf.Password = dbPassword;
        srcInf.User = dbUser;

        PropertyValue[] propInfo = new PropertyValue[1];
        propInfo[0] = new PropertyValue();
        propInfo[0].Name = "JavaDriverClass";
        //                propInfo[0].Value = "org.gjt.mm.mysql.Driver";
        propInfo[0].Value = "util.dddriver.Driver";
        srcInf.Info = propInfo;

        dbSrc = srcInf.getDataSourceService();
        dbTools.reRegisterDB(dbSourceName, dbSrc);
      } catch (com.sun.star.uno.Exception e) {
        log.println("Error while object test initialization :");
        e.printStackTrace(log);
        throw new StatusException("Error while object test" + " initialization", e);
      }
    } else {
      // DataSource for sdbc db
      try {
        String myDbUrl = "sdbc:dbase:" + DBTools.dirToUrl(tmpDir);
        srcInf.URL = myDbUrl;

        log.println("try to register '" + myDbUrl + "' as '" + dbSourceName + "'");

        dbSrc = srcInf.getDataSourceService();
        dbTools.reRegisterDB(dbSourceName, dbSrc);
      } catch (com.sun.star.uno.Exception e) {
        log.println("Error while object test initialization :");
        e.printStackTrace(log);
        throw new StatusException("Error while object test initialization", e);
      }

      String oldF = null;
      String newF = null;

      do {
        tableName = "ODatabaseForm_tmp" + uniqueSuffix;
        oldF = utils.getFullURL(origDB);
        newF = utils.getOfficeTemp((XMultiServiceFactory) tParam.getMSF()) + tableName + ".dbf";
      } while (!utils.tryOverwriteFile(((XMultiServiceFactory) tParam.getMSF()), oldF, newF)
          && (uniqueSuffix++ < 50));
    }
  }
  /**
   * Called to create an instance of <code>TestEnvironment</code> with an object to test and related
   * objects. Subclasses should implement this method to provide the implementation and related
   * objects. The method is called from <code>getTestEnvironment()</code>.
   *
   * @param tParam test parameters
   * @param log writer to log information while testing
   * @see TestEnvironment
   * @see #getTestEnvironment
   */
  @Override
  protected TestEnvironment createTestEnvironment(TestParameters tParam, PrintWriter log)
      throws Exception {

    log.println("creating a test environment");

    if (xTextDoc != null) {
      xTextDoc.dispose(); // get a soffice factory object
    }
    SOfficeFactory SOF = SOfficeFactory.getFactory(tParam.getMSF());

    log.println("creating a text document");
    xTextDoc = SOF.createTextDoc(null);

    util.utils.waitForEventIdle(tParam.getMSF());

    XModel aModel1 = UnoRuntime.queryInterface(XModel.class, xTextDoc);

    XController secondController = aModel1.getCurrentController();

    XDispatchProvider aProv = UnoRuntime.queryInterface(XDispatchProvider.class, secondController);

    XDispatch getting = null;

    log.println("opening DatasourceBrowser");
    URL the_url = new URL();
    the_url.Complete = ".component:DB/DataSourceBrowser";
    getting = aProv.queryDispatch(the_url, "_beamer", 12);
    PropertyValue[] noArgs = new PropertyValue[0];
    getting.dispatch(the_url, noArgs);

    util.utils.waitForEventIdle(tParam.getMSF());

    XFrame the_frame1 = the_Desk.getCurrentFrame();

    if (the_frame1 == null) {
      log.println("Current frame was not found !!!");
    }

    XFrame the_frame2 = the_frame1.findFrame("_beamer", 4);

    the_frame2.setName("DatasourceBrowser");

    XInterface oObj = null;

    final XSelectionSupplier xSelect =
        UnoRuntime.queryInterface(XSelectionSupplier.class, the_frame2.getController());

    PropertyValue[] params =
        new PropertyValue[] {new PropertyValue(), new PropertyValue(), new PropertyValue()};
    params[0].Name = "DataSourceName";
    params[0].Value = "Bibliography";
    params[1].Name = "CommandType";
    params[1].Value = Integer.valueOf(com.sun.star.sdb.CommandType.TABLE);
    params[2].Name = "Command";
    params[2].Value = "biblio";

    final PropertyValue[] fParams = params;

    util.utils.waitForEventIdle(tParam.getMSF());

    XWindow xWindow = secondController.getFrame().getContainerWindow();

    XAccessible xRoot = AccessibilityTools.getAccessibleObject(xWindow);

    AccessibilityTools.printAccessibleTree(
        log, xRoot, tParam.getBool(util.PropertyName.DEBUG_IS_ACTIVE));

    oObj =
        AccessibilityTools.getAccessibleObjectForRole(
            xRoot, AccessibleRole.PANEL, "", "AccessibleBrowseBox");

    log.println("ImplementationName: " + util.utils.getImplName(oObj));

    TestEnvironment tEnv = new TestEnvironment(oObj);

    tEnv.addObjRelation(
        "EventProducer",
        new ifc.accessibility._XAccessibleEventBroadcaster.EventProducer() {

          public void fireEvent() {
            try {
              xSelect.select(fParams);
            } catch (com.sun.star.lang.IllegalArgumentException e) {
              e.printStackTrace();
            }
          }
        });

    return tEnv;
  }
 /**
  * Called while the <code>TestCase</code> initialization. Creates a text document.
  *
  * @param Param test parameters
  * @param log writer to log information while testing
  * @see #initializeTestCase
  */
 protected void initialize(TestParameters Param, PrintWriter log) {
   log.println("creating a text document");
   xTextDoc = WriterTools.createTextDoc((XMultiServiceFactory) Param.getMSF());
 }