/**
* Through <code>XEnumeration</code> interface an element from the set is retrieved. Then this
* element removed.
*
* <p>Has <b> OK </b> status if after removing <code>has()</code> method returns false.
*/
public void _remove() {
requiredMethod("insert()");
boolean res = true;
try {
// get an element to be removed/inserted
oObj.remove(element);
if (oObj.has(element)) {
res = false;
log.println("After removing element method has()" + " returned true");
hasResult = false;
}
} catch (com.sun.star.container.NoSuchElementException e) {
e.printStackTrace(log);
res = false;
} catch (com.sun.star.lang.IllegalArgumentException e) {
e.printStackTrace(log);
res = false;
}
tRes.tested("remove()", res);
}
/** Removes added element from AutoTextGroup */
protected void cleanup(TestParameters Param, PrintWriter log) {
try {
if (oGroup.hasByName("NewEntryName")) {
log.println("Removing 'NewEntryName' element");
oGroup.removeByName("NewEntryName");
}
} catch (com.sun.star.container.NoSuchElementException e) {
log.println("Cannot remove TextEntry from group...");
e.printStackTrace(log);
}
log.println("disposing xTextDoc ");
util.DesktopTools.closeDoc(xTextDoc);
}
private boolean action_removeSectionWithoutContents(OOComponentHelper ooDoc, String sectionName) {
boolean bResult = false;
try {
XTextSection theSection = ooDocument.getSection(sectionName);
XText docText = ooDocument.getTextDocument().getText();
docText.removeTextContent(theSection);
bResult = true;
} catch (NoSuchElementException ex) {
log.error("in removeSectionWIthoutContents : " + ex.getLocalizedMessage(), ex);
bResult = false;
} finally {
return bResult;
}
}
/**
* Removes the text contet added before.
*
* <p>Has <b> OK </b> status if the method successfully returns and no exceptions were thrown.
*
* <p>The following method tests are to be completed successfully before :
*
* <ul>
* <li><code> insertTextContent() </code> : inserts the content to be removed in this test.
* </ul>
*/
public void _removeTextContent() {
// leads to a method which should be called previously
requiredMethod("insertTextContent()");
// write to log what we try next
log.println("test for removeTextContent");
try {
oObj.removeTextContent((XTextContent) oInt);
// oObj.removeTextContent( (XTextContent)oInt );
} catch (com.sun.star.container.NoSuchElementException nseE) {
// Some exception.FAILED
Status.failed(nseE.toString());
return;
}
// no exception occurred so it works
tRes.tested("removeTextContent()", true);
}
/**
* 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 */
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
/**
* Creating a Testenvironment for the interfaces to be tested. Retrieves the collection of style
* families available in the document using the interface <code>XStyleFamiliesSupplier</code>.
* Obtains default style from the style family <code>'PageStyles'</code>. Retrieves value of the
* property <code>'RightPageHeaderContent'</code>. Sets some string for the text which is printed
* in the center part of the header or footer using the interface <code>XHeaderFooterContent
* </code> and sets new value of the property <code>'RightPageHeaderContent'</code>. Creates text
* cursor for the text which is printed in the center part of the header or footer. This text
* cursor is the instance of the service <code>com.sun.star.text.TextCursor</code>.
* </ul>
*/
protected TestEnvironment createTestEnvironment(TestParameters tParam, PrintWriter log) {
XInterface oObj = null;
XPropertySet PropSet;
XNameAccess PageStyles = null;
XStyle StdStyle = null;
XStyleFamiliesSupplier StyleFam =
UnoRuntime.queryInterface(XStyleFamiliesSupplier.class, xSpreadsheetDoc);
XNameAccess StyleFamNames = StyleFam.getStyleFamilies();
try {
PageStyles =
(XNameAccess)
AnyConverter.toObject(
new Type(XNameAccess.class), StyleFamNames.getByName("PageStyles"));
StdStyle =
(XStyle) AnyConverter.toObject(new Type(XStyle.class), PageStyles.getByName("Default"));
} catch (com.sun.star.lang.WrappedTargetException e) {
e.printStackTrace(log);
throw new StatusException("Couldn't get by name", e);
} catch (com.sun.star.container.NoSuchElementException e) {
e.printStackTrace(log);
throw new StatusException("Couldn't get by name", e);
} catch (com.sun.star.lang.IllegalArgumentException e) {
e.printStackTrace(log);
throw new StatusException("Couldn't get by name", e);
}
// get the property-set
PropSet = UnoRuntime.queryInterface(XPropertySet.class, StdStyle);
XHeaderFooterContent RPHC = null;
// creation of testobject here
// first we write what we are intend to do to log file
log.println("creating a test environment");
try {
RPHC =
(XHeaderFooterContent)
AnyConverter.toObject(
new Type(XHeaderFooterContent.class),
PropSet.getPropertyValue("RightPageHeaderContent"));
} catch (com.sun.star.lang.WrappedTargetException e) {
e.printStackTrace(log);
throw new StatusException("Couldn't get HeaderContent", e);
} catch (com.sun.star.beans.UnknownPropertyException e) {
e.printStackTrace(log);
throw new StatusException("Couldn't get HeaderContent", e);
} catch (com.sun.star.lang.IllegalArgumentException e) {
e.printStackTrace(log);
throw new StatusException("Couldn't get HeaderContent", e);
}
XText center = RPHC.getCenterText();
center.setString("CENTER");
try {
PropSet.setPropertyValue("RightPageHeaderContent", RPHC);
} catch (com.sun.star.lang.WrappedTargetException e) {
e.printStackTrace(log);
throw new StatusException("Couldn't set HeaderContent", e);
} catch (com.sun.star.lang.IllegalArgumentException e) {
e.printStackTrace(log);
throw new StatusException("Couldn't set HeaderContent", e);
} catch (com.sun.star.beans.PropertyVetoException e) {
e.printStackTrace(log);
throw new StatusException("Couldn't set HeaderContent", e);
} catch (com.sun.star.beans.UnknownPropertyException e) {
e.printStackTrace(log);
throw new StatusException("Couldn't set HeaderContent", e);
}
// create testobject here
oObj = center.createTextCursor();
TestEnvironment tEnv = new TestEnvironment(oObj);
// add relation for XTextRange
tEnv.addObjRelation("XTEXT", UnoRuntime.queryInterface(XText.class, center));
return tEnv;
} // finish method getTestEnvironment
