/**************************************************************
*
* 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
*
* Unless required by applicable law or agreed to in writing,
* software distributed under the License is distributed on an
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
* KIND, either express or implied. See the License for the
* specific language governing permissions and limitations
* under the License.
*
*************************************************************/
package ifc.sdbcx;
import lib.MultiMethodTest;
import lib.Status;
import lib.StatusException;
import com.sun.star.beans.PropertyValue;
import com.sun.star.sdbc.XConnection;
import com.sun.star.sdbc.XDriver;
import com.sun.star.sdbcx.XDataDefinitionSupplier;
import com.sun.star.sdbcx.XTablesSupplier;
import com.sun.star.uno.UnoRuntime;
/**
* Testing <code>com.sun.star.sdbcx.XDataDefinitionSupplier</code>
* interface methods :
* <ul>
* <li><code> getDataDefinitionByConnection()</code></li>
* <li><code> getDataDefinitionByURL()</code></li>
* </ul> <p>
* Required object relations :
* <ul>
* <li> <code>'XDriver.URL'</code>:
* is the URL of the database to which to connect</code></li>
* <li><code>'XDriver.UNSUITABLE_URL'</code>:
* the wrong kind of URL to connect using given driver</li>
* <li><code>'XDriver.INFO'</code>:
* a list of arbitrary string tag/value pairs as connection arguments</li>
* </ul> <p>
* @see com.sun.star.sdbcx.XDataDefinitionSupplier
*/
public class _XDataDefinitionSupplier extends MultiMethodTest {
// oObj filled by MultiMethodTest
public XDataDefinitionSupplier oObj = null ;
String url = null;
String wrongUrl = null;
PropertyValue[] info = null;
/**
* Retrieves relations.
* @throw StatusException If any relation not found.
*/
protected void before() {
url = (String)tEnv.getObjRelation("XDriver.URL");
if (url == null) {
throw new StatusException(Status.failed(
"Couldn't get relation 'XDriver.URL'"));
}
wrongUrl = (String)tEnv.getObjRelation("XDriver.UNSUITABLE_URL");
if (wrongUrl == null) {
throw new StatusException(Status.failed(
"Couldn't get relation 'XDriver.WRONG_URL'"));
}
info = (PropertyValue[])tEnv.getObjRelation("XDriver.INFO");
if (info == null) {
throw new StatusException(Status.failed(
"Couldn't get relation 'XDriver.INFO'"));
}
}
XConnection connection = null;
/**
* Obtains the connection to url(relation <code>'XDriver.URL'</code>)
* with info(relation <code>'XDriver.INFO'</code>).
* Calls the method with obtained connection and checks that returned value
* isn't null.
*/
public void _getDataDefinitionByConnection() {
boolean bRes = true;
XDriver xDriver = (XDriver)
UnoRuntime.queryInterface(XDriver.class, oObj);
if (xDriver == null) {
log.println("The XDriver interface isn't supported");
tRes.tested("getDataDefinitionByConnection()",
Status.skipped(false));
return;
}
try {
connection = xDriver.connect(url, info);
} catch(com.sun.star.sdbc.SQLException e) {
e.printStackTrace(log);
bRes = false;
}
if (connection == null) {
log.println("Couldn't get connection to specified url using " +
"specified info");
tRes.tested("getDataDefinitionByConnection()",
Status.skipped(false));
return;
}
XTablesSupplier xTS = null;
try {
log.println("getDataDefinitionByConnection(connection)");
xTS = oObj.getDataDefinitionByConnection(connection);
bRes = xTS != null;
} catch(com.sun.star.sdbc.SQLException e) {
log.println("Unexpected exception: " + e);
bRes = false;
}
try {
log.println("getDataDefinitionByConnection(null)");
xTS = oObj.getDataDefinitionByConnection(null);
bRes = xTS == null;
} catch(com.sun.star.sdbc.SQLException e) {
log.println("Exception: " + e);
bRes = true;
}
tRes.tested("getDataDefinitionByConnection()", bRes);
}
/**
* Calls the method with url and info obtained from the relations
* <code>XDriver.URL</code> and <code>XDriver.INFO</code>.
* Checks that retuned value isn't null.
* Then calls the method with the unsuitable url obtained from the relation
* <code>XDriver.UNSUITABLE_URL</code> and checks that SQLException
* exception was thrown.
*/
public void _getDataDefinitionByURL() {
boolean bRes = false;
XTablesSupplier xTS = null;
try {
log.println("getDataDefinitionByURL('" + url + "')");
xTS = oObj.getDataDefinitionByURL(url, info);
bRes = xTS != null;
} catch (com.sun.star.sdbc.SQLException e) {
log.println("Unexpected exception: " + e);
bRes = false;
}
try {
log.println("getDataDefinitionByURL('" + wrongUrl + "')");
xTS = oObj.getDataDefinitionByURL(wrongUrl, info);
log.println("Exception was expected");
bRes = false;
} catch (com.sun.star.sdbc.SQLException e) {
log.println("Expected exception");
bRes &= true;
}
tRes.tested("getDataDefinitionByURL()", true);
}
} // finish class _XDataDefinitionSupplier