qadevOOo/tests/java/ifc/sdb/_XSingleSelectQueryAnalyzer.java

   1 /*
   2  * This file is part of the LibreOffice project.
   3  *
   4  * This Source Code Form is subject to the terms of the Mozilla Public
   5  * License, v. 2.0. If a copy of the MPL was not distributed with this
   6  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   7  *
   8  * This file incorporates work covered by the following license notice:
   9  *
  10  *   Licensed to the Apache Software Foundation (ASF) under one or more
  11  *   contributor license agreements. See the NOTICE file distributed
  12  *   with this work for additional information regarding copyright
  13  *   ownership. The ASF licenses this file to you under the Apache
  14  *   License, Version 2.0 (the "License"); you may not use this file
  15  *   except in compliance with the License. You may obtain a copy of
  16  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  17  */
  18
  19 package ifc.sdb;
  20
  21 import com.sun.star.sdb.XSingleSelectQueryAnalyzer;
  22 import lib.MultiMethodTest;
  23 import com.sun.star.sdb.XSingleSelectQueryComposer;
  24 import com.sun.star.uno.UnoRuntime;
  25 import lib.StatusException;
  26 import lib.Status;
  27 import com.sun.star.beans.PropertyValue;
  28 import com.sun.star.container.XIndexAccess;
  29
  30 /**
  31 * Testing <code>com.sun.star.sdb.XSingleSelectQueryAnalyzer</code>
  32 * interface methods :
  33 * <ul>
  34 *  <li><code>getQuery()</code></li>
  35 *  <li><code>setQuery()</code></li>
  36 *  <li><code>getFilter()</code></li>
  37 *  <li><code>getStructuredFilter()</code></li>
  38 *  <li><code>getGroup()</code></li>
  39 *  <li><code>getGroupColumns()</code></li>
  40 *  <li><code>getHavingClause()</code></li>
  41 *  <li><code>getStructuredHavingClause()</code></li>
  42 *  <li><code>getOrder()</code></li>
  43 *  <li><code>getOrderColumns()</code></li>
  44
  45 * </ul> <p>
  46 * @see com.sun.star.sdb.XSingleSelectQueryAnalyzer
  47 */
  48 public class _XSingleSelectQueryAnalyzer extends MultiMethodTest {
  49
  50     // oObj filled by MultiMethodTest
  51     public XSingleSelectQueryAnalyzer oObj = null ;
  52
  53     private static final String queryString = "SELECT * FROM \"biblio\"";
  54
  55     private XSingleSelectQueryComposer xComposer = null;
  56
  57     /**
  58      * Receives the object relations:
  59     * <ul>
  60     *  <li><code>XSingleSelectQueryComposer xCompoer</code></li>
  61     * </ul> <p>
  62      * @see com.sun.star.sdb.XSingleSelectQueryComposer
  63      */
  64     @Override
  65     protected void before() {
  66
  67         xComposer = UnoRuntime.queryInterface(XSingleSelectQueryComposer.class,
  68           tEnv.getObjRelation("xComposer"));
  69
  70         if (xComposer == null) {
  71             throw new StatusException(Status.failed(
  72            "Couldn't get object relation 'xComposer'. Test must be modified"));
  73
  74         }
  75
  76     }
  77     /**
  78     * call <code>setQuery()</code> once with valid query, once with invalid
  79     * query. Has ok if only on second call <code>SQLException</code> was thrown
  80     */
  81     public void _setQuery() {
  82
  83         try{
  84             oObj.setQuery("This is an invalid SQL query");
  85         } catch (com.sun.star.sdbc.SQLException e){
  86             log.println("expected Exception. ");
  87         }
  88
  89         try{
  90             oObj.setQuery(queryString);
  91         } catch (com.sun.star.sdbc.SQLException e){
  92             log.println("unexpected Exception: " + e.toString());
  93             tRes.tested("setQuery()", false);
  94         }
  95         tRes.tested("setQuery()", true);
  96     }
  97
  98     /**
  99     * checks of the returned value of <code>getQuery()</code>
 100     * equals the string which was set by <code>setQuery()</code>
 101     * <p>
 102     * required methods:
 103     *<ul>
 104     * <li><code>setQuery</code></li>
 105     *</ul>
 106     */
 107     public void _getQuery() {
 108         this.requiredMethod("setQuery()");
 109
 110         boolean res = false;
 111
 112         res = oObj.getQuery().equals(queryString);
 113
 114         tRes.tested("getQuery()", res);
 115     }
 116
 117
 118     /**
 119     * Object relation <code>xComposer</code> set a filter. This filter
 120     * must returned while calling <code>getFilter</code>
 121     */
 122     public void _getFilter() {
 123         try{
 124             String filter = "\"Identifier\" = 'BOR02b'";
 125             xComposer.setFilter(filter);
 126             tRes.tested("getFilter()", oObj.getFilter().equals(filter));
 127
 128         } catch (com.sun.star.sdbc.SQLException e){
 129             log.println("unexpected Exception: " + e.toString());
 130             tRes.tested("getFilter()", false);
 131         }
 132     }
 133
 134     /**
 135     * Object relation <code>xComposer</code> set a complex filter with method
 136     . <code>setFilter</code>. Then <code>getStructuredFilter</code> returns a
 137     * sequence of <code>PropertyValue</code> which was set with method
 138     * <code>setStructuredFilter</code> from <xComposer>.
 139     * Then test has ok status if <getFilter> returns the complex filter.
 140     * <p>
 141     * required methods:
 142     *<ul>
 143     * <li><code>setQuery</code></li>
 144     * <li><code>getFilter</code></li>
 145     *</ul>
 146     */
 147     public void _getStructuredFilter() {
 148         requiredMethod("setQuery()");
 149         requiredMethod("getFilter()");
 150         try{
 151             oObj.setQuery("SELECT \"Identifier\", \"Type\", \"Address\" FROM \"biblio\" \"biblio\"");
 152             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' )";
 153             xComposer.setFilter(complexFilter);
 154             PropertyValue[][] aStructuredFilter = oObj.getStructuredFilter();
 155
 156             xComposer.setFilter("");
 157             xComposer.setStructuredFilter(aStructuredFilter);
 158             tRes.tested("getStructuredFilter()", oObj.getFilter().equals(complexFilter));
 159
 160         } catch (com.sun.star.sdbc.SQLException e){
 161             log.println("unexpected Exception: " + e.toString());
 162             tRes.tested("getStructuredFilter()", false);
 163         } catch (com.sun.star.lang.IllegalArgumentException e){
 164             log.println("unexpected Exception: " + e.toString());
 165             tRes.tested("getStructuredFilter()", false);
 166         }
 167     }
 168
 169     /**
 170     * Object relation <code>xComposer</code> set a group. This group
 171     * must returned while calling <code>getGroup</code>
 172     */
 173     public void _getGroup() {
 174         try{
 175             String group = "\"Identifier\"";
 176             xComposer.setGroup(group);
 177             tRes.tested("getGroup()", oObj.getGroup().equals(group));
 178
 179         } catch (com.sun.star.sdbc.SQLException e){
 180             log.println("unexpected Exception: " + e.toString());
 181             tRes.tested("getGroup()", false);
 182         }
 183     }
 184
 185     /**
 186     * Method <code>getGroupColumns</code> returns a <code>XIndexAccess</code>
 187     * Test has ok status if returned value is a usable <code>XIndexAccess</code>
 188     */
 189     public void _getGroupColumns() {
 190         try{
 191            XIndexAccess xGroupColumns = oObj.getGroupColumns();
 192
 193            tRes.tested("getGroupColumns()", (xGroupColumns != null &&
 194                                             xGroupColumns.getCount() == 1 &&
 195                                         xGroupColumns.getByIndex(0) != null));
 196
 197         } catch (com.sun.star.lang.IndexOutOfBoundsException e){
 198             log.println("unexpected Exception: " + e.toString());
 199             tRes.tested("getGroupColumns()", false);
 200         } catch (com.sun.star.lang.WrappedTargetException e){
 201             log.println("unexpected Exception: " + e.toString());
 202             tRes.tested("getGroupColumns()", false);
 203         }
 204     }
 205
 206     /**
 207     * Object relation <code>xComposer</code> set a clause. This clause
 208     * must returned while calling <code>getHavingClause</code>
 209     */
 210     public void _getHavingClause() {
 211         try{
 212             String clause = "\"Identifier\" = 'BOR02b'";
 213             xComposer.setHavingClause(clause);
 214             tRes.tested("getHavingClause()", oObj.getHavingClause().equals(clause));
 215
 216         } catch (com.sun.star.sdbc.SQLException e){
 217             log.println("unexpected Exception: " + e.toString());
 218             tRes.tested("getHavingClause()", false);
 219         }
 220     }
 221
 222     /**
 223     * Object relation <code>xComposer</code> set a clause. This clause
 224     * must returned while calling <code>getHavingClause</code>
 225     * <p>
 226     * required methods:
 227     *<ul>
 228     * <li><code>setQuery</code></li>
 229     * <li><code>getFilter</code></li>
 230     * <li><code>getStructuredFilter</code></li>
 231     *</ul>
 232     */
 233     public void _getStructuredHavingClause() {
 234         requiredMethod("setQuery()");
 235         requiredMethod("getFilter()");
 236         executeMethod("getStructuredFilter()");
 237
 238         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' )";
 239         try{
 240            xComposer.setHavingClause(complexFilter);
 241            PropertyValue[][] aStructuredHaving = oObj.getStructuredHavingClause();
 242            xComposer.setHavingClause("");
 243            xComposer.setStructuredHavingClause(aStructuredHaving);
 244            tRes.tested("getStructuredHavingClause()",
 245                                 oObj.getHavingClause().equals(complexFilter));
 246
 247         } catch (com.sun.star.sdbc.SQLException e){
 248             log.println("unexpected Exception: " + e.toString());
 249             tRes.tested("getStructuredHavingClause()", false);
 250         }
 251     }
 252
 253     /**
 254     * Object relation <code>xComposer</code> set an order. This order
 255     * must returned while calling <code>getOrder</code>
 256     */
 257     public void _getOrder() {
 258         try{
 259             String order = "\"Identifier\"";
 260             xComposer.setOrder(order);
 261             tRes.tested("getOrder()", oObj.getOrder().equals(order));
 262
 263         } catch (com.sun.star.sdbc.SQLException e){
 264             log.println("unexpected Exception: " + e.toString());
 265             tRes.tested("getOrder()", false);
 266         }
 267     }
 268
 269     /**
 270     * Method <code>getGroupColumns</code> returns a <code>XIndexAccess</code>
 271     * Test has ok status if returned value is a usable <code>XIndexAccess</code>
 272     */
 273     public void _getOrderColumns() {
 274         try{
 275             XIndexAccess xOrderColumns = oObj.getOrderColumns();
 276             tRes.tested("getOrderColumns()", (xOrderColumns != null &&
 277                                               xOrderColumns.getCount() == 1 &&
 278                                          xOrderColumns.getByIndex(0) != null));
 279
 280         } catch (com.sun.star.lang.IndexOutOfBoundsException e){
 281             log.println("unexpected Exception: " + e.toString());
 282             tRes.tested("getOrderColumns()", false);
 283         } catch (com.sun.star.lang.WrappedTargetException e){
 284             log.println("unexpected Exception: " + e.toString());
 285             tRes.tested("getOrderColumns()", false);
 286         }
 287     }
 288
 289
 290 }  // finish class _XSingleSelectQueryAnalyzer