diff options
Diffstat (limited to 'connectivity/qa/complex/connectivity/dbase/DBaseStringFunctions.java')
| -rwxr-xr-x | connectivity/qa/complex/connectivity/dbase/DBaseStringFunctions.java | 319 |
1 files changed, 0 insertions, 319 deletions
diff --git a/connectivity/qa/complex/connectivity/dbase/DBaseStringFunctions.java b/connectivity/qa/complex/connectivity/dbase/DBaseStringFunctions.java deleted file mode 100755 index 7029afa8f2..0000000000 --- a/connectivity/qa/complex/connectivity/dbase/DBaseStringFunctions.java +++ /dev/null @@ -1,319 +0,0 @@ -/************************************************************************* - * - * 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 complex.connectivity.dbase; - -import com.sun.star.uno.UnoRuntime; -import com.sun.star.sdbc.*; -import com.sun.star.beans.XPropertySet; -import com.sun.star.lang.XMultiServiceFactory; -import complex.connectivity.SubTestCase; -import complex.connectivity.TestCase; - -public class DBaseStringFunctions extends SubTestCase -{ - private String where = "FROM \"biblio\" \"biblio\" where \"Identifier\" = 'BOR00'"; - private final XMultiServiceFactory m_xORB; - - public DBaseStringFunctions(final XMultiServiceFactory _xORB,final TestCase i_testCase) - { - super( i_testCase ); - m_xORB = _xORB; - } - - public void testFunctions() throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRowSet xRowRes = (XRowSet) UnoRuntime.queryInterface(XRowSet.class, - m_xORB.createInstance("com.sun.star.sdb.RowSet")); - - getLog().println("starting String function test"); - // set the properties needed to connect to a database - final XPropertySet xProp = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, xRowRes); - xProp.setPropertyValue("DataSourceName", "Bibliography"); - - xProp.setPropertyValue("CommandType", Integer.valueOf(com.sun.star.sdb.CommandType.COMMAND)); - - try - { - upper(xRowRes); - } - catch (SQLException ex) - { - assure("upper " + ex.getMessage(), false); - throw ex; - } - try - { - lower(xRowRes); - } - catch (SQLException ex) - { - assure("lower " + ex.getMessage(), false); - throw ex; - } - try - { - acsii(xRowRes); - } - catch (SQLException ex) - { - assure("ascii " + ex.getMessage(), false); - throw ex; - } - try - { - char_length(xRowRes); - } - catch (SQLException ex) - { - assure("char_len " + ex.getMessage(), false); - throw ex; - } - try - { - concat(xRowRes); - } - catch (SQLException ex) - { - assure("concat " + ex.getMessage(), false); - throw ex; - } - try - { - chartest(xRowRes); - } - catch (SQLException ex) - { - assure("char " + ex.getMessage(), false); - throw ex; - } - try - { - locate(xRowRes); - } - catch (SQLException ex) - { - assure("locate " + ex.getMessage(), false); - throw ex; - } - try - { - substring(xRowRes); - } - catch (SQLException ex) - { - assure("substr " + ex.getMessage(), false); - throw ex; - } - try - { - ltrim(xRowRes); - } - catch (SQLException ex) - { - assure("ltrim " + ex.getMessage(), false); - throw ex; - } - try - { - rtrim(xRowRes); - } - catch (SQLException ex) - { - assure("rtrim " + ex.getMessage(), false); - throw ex; - } - try - { - space(xRowRes); - } - catch (SQLException ex) - { - assure("space " + ex.getMessage(), false); - throw ex; - } - try - { - replace(xRowRes); - } - catch (SQLException ex) - { - assure("replace " + ex.getMessage(), false); - throw ex; - } - try - { - repeat(xRowRes); - } - catch (SQLException ex) - { - assure("repeat " + ex.getMessage(), false); - throw ex; - } - try - { - insert(xRowRes); - } - catch (SQLException ex) - { - assure("insert " + ex.getMessage(), false); - throw ex; - } - try - { - left(xRowRes); - } - catch (SQLException ex) - { - assure("left " + ex.getMessage(), false); - throw ex; - } - try - { - right(xRowRes); - } - catch (SQLException ex) - { - assure("right " + ex.getMessage(), false); - throw ex; - } - } - - private XRow execute(final XRowSet xRowRes, String sql) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XPropertySet xProp = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, xRowRes); - xProp.setPropertyValue("Command", "SELECT " + sql + where); - xRowRes.execute(); - final XResultSet xRes = (XResultSet) UnoRuntime.queryInterface(XResultSet.class, xRowRes); - assure("No valid row! ", xRes.next()); - - return (XRow) UnoRuntime.queryInterface(XRow.class, xRes); - } - - private void upper(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "upper('test'),UCASE('test') "); - assure("upper('test') failed!", row.getString(1).equals("TEST")); - assure("ucase('test') failed!", row.getString(2).equals("TEST")); - } - - private void lower(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "lower('TEST'),LCASE('TEST') "); - assure("lower('TEST') failed!", row.getString(1).equals("test")); - assure("lcase('TEST') failed!", row.getString(2).equals("test")); - final String temp = where; - where = "FROM \"biblio\" \"biblio\" where LOWER(\"Identifier\") like 'bor%'"; - execute(xRowRes, "lower('TEST'),LCASE('TEST') "); - where = temp; - } - - private void acsii(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "ASCII('2') "); - assure("acsii('2') failed!", row.getInt(1) == 50); - } - - private void char_length(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "char_length('test'),character_length('test'),OCTET_LENGTH('test') "); - assure("char_length('test') failed!", row.getInt(1) == 4); - assure("character_length('test') failed!", row.getInt(2) == 4); - assure("OCTET_LENGTH('test') failed!", row.getInt(3) == 4); - } - - private void concat(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "CONCAT('Hello',' ','World') "); - assure("CONCAT('Hello',' ',,'World') failed!", row.getString(1).equals("Hello World")); - } - - private void locate(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "LOCATE('bar', 'foobarbar') "); - assure("LOCATE('bar', 'foobarbar') failed!", row.getInt(1) == 4); - } - - private void substring(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "SUBSTRING('Quadratically',5) "); - assure("SUBSTRING('Quadratically',5) failed!", row.getString(1).equals("ratically")); - } - - private void ltrim(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "LTRIM(' barbar') "); - assure("LTRIM(' barbar') failed!", row.getString(1).equals("barbar")); - } - - private void rtrim(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "RTRIM('barbar ') "); - assure("RTRIM('barbar ') failed!", row.getString(1).equals("barbar")); - } - - private void space(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "space(6) "); - assure("space(6) failed!", row.getString(1).equals(" ")); - } - - private void replace(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "REPLACE('www.OOo.com', 'w', 'Ww') "); - assure("REPLACE('www.OOo.com', 'w', 'Ww') failed!", row.getString(1).equals("WwWwWw.OOo.com")); - } - - private void repeat(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "REPEAT('OOo', 3) "); - assure("REPEAT('OOo', 3) failed!", row.getString(1).equals("OOoOOoOOo")); - } - - private void insert(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "INSERT('Quadratic', 3, 4, 'What') "); - assure("INSERT('Quadratic', 3, 4, 'What') failed!", row.getString(1).equals("QuWhattic")); - } - - private void left(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "LEFT('foobarbar', 5) "); - assure("LEFT('foobarbar', 5) failed!", row.getString(1).equals("fooba")); - } - - private void right(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "RIGHT('foobarbar', 4) "); - assure("RIGHT('foobarbar', 4) failed!", row.getString(1).equals("rbar")); - } - - private void chartest(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException - { - final XRow row = execute(xRowRes, "CHAR(ascii('t'),ascii('e'),ascii('s'),ascii('t')) "); - assure("CHAR(ascii('t'),ascii('e'),ascii('s'),ascii('t')) failed!", row.getString(1).equals("test")); - } -} |