/*
* 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.XSingleSelectQueryComposer;
import lib.MultiMethodTest;
import com.sun.star.sdb.XSingleSelectQueryAnalyzer;
import com.sun.star.uno.AnyConverter;
import com.sun.star.uno.UnoRuntime;
import lib.StatusException;
import lib.Status;
import com.sun.star.beans.PropertyValue;
import com.sun.star.beans.XPropertySet;
import com.sun.star.sdb.SQLFilterOperator;
/**
* Testing com.sun.star.sdb.XSingleSelectQueryComposer
* interface methods :
*
setFilter()
setStructuredFilter()
appendFilterByColumn()
appendGroupByColumn()
setGroup()
setHavingClause()
setStructuredHavingClause()
appendHavingClauseByColumn()
appendOrderByColumn()
setOrder()
* @see com.sun.star.sdb.XSingleSelectQueryComposer */ public class _XSingleSelectQueryComposer extends MultiMethodTest { // oObj filled by MultiMethodTest public XSingleSelectQueryComposer oObj = null ; private String queryString = "SELECT * FROM \"biblio\""; private XSingleSelectQueryAnalyzer xQueryAna = null; private XPropertySet xProp = null; private String colName = null; /** * Retcieves the object relations: *
XSingleSelectQueryAnalyzer xQueryAna
XPropertySet xProp
String colName
* @see om.sun.star.sdb.XSingleSelectQueryAnalyzer
* @see com.sun.star.beans.XPropertySet
*/
protected void before() /* throws Exception*/ {
xQueryAna = UnoRuntime.queryInterface(XSingleSelectQueryAnalyzer.class,
tEnv.getObjRelation("xQueryAna"));
if (xQueryAna == null) {
throw new StatusException(Status.failed(
"Couldn't get object relation 'xQueryAna'. Test must be modified"));
}
xProp = UnoRuntime.queryInterface(XPropertySet.class,
tEnv.getObjRelation("xProp"));
if (xProp == null) {
throw new StatusException(Status.failed(
"Couldn't get object relation 'xProp'. Test must be modified"));
}
try
{
colName = AnyConverter.toString(tEnv.getObjRelation("colName"));
}
catch (com.sun.star.lang.IllegalArgumentException e)
{
colName = null;
}
if (colName == null) {
throw new StatusException(Status.failed(
"Couldn't get object relation 'colName'. Test must be modified"));
}
}
/**
* Object relation xQueryAna
set a filter. This filter
* must returned while calling getFilter
*/
public void _setFilter() {
try{
String filter = "\"Identifier\" = 'BOR02b'";
oObj.setFilter(filter);
tRes.tested("setFilter()", (xQueryAna.getFilter().equals(filter)));
} catch (com.sun.star.sdbc.SQLException e){
log.println("unexpected Exception: " + e.toString());
tRes.tested("setFilter()", false);
}
}
/**
* Object relation xQueryAna
set a complex filter with method
. setFilter
. Then getStructuredFilter
returns a
* sequenze of PropertyValue
which was set with method
* setStructuredFilter
from xQueryAna
.
* Then test has ok status if getFilter
returns the complex filter.
*/
public void _setStructuredFilter() {
requiredMethod("setFilter()");
try{
xQueryAna.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' )";
oObj.setFilter(complexFilter);
PropertyValue[][] aStructuredFilter = xQueryAna.getStructuredFilter();
oObj.setFilter("");
oObj.setStructuredFilter(aStructuredFilter);
tRes.tested("setStructuredFilter()", (xQueryAna.getFilter().equals(complexFilter)));
} catch (com.sun.star.sdbc.SQLException e){
log.println("unexpected Exception: " + e.toString());
tRes.tested("setStructuredFilter()", false);
} catch (com.sun.star.lang.IllegalArgumentException e){
log.println("unexpected Exception: " + e.toString());
tRes.tested("setStructuredFilter()", false);
}
}
/**
* At first the object relation xProp
was set as parameter.
* Relation xQueryAna
was used to chek if realtion
* colName
was found.
* Second an empty XPropertySet
was used as parameter. A
* com.sun.star.sdbc.SQLException
must be thrown.
*/
public void _appendFilterByColumn() {
boolean ok = true;
try{
oObj.appendFilterByColumn(xProp, true,SQLFilterOperator.EQUAL);
log.println("appendFilterByColumn: " + xQueryAna.getFilter());
ok = ok && (xQueryAna.getFilter().indexOf(colName) > 0);
} catch (com.sun.star.sdbc.SQLException e){
log.println("unexpected Exception: " + e.toString());
tRes.tested("appendFilterByColumn()", false);
}
try{
oObj.appendFilterByColumn(xProp, false,SQLFilterOperator.EQUAL);
log.println("appendFilterByColumn: " + xQueryAna.getFilter());
ok = ok && (xQueryAna.getFilter().indexOf(colName) > 0);
} catch (com.sun.star.sdbc.SQLException e){
log.println("unexpected Exception: " + e.toString());
tRes.tested("appendFilterByColumn()", false);
}
try{
XPropertySet dummy = null;
oObj.appendFilterByColumn(dummy, true,SQLFilterOperator.EQUAL);
log.println("expected Exception was not thrown");
tRes.tested("appendFilterByColumn()", false);
} catch (com.sun.star.sdbc.SQLException e){
log.println("expected Exception");
ok = ok && true;
}
tRes.tested("appendFilterByColumn()", ok);
}
/**
* At first the object relation xProp
was used as parameter.
* Relation xQueryAna
was used to chek if realtion
* colName
was found.
* Second an empty XPropertySet
was used as parameter. An
* com.sun.star.sdbc.SQLException
must be thrown.
*/
public void _appendGroupByColumn() {
boolean ok = true;
try{
oObj.appendGroupByColumn(xProp);
log.println("appendGroupByColumn: " + xQueryAna.getFilter());
ok = ok && (xQueryAna.getFilter().indexOf(colName) > 0);
} catch (com.sun.star.sdbc.SQLException e){
log.println("unexpected Exception: " + e.toString());
tRes.tested("appendGroupByColumn()", false);
}
try{
XPropertySet dummy = null;
oObj.appendGroupByColumn(dummy);
log.println("expected Exception was not thrown");
tRes.tested("appendGroupByColumn()", false);
} catch (com.sun.star.sdbc.SQLException e){
log.println("expected Exception");
ok = ok && true;
}
tRes.tested("appendGroupByColumn()", ok);
}
/**
* The group which was setted by setGroup
must be returned
* while calling from object relation XQueryAna
* method getGroup
*/
public void _setGroup() {
try{
String group = "\"Identifier\"";
oObj.setGroup(group);
tRes.tested("setGroup()", (xQueryAna.getGroup().equals(group)));
} catch (com.sun.star.sdbc.SQLException e){
log.println("unexpected Exception: " + e.toString());
tRes.tested("setGroup()", false);
}
}
/**
* The cluase which was setted by setHavingClause
must be returned
* while calling from object relation XQueryAna
* method getHavingClause
*/
public void _setHavingClause() {
try{
String clause = "\"Identifier\" = 'BOR02b'";
oObj.setHavingClause(clause);
tRes.tested("setHavingClause()", (
xQueryAna.getHavingClause().equals(clause)));
} catch (com.sun.star.sdbc.SQLException e){
log.println("unexpected Exception: " + e.toString());
tRes.tested("setHavingClause()", false);
}
}
/**
* At first setHavingClause
sets a complex clause.
* Then method getStructuredHavingClause
from object relation
* xQueryAna
returns a valid PropertyValue[][]
* Method setHavingClause
was called with an empty sting to
* reset filter. Now setStructuredHavingClause
with the valid
* PropertyValue[][]
as parameter was called.
* Test is ok if getHavingClause
from xQueryAna
* returns the complex clause from beginning.
*
* required methods: *
setHavingClause
setStructuredFilter
xProp
was used as parameter. Relation
* xQueryAna
was used to chek if realtion colName
* was found.
* Second an empty XPropertySet
was given as parameter. An
* com.sun.star.sdbc.SQLException
must be thrown.
*/
public void _appendHavingClauseByColumn() {
boolean ok = true;
try{
oObj.appendHavingClauseByColumn(xProp, true,SQLFilterOperator.EQUAL);
log.println("appendHavingClauseByColumn: " + xQueryAna.getFilter());
ok = ok && (xQueryAna.getFilter().indexOf(colName) > 0);
} catch (com.sun.star.sdbc.SQLException e){
log.println("unexpected Exception: " + e.toString());
tRes.tested("appendHavingClauseByColumn()", false);
}
try{
XPropertySet dummy = null;
oObj.appendHavingClauseByColumn(dummy, true,SQLFilterOperator.EQUAL);
log.println("expected Exception was not thrown");
tRes.tested("appendHavingClauseByColumn()", false);
} catch (com.sun.star.sdbc.SQLException e){
log.println("expected Exception");
ok = ok && true;
}
tRes.tested("appendHavingClauseByColumn()", ok);
}
/**
* First object relation xProp
was set as parameter. Relation
* xQueryAna
was used to chek if realtion colName
* was found.
* Second an empty XPropertySet
was given as parameter. An
* com.sun.star.sdbc.SQLException
must be thrown.
*/
public void _appendOrderByColumn() {
boolean ok = true;
try{
oObj.appendOrderByColumn(xProp, true);
log.println("appendOrderByColumn: " + xQueryAna.getFilter());
ok = ok && (xQueryAna.getFilter().indexOf(colName) > 0);
} catch (com.sun.star.sdbc.SQLException e){
log.println("unexpected Exception: " + e.toString());
tRes.tested("appendOrderByColumn()", false);
}
try{
XPropertySet dummy = null;
oObj.appendOrderByColumn(dummy, true);
log.println("expected Exception was not thrown");
tRes.tested("appendOrderByColumn()", false);
} catch (com.sun.star.sdbc.SQLException e){
log.println("expected Exception");
ok = ok && true;
}
tRes.tested("appendOrderByColumn()", ok);
}
/**
* Method getOrder
from object relation xQueryAna
* checks the order which was setted while calling setOrder
*/
public void _setOrder() {
try{
String order = "\"Identifier\"";
oObj.setOrder(order);
tRes.tested("setOrder()", (xQueryAna.getOrder().equals(order)));
} catch (com.sun.star.sdbc.SQLException e){
log.println("unexpected Exception: " + e.toString());
tRes.tested("setOrder()", false);
}
}
} // finish class _XSingleSelectQueryComposer