@Override public void handle(Object aFormComponent) throws com.sun.star.uno.Exception { // the name of the child XNamed xName = UnoRuntime.queryInterface(XNamed.class, aFormComponent); // if it's a form control model, check it's type XPropertySet xProps = UNO.queryPropertySet(aFormComponent); String sTypeName = FLTools.classifyFormComponentType(xProps); String sName; if (null == xName) sName = "<unnamed>"; else sName = xName.getName(); // print the component's name if (0 != sTypeName.length()) { System.out.println(m_sPrefix + sName + " (" + sTypeName + ")"); } else { System.out.println(m_sPrefix + sName); } // let the super class step down the tree m_sPrefix = m_sPrefix + " "; super.handle(aFormComponent); m_sPrefix = m_sPrefix.substring(0, m_sPrefix.length() - 1); }
public static String getDrawPageName(XDrawPage xComponent) { // XComponent xComponent ){ XNamed xNamed = (XNamed) UnoRuntime.queryInterface(XNamed.class, xComponent); if (null == xNamed) { logger.info("PageHelper.getDrawPageName() " + " XNamed not found."); return null; } else { return xNamed.getName(); } }
/** * enumerates and prints all the elements in the given container, together with the container * itself */ protected void enumFormComponents(XNameAccess xContainer) throws java.lang.Exception { String sObjectName; XNamed xNameAcc = UnoRuntime.queryInterface(XNamed.class, xContainer); if (null == xNameAcc) sObjectName = "<unnamed>"; else sObjectName = xNameAcc.getName(); System.out.println("enumerating the container named \"" + sObjectName + "\"\n"); PrintComponentTree aPrinter = new PrintComponentTree(); aPrinter.handle(xContainer); }
private void insertBookmark(XTextCursor crsr, String name, String content) throws com.sun.star.uno.Exception { XMultiServiceFactory xDocFactory = UnoRuntime.queryInterface(XMultiServiceFactory.class, m_xDoc); Object xBookmark = xDocFactory.createInstance("com.sun.star.text.Bookmark"); XTextContent xBookmarkAsTextContent = UnoRuntime.queryInterface(XTextContent.class, xBookmark); crsr.setString(content); XNamed xBookmarkAsNamed = UnoRuntime.queryInterface(XNamed.class, xBookmark); xBookmarkAsNamed.setName(name); m_xDoc.getText().insertTextContent(crsr, xBookmarkAsTextContent, true); }
private void insertRefMark( OOComponentHelper ooHandle, XTextCursor thisCursor, String referenceName) { Object referenceMark = ooHandle.createInstance("com.sun.star.text.ReferenceMark"); XNamed xRefMark = ooQueryInterface.XNamed(referenceMark); xRefMark.setName(referenceName); XTextContent xContent = ooQueryInterface.XTextContent(xRefMark); try { thisCursor.getText().insertTextContent(thisCursor, xContent, true); } catch (Exception ex) { log.error("insertReferenceMark :" + ex.getMessage()); } }
/** * 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; }
@Override protected TestEnvironment createTestEnvironment(TestParameters Param, PrintWriter log) throws Exception { XInterface oObj = null; XInterface datapilotfield = null; // creation of testobject here // first we write what we are intend to do to log file log.println("Creating a test environment"); // the cell range CellRangeAddress sCellRangeAdress = new CellRangeAddress(); sCellRangeAdress.Sheet = 0; sCellRangeAdress.StartColumn = 1; sCellRangeAdress.StartRow = 0; sCellRangeAdress.EndColumn = mMaxFieldIndex - 1; sCellRangeAdress.EndRow = mMaxFieldIndex - 1; // position of the data pilot table CellAddress sCellAdress = new CellAddress(); sCellAdress.Sheet = 0; sCellAdress.Column = 7; sCellAdress.Row = 8; log.println("Getting a sheet"); XSpreadsheets xSpreadsheets = xSheetDoc.getSheets(); XSpreadsheet oSheet = null; XSpreadsheet oSheet2 = null; XIndexAccess oIndexAccess = UnoRuntime.queryInterface(XIndexAccess.class, xSpreadsheets); // Make sure there are at least two sheets xSpreadsheets.insertNewByName("Some Sheet", (short) 0); oSheet = (XSpreadsheet) AnyConverter.toObject(new Type(XSpreadsheet.class), oIndexAccess.getByIndex(0)); oSheet2 = (XSpreadsheet) AnyConverter.toObject(new Type(XSpreadsheet.class), oIndexAccess.getByIndex(1)); log.println("Filling a table"); for (int i = 1; i < mMaxFieldIndex; i++) { oSheet.getCellByPosition(i, 0).setFormula("Col" + i); oSheet.getCellByPosition(0, i).setFormula("Row" + i); oSheet2.getCellByPosition(i, 0).setFormula("Col" + i); oSheet2.getCellByPosition(0, i).setFormula("Row" + i); } for (int i = 1; i < mMaxFieldIndex; i++) { for (int j = 1; j < mMaxFieldIndex; j++) { oSheet.getCellByPosition(i, j).setValue(i * (j + 1)); oSheet2.getCellByPosition(i, j).setValue(i * (j + 2)); } } oSheet.getCellByPosition(1, 1).setFormula("aName"); oSheet.getCellByPosition(1, 2).setFormula("otherName"); oSheet.getCellByPosition(1, 3).setFormula("una"); oSheet.getCellByPosition(1, 4).setFormula("otherName"); oSheet.getCellByPosition(1, 5).setFormula("somethingelse"); oSheet.getCellByPosition(1, 5); int x = sCellAdress.Column; int y = sCellAdress.Row + 3; oSheet.getCellByPosition(x, y); // create the test objects log.println("Getting test objects"); XDataPilotTablesSupplier DPTS = UnoRuntime.queryInterface(XDataPilotTablesSupplier.class, oSheet); XDataPilotTables DPT = DPTS.getDataPilotTables(); XDataPilotDescriptor DPDsc = DPT.createDataPilotDescriptor(); DPDsc.setSourceRange(sCellRangeAdress); XPropertySet fieldPropSet = null; Object oDataPilotField = DPDsc.getDataPilotFields().getByIndex(0); fieldPropSet = UnoRuntime.queryInterface(XPropertySet.class, oDataPilotField); fieldPropSet.setPropertyValue("Orientation", com.sun.star.sheet.DataPilotFieldOrientation.ROW); oDataPilotField = DPDsc.getDataPilotFields().getByIndex(1); fieldPropSet = UnoRuntime.queryInterface(XPropertySet.class, oDataPilotField); fieldPropSet.setPropertyValue("Function", com.sun.star.sheet.GeneralFunction.SUM); fieldPropSet.setPropertyValue("Orientation", com.sun.star.sheet.DataPilotFieldOrientation.DATA); oDataPilotField = DPDsc.getDataPilotFields().getByIndex(2); fieldPropSet = UnoRuntime.queryInterface(XPropertySet.class, oDataPilotField); fieldPropSet.setPropertyValue( "Orientation", com.sun.star.sheet.DataPilotFieldOrientation.COLUMN); log.println("Insert the DataPilotTable"); if (DPT.hasByName("DataPilotTable")) { DPT.removeByName("DataPilotTable"); } DPT.insertNewByName("DataPilotTable", sCellAdress, DPDsc); XIndexAccess xIA = UnoRuntime.queryInterface(XIndexAccess.class, DPTS.getDataPilotTables()); XIndexAccess IA = null; XDataPilotDescriptor xDPT = UnoRuntime.queryInterface(XDataPilotDescriptor.class, xIA.getByIndex(0)); IA = xDPT.getRowFields(); System.out.println("COUNT: " + IA.getCount()); datapilotfield = (XInterface) AnyConverter.toObject(new Type(XInterface.class), IA.getByIndex(0)); try { XDataPilotFieldGrouping dpfg = UnoRuntime.queryInterface(XDataPilotFieldGrouping.class, datapilotfield); String[] elements = new String[] {"aName", "otherName"}; dpfg.createNameGroup(elements); DataPilotFieldGroupInfo dpgi = null; xIA = UnoRuntime.queryInterface(XIndexAccess.class, DPTS.getDataPilotTables()); XDataPilotDescriptor xDPT2 = UnoRuntime.queryInterface(XDataPilotDescriptor.class, xIA.getByIndex(0)); IA = xDPT2.getRowFields(); for (int i = 0; i < IA.getCount(); i++) { datapilotfield = (XInterface) AnyConverter.toObject(new Type(XInterface.class), IA.getByIndex(i)); XPropertySet xPropertySet = UnoRuntime.queryInterface(XPropertySet.class, IA.getByIndex(i)); if (((Boolean) xPropertySet.getPropertyValue("IsGroupField")).booleanValue()) { xPropertySet = UnoRuntime.queryInterface(XPropertySet.class, datapilotfield); XNamed xNamed = UnoRuntime.queryInterface(XNamed.class, IA.getByIndex(i)); System.out.println("name: " + xNamed.getName()); dpgi = (DataPilotFieldGroupInfo) xPropertySet.getPropertyValue("GroupInfo"); } } oObj = dpgi.Groups; } catch (Exception e) { e.printStackTrace(); } log.println("Creating object - " + ((oObj == null) ? "FAILED" : "OK")); TestEnvironment tEnv = new TestEnvironment(oObj); log.println("Implementationname: " + util.utils.getImplName(oObj)); // Other parameters required for interface tests 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