diff options
Diffstat (limited to 'qadevOOo/tests/java/ifc/sdbcx/_XDataDefinitionSupplier.java')
| -rw-r--r-- | qadevOOo/tests/java/ifc/sdbcx/_XDataDefinitionSupplier.java | 179 |
1 files changed, 179 insertions, 0 deletions
diff --git a/qadevOOo/tests/java/ifc/sdbcx/_XDataDefinitionSupplier.java b/qadevOOo/tests/java/ifc/sdbcx/_XDataDefinitionSupplier.java new file mode 100644 index 000000000000..11f68d19ce86 --- /dev/null +++ b/qadevOOo/tests/java/ifc/sdbcx/_XDataDefinitionSupplier.java @@ -0,0 +1,179 @@ +/************************************************************************* + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 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 + + |