connectivity/qa/drivers/dbase/DBaseStringFunctions.java

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: DBaseStringFunctions.java,v $
  10  * $Revision: 1.6 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30 package qa.drivers.dbase;
  31
  32 import com.sun.star.uno.UnoRuntime;
  33 import com.sun.star.sdbc.*;
  34 import com.sun.star.beans.XPropertySet;
  35 import com.sun.star.lang.XMultiServiceFactory;
  36
  37 public class DBaseStringFunctions
  38 {
  39     private String where = "FROM \"biblio\" \"biblio\" where \"Identifier\" = 'BOR00'";
  40     private final XMultiServiceFactory m_xORB;
  41     private final DBaseDriverTest testcase;
  42
  43     public DBaseStringFunctions(final XMultiServiceFactory _xORB,final DBaseDriverTest _testcase)
  44     {
  45         m_xORB = _xORB;
  46         testcase = _testcase;
  47     }
  48
  49     private void assure(final String s,final boolean b)
  50     {
  51         testcase.assure2(s, b);
  52     }
  53
  54     public void testFunctions() throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
  55     {
  56         final XRowSet xRowRes = (XRowSet) UnoRuntime.queryInterface(XRowSet.class,
  57                 m_xORB.createInstance("com.sun.star.sdb.RowSet"));
  58
  59         testcase.getLog().println("starting String function test");
  60         // set the properties needed to connect to a database
  61         final XPropertySet xProp = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, xRowRes);
  62         xProp.setPropertyValue("DataSourceName", "Bibliography");
  63
  64         xProp.setPropertyValue("CommandType", Integer.valueOf(com.sun.star.sdb.CommandType.COMMAND));
  65
  66         try
  67         {
  68             upper(xRowRes);
  69         }
  70         catch (SQLException ex)
  71         {
  72             assure("upper " + ex.getMessage(), false);
  73             throw ex;
  74         }
  75         try
  76         {
  77             lower(xRowRes);
  78         }
  79         catch (SQLException ex)
  80         {
  81             assure("lower " + ex.getMessage(), false);
  82             throw ex;
  83         }
  84         try
  85         {
  86             acsii(xRowRes);
  87         }
  88         catch (SQLException ex)
  89         {
  90             assure("ascii " + ex.getMessage(), false);
  91             throw ex;
  92         }
  93         try
  94         {
  95             char_length(xRowRes);
  96         }
  97         catch (SQLException ex)
  98         {
  99             assure("char_len " + ex.getMessage(), false);
 100             throw ex;
 101         }
 102         try
 103         {
 104             concat(xRowRes);
 105         }
 106         catch (SQLException ex)
 107         {
 108             assure("concat " + ex.getMessage(), false);
 109             throw ex;
 110         }
 111         try
 112         {
 113             chartest(xRowRes);
 114         }
 115         catch (SQLException ex)
 116         {
 117             assure("char " + ex.getMessage(), false);
 118             throw ex;
 119         }
 120         try
 121         {
 122             locate(xRowRes);
 123         }
 124         catch (SQLException ex)
 125         {
 126             assure("locate " + ex.getMessage(), false);
 127             throw ex;
 128         }
 129         try
 130         {
 131             substring(xRowRes);
 132         }
 133         catch (SQLException ex)
 134         {
 135             assure("substr " + ex.getMessage(), false);
 136             throw ex;
 137         }
 138         try
 139         {
 140             ltrim(xRowRes);
 141         }
 142         catch (SQLException ex)
 143         {
 144             assure("ltrim " + ex.getMessage(), false);
 145             throw ex;
 146         }
 147         try
 148         {
 149             rtrim(xRowRes);
 150         }
 151         catch (SQLException ex)
 152         {
 153             assure("rtrim " + ex.getMessage(), false);
 154             throw ex;
 155         }
 156         try
 157         {
 158             space(xRowRes);
 159         }
 160         catch (SQLException ex)
 161         {
 162             assure("space " + ex.getMessage(), false);
 163             throw ex;
 164         }
 165         try
 166         {
 167             replace(xRowRes);
 168         }
 169         catch (SQLException ex)
 170         {
 171             assure("replace " + ex.getMessage(), false);
 172             throw ex;
 173         }
 174         try
 175         {
 176             repeat(xRowRes);
 177         }
 178         catch (SQLException ex)
 179         {
 180             assure("repeat " + ex.getMessage(), false);
 181             throw ex;
 182         }
 183         try
 184         {
 185             insert(xRowRes);
 186         }
 187         catch (SQLException ex)
 188         {
 189             assure("insert " + ex.getMessage(), false);
 190             throw ex;
 191         }
 192         try
 193         {
 194             left(xRowRes);
 195         }
 196         catch (SQLException ex)
 197         {
 198             assure("left " + ex.getMessage(), false);
 199             throw ex;
 200         }
 201         try
 202         {
 203             right(xRowRes);
 204         }
 205         catch (SQLException ex)
 206         {
 207             assure("right " + ex.getMessage(), false);
 208             throw ex;
 209         }
 210     }
 211
 212     private XRow execute(final XRowSet xRowRes, String sql) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 213     {
 214         final XPropertySet xProp = (XPropertySet) UnoRuntime.queryInterface(XPropertySet.class, xRowRes);
 215         xProp.setPropertyValue("Command", "SELECT " + sql + where);
 216         xRowRes.execute();
 217         final XResultSet xRes = (XResultSet) UnoRuntime.queryInterface(XResultSet.class, xRowRes);
 218         assure("No valid row! ", xRes.next());
 219
 220         return (XRow) UnoRuntime.queryInterface(XRow.class, xRes);
 221     }
 222
 223     private void upper(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 224     {
 225         final XRow row = execute(xRowRes, "upper('test'),UCASE('test') ");
 226         assure("upper('test') failed!", row.getString(1).equals("TEST"));
 227         assure("ucase('test') failed!", row.getString(2).equals("TEST"));
 228     }
 229
 230     private void lower(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 231     {
 232         final XRow row = execute(xRowRes, "lower('TEST'),LCASE('TEST') ");
 233         assure("lower('TEST') failed!", row.getString(1).equals("test"));
 234         assure("lcase('TEST') failed!", row.getString(2).equals("test"));
 235         final String temp = where;
 236         where = "FROM \"biblio\" \"biblio\" where LOWER(\"Identifier\") like 'bor%'";
 237         execute(xRowRes, "lower('TEST'),LCASE('TEST') ");
 238         where = temp;
 239     }
 240
 241     private void acsii(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 242     {
 243         final XRow row = execute(xRowRes, "ASCII('2') ");
 244         assure("acsii('2') failed!", row.getInt(1) == 50);
 245     }
 246
 247     private void char_length(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 248     {
 249         final XRow row = execute(xRowRes, "char_length('test'),character_length('test'),OCTET_LENGTH('test') ");
 250         assure("char_length('test') failed!", row.getInt(1) == 4);
 251         assure("character_length('test') failed!", row.getInt(2) == 4);
 252         assure("OCTET_LENGTH('test') failed!", row.getInt(3) == 4);
 253     }
 254
 255     private void concat(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 256     {
 257         final XRow row = execute(xRowRes, "CONCAT('Hello',' ','World') ");
 258         assure("CONCAT('Hello',' ',,'World') failed!", row.getString(1).equals("Hello World"));
 259     }
 260
 261     private void locate(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 262     {
 263         final XRow row = execute(xRowRes, "LOCATE('bar', 'foobarbar') ");
 264         assure("LOCATE('bar', 'foobarbar') failed!", row.getInt(1) == 4);
 265     }
 266
 267     private void substring(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 268     {
 269         final XRow row = execute(xRowRes, "SUBSTRING('Quadratically',5) ");
 270         assure("SUBSTRING('Quadratically',5) failed!", row.getString(1).equals("ratically"));
 271     }
 272
 273     private void ltrim(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 274     {
 275         final XRow row = execute(xRowRes, "LTRIM('  barbar') ");
 276         assure("LTRIM('  barbar') failed!", row.getString(1).equals("barbar"));
 277     }
 278
 279     private void rtrim(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 280     {
 281         final XRow row = execute(xRowRes, "RTRIM('barbar  ') ");
 282         assure("RTRIM('barbar  ') failed!", row.getString(1).equals("barbar"));
 283     }
 284
 285     private void space(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 286     {
 287         final XRow row = execute(xRowRes, "space(6) ");
 288         assure("space(6) failed!", row.getString(1).equals("      "));
 289     }
 290
 291     private void replace(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 292     {
 293         final XRow row = execute(xRowRes, "REPLACE('www.OOo.com', 'w', 'Ww') ");
 294         assure("REPLACE('www.OOo.com', 'w', 'Ww') failed!", row.getString(1).equals("WwWwWw.OOo.com"));
 295     }
 296
 297     private void repeat(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 298     {
 299         final XRow row = execute(xRowRes, "REPEAT('OOo', 3) ");
 300         assure("REPEAT('OOo', 3) failed!", row.getString(1).equals("OOoOOoOOo"));
 301     }
 302
 303     private void insert(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 304     {
 305         final XRow row = execute(xRowRes, "INSERT('Quadratic', 3, 4, 'What') ");
 306         assure("INSERT('Quadratic', 3, 4, 'What') failed!", row.getString(1).equals("QuWhattic"));
 307     }
 308
 309     private void left(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 310     {
 311         final XRow row = execute(xRowRes, "LEFT('foobarbar', 5) ");
 312         assure("LEFT('foobarbar', 5) failed!", row.getString(1).equals("fooba"));
 313     }
 314
 315     private void right(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 316     {
 317         final XRow row = execute(xRowRes, "RIGHT('foobarbar', 4) ");
 318         assure("RIGHT('foobarbar', 4) failed!", row.getString(1).equals("rbar"));
 319     }
 320
 321     private void chartest(final XRowSet xRowRes) throws com.sun.star.uno.Exception, com.sun.star.beans.UnknownPropertyException
 322     {
 323         final XRow row = execute(xRowRes, "CHAR(ascii('t'),ascii('e'),ascii('s'),ascii('t')) ");
 324         assure("CHAR(ascii('t'),ascii('e'),ascii('s'),ascii('t')) failed!", row.getString(1).equals("test"));
 325     }
 326 }