290 lines
10 KiB
Java
290 lines
10 KiB
Java
/*
|
|
* 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 group. 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
|