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, 290 insertions, 0 deletions

diff --git a/qadevOOo/tests/java/ifc/sdb/_XSingleSelectQueryAnalyzer.java b/qadevOOo/tests/java/ifc/sdb/_XSingleSelectQueryAnalyzer.java
new file mode 100644
index 000000000..39aabf688
--- /dev/null
+++ b/qadevOOo/tests/java/ifc/sdb/_XSingleSelectQueryAnalyzer.java
@@ -0,0 +1,290 @@
+/*
+ * 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.XSingleSelectQueryAnalyzer;
+import lib.MultiMethodTest;
+import com.sun.star.sdb.XSingleSelectQueryComposer;
+import com.sun.star.uno.UnoRuntime;
+import lib.StatusException;
+import lib.Status;
+import com.sun.star.beans.PropertyValue;
+import com.sun.star.container.XIndexAccess;
+
+/**
+* Testing <code>com.sun.star.sdb.XSingleSelectQueryAnalyzer</code>
+* interface methods :
+* <ul>
+*  <li><code>getQuery()</code></li>
+*  <li><code>setQuery()</code></li>
+*  <li><code>getFilter()</code></li>
+*  <li><code>getStructuredFilter()</code></li>
+*  <li><code>getGroup()</code></li>
+*  <li><code>getGroupColumns()</code></li>
+*  <li><code>getHavingClause()</code></li>
+*  <li><code>getStructuredHavingClause()</code></li>
+*  <li><code>getOrder()</code></li>
+*  <li><code>getOrderColumns()</code></li>
+
+* </ul> <p>
+* @see com.sun.star.sdb.XSingleSelectQueryAnalyzer
+*/
+public class _XSingleSelectQueryAnalyzer extends MultiMethodTest {
+
+    // oObj filled by MultiMethodTest
+    public XSingleSelectQueryAnalyzer oObj = null ;
+
+    private static final String queryString = "SELECT * FROM \"biblio\"";
+
+    private XSingleSelectQueryComposer xComposer = null;
+
+    /**
+     * Receives the object relations:
+    * <ul>
+    *  <li><code>XSingleSelectQueryComposer xCompoer</code></li>
+    * </ul> <p>
+     * @see com.sun.star.sdb.XSingleSelectQueryComposer
+     */
+    @Override
+    protected void before() {
+
+        xComposer = UnoRuntime.queryInterface(XSingleSelectQueryComposer.class,
+          tEnv.getObjRelation("xComposer"));
+
+        if (xComposer == null) {
+            throw new StatusException(Status.failed(
+           "Couldn't get object relation 'xComposer'. Test must be modified"));
+
+        }
+
+    }
+    /**
+    * call <code>setQuery()</code> once with valid query, once with invalid
+    * query. Has ok if only on second call <code>SQLException</code> was thrown
+    */
+    public void _setQuery() {
+
+        try{
+            oObj.setQuery("This is an invalid SQL query");
+        } catch (com.sun.star.sdbc.SQLException e){
+            log.println("expected Exception. ");
+        }
+
+        try{
+            oObj.setQuery(queryString);
+        } catch (com.sun.star.sdbc.SQLException e){
+            log.println("unexpected Exception: " + e.toString());
+            tRes.tested("setQuery()", false);
+        }
+        tRes.tested("setQuery()", true);
+    }
+
+    /**
+    * checks of the returned value of <code>getQuery()</code>
+    * equals the string which was set by <code>setQuery()</code>
+    * <p>
+    * required methods:
+    *<ul>
+    * <li><code>setQuery</code></li>
+    *</ul>
+    */
+    public void _getQuery() {
+        this.requiredMethod("setQuery()");
+
+        boolean res = false;
+
+        res = oObj.getQuery().equals(queryString);
+
+        tRes.tested("getQuery()", res);
+    }
+
+
+    /**
+    * Object relation <code>xComposer</code> set a filter. This filter
+    * must returned while calling <code>getFilter</code>
+    */
+    public void _getFilter() {
+        try{
+            String filter = "\"Identifier\" = 'BOR02b'";
+            xComposer.setFilter(filter);
+            tRes.tested("getFilter()", oObj.getFilter().equals(filter));
+
+        } catch (com.sun.star.sdbc.SQLException e){
+            log.println("unexpected Exception: " + e.toString());
+            tRes.tested("getFilter()", false);
+        }
+    }
+
+    /**
+    * Object relation <code>xComposer</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 <xComposer>.
+    * Then test has ok status if <getFilter> returns the complex filter.
+    * <p>
+    * required methods:
+    *<ul>
+    * <li><code>setQuery</code></li>
+    * <li><code>getFilter</code></li>
+    *</ul>
+    */
+    public void _getStructuredFilter() {
+        requiredMethod("setQuery()");
+        requiredMethod("getFilter()");
+        try{
+            oObj.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' )";
+            xComposer.setFilter(complexFilter);
+            PropertyValue[][] aStructuredFilter = oObj.getStructuredFilter();
+
+            xComposer.setFilter("");
+            xComposer.setStructuredFilter(aStructuredFilter);
+            tRes.tested("getStructuredFilter()", oObj.getFilter().equals(complexFilter));
+
+        } catch (com.sun.star.sdbc.SQLException e){
+            log.println("unexpected Exception: " + e.toString());
+            tRes.tested("getStructuredFilter()", false);
+        } catch (com.sun.star.lang.IllegalArgumentException e){
+            log.println("unexpected Exception: " + e.toString());
+            tRes.tested("getStructuredFilter()", false);
+        }
+    }
+
+    /**
+    * Object relation <code>xComposer</code> set a goup. This group
+    * must returned while calling <code>getGroup</code>
+    */
+    public void _getGroup() {
+        try{
+            String group = "\"Identifier\"";
+            xComposer.setGroup(group);
+            tRes.tested("getGroup()", oObj.getGroup().equals(group));
+
+        } catch (com.sun.star.sdbc.SQLException e){
+            log.println("unexpected Exception: " + e.toString());
+            tRes.tested("getGroup()", false);
+        }
+    }
+
+    /**
+    * Method <code>getGroupColumns</code> returns a <code>XIndexAccess</code>
+    * Test has ok status if returned value is a usable <code>XIndexAccess</code>
+    */
+    public void _getGroupColumns() {
+        try{
+           XIndexAccess xGroupColumns = oObj.getGroupColumns();
+
+           tRes.tested("getGroupColumns()", (xGroupColumns != null &&
+                                            xGroupColumns.getCount() == 1 &&
+                                        xGroupColumns.getByIndex(0) != null));
+
+        } catch (com.sun.star.lang.IndexOutOfBoundsException e){
+            log.println("unexpected Exception: " + e.toString());
+            tRes.tested("getGroupColumns()", false);
+        } catch (com.sun.star.lang.WrappedTargetException e){
+            log.println("unexpected Exception: " + e.toString());
+            tRes.tested("getGroupColumns()", false);
+        }
+    }
+
+    /**
+    * Object relation <code>xComposer</code> set a clause. This clause
+    * must returned while calling <code>getHavingClause</code>
+    */
+    public void _getHavingClause() {
+        try{
+            String clause = "\"Identifier\" = 'BOR02b'";
+            xComposer.setHavingClause(clause);
+            tRes.tested("getHavingClause()", oObj.getHavingClause().equals(clause));
+
+        } catch (com.sun.star.sdbc.SQLException e){
+            log.println("unexpected Exception: " + e.toString());
+            tRes.tested("getHavingClause()", false);
+        }
+    }
+
+    /**
+    * Object relation <code>xComposer</code> set a clause. This clause
+    * must returned while calling <code>getHavingClause</code>
+    * <p>
+    * required methods:
+    *<ul>
+    * <li><code>setQuery</code></li>
+    * <li><code>getFilter</code></li>
+    * <li><code>getStructuredFilter</code></li>
+    *</ul>
+    */
+    public void _getStructuredHavingClause() {
+        requiredMethod("setQuery()");
+        requiredMethod("getFilter()");
+        executeMethod("getStructuredFilter()");
+
+        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{
+           xComposer.setHavingClause(complexFilter);
+           PropertyValue[][] aStructuredHaving = oObj.getStructuredHavingClause();
+           xComposer.setHavingClause("");
+           xComposer.setStructuredHavingClause(aStructuredHaving);
+           tRes.tested("getStructuredHavingClause()",
+                                oObj.getHavingClause().equals(complexFilter));
+
+        } catch (com.sun.star.sdbc.SQLException e){
+            log.println("unexpected Exception: " + e.toString());
+            tRes.tested("getStructuredHavingClause()", false);
+        }
+    }
+
+    /**
+    * Object relation <code>xComposer</code> set an order. This order
+    * must returned while calling <code>getOrder</code>
+    */
+    public void _getOrder() {
+        try{
+            String order = "\"Identifier\"";
+            xComposer.setOrder(order);
+            tRes.tested("getOrder()", oObj.getOrder().equals(order));
+
+        } catch (com.sun.star.sdbc.SQLException e){
+            log.println("unexpected Exception: " + e.toString());
+            tRes.tested("getOrder()", false);
+        }
+    }
+
+    /**
+    * Method <code>getGroupColumns</code> returns a <code>XIndexAccess</code>
+    * Test has ok status if returned value is a usable <code>XIndexAccess</code>
+    */
+    public void _getOrderColumns() {
+        try{
+            XIndexAccess xOrderColumns = oObj.getOrderColumns();
+            tRes.tested("getOrderColumns()", (xOrderColumns != null &&
+                                              xOrderColumns.getCount() == 1 &&
+                                         xOrderColumns.getByIndex(0) != null));
+
+        } catch (com.sun.star.lang.IndexOutOfBoundsException e){
+            log.println("unexpected Exception: " + e.toString());
+            tRes.tested("getOrderColumns()", false);
+        } catch (com.sun.star.lang.WrappedTargetException e){
+            log.println("unexpected Exception: " + e.toString());
+            tRes.tested("getOrderColumns()", false);
+        }
+    }
+
+
+}  // finish class _XSingleSelectQueryAnalyzer