diff options
Diffstat (limited to 'qadevOOo/tests/java/ifc/sdb/_XSingleSelectQueryComposer.java')
| -rw-r--r-- | qadevOOo/tests/java/ifc/sdb/_XSingleSelectQueryComposer.java | 521 |
1 files changed, 521 insertions, 0 deletions
diff --git a/qadevOOo/tests/java/ifc/sdb/_XSingleSelectQueryComposer.java b/qadevOOo/tests/java/ifc/sdb/_XSingleSelectQueryComposer.java new file mode 100644 index 000000000..53b31f693 --- /dev/null +++ b/qadevOOo/tests/java/ifc/sdb/_XSingleSelectQueryComposer.java @@ -0,0 +1,521 @@ +/* + * This file is part of the LibreOffice project. + * + * This Source Code Form is subject to the terms of the Mozilla Public + * License, v. 2.0. If a copy of the MPL was not distributed with this + * file, You can obtain one at http://mozilla.org/MPL/2.0/. + * + * This file incorporates work covered by the following license notice: + * + * Licensed to the Apache Software Foundation (ASF) under one or more + * contributor license agreements. See the NOTICE file distributed + * with this work for additional information regarding copyright + * ownership. The ASF licenses this file to you under the Apache + * License, Version 2.0 (the "License"); you may not use this file + * except in compliance with the License. You may obtain a copy of + * the License at http://www.apache.org/licenses/LICENSE-2.0 . + */ + +package ifc.sdb; + +import com.sun.star.sdb.XSingleSelectQueryComposer; +import lib.MultiMethodTest; +import com.sun.star.sdb.XSingleSelectQueryAnalyzer; +import com.sun.star.sdbc.XResultSet; +import com.sun.star.uno.AnyConverter; +import com.sun.star.uno.UnoRuntime; +import lib.StatusException; +import lib.Status; +import com.sun.star.beans.PropertyValue; +import com.sun.star.beans.XPropertySet; +import com.sun.star.sdb.SQLFilterOperator; +import com.sun.star.sdbc.SQLException; + +/** +* Testing <code>com.sun.star.sdb.XSingleSelectQueryComposer</code> +* interface methods : +* <ul> +* <li><code>setFilter()</code></li> +* <li><code>setStructuredFilter()</code></li> +* <li><code>appendFilterByColumn()</code></li> +* <li><code>appendGroupByColumn()</code></li> +* <li><code>setGroup()</code></li> +* <li><code>setHavingClause()</code></li> +* <li><code>setStructuredHavingClause()</code></li> +* <li><code>appendHavingClauseByColumn()</code></li> +* <li><code>appendOrderByColumn()</code></li> +* <li><code>setOrder()</code></li> + +* </ul> <p> +* @see com.sun.star.sdb.XSingleSelectQueryComposer +*/ +public class _XSingleSelectQueryComposer extends MultiMethodTest { + + // oObj filled by MultiMethodTest + public XSingleSelectQueryComposer oObj = null ; + + private XSingleSelectQueryAnalyzer xQueryAna = null; + + private XPropertySet xProp = null; + + private String colName = null; + + private XResultSet xReSet = null; + + /** + * Retrieves the object relations: + * <ul> + * <li><code>XSingleSelectQueryAnalyzer xQueryAna</code></li> + * <li><code>XPropertySet xProp</code></li> + * <li><code>String colName</code></li> + * </ul> <p> + * @see com.sun.star.sdb.XSingleSelectQueryAnalyzer + * @see com.sun.star.beans.XPropertySet + */ + @Override + protected void before() /* throws Exception*/ { + + xQueryAna = UnoRuntime.queryInterface(XSingleSelectQueryAnalyzer.class, + tEnv.getObjRelation("xQueryAna")); + + if (xQueryAna == null) { + throw new StatusException(Status.failed( + "Couldn't get object relation 'xQueryAna'. Test must be modified")); + + } + + xProp = UnoRuntime.queryInterface(XPropertySet.class, + tEnv.getObjRelation("xProp")); + + if (xProp == null) { + throw new StatusException(Status.failed( + "Couldn't get object relation 'xProp'. Test must be modified")); + + } + + xReSet = UnoRuntime.queryInterface(XResultSet.class, + tEnv.getObjRelation("xResultSet")); + + if (xReSet == null) { + throw new StatusException(Status.failed( + "Couldn't get object relation 'xResultSet'. Test must be modified")); + + } + + try + { + colName = AnyConverter.toString(tEnv.getObjRelation("colName")); + } + catch (com.sun.star.lang.IllegalArgumentException e) + { + colName = null; + } + + if (colName == null) { + throw new StatusException(Status.failed( + "Couldn't get object relation 'colName'. Test must be modified")); + + } + + } + + + /** + * Object relation <code>xQueryAna</code> set a filter. This filter + * must returned while calling <code>getFilter</code> + */ + public void _setFilter() { + try{ + String filter = "\"Identifier\" = 'BOR02b'"; + oObj.setFilter(filter); + tRes.tested("setFilter()", xQueryAna.getFilter().equals(filter)); + + } catch (SQLException e){ + log.println("unexpected Exception: " + e.toString()); + tRes.tested("setFilter()", false); + } + } + + /** + * Object relation <code>xQueryAna</code> set a complex filter with method + . <code>setFilter</code>. Then <code>getStructuredFilter</code> returns a + * sequence of <code>PropertyValue</code> which was set with method + * <code>setStructuredFilter</code> from <code>xQueryAna</code>. + * Then test has ok status if <code>getFilter</code> returns the complex filter. + */ + public void _setStructuredFilter() { + requiredMethod("setFilter()"); + try{ + xQueryAna.setQuery("SELECT \"Identifier\", \"Type\", \"Address\" FROM \"biblio\" \"biblio\""); + String complexFilter = "( \"Identifier\" >= '1' AND \"Type\" <= '4' ) OR ( \"Identifier\" <> '2' AND \"Type\" = '5' ) OR ( \"Identifier\" < '3' AND \"Type\" > '6' AND \"Address\" = '7' ) OR ( \"Address\" >= '8' ) OR ( \"Type\" = '9' )"; + oObj.setFilter(complexFilter); + PropertyValue[][] aStructuredFilter = xQueryAna.getStructuredFilter(); + oObj.setFilter(""); + oObj.setStructuredFilter(aStructuredFilter); + tRes.tested("setStructuredFilter()", xQueryAna.getFilter().equals(complexFilter)); + + } catch (SQLException e){ + log.println("unexpected Exception: " + e.toString()); + tRes.tested("setStructuredFilter()", false); + } catch (com.sun.star.lang.IllegalArgumentException e){ + log.println("unexpected Exception: " + e.toString()); + tRes.tested("setStructuredFilter()", false); + } + } + + /** + * At first the object relation <code>xProp</code> was set as parameter. + * Relation <code>xQueryAna</code> was used to check if relation + * <code>colName</code> was found. + * Second an empty <code>XPropertySet</code> was used as parameter. A + * <code>SQLException</code> must be thrown. + */ + public void _appendFilterByColumn() { + boolean ok = true; + try + { + xReSet.beforeFirst(); + } + catch (SQLException e) + { + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendFilterByColumn()", false); + } + try + { + oObj.appendFilterByColumn(xProp, true,SQLFilterOperator.EQUAL); + log.println("expected Exception was not thrown"); + tRes.tested("appendFilterByColumn()", false); + ok = false; + } + catch (com.sun.star.uno.RuntimeException e) + { + log.println("expected Exception: " + e.toString()); + ok = ok && true; + } + catch (SQLException e) + { + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendFilterByColumn()", false); + } + catch (com.sun.star.lang.WrappedTargetException e) + { + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendFilterByColumn()", false); + } + + try + { + xReSet.first(); + } + catch (SQLException e) + { + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendFilterByColumn()", false); + } + try{ + + oObj.appendFilterByColumn(xProp, true,SQLFilterOperator.EQUAL); + log.println("appendFilterByColumn: " + xQueryAna.getFilter()); + ok = ok && (xQueryAna.getFilter().indexOf(colName) > 0); + + } catch (SQLException e){ + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendFilterByColumn()", false); + } + catch (com.sun.star.lang.WrappedTargetException e) + { + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendFilterByColumn()", false); + } + + try{ + + oObj.appendFilterByColumn(xProp, false,SQLFilterOperator.EQUAL); + log.println("appendFilterByColumn: " + xQueryAna.getFilter()); + ok = ok && (xQueryAna.getFilter().indexOf(colName) > 0); + + } catch (SQLException e){ + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendFilterByColumn()", false); + } catch (com.sun.star.lang.WrappedTargetException e) + { + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendFilterByColumn()", false); + } + + try{ + XPropertySet dummy = null; + oObj.appendFilterByColumn(dummy, true,SQLFilterOperator.EQUAL); + log.println("expected Exception was not thrown"); + tRes.tested("appendFilterByColumn()", false); + + } catch (SQLException e){ + log.println("expected Exception"); + ok = ok && true; + } catch (com.sun.star.lang.WrappedTargetException e) + { + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendFilterByColumn()", false); + } + + try + { + xReSet.beforeFirst(); + } + catch (SQLException e) + { + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendFilterByColumn()", false); + } + tRes.tested("appendFilterByColumn()", ok); + } + + /** + * At first the object relation <code>xProp</code> was used as parameter. + * Relation <code>xQueryAna</code> was used to check if relation + * <code>colName</code> was found. + * Second an empty <code>XPropertySet</code> was used as parameter. An + * <code>SQLException</code> must be thrown. + */ + public void _appendGroupByColumn() { + boolean ok = true; + try{ + + oObj.appendGroupByColumn(xProp); + log.println("appendGroupByColumn: " + xQueryAna.getFilter()); + ok = ok && (xQueryAna.getFilter().indexOf(colName) > 0); + + } catch (SQLException e){ + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendGroupByColumn()", false); + } + try{ + XPropertySet dummy = null; + oObj.appendGroupByColumn(dummy); + log.println("expected Exception was not thrown"); + tRes.tested("appendGroupByColumn()", false); + + } catch (SQLException e){ + log.println("expected Exception"); + ok = ok && true; + } + tRes.tested("appendGroupByColumn()", ok); + } + + /** + * The group which was set by <code>setGroup</code> must be returned + * while calling from object relation <code>XQueryAna</code> + * method <code>getGroup</code> + */ + public void _setGroup() { + try{ + String group = "\"Identifier\""; + oObj.setGroup(group); + tRes.tested("setGroup()", xQueryAna.getGroup().equals(group)); + + } catch (SQLException e){ + log.println("unexpected Exception: " + e.toString()); + tRes.tested("setGroup()", false); + } + } + + + /** + * The clause which was set by <code>setHavingClause</code> must be returned + * while calling from object relation <code>XQueryAna</code> + * method <code>getHavingClause</code> + */ + public void _setHavingClause() { + try{ + String clause = "\"Identifier\" = 'BOR02b'"; + oObj.setHavingClause(clause); + tRes.tested("setHavingClause()", + xQueryAna.getHavingClause().equals(clause)); + + } catch (SQLException e){ + log.println("unexpected Exception: " + e.toString()); + tRes.tested("setHavingClause()", false); + } + } + + /** + * At first <code>setHavingClause</code> sets a complex clause. + * Then method <code>getStructuredHavingClause</code> from object relation + * <code>xQueryAna</code> returns a valid <code>PropertyValue[][]</code> + * Method <code>setHavingClause</code> was called with an empty string to + * reset filter. Now <code>setStructuredHavingClause</code> with the valid + * <code>PropertyValue[][]</code> as parameter was called. + * Test is ok if <code>getHavingClause</code> from <code>xQueryAna</code> + * returns the complex clause from beginning. + * <p> + * required methods: + *<ul> + * <li><code>setHavingClause</code></li> + * <li><code>setStructuredFilter</code></li> + *</ul> + */ + public void _setStructuredHavingClause() { + requiredMethod("setHavingClause()"); + executeMethod("setStructuredFilter()"); + String complexFilter = "( \"Identifier\" >= '1' AND \"Type\" <= '4' ) OR ( \"Identifier\" <> '2' AND \"Type\" = '5' ) OR ( \"Identifier\" < '3' AND \"Type\" > '6' AND \"Address\" = '7' ) OR ( \"Address\" >= '8' ) OR ( \"Type\" = '9' )"; + try{ + oObj.setHavingClause(complexFilter); + PropertyValue[][] aStructuredHaving = + xQueryAna.getStructuredHavingClause(); + oObj.setHavingClause(""); + oObj.setStructuredHavingClause(aStructuredHaving); + tRes.tested("setStructuredHavingClause()", + xQueryAna.getHavingClause().equals(complexFilter)); + + } catch (SQLException e){ + log.println("unexpected Exception: " + e.toString()); + tRes.tested("setStructuredHavingClause()", false); + } + } + + /** + * First object relation <code>xProp</code> was used as parameter. Relation + * <code>xQueryAna</code> was used to check if relation <code>colName</code> + * was found. + * Second an empty <code>XPropertySet</code> was given as parameter. An + * <code>SQLException</code> must be thrown. + */ + public void _appendHavingClauseByColumn() { + boolean ok = true; + try + { + xReSet.beforeFirst(); + } + catch (SQLException e) + { + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendHavingClauseByColumn()", false); + } + try{ + + oObj.appendHavingClauseByColumn(xProp, true,SQLFilterOperator.EQUAL); + log.println("expected Exception was not thrown"); + tRes.tested("appendHavingClauseByColumn()", false); + ok = false; + + } + catch (com.sun.star.uno.RuntimeException e) + { + log.println("expected Exception: " + e.toString()); + ok = ok && true; + } + catch (SQLException e) + { + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendHavingClauseByColumn()", false); + } catch (com.sun.star.lang.WrappedTargetException e) + { + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendHavingClauseByColumn()", false); + } + + try + { + xReSet.first(); + } + catch (SQLException e) + { + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendHavingClauseByColumn()", false); + } + try{ + + oObj.appendHavingClauseByColumn(xProp, true,SQLFilterOperator.EQUAL); + log.println("appendHavingClauseByColumn: " + xQueryAna.getFilter()); + ok = ok && (xQueryAna.getFilter().indexOf(colName) > 0); + + } catch (SQLException e){ + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendHavingClauseByColumn()", false); + } catch (com.sun.star.lang.WrappedTargetException e) + { + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendHavingClauseByColumn()", false); + } + + try{ + XPropertySet dummy = null; + oObj.appendHavingClauseByColumn(dummy, true,SQLFilterOperator.EQUAL); + log.println("expected Exception was not thrown"); + tRes.tested("appendHavingClauseByColumn()", false); + + } catch (SQLException e){ + log.println("expected Exception"); + ok = ok && true; + } catch (com.sun.star.lang.WrappedTargetException e) + { + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendHavingClauseByColumn()", false); + } + + // cleanup + try + { + xReSet.beforeFirst(); + } + catch (SQLException e) + { + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendHavingClauseByColumn()", false); + } + tRes.tested("appendHavingClauseByColumn()", ok); + } + + /** + * First object relation <code>xProp</code> was set as parameter. Relation + * <code>xQueryAna</code> was used to check if relation <code>colName</code> + * was found. + * Second an empty <code>XPropertySet</code> was given as parameter. An + * <code>SQLException</code> must be thrown. + */ + public void _appendOrderByColumn() { + boolean ok = true; + try{ + + oObj.appendOrderByColumn(xProp, true); + log.println("appendOrderByColumn: " + xQueryAna.getFilter()); + ok = ok && (xQueryAna.getFilter().indexOf(colName) > 0); + + } catch (SQLException e){ + log.println("unexpected Exception: " + e.toString()); + tRes.tested("appendOrderByColumn()", false); + } + try{ + XPropertySet dummy = null; + oObj.appendOrderByColumn(dummy, true); + log.println("expected Exception was not thrown"); + tRes.tested("appendOrderByColumn()", false); + + } catch (SQLException e){ + log.println("expected Exception"); + ok = ok && true; + } + tRes.tested("appendOrderByColumn()", ok); + } + + + /** + * Method <code>getOrder</code> from object relation <code>xQueryAna</code> + * checks the order which was set while calling <code>setOrder</code> + */ + public void _setOrder() { + try{ + String order = "\"Identifier\""; + oObj.setOrder(order); + tRes.tested("setOrder()", xQueryAna.getOrder().equals(order)); + + } catch (SQLException e){ + log.println("unexpected Exception: " + e.toString()); + tRes.tested("setOrder()", false); + } + } + + + +} // finish class _XSingleSelectQueryComposer |