Adding upstream version 1:7.0.4.upstream/1%7.0.4upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

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