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

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