qadevOOo/tests/java/ifc/sdb/_XSingleSelectQueryComposer.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.XSingleSelectQueryComposer;
  22 import lib.MultiMethodTest;
  23 import com.sun.star.sdb.XSingleSelectQueryAnalyzer;
  24 import com.sun.star.sdbc.XResultSet;
  25 import com.sun.star.uno.AnyConverter;
  26 import com.sun.star.uno.UnoRuntime;
  27 import lib.StatusException;
  28 import lib.Status;
  29 import com.sun.star.beans.PropertyValue;
  30 import com.sun.star.beans.XPropertySet;
  31 import com.sun.star.sdb.SQLFilterOperator;
  32 import com.sun.star.sdbc.SQLException;
  33
  34 /**
  35 * Testing <code>com.sun.star.sdb.XSingleSelectQueryComposer</code>
  36 * interface methods :
  37 * <ul>
  38 *  <li><code>setFilter()</code></li>
  39 *  <li><code>setStructuredFilter()</code></li>
  40 *  <li><code>appendFilterByColumn()</code></li>
  41 *  <li><code>appendGroupByColumn()</code></li>
  42 *  <li><code>setGroup()</code></li>
  43 *  <li><code>setHavingClause()</code></li>
  44 *  <li><code>setStructuredHavingClause()</code></li>
  45 *  <li><code>appendHavingClauseByColumn()</code></li>
  46 *  <li><code>appendOrderByColumn()</code></li>
  47 *  <li><code>setOrder()</code></li>
  48
  49 * </ul> <p>
  50 * @see com.sun.star.sdb.XSingleSelectQueryComposer
  51 */
  52 public class _XSingleSelectQueryComposer extends MultiMethodTest {
  53
  54     // oObj filled by MultiMethodTest
  55     public XSingleSelectQueryComposer oObj = null ;
  56
  57     private XSingleSelectQueryAnalyzer xQueryAna = null;
  58
  59     private XPropertySet xProp = null;
  60
  61     private String colName = null;
  62
  63     private XResultSet xReSet = null;
  64
  65     /**
  66      * Retcieves the object relations:
  67     * <ul>
  68     *  <li><code>XSingleSelectQueryAnalyzer xQueryAna</code></li>
  69     *  <li><code>XPropertySet xProp</code></li>
  70     *  <li><code>String colName</code></li>
  71     * </ul> <p>
  72      * @see com.sun.star.sdb.XSingleSelectQueryAnalyzer
  73      * @see com.sun.star.beans.XPropertySet
  74      */
  75     @Override
  76     protected void before() /* throws Exception*/ {
  77
  78         xQueryAna = UnoRuntime.queryInterface(XSingleSelectQueryAnalyzer.class,
  79           tEnv.getObjRelation("xQueryAna"));
  80
  81         if (xQueryAna == null) {
  82             throw new StatusException(Status.failed(
  83            "Couldn't get object relation 'xQueryAna'. Test must be modified"));
  84
  85         }
  86
  87         xProp = UnoRuntime.queryInterface(XPropertySet.class,
  88           tEnv.getObjRelation("xProp"));
  89
  90         if (xProp == null) {
  91             throw new StatusException(Status.failed(
  92            "Couldn't get object relation 'xProp'. Test must be modified"));
  93
  94         }
  95
  96         xReSet = UnoRuntime.queryInterface(XResultSet.class,
  97           tEnv.getObjRelation("xResultSet"));
  98
  99         if (xReSet == null) {
 100             throw new StatusException(Status.failed(
 101            "Couldn't get object relation 'xResultSet'. Test must be modified"));
 102
 103         }
 104
 105         try
 106         {
 107             colName = AnyConverter.toString(tEnv.getObjRelation("colName"));
 108         }
 109         catch (com.sun.star.lang.IllegalArgumentException e)
 110         {
 111             colName = null;
 112         }
 113
 114         if (colName == null) {
 115             throw new StatusException(Status.failed(
 116            "Couldn't get object relation 'colName'. Test must be modified"));
 117
 118         }
 119
 120     }
 121
 122
 123     /**
 124     * Object relation <code>xQueryAna</code> set a filter. This filter
 125     * must returned while calling <code>getFilter</code>
 126     */
 127     public void _setFilter() {
 128         try{
 129             String filter = "\"Identifier\" = 'BOR02b'";
 130             oObj.setFilter(filter);
 131             tRes.tested("setFilter()", (xQueryAna.getFilter().equals(filter)));
 132
 133         } catch (SQLException e){
 134             log.println("unexpected Exception: " + e.toString());
 135             tRes.tested("setFilter()", false);
 136         }
 137     }
 138
 139     /**
 140     * Object relation <code>xQueryAna</code> set a complex filter with method
 141     . <code>setFilter</code>. Then <code>getStructuredFilter</code> returns a
 142     * sequenze of <code>PropertyValue</code> which was set with method
 143     * <code>setStructuredFilter</code> from <code>xQueryAna</code>.
 144     * Then test has ok status if <code>getFilter</code> returns the complex filter.
 145     */
 146     public void _setStructuredFilter() {
 147         requiredMethod("setFilter()");
 148         try{
 149             xQueryAna.setQuery("SELECT \"Identifier\", \"Type\", \"Address\" FROM \"biblio\" \"biblio\"");
 150             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' )";
 151             oObj.setFilter(complexFilter);
 152             PropertyValue[][] aStructuredFilter = xQueryAna.getStructuredFilter();
 153             oObj.setFilter("");
 154             oObj.setStructuredFilter(aStructuredFilter);
 155             tRes.tested("setStructuredFilter()", (xQueryAna.getFilter().equals(complexFilter)));
 156
 157         } catch (SQLException e){
 158             log.println("unexpected Exception: " + e.toString());
 159             tRes.tested("setStructuredFilter()", false);
 160         } catch (com.sun.star.lang.IllegalArgumentException e){
 161             log.println("unexpected Exception: " + e.toString());
 162             tRes.tested("setStructuredFilter()", false);
 163         }
 164     }
 165
 166     /**
 167     * At first the object relation <code>xProp</code> was set as parameter.
 168     * Relation <code>xQueryAna</code> was used to check if relation
 169     * <code>colName</code> was found.
 170     * Second an empty <code>XPropertySet</code> was used as parameter. A
 171     * <code>SQLException</code> must be thrown.
 172     */
 173     public void _appendFilterByColumn() {
 174         boolean ok = true;
 175         try
 176         {
 177             xReSet.beforeFirst();
 178         }
 179         catch (SQLException e)
 180         {
 181             log.println("unexpected Exception: " + e.toString());
 182             tRes.tested("appendFilterByColumn()", false);
 183         }
 184         try
 185         {
 186             oObj.appendFilterByColumn(xProp, true,SQLFilterOperator.EQUAL);
 187             log.println("expected Exception was not thrown");
 188             tRes.tested("appendFilterByColumn()", false);
 189             ok = false;
 190         }
 191         catch (com.sun.star.uno.RuntimeException e)
 192         {
 193             log.println("expected Exception: " + e.toString());
 194             ok = ok && true;
 195         }
 196         catch (SQLException e)
 197         {
 198             log.println("unexpected Exception: " + e.toString());
 199             tRes.tested("appendFilterByColumn()", false);
 200         }
 201         catch (com.sun.star.lang.WrappedTargetException e)
 202         {
 203             log.println("unexpected Exception: " + e.toString());
 204             tRes.tested("appendFilterByColumn()", false);
 205         }
 206
 207         try
 208         {
 209             xReSet.first();
 210         }
 211         catch (SQLException e)
 212         {
 213             log.println("unexpected Exception: " + e.toString());
 214             tRes.tested("appendFilterByColumn()", false);
 215         }
 216         try{
 217
 218             oObj.appendFilterByColumn(xProp, true,SQLFilterOperator.EQUAL);
 219             log.println("appendFilterByColumn: " + xQueryAna.getFilter());
 220             ok = ok && (xQueryAna.getFilter().indexOf(colName) > 0);
 221
 222         } catch (SQLException e){
 223             log.println("unexpected Exception: " + e.toString());
 224             tRes.tested("appendFilterByColumn()", false);
 225         }
 226         catch (com.sun.star.lang.WrappedTargetException e)
 227         {
 228             log.println("unexpected Exception: " + e.toString());
 229             tRes.tested("appendFilterByColumn()", false);
 230         }
 231
 232         try{
 233
 234             oObj.appendFilterByColumn(xProp, false,SQLFilterOperator.EQUAL);
 235             log.println("appendFilterByColumn: " + xQueryAna.getFilter());
 236             ok = ok && (xQueryAna.getFilter().indexOf(colName) > 0);
 237
 238         } catch (SQLException e){
 239             log.println("unexpected Exception: " + e.toString());
 240             tRes.tested("appendFilterByColumn()", false);
 241         } catch (com.sun.star.lang.WrappedTargetException e)
 242         {
 243             log.println("unexpected Exception: " + e.toString());
 244             tRes.tested("appendFilterByColumn()", false);
 245         }
 246
 247         try{
 248             XPropertySet dummy = null;
 249             oObj.appendFilterByColumn(dummy, true,SQLFilterOperator.EQUAL);
 250             log.println("expected Exception was not thrown");
 251             tRes.tested("appendFilterByColumn()", false);
 252
 253         } catch (SQLException e){
 254             log.println("expected Exception");
 255             ok = ok && true;
 256         } catch (com.sun.star.lang.WrappedTargetException e)
 257         {
 258             log.println("unexpected Exception: " + e.toString());
 259             tRes.tested("appendFilterByColumn()", false);
 260         }
 261
 262         try
 263         {
 264             xReSet.beforeFirst();
 265         }
 266         catch (SQLException e)
 267         {
 268             log.println("unexpected Exception: " + e.toString());
 269             tRes.tested("appendFilterByColumn()", false);
 270         }
 271         tRes.tested("appendFilterByColumn()", ok);
 272     }
 273
 274     /**
 275     * At first the object relation <code>xProp</code> was used as parameter.
 276     * Relation <code>xQueryAna</code> was used to check if relation
 277     * <code>colName</code> was found.
 278     * Second an empty <code>XPropertySet</code> was used as parameter. An
 279     * <code>SQLException</code> must be thrown.
 280     */
 281     public void _appendGroupByColumn() {
 282         boolean ok = true;
 283         try{
 284
 285             oObj.appendGroupByColumn(xProp);
 286             log.println("appendGroupByColumn: " + xQueryAna.getFilter());
 287             ok = ok && (xQueryAna.getFilter().indexOf(colName) > 0);
 288
 289         } catch (SQLException e){
 290             log.println("unexpected Exception: " + e.toString());
 291             tRes.tested("appendGroupByColumn()", false);
 292         }
 293         try{
 294             XPropertySet dummy = null;
 295             oObj.appendGroupByColumn(dummy);
 296             log.println("expected Exception was not thrown");
 297             tRes.tested("appendGroupByColumn()", false);
 298
 299         } catch (SQLException e){
 300             log.println("expected Exception");
 301             ok = ok && true;
 302         }
 303         tRes.tested("appendGroupByColumn()", ok);
 304     }
 305
 306     /**
 307     * The group which was setted by <code>setGroup</code> must be returned
 308     * while calling from object relation <code>XQueryAna</code>
 309     * method <code>getGroup</code>
 310     */
 311     public void _setGroup() {
 312         try{
 313             String group = "\"Identifier\"";
 314             oObj.setGroup(group);
 315             tRes.tested("setGroup()", (xQueryAna.getGroup().equals(group)));
 316
 317         } catch (SQLException e){
 318             log.println("unexpected Exception: " + e.toString());
 319             tRes.tested("setGroup()", false);
 320         }
 321     }
 322
 323
 324     /**
 325     * The cluase which was setted by <code>setHavingClause</code> must be returned
 326     * while calling from object relation <code>XQueryAna</code>
 327     * method <code>getHavingClause</code>
 328     */
 329     public void _setHavingClause() {
 330         try{
 331             String clause = "\"Identifier\" = 'BOR02b'";
 332             oObj.setHavingClause(clause);
 333             tRes.tested("setHavingClause()", (
 334                                    xQueryAna.getHavingClause().equals(clause)));
 335
 336         } catch (SQLException e){
 337             log.println("unexpected Exception: " + e.toString());
 338             tRes.tested("setHavingClause()", false);
 339         }
 340     }
 341
 342     /**
 343     * At first <code>setHavingClause</code> sets a complex clause.
 344     * Then method <code>getStructuredHavingClause</code> from object relation
 345     * <code>xQueryAna</code> returns a valid <code>PropertyValue[][]</code>
 346     * Method <code>setHavingClause</code> was called with an empty sting to
 347     * reset filter. Now <code>setStructuredHavingClause</code> with the valid
 348     * <code>PropertyValue[][]</code> as parameter was called.
 349     * Test is ok if <code>getHavingClause</code> from <code>xQueryAna</code>
 350     * returns the complex clause from beginning.
 351     * <p>
 352     * required methods:
 353     *<ul>
 354     * <li><code>setHavingClause</code></li>
 355     * <li><code>setStructuredFilter</code></li>
 356     *</ul>
 357     */
 358     public void _setStructuredHavingClause() {
 359         requiredMethod("setHavingClause()");
 360         executeMethod("setStructuredFilter()");
 361         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' )";
 362
 363         try{
 364            oObj.setHavingClause(complexFilter);
 365            PropertyValue[][] aStructuredHaving =
 366                                           xQueryAna.getStructuredHavingClause();
 367            oObj.setHavingClause("");
 368            oObj.setStructuredHavingClause(aStructuredHaving);
 369            tRes.tested("setStructuredHavingClause()",
 370                            (xQueryAna.getHavingClause().equals(complexFilter)));
 371
 372         } catch (SQLException e){
 373             log.println("unexpected Exception: " + e.toString());
 374             tRes.tested("setStructuredHavingClause()", false);
 375         }
 376     }
 377
 378     /**
 379     * First object relation <code>xProp</code> was used as parameter. Relation
 380     * <code>xQueryAna</code> was used to check if relation <code>colName</code>
 381     * was found.
 382     * Second an empty <code>XPropertySet</code> was given as parameter. An
 383     * <code>SQLException</code> must be thrown.
 384     */
 385     public void _appendHavingClauseByColumn() {
 386         boolean ok = true;
 387         try
 388         {
 389             xReSet.beforeFirst();
 390         }
 391         catch (SQLException e)
 392         {
 393             log.println("unexpected Exception: " + e.toString());
 394             tRes.tested("appendHavingClauseByColumn()", false);
 395         }
 396         try{
 397
 398             oObj.appendHavingClauseByColumn(xProp, true,SQLFilterOperator.EQUAL);
 399             log.println("expected Exception was not thrown");
 400             tRes.tested("appendHavingClauseByColumn()", false);
 401             ok = false;
 402
 403         }
 404         catch (com.sun.star.uno.RuntimeException e)
 405         {
 406             log.println("expected Exception: " + e.toString());
 407             ok = ok && true;
 408         }
 409         catch (SQLException e)
 410         {
 411             log.println("unexpected Exception: " + e.toString());
 412             tRes.tested("appendHavingClauseByColumn()", false);
 413         } catch (com.sun.star.lang.WrappedTargetException e)
 414         {
 415             log.println("unexpected Exception: " + e.toString());
 416             tRes.tested("appendHavingClauseByColumn()", false);
 417         }
 418
 419         try
 420         {
 421             xReSet.first();
 422         }
 423         catch (SQLException e)
 424         {
 425             log.println("unexpected Exception: " + e.toString());
 426             tRes.tested("appendHavingClauseByColumn()", false);
 427         }
 428         try{
 429
 430             oObj.appendHavingClauseByColumn(xProp, true,SQLFilterOperator.EQUAL);
 431             log.println("appendHavingClauseByColumn: " + xQueryAna.getFilter());
 432             ok = ok && (xQueryAna.getFilter().indexOf(colName) > 0);
 433
 434         } catch (SQLException e){
 435             log.println("unexpected Exception: " + e.toString());
 436             tRes.tested("appendHavingClauseByColumn()", false);
 437         } catch (com.sun.star.lang.WrappedTargetException e)
 438         {
 439             log.println("unexpected Exception: " + e.toString());
 440             tRes.tested("appendHavingClauseByColumn()", false);
 441         }
 442
 443         try{
 444             XPropertySet dummy = null;
 445             oObj.appendHavingClauseByColumn(dummy, true,SQLFilterOperator.EQUAL);
 446             log.println("expected Exception was not thrown");
 447             tRes.tested("appendHavingClauseByColumn()", false);
 448
 449         } catch (SQLException e){
 450             log.println("expected Exception");
 451             ok = ok && true;
 452         } catch (com.sun.star.lang.WrappedTargetException e)
 453         {
 454             log.println("unexpected Exception: " + e.toString());
 455             tRes.tested("appendHavingClauseByColumn()", false);
 456         }
 457
 458         // cleanup
 459         try
 460         {
 461             xReSet.beforeFirst();
 462         }
 463         catch (SQLException e)
 464         {
 465             log.println("unexpected Exception: " + e.toString());
 466             tRes.tested("appendHavingClauseByColumn()", false);
 467         }
 468         tRes.tested("appendHavingClauseByColumn()", ok);
 469     }
 470
 471     /**
 472     * First object relation <code>xProp</code> was set as parameter. Relation
 473     * <code>xQueryAna</code> was used to check if relation <code>colName</code>
 474     * was found.
 475     * Second an empty <code>XPropertySet</code> was given as parameter. An
 476     * <code>SQLException</code> must be thrown.
 477     */
 478     public void _appendOrderByColumn() {
 479         boolean ok = true;
 480         try{
 481
 482             oObj.appendOrderByColumn(xProp, true);
 483             log.println("appendOrderByColumn: " + xQueryAna.getFilter());
 484             ok = ok && (xQueryAna.getFilter().indexOf(colName) > 0);
 485
 486         } catch (SQLException e){
 487             log.println("unexpected Exception: " + e.toString());
 488             tRes.tested("appendOrderByColumn()", false);
 489         }
 490         try{
 491             XPropertySet dummy = null;
 492             oObj.appendOrderByColumn(dummy, true);
 493             log.println("expected Exception was not thrown");
 494             tRes.tested("appendOrderByColumn()", false);
 495
 496         } catch (SQLException e){
 497             log.println("expected Exception");
 498             ok = ok && true;
 499         }
 500         tRes.tested("appendOrderByColumn()", ok);
 501     }
 502
 503
 504     /**
 505     * Method <code>getOrder</code> from object relation <code>xQueryAna</code>
 506     * checks the order which was setted while calling <code>setOrder</code>
 507     */
 508     public void _setOrder() {
 509         try{
 510             String order = "\"Identifier\"";
 511             oObj.setOrder(order);
 512             tRes.tested("setOrder()", (xQueryAna.getOrder().equals(order)));
 513
 514         } catch (SQLException e){
 515             log.println("unexpected Exception: " + e.toString());
 516             tRes.tested("setOrder()", false);
 517         }
 518     }
 519
 520
 521
 522 }  // finish class _XSingleSelectQueryComposer